My Oracle Support Banner

EDW_SUPPLIER_ITEM_PKG Package Is Invalid (Doc ID 1545797.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

Oracle Procurement Intelligence - Version 11.5.10.0 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Embedded Data Warehouse

After application of some patch, the package
EDW_SUPPLIER_ITEM_PKG - poafksib.pls version 120.0 is invalid.

Errors for PACKAGE BODY EDW_SUPPLIER_ITEM_PKG

PLS-00452: Subprogram 'SUPPLIER_ITEM_FK' violates its associated pragma

ERROR
-----------------------
SQL> alter package APPS.EDW_SUPPLIER_ITEM_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> sho error
Errors for PACKAGE BODY APPS.EDW_SUPPLIER_ITEM_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3 PLS-00452: Subprogram 'SUPPLIER_ITEM_FK' violates its associated
pragma




Changes

 

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


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