PCG 7.3.3: PCG SQL Rule Remote Compilation Fails
Applies to:
This document pertains to Oracle Preventive Controls Governor, starting from version 7.3 and beyond. Please note that the information provided here is specific to the EBS 12.2.4 platform.
Symptoms:
Within Preventive Controls Governor (PCG) version 7.3.3:
Form Rules is a component of the PCG application. In the Form Rules section, one of the features allows for the application of SQL rules to Oracle Business Suite forms. However, this particular feature is currently experiencing issues. When attempting to compile SQL rules, the program terminates and generates the following error. It’s important to mention that the other functionalities within the Form Rules module are functioning as expected.
ERROR:-
Error seen on the log file:
LAGENLIB: Number of entries found in laconfig : 0
LAGENLIB: Compiling the library on this concurrent manager’s appl top
/ucln01/afinprd/apps/apps_st/appl/xxlaapps/12.0.0/bin/LAFORMSGEN.prog[2]: %s_tools_home_file%: not found.
LAGENLIB: Library compilation failed
LAGENLIB: Please verify your Remote compilation configuration
LAGENLIB: Quitting with error…
/ucln01/afinprd/apps/apps_st/appl/xxlaapps/12.0.0/bin/LAGENLIB
Program exited with status 1
Cause:-
LAFORMSGEN.prog file under $XXLAAPPS_TOP/bin is pointing to incorrect environment file.As you’re aware in EBS12.2.4 there are couple of file systems namely
1) Patch 2) Run
To Implement the Solution.Please execute the Following Steps:-
Login to Form server.
echo $APPL_TOP/$APPLFENV
cd $XXLAAPPS_TOP/bin
cp LAFORMSGEN.prog LAFORMSGEN.prog_orig
vi LAFORMSGEN.prog
Comment following line:
./ucln01/afinprd/apps/apps_st/appl/ad/12.0.0/admin/template/APPSORA_ux.env
Add following as first line in file:
. <Output_from_step2>
Leave a Reply