PCG : Preventive Controls Governor
PCG 7.3.3: PCG SQL Rule Remote Compilation Fails
Applies to:-
Oracle Preventive Controls Governor – Version 7.3 and later Information in this document applies to EBS 12.2.4 platform only.
Symptoms:-
On Preventative Controls Governor (PCG) version 7.3.3:
Form Rules is a module of PCG application. In the Form Rules module, one of the functionality is to apply SQL rules to Oracle Business Suite forms and this functionality is currently not working. When compiling SQL rules the program ends with the following error:Other functionality of the Form Rules module is working 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>