Unable To Compile LA Biz Rules: mv: LABRSQL.plx: cannot access: No such file or directory
Last updated on SEPTEMBER 25, 2015
Applies to:Oracle Preventive Controls Governor - Version 6.5.8 and later
Information in this document applies to any platform.
On Preventative Controls Governor (PCG) version 6.5.8:
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 trying to compile all SQL rules, the program/request ends with following error:
Other functionality of the Form Rules module is working as expected.
Forms 6.0 (Form Compiler): Release - Production
(c) Copyright 1999 Oracle Corporation. All rights reserved.
PL/SQL Version 188.8.131.52.0 (Production)
Oracle Procedure Builder V184.108.40.206.0 Build #0 - Production
Oracle Virtual Graphics System Version 220.127.116.11.0 (Production)
Oracle Multimedia Version 18.104.22.168.0 (Production)
Oracle Tools Integration Version 22.214.171.124.0 (Production)
Oracle Tools Common Area Version 126.96.36.199.0
Oracle CORE Version 188.8.131.52.0 - Production
ORA-01017: invalid username/password; logon denied
/u02/app/itoa035a/app/XXLAAPPS/11.5.0/bin/LAFORMSGEN.prog: /: not found.
mv: LABRSQL.plx: cannot access: No such file or directory
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. The program ends with error mentioned above
The issue has the following business impact:
Due to this issue, users cannot apply SQL rules create on the OEBS forms.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms