How to get concurrent program to look for file in $CE_TOP/patch/115/sql
The following patch was installed: Patch 17731085:R12.CE.B in a test environment. It added these two files to the $CE_TOP/patch/115/sql directory:
ce patch/115/sql ce_bank_merge.sql 120.1.12000000.1
ce patch/115/sql ce_branch_merge.sql 120.3.12000000.2
However, when I run my concurrent program, it is looking for the files to be in $CE_TOP/sql
Error message:
Routine fdpsql cannot read the file /u01/oracle/UAT/apps/apps_st/appl/ce/12.0.0/sql/ce_branch_merge.sql.
Check if the file exists under correct product directory.
Is there a way to get the concurrent program to access the programs from the patch directory or will I just have to move them to the