My Oracle Support Banner

R12.1.3: PA_EFC_PRJ_AST_LINE_DTLS_AIUD Trigger Invalid Due To Error: PLS-00201: Identifier 'GL_EFC_UTILS_PKG.CHECK (Doc ID 1592216.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, found that the trigger PA_EFC_PRJ_AST_LINE_DTLS_AIUD is invalid

SQL> select owner,object_name,object_type,status,last_ddl_time from dba_objects where object_name='PA_EFC_PRJ_AST_LINE_DTLS_AIUD';

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS LAST_DDL_
------------------- ------- ---------
APPS
PA_EFC_PRJ_AST_LINE_DTLS_AIUD
TRIGGER INVALID 26-SEP-13

Try to compile this trigger and get the following error:


SQL> alter trigger apps.PA_EFC_PRJ_AST_LINE_DTLS_AIUD compile;

Warning: Trigger altered with compilation errors.

SQL> show errors
Errors for TRIGGER APPS.PA_EFC_PRJ_AST_LINE_DTLS_AIUD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
22/4 PL/SQL: Statement ignored
22/8 PLS-00201: identifier 'GL_EFC_UTILS_PKG.CHECK_EFC_PROCESSING' 

must be declared

 

However, the GL_EFC_UTILS_PKG doesn't exist:

SQL> select owner,object_name,object_type,status,last_ddl_time from dba_objects where object_name='GL_EFC_UTILS_PKG';

no rows selected

Changes

Upgraded from Release 11i to Release 12.1.3

 

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
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.