Agile-Ebusiness Suite (Ebiz) Process Integration Pack (PIP): Transfer Bill of Material (BOM) From Agile to Ebiz using Engineering Change Order (ECO) - issue with DEFAULT_STRUCTURE_TYPE (Doc ID 1360336.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

Agile - Ebiz PIP 3.1/11.x

Current Behavior: An ECO containing a BOM is released from Agile to E-Business Suite, the ECO is not created due to the following error in the CreateEngineeringChangeOrderListEbizProvABCSImpl service

ERROR:

Raw Audits show the following error

...
Org Code: XXX ECO Name: C00044 Err Msg: Entity Id: BH Message Text: The Structure Type entered is not a Valid Structure Type. , Entity Id: BH Message Text: This record was not processed since a severe error occured while performing value to id conversion for assembly item P00024. , Entity Id: BO Message Text: An error occured while processing business object P00024 in organization MST. Please check the data in this business object and re-run the import process....
...

EBusiness Suite Trace shows the following

...
PARSING IN CURSOR #19 len=250 dep=1 uid=173 oct=3 lid=173 tim=1363186067826102 hv=2326302190 ad='2d77cf5d0' sqlid='bkaaqaa5aj3gf'
SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID
END OF STMT
PARSE #19:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1922647006,tim=1363186067826102
BINDS #19:
Bind#0
oacdty=01 mxl=32(26) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=01 siz=192 off=0
kxsbbbfp=2b4d6c9d0358 bln=32 avl=26 flg=05
value="BOM_STRUCTURE_TYPE_INVALID"
...
 

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