My Oracle Support Banner

SQL Compilation is Erroring when PCG 7.3.1 is installed against 11g database (Doc ID 1078979.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Preventive Controls Governor - Version 7.3.1 to 7.3.1 [Release 7]
Information in this document applies to any platform.

Symptoms

When attempting to do SQL Compilation after PCG 7.3.1 installation against 11g database,
the following error occurs in concurrent program log.

ERROR
-----------------------

LAGENLIB: Input parameters are
LAGENLIB: Library name: LABRSQL
LAGENLIB: Connect str : jdbc:oracle:thin:@alvofau22:1537:R12TST
LAGENLIB: Library will be : /apps/R12TST/apps/apps_st/appl/xxlaapps/12.0.0/bin/LABRSQL.pld
java.lang.NullPointerException
at Logg.fndMessage(Logg.java:100)
at Logg.mlsLog(Logg.java:164)
at LaGenLib.main(LaGenLib.java:151)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install PCG 7.3.1 on EBS at 11g database
2. Run SQL Compilation Program to generate LABRSQL.pld/pll/plx file
3. Check the Concurrent Program log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use AppsRule defined using SQL tab.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.