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
|