PCG 7.x: Unable To Compile SQL Rules
Last updated on MARCH 08, 2017
Applies to:Oracle Preventive Controls Governor - Version 5.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-JUL-2014***
-- Problem Statement:
Post-install step of PCG is to compile all SQL rules. However, the concurrent request that this
submits is failing.
Error Message in the logs of Concurrent request :
LAGENLIB: Last 100 lines of the generated library
tail: cannot open `/u02/oracle/CRP1/apps/apps_st/appl/xxlaapps/12.0.0/bin/LABRSQL.pld' for
reading: No such file or directory
-- Steps To Reproduce:
1. Log on to the GRC Controls responsibility in Oracle E-Business Suite
2. Navigate to: Preventive Control Governor -> Form Rules
3. GRC Controls-Oracle Rules form opens. Select its Form Rules tab.
4. Click on Tools in the menu bar, and then:
Oracle Form Rules Compile All Active SQL Rules in the Tools menu.
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