EDW_SUPPLIER_ITEM_PKG Package Is Invalid (Doc ID 1545797.1)

Last updated on FEBRUARY 10, 2017

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 <Patch 15966842>, 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




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