Package INV_EBI_CHANGE_ORDER_PUB Compilation fails with ERROR "PLS-323" "CHECK_WORKFLOW_IN_PLM" (Doc ID 1969313.1)

Last updated on JANUARY 27, 2017

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

Design to Release (D2R) Agile to Ebusiness Suite (EBiz) Process Integration Pack (PIP) 11.X
EBiz Version - 12.1.3

Create Engineering Change Order (ECO) flow fails in the service CreateEngineeringChangeOrderListEbizProvABCSImpl with the following error

... ORA-06508: PL/SQL: could not find program unit being called INV_EBI_CHANGE_ORDER_PUB.process_change_order_items ...

Checking INVALIDS and Compiling the INV_EBI_CHANGE_ORDER_PUB in Ebiz fails with the error
 ... Error(138,10): PLS-323: subprogram or cursor 'CHECK_WORKFLOW_IN_PLM' is declared in a package specification and must be defined in the package body ...

Steps to Reproduce:

1. Create an ECO for an Item in Agile
2. Release to EBiz
3. AIA services are invoked for integration
4. Service CreateEngineeringChangeOrderListEbizProvABCSImpl fails with the error ORA-6508
5. Checking INVALIDS in EBiz and re-compiling the package INV_EBI_CHANGE_ORDER_PUB failes with that error PLS-323 as noted.

Changes

EBiz <Patch 14306716> R12.INV.B has been applied.

Version of File INVEIHCOB.pls changed From 120.32.12010000.27 to 120.32.12010000.28

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