Send Manufacturing BOM Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: billsOfMaterial1227.fromOA.manufacturingBOM:sendManufacturingBOM.
This service sends to the Integration Server information about the parent, component, and substitutes Manufacturing Bills of Material items as well as revisions.
Database Scripts
This service uses the following database scripts:
Script | Description |
wm_install_from_mfgbom.sql | Runs the scripts below, except the uninstall script. |
wm_from_mfgbom_vw.sql | Creates the following required view components for Manufacturing BOM outbound transactions:  WM_BOM_BILL_OF_MTLS_VW WM_BOM_ITEM_REVISIONS_VW WM_BOM_INVENTORY_COMPS_VW WM_BOM_SUBSTITUTE_COMPS_VW WM_BOM_REFERENCE_DESGS_VW WM_BOM_BILL_OF_MTLS_QRY_VW |
wm_from_mfgbom_trg.sql | Creates the following trigger components to be used for writing to the WM_TRACKCHANGES table to indicate a new/updated document: WM_BOM_BILL_OF_MTLS_IUD_TRG WM_MTL_ITEM_REV_IUD_TRG WM_BOM_INV_COMPS_IUD_TRG WM_BOM_SUB_COMPS_IUD_TRG WM_BOM_REF_DESGS_IUD_TRG |
wm_disable_from_mfgbom.sql | Disables the triggers installed by wm_from_mfgbom_trg.sql. |
wm_enable_from_mfgbom.sql | Re-enables the triggers installed by wm_from_mfgbom_trg.sql. |
wm_drop_from_mfgbom.sql | Uninstalls all components created by wm_install_from_mfgbom.sql. |
For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definition:
getManufacturingBOMTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
You can send new or changed Manufacturing Bills of Material data using the following services:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
lockTxnCtrl determines whether the
sendManufacturingBOM service is ready for execution. That is, it determines whether no other instance of this service is already in process.
If
lockTxnCtrl service returns False, it means that another instance of this service is already in process. The service exits and waits for next scheduled execution.
If
lockTxnCtrl service returns True, it means that the service is ready to execute, the Manufacturing BOM row in the control table is locked and updated, and the status is changed to INPROCESS. This prevents any other Manufacturing BOM service from executing.
getManufacturingBOMTxn queries the Oracle Applications database for any Manufacturing BOM Transaction to be processed. The number of records returned depends on the parameter value specified in the above map.
processBizDoc is the customizable step that sends the business document to a trading partner. You must customize this step to receive a Success or an Error status of the document transfer. If an error occurs in a particular business document transfer, then the error information is sent back to the calling service (
sendManufacturingBOM). The error information passed back should have the document identifiers. If a particular document is transferred successfully to the trading partner, no information needs to be sent back to the calling program (sendManufacturingBOM).
Based on the Debug Mode specified during execution, it either purges or updates the records in the WM_TRACKCHANGES custom table.
If the Debug Mode is TRUE, then based on the purge criteria, the records in the WM_TRACKCHANGES table are updated, and the PROCESSED_FLAG is set to Y. This ensures that the same set of records is not picked up during next polling interval. The
updateTrackChanges service updates the PROCESSED_FLAG in the WM_TRACKCHANGES table to Y so that same information is not picked up again during next polling instance.
If the Debug Mode is FALSE, then based on the purge criteria, the records in the WM_TRACKCHANGES table are deleted. The purgeTrackChanges service purges the records from the WM_TRACKCHANGES table.
If an error occurs when transferring the business document, the
insertTransferERRInfo service inserts a new record into the WM_TRACKCHANGES table so that same document can be picked up during the next polling interval.
Any document that is created and deleted in between two successive polling operations will not be delivered. Such records are not selected by
getManufacturingBOMTxn service; thus they are not updated as processed or purged in the WM_TRACKCHANGES table.
If the Debug Mode is TRUE, then
updateUnqualifiedRec service recognizes such records and updates the corresponding PROCESSED_FLAG to Y.
If the Debug Mode is FALSE, then the
purgeUnqualifiedRec service recognizes such records and deletes them from the WM_TRACKCHANGES table.
unlockTxnCtrl releases the lock on the Custom Control table so that next polling instance of sendManufacturingBOM service can begin.
If the document transfer is successful, the flow exits.
Business Document Structure
This service uses the following business document structure:
1.0. BOM_BILL_OF_MTLS
1.1. MTL_ITEM_REVISIONS
1.2. BOM_INVENTORY_COMPS
1.2.1. BOM_SUB_COMPS
1.2.2. BOM_REF_DESGS
1.0. BOM_BILL_OF_MTLS
Document Field | Oracle Applications Table/View Name | Column Name | Description |
WEB_
TRANSACTION_
ID | | | |
DOCUMENT_
TYPE | | | MFGBOM will be populated in this field. |
DOCUMENT_
STATUS | | | UPDATE, INSERT or DELETE will be populated in this field. |
BILL_
SEQUENCE_
ID | BOM_BILL_OF_
MATERIALS | BILL_
SEQUENCE_
ID | Unique identifier for bill. |
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Concatenated segments. |
ORGANIZATION_
NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | |
COMMON_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Concatenated segments for common bill item. |
COMMON_
ORG_NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | Organization name for common bill. |
ALTERNATE_
BOM_
DESIGNATOR | BOM_BILL_OF_
MATERIALS | ALTERNATE_
BOM_
DESIGNATOR | Alternate Bill of Materials designator code. |
SPECIFIC_
ASSEMBLY_
COMMENT | BOM_BILL_OF_
MATERIALS | SPECIFIC_
ASSEMBLY_
COMMENT | Specific Bill of Materials comment. |
PENDING_
FROM_
ECN | BOM_BILL_OF_
MATERIALS | PENDING_
FROM_
ECN | Change notice that created this Bill of Materials. |
ASSEMBLY_
TYPE | BOM_BILL_OF_
MATERIALS | ASSEMBLY_
TYPE | For Manufacturing/Engineering. |
DEMAND_
SOURCE_
LINE | | | Not used for Bills of Material outbound transactions. |
SET_ID | | | Not used for Bills of Material outbound transactions. |
DEMAND_
SOURCE_
TYPE | | | Not used for Bills of Material outbound transactions. |
DEMAND_
SOURCE_
HEADER_ID | | | Not used for Bills of Material outbound transactions. |
NEXT_
EXPLODE_
DATE | BOM_BILL_
OF_MATERIALS | NEXT_
EXPLODE_
DATE | Next date when pre- explosion will be refreshed. |
TRANSACTION_
TYPE | | | Not used for Bills of Material outbound transactions. |
REVISION | | | Not used for Bills of Material outbound transactions. |
UOM | MTL_UNITS_OF_
MEASURE_TL | UNIT_OF_
MEASURE | Unit of measure. |
IMPLEMENTATION_
DATE | BOM_BILL_OF_
MATERIALS | IMPLEMENTATION_
DATE | Implementation date. |
1.1 MTL_ITEM_REVISIONS
Document Field | Oracle Applications Table/View Name | Column Name | Description |
BILL_
SEQUENCE_
ID | BOM_
INVENTORY_
COMPONENTS | BILL_
SEQUENCE_
ID | Unique bill identifier. |
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Concatenated segments. |
ORGANIZATION_
NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | |
REVISION | MTL_ITEM_
REVISIONS | REVISION | Item revision code. |
CHANGE_
NOTICE | MTL_ITEM_
REVISIONS | CHANGE_
NOTICE | Engineering change order number. |
ECN_
INITIATION_
DATE | MTL_ITEM_
REVISIONS | ECN_
INITIATION_
DATE | Engineering change order Initiation date. |
IMPLEMENTATION_
DATE | MTL_ITEM_
REVISIONS | IMPLEMENTATION_
DATE | Engineering change order implementation date. |
EFFECTIVITY_
DATE | MTL_ITEM_
REVISIONS | EFFECTIVITY_
DATE | Revision effective date. |
REVISED_
ITEM_
SEQUENCE_
ID | MTL_ITEM_
REVISIONS
| REVISED_
ITEM_
SEQUENCE_
ID | Revised item sequence ID. |
TRANSACTION_
TYPE | | | Not used for Bills of Material outbound transactions. |
REVISION_
LABEL | MTL_ITEM_
REVISION | REVISION_
LABEL | Revision label. (This field is in the table but not shown in the Designer; it is for future use.) |
REVISION_
REASON | MTL_ITEM_
REVISION | REVISION_
REASON | Revision reason. (This field is in the table but not shown in the Designer; it is for future use.) |
1.2 BOM_INVENTORY_COMPS
Document Field | Oracle Applications Table/View Name | Column Name | Description |
COMPONENT_
SEQUENCE_
ID | BOM_
INVENTORY_
COMPONENTS | COMPONENT_
SEQUENCE_
ID | Unique component identifier. |
BILL_
SEQUENCE_
ID | BOM_
INVENTORY_
COMPONENTS | BILL_
SEQUENCE_
ID | Unique bill identifier. |
ASSEMBLY_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Inventory item number of manufactured assembly. |
ALTERNATE_
BOM_
DESIGNATOR | BOM_BILL_
OF_MATERIALS | ALTERNATE_
BOM_
DESIGNATOR | Alternate Bill of Materials designator code. |
ORGANIZATION_
NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | |
COMPONENT_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | |
OPERATION_
SEQ_NUM | BOM_
INVENTORY_
COMPONENTS | OPERATION_
SEQ_NUM | Operation sequence number. |
EFFECTIVITY_
DATE | BOM_
INVENTORY_
COMPONENTS | EFFECTIVITY_
DATE | Effective date. |
LOCATION_
NAME | MTL_ITEM_
LOCATIONS | DESCRIPTION | Supply locator name. |
SUBSTITUTE_
COMPONENT_
NUMBER | | | Not used for Bills of Material outbound transactions. |
ITEM_
NUM | BOM_
INVENTORY_
COMPONENTS | ITEM_
NUM | Item sequence within Bill of Materials structure. |
COMPONENT_
QUANTITY | BOM_
INVENTORY_
COMPONENTS | COMPONENT_
QUANTITY | Quantity of component in Bill of Materials. |
COMPONENT_
YIELD_FACTOR | BOM_
INVENTORY_
COMPONENTS | COMPONENT_
YIELD_
FACTOR | Multiple this factor with component quantity to obtain required component quantity. |
COMPONENT_
REMARKS | BOM_
INVENTORY_
COMPONENTS | COMPONENT_
REMARKS | Component remarks. |
CHANGE_
NOTICE | BOM_
INVENTORY_
COMPONENTS | CHANGE_
NOTICE | Engineering change order number. |
IMPLEMENTATION_
DATE | BOM_
INVENTORY_
COMPONENTS | IMPLEMENTATION_
DATE | Date when engineering change order was implemented. |
DISABLE_
DATE | BOM_
INVENTORY_
COMPONENTS | DISABLE_
DATE | |
PLANNING_
FACTOR | BOM_
INVENTORY_
COMPONENTS | PLANNING_
FACTOR | Multiple this factor with component quantity to obtain required planning quantity. |
QUANTITY_
RELATED | BOM_
INVENTORY_
COMPONENTS | QUANTITY_
RELATED | Identifier to indicate if this component has quantity-related reference designators. |
SO_BASIS | BOM_
INVENTORY_
COMPONENTS | SO_
BASIS | Quantity basis used by Oracle Order Management to determine how many units of component to put on an order. |
OPTIONAL | BOM_
INVENTORY_
COMPONENTS | OPTIONAL | Indicates whether component is optional in bill. |
MUTUALLY_
EXCLUSIVE_
OPTIONS | BOM_
INVENTORY_
COMPONENTS | MUTUALLY_
EXCLUSIVE_
OPTIONS | Indicates whether one or more children of the component can be picked when taking an order. |
INCLUDE_IN_
COST_ROLLUP | BOM_
INVENTORY_
COMPONENTS | INCLUDE_IN_
COST_ROLLUP | Indicates whether to use this component when rolling up costs. |
CHECK_
ATP | BOM_
INVENTORY_
COMPONENTS | CHECK_
ATP | Indicates if ATP check is required. |
SHIPPING_
ALLOWED | BOM_
INVENTORY_
COMPONENTS | SHIPPING_
ALLOWED | Indicates if component is allowed to ship. |
REQUIRED_
TO_SHIP | BOM_
INVENTORY_
COMPONENTS | REQUIRED_
TO_SHIP | Indicates if component is required to ship. |
REQUIRED_
FOR_
REVENUE | BOM_
INVENTORY_
COMPONENTS | REQUIRED_
FOR_
REVENUE | Indicates if component is required for revenue. |
INCLUDE_ON_
SHIP_DOCS | BOM_
INVENTORY_
COMPONENTS | INCLUDE_ON_
SHIP_DOCS | Indicates if component is displayed on shipping documents. |
LOW_
QUANTITY | BOM_
INVENTORY_
COMPONENTS | LOW_
QUANTITY
| Minimum quantity allowed on an order. |
HIGH_
QUANTITY | BOM_
INVENTORY_
COMPONENTS | HIGH_
QUANTITY | Maximum quantity allowed on an order. |
ACD_TYPE | BOM_
INVENTORY_
COMPONENTS | ACD_TYPE | Add, change, or disable code for component on an engineering change order. |
REVISED_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | |
REVISION | MTL_ITEM_
REVISIONS | REVISION | |
OLD_
OPERATION_
SEQ_NUM | BOM_
INVENTORY_
COMPONENTS | OPERATION_
SEQ_NUM | Operation sequence number in the original component record that an engineering change order affects. |
OLD_
EFFECTIVITY_
DATE | BOM_
INVENTORY_
COMPONENTS | EFFECTIVITY_
DATE | Value of effective date in the original component record that an engineering change order affects. |
WIP_SUPPLY_
TYPE | BOM_
INVENTORY_
COMPONENTS | WIP_SUPPLY_
TYPE | WIP supply type code. |
SUPPLY_
SUBINVENTORY | BOM_
INVENTORY_
COMPONENTS | SUPPLY_
SUBINVENTORY | |
REFERENCE_
DESIGNATOR | | | Not used for Bills of Material outbound transactions. |
NEW_
OPERATION_
SEQ_NUM | | | Not used for Bills of Material outbound transactions. |
NEW_
EFFECTIVITY_
DATE | | | Not used for Bills of Material outbound transactions. |
BOM_ITEM_
TYPE | BOM_
INVENTORY_
COMPONENTS | BOM_ITEM_
TYPE | Type of item (de- normalized from BOM Item Type in MTL_SYSTEM_ITEMS). |
OPERATION_
LEAD_TIME_
PERCENT | BOM_
INVENTORY_
COMPONENTS | OPERATION_
LEAD_TIME_
PERCENT | Operation offset from first operation in routing. |
ASSEMBLY_
TYPE | BOM_BILL_OF_
MATERIALS | ASSEMBLY_
TYPE | Assembly type of the parent bill. |
INTERFACE_
ENTITY_TYPE | BOM_BILL_OF_
MATERIALS | DECODE
(BOM.ASSEMBLY_
TYPE, 1,'BILL',2,'ECO', NULL) | Use Bill or ECO. |
TRANSACTION_
TYPE | | | Not used for Bills of Material outbound transactions. |
UOM | MTL_UNITS_OF_
MEASURE_TL | UNIT_OF_
MEASURE | Unit of measure. |
AUTO_
REQUEST_
MATERIAL | BOM_
INVENTORY_
COMPONENTS | AUTO_
REQUEST_
MATERIAL | Auto request material (Y/N). |
1.2.1 BOM_SUB_COMPS
Document Field | Oracle Applications Table/View Name | Column Name | Description |
SUBSTITUTE_
COMP_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Substitute component number. |
SUBSTITUTE_
ITEM_
QUANTITY | BOM_
SUBSTITUTE_
COMPONENTS | SUBSTITUTE_
ITEM_
QUANTITY | Substitute component quantity. |
ACD_
TYPE | BOM_
SUBSTITUTE_
COMPONENTS | ACD_
TYPE | ADD or DELETE code on an engineering change order. |
CHANGE_
NOTICE | BOM_
SUBSTITUTE_
COMPONENTS | CHANGE_
NOTICE | Engineering change order number. |
ORGANIZATION_
NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | |
ASSEMBLY_
ITEM_NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Inventory item number of manufactured assembly. |
ALTERNATE_
BOM_
DESIGNATOR | BOM_BILL_OF_
MATERIALS | ALTERNATE_
BOM_
DESIGNATOR | Alternate Bill of Materials designator code. |
COMPONENT_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | Inventory item number of component. |
OPERATION_SEQ_
NUM | BOM_INVENTORY_
COMPONENTS | OPERATION_SEQ_
NUM | Manufacturing operation sequence number. |
EFFECTIVITY_
DATE | BOM_INVENTORY_
COMPONENTS | EFFECTIVITY_DATE | Effective date. |
NEW_SUB_
COMP_NUMBER | | | Not used for Bills of Material outbound transactions. |
INTERFACE_
ENTITY_
TYPE | BOM_BILL_OF_
MATERIALS | DECODE
(BOM.ASSEMBLY_
TYPE, 1,'BILL', 2,'ECO', NULL) | Inventory item type. |
TRANSACTION_
TYPE | | | Not used for Bills of Material outbound transactions. |
UOM | MTL_UNITS_OF_
MEASURE_TL | UNIT_OF_
MEASURE | Unit of measure. |
1.2.2 BOM_REF_DESGS
Document Field | Oracle Applications Table/View Name | Column Name | Description |
COMPONENT_
REFERENCE_
DESIGNATOR | BOM_
REFERENCE_
DESIGNATORS | COMPONENT_
REFERENCE_
DESIGNATOR | Component reference designator. |
ORGANIZATION_
NAME | HR_ALL_
ORGANIZATION_
UNITS | NAME | |
ASSEMBLY_
ITEM_
NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | |
ALTERNATE_
BOM_
DESIGNATOR | BOM_BILL_OF_
MATERIALS | ALTERNATE_
BOM_
DESIGNATOR | Alternate Bill of Materials identifier. |
COMPONENT_
ITEM_NUMBER | MTL_SYSTEM_
ITEMS_B_KFV | CONCATENATED_
SEGMENTS | |
OPERATION_
SEQ_NUM | BOM_
INVENTORY_
COMPONENTS | OPERATION_
SEQ_NUM | Manufacturing operation sequence number. |
EFFECTIVITY_
DATE | BOM_
INVENTORY_
COMPONENTS | EFFECTIVITY_
DATE | Date when functionality will be enabled. |
REF_
DESIGNATOR_
COMMENT | BOM_
REFERENCE_
DESIGNATORS | REF_
DESIGNATOR_
COMMENT | Reference designator comment. |
CHANGE_
NOTICE | BOM_
REFERENCE_
DESIGNATORS | CHANGE_
NOTICE | Engineering change order number. |
ACD_TYPE | BOM_
REFERENCE_
DESIGNATORS | ACD_TYPE | ADD or DELETE code on an engineering change order. |
NEW_
DESIGNATOR | | | Not used for Bills of Material outbound transactions. |
INTERFACE_
ENTITY_TYPE | BOM_BILL_OF_
MATERIALS | DECODE
(BOM.ASSEMBLY_
TYPE, 1,'BILL', 2,'ECO', NULL) | Use Bill or ECO. |
TRANSACTION_
TYPE | | | Not used for Bills of Material outbound transactions. |