Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Oracle Applications API and OIT Structures > Create and Change BOM
  
Create and Change BOM
The following API structure tables list all the APIs and the respective API fields that are required to create BOMs within the current version of Oracle Applications distribution targets.
API Name = Bill of Material Business Object Interface
The Bill of Material (BOM) Business Object Interface (BOI) is invoked to create and change BOMs in Oracle. The BOM API is designed so that objects within one BOM are entered into the API by referencing each other through the common business relationships. There are five main areas of the BOM API:
1. BOM Header
2. BOM Components
3. BOM Substitutes
4. BOM Reference Designators
5. BOM Revision (This section of the BIO will not be populated. Revisions will be created via the Item OIT)
All calls to the BOM API require the BOM Header to be populated. BOM Components, BOM Substitutes, and BOM Reference Designators are repeating structures, whereas you may only have one BOM Header.
Windchill Attribute Name
API Structure
API Field
Value If Default
Source
Transform
Transaction ID
TIB_INT _BOM_ API_HD R
TIBCO_Key
Transaction ID + Time stamp
Windchill/ TIBCO
Concatenate
Assembly Part Number
TIB_INT _BOM_ API_HD R
ASSEMBLY_ITEM_ NAME
N/A
Windchill
N/A
Distribution Target
TIB_INT _BOM_ API_HD R
ORGANIZATION_ CODE
N/A
Windchill
Sub-string
BOM Usage
TIB_INT _BOM_ API_HD R
ASSEMBLY_TYPE
If Usage is blank then the value is set to “1”
If value is blank then the default is used. If not, a cross reference value is used.
N/A
BOM Alternate
TIB_INT _BOM_ API_HD R
ALternate_BOM_Code
N/A
Windchill
N/A
(Action flag)
TIB_INT _BOM_ API_HD R
TRANSACTION_ TYPE
"CREATE"
Cross Reference
N/A
Transaction ID
TIB_INT _BOM_ API_INV _COMP
TIBCO_KEY
Transaction ID + time Stamp
Windchill/ TIBCO
Concatenate
Distribution Target
TIB_INT _BOM_ API_INV _COMP
ORGANIZATION_ CODE
N/A
Windchill
Sub-string
Assembly Part Number
TIB_INT _BOM_ API_INV _COMP
ASSEMBLY_ITEM_ NAME
N/A
Windchill
N/A
Start Effective Date
TIB_INT _BOM_ API_INV _COMP
START_EFFECTIVE_ DATE
N/A
Windchill/ Oracle (For Create and Change this date is from Windchill- for delete, the value is queried from Oracle)
N/A
N/A
TIB_INT _BOM_ API_INV _COMP
OPERATION_ SEQUENCE_ NUMBER
1
Windchill
OperationBOMAl locatePart will be considered as BOM component.
(Component) Part Number
TIB_INT _BOM_ API_INV _COMP
COMPONENT_ ITEM_NAME
N/A
Windchill
N/A
Line Number
TIB_INT _BOM_ API_INV _COMP
ITEM_SEQUENCE_ NUMBER
N/A
Windchill
N/A
(Component) Quantity
TIB_INT _BOM_ API_INV _COMP
QUANTITY_PER_ ASSEMBLY
N/A
Windchill
N/A
(Action Flag)
TIB_INT _BOM_ API_INV _COMP
TRANSACTION_ TYPE
"CREATE" "UPDATE"
Cross Reference
N/A
Start Effective Date
TIB_INT _BOM_ API_INV _COMP
DISABLE_DATE
N/A
Windchill
N/A
N/A
TIB_INT _BOM_ API_SU BS_CO MP
TIBCO_KEY
Transaction ID + time Stamp
Windchill/ TIBCO
N/A
Distribution Target
TIB_INT _BOM_ API_SU BS_CO MP
ORGANIZATION_ CODE
N/A
Windchill
Sub-string
Assembly Part Number
TIB_INT _BOM_ API_SU BS_CO MP
ASSEMBLY_ITEM_ NAME
N/A
Windchill
N/A
Start Effective Date
TIB_INT _BOM_ API_SU BS_CO MP
START_EFFECTIVE_ DATE
N/A
Windchill
N/A
N/A
TIB_INT _BOM_ API_SU BS_CO MP
OPERATION_ SEQUENCE_ NUMBER
1
Default
N/A
(Component) Part Number
TIB_INT _BOM_ API_SU BS_CO MP
COMPONENT_ ITEM_NAME
N/A
Windchill
N/A
Substitute Part Number
TIB_INT _BOM_ API_SU BS_CO MP
SUBSTITUTE_ ITEM_NAME
N/A
Windchill
N/A
(Substitute) Quantity
TIB_INT _BOM_ API_SU BS_CO MP
SUBSTITUTE_ ITEM_QUANTITY
N/A
Windchill
N/A
(Action flag)
TIB_INT _BOM_ API_SU BS_CO MP
TRANSACTION_ TYPE
"CREATE" "DELETE"
Cross Reference
N/A
N/A
Oracle
TIBCO_KEY
Transaction ID + time Stamp
Windchill/ TIBCO
N/A
Distribution Target
TIB_INT _BOM_ API_REF _DESG
ORGANIZATION_ CODE
N/A
Windchill
Sub-string
Assembly Part Number
TIB_INT _BOM_ API_REF _DESG
ASSEMBLY_ITEM_ NAME
N/A
Windchill
N/A
Start Effectivity Date
TIB_INT _BOM_ API_REF _DESG
START_EFFECTIVE _DATE
N/A
Windchill
N/A
N/A
TIB_INT _BOM_ API_REF _DESG
OPERATION_ SEQUENCE_ NUMBER
1
Default
N/A
(Component) Part Number
TIB_INT _BOM_ API_REF _DESG
COMPONENT_ ITEM_NAME
N/A
Windchill
N/A
Reference Designator
TIB_INT _BOM_ API_REF _DESG
REFERENCE_ DESIGNATOR_ NAME
N/A
Windchill
N/A
N/A
TIB_INT _BOM_ API_REF _DESG
TRANSACTION_ TYPE
"CREATE" "DELETE"
Default
N/A
* 
The following API Structures are not used by default:
TIB_INT_BOM_API_ITM_REV
TIB_INT_BOM_API_COMP_OPS