Cannot View Old Concurrent Requests After Clone (Doc ID 395284.1)
Solution
Oracle Application Object Library - Version 11.5.10.0 to 12.2 [Release 11.5 to 12.2]
The table FND_CONCURRENT_RQUESTS needs to get updated with the new Node Name.
First take backup of the table, then update the old records with the new Node Name.
1. Backup process:
Create table FND_CONCURRENT_REQUESTS_BKP as select * from FND_CONCURRENT_REQUESTS;
2. Update Process:
Update FND_CONCURRENT_REQUESTS set LOGFILE_NODE_NAME='ORATST', OUTFILE_NODE_NAME='ORATST'
Where (UPPER(LOGFILE_NODE_NAME) LIKE 'ORACLESRV') and (UPPER(OUTFILE_NODE_NAME) LIKE 'ORACLESRV');
Where ORATST should be replaced by the cloned instance node name (Target)
and ORACLESRV should be replace by the source instance node name (Source).
Solution
The content applies to all Release 12.x.x versions
Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)
FND_CONCURRENT_REQUESTS | LOGFILE_NAME | Update with the correct path to the logfile directory. |
FND_CONCURRENT_REQUESTS | OUTFILE_NAME | Update with the new directory path on the target system. |