PCG 7.3.x: PCG SQL Rule Remote Compilation Fails
Last updated on MARCH 08, 2017
Applies to:Oracle Preventive Controls Governor - Version 7.3 and later
Information in this document applies to any platform.
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 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: %s_tools_home_file%: not found.
LAGENLIB: Library compilation failed
LAGENLIB: Please verify your Remote compilation configuration
LAGENLIB: Quitting with error...
Program exited with status 1
The issue can be reproduced at will with the following steps:
1. Log on to the GRC Controls responsibility in Oracle E-Business Suite. In that responsibility, select Form Rules.
2. A GRC Controls–Oracle Rules form opens. Select its Form Rules tab.
3. Click on Tools in the menu bar, and then Oracle Form Rules Compile All Active SQL Rules in the Tools menu.
4. A pop-up message informs you of an ID number for the concurrent request that executes the SQL rule compilation. Make a note of the number, and then click on the OK button to close the message.
5. Optionally, verify that the request has been completed successfully.
a Click on View in the menu bar, then on Requests in the View menu.
b A Find Requests form opens. In it, click on the Specific Request radio button. Type the ID number of your concurrent request in the Request ID field, and click on the Find button.
The issue has the following business impact:
Due to this issue, users cannot apply SQL rules create on the OEBS forms. However, other types of rules created in the Form Rules are working as expected.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms