Thursday, January 21, 2016

Where do concurrent request log files and output files go, Oracle 12.1 12.2


SELECT LOGFILE_NAME, OUTFILE_NAME ,a.request_date ,a.lfile_size/1024/1024 lfile ,a.ofile_size/1024/1024 ofile
 ,b.user_concurrent_program_name
from fnd_concurrent_requests a ,
fnd_concurrent_programs_vl b
where a.request_date between sysdate -4 and sysdate
and a.concurrent_program_id = b.concurrent_program_id

;

Wednesday, January 20, 2016

Get Oracle 12 payment XML output, Custom payment template

Get Oracle 12 payment XML output.
Use the following query to get XML Output for payment to modify the payment template:
Q1:-
SELECT   document
  FROM   iby_trxn_documents
 WHERE   payment_instruction_id = :p_payment_instruction_id;

use the output to build custom payment template

Thanks,