How to get the output xml file (.out) file of the specific concurrent request in application R12.

How to get the output xml file (.out) file of the specific concurrent request in application R12.

Requirements:

1.Concurrent program Request ID.
2.Output file destination.

Steps:

1.End user ask for xml output file for specific request ID.

2.login as APPS user.

3.The following table contains the details of the output file.

DESC FND_CONCURRENT_REQUESTS

APPS@TEST> select REQUEST_ID,LOGFILE_NAME,LOGFILE_NODE_NAME,OUTFILE_NAME,OUTFILE_NODE_NAME from fnd_concurrent_requests where REQUEST_ID=&a;

Enter value for a: 122639731

old   1: select REQUEST_ID,LOGFILE_NAME,LOGFILE_NODE_NAME,OUTFILE_NAME,OUTFILE_NODE_NAME from fnd_concurrent_requests where REQUEST_ID=&a
new   1: select REQUEST_ID,LOGFILE_NAME,LOGFILE_NODE_NAME,OUTFILE_NAME,OUTFILE_NODE_NAME from fnd_concurrent_requests where REQUEST_ID=122639731

REQUEST_ID LOGFILE_NAME LOGFILE_NODE_NAME OUTFILE_NAME OUTFILE_NODE_NAME
————————————————————————————
 122639731 /u01/oracle/PROD/inst/apps/test/logs/appl/conc/log/l122639731.req sssssss
           /u01/oracle/PROD/inst/apps/test/logs/appl/conc/out/o122639731.out sssssss

4.Connect through winscp and go to the out file location and download the file and give the file to end user.

  • January 23, 2019 | 18 views
  • Comments