Agile-Ebusiness Suite (Ebiz) Process Integration Pack (PIP): Performance issue for the Engineering Change Order (ECO) Creation when submitted from Agile. (Doc ID 2199290.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

Agile-Ebiz PIP 11.x
EBusiness Suite - 12.1.3
PRODUCTION Instance

Current Behavior:
Using Agile-Ebusiness Suite PIP. CreateEngineeringChangeOrderEbizProvABCSImpl calls Integration API INV_EBI_CHANGE_ORDER_PUB which inturn calls the EGO_ITEM_PUB to create the Item and then the ECO

Performance issues are identified when submitting ECO from Agile to Ebusiness Suite.

Previously it was taking around 3 minutes to complete end to end load
BUT now, it is taking more than 1 hours to complete the same

Expected Behavior:
ECO Creation from Agile to Ebusiness Suite should complete in less time

Changes

 Conversions happened on EBusiness Suite. Count on the MTL_CROSS_REFERENCES_B table Currently : 4 million

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