SQL Error: LAFORMSGEN: Failed to parse PLD to PLL -Parsing the script file... PDE-PER001 Internal error (sderf 2) (Doc ID 1297814.1)

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.
***Checked for relevance on 02-Jun-2014***

Symptoms

Problem Statement:
--------------------------
On Preventative Controls Governor (PCG) version 7.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:


Oracle CORE Version 4.0.6.0.0 - Production
 - Parsing the script file...
PDE-PER001 Internal error (sderf 2)./u001/oracle/env22appl/xxlaapps/11.5.0/bin/LAFORMSGEN.prog: line 83:  6124 Segmentation fault      $v_frmcmp module=$v_lib.pld module_type=library userid=$oracle_login PARSE=YES

LAFORMSGEN: Failed to parse PLD to PLL
LAFORMSGEN: Quitting with error...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigation: OEBS > GRC Controls Responsibility (PCG) > Form Rules

1. In form rules navigate to the SQL tab
2. Create a SQL rule
3. Compile all SQL rules
4. Verify the log and the above mentioned error is visible

BUSINESS IMPACT
-----------------------
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.

Cause

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