- We generally write FND_FILE statements in concurrent programs for debugging, logs, and various other messages
- These are visible in Concurrent request logs and out once the concurrent program completes only
- If we want to see the logs and out for the running concurrent request, then we need to find the temporary log and out file which the concurrent program is writing
- We can use the below query to find the temporary log and out files and then we need to go $APPLPTMP directory and find those files
Query to find the FND_FILE output of the running concurrent request
sqlplus apps/<apps pass> select cql.user_concurrent_queue_name,cp.plsql_dir, cp.plsql_out, cp.plsql_log from fnd_concurrent_requests cr, fnd_concurrent_processes cp where cr.request_id =< running request id> and cp.concurrent_process_id = cr.controlling_manager and cp.concurrent_queue_id=cql.concurrent_queue_id;
The temporary files are named as follows, padded to 7 digits:
l<seq no>.req
o<seq no>.req
Once we find the names of the temporary files, we can look out for those in the $APPLPTMP directory
cd $APPLPTMP
ls -lrt o647647647.tmp
I hope you like this short post on finding this important information
Related Articles
FND_FILE in oracle apps: Check out this post for the FND_FILE package in oracle apps, how it worked, FND_FILE API calls, common errors and solutions
Concurrent Manager Queries :This article contains awesome top 30 Concurrent Manager Queries for Concurrent Manager troubleshooting ,resolution ,run time, details
ORA-01427 :Check out this for the solution on ORA-01427: single-row subquery returns more than one row error ,how to resolve it when it happens with Concurrent Manager
request set in oracle apps : Request set gives the capability to submit the same set of requests regularly using a single transaction.
Concurrent Manager Interview questions ::Check out 24 Concurrent Manager Interview questions to help you in EBS interview. This consists of all sort of question on standard manager,service manager
Parallel Concurrent Processing :What is PCP, How to setup it, how to define internal monitor
Oracle Concurrent Manager :How an E-Business Suite Concurrent Manager Process Works,Oracle Concurrent Manager,What is internal monitor,What is service manager and troubleshooting
https://docs.oracle.com/cd/E18727_01/doc.121/e12893/T174296T174302.htm