Package INV_EBI_CHANGE_ORDER_PUB Compilation fails with ERROR "PLS-323" "CHECK_WORKFLOW_IN_PLM"
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.
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.
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
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