Receive Bills and Route Service

Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Manufacturing Predefined Transaction Services | Receive Bills and Route Service

This service is in the WmOAMFG1227 package and has the following fully-qualified service name: billsOfMaterial1227.intoOA.billsAndRoute:receiveBillsAndRoute.

This service creates, updates, and deletes Manufacturing and Engineering Bills of Material and product families. Based on the attributes of the parent item, the program creates planning, model, option class, and standard Bills of Material.

Database Scripts

This service uses the following database scripts:

Script	Description
wm_install_into_bom.sql	Runs the scripts listed below, except the uninstall script.
wm_into_bom_pkg.sql	Installs WM_BOM_IMP_HANDLER_PKG.WM_HANDLE_BOM, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT procedure to submit the Bills and Routing Import process.
wm_drop_into_bom.sql	Uninstalls all components created by wm_install_into_bom.sql.

For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service uses services defined in the following transaction definitions:

setBillsAndRouteTxn1227.txp

BillsAndRouteTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

This service uses the following flow steps to import Bills of Material transactions:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.

bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables). This service uses the following services internally to provide required data feed during the mapping:

getOrgId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORGANIZATION_NAME as the input parameter, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID corresponding to the ORGANIZATION_NAME.

commonLookup is a transformer for mapping the business document IData structure to the line interface IData structure. This finds the lookup code for the particular lookup type.

convertToDateObject converts the text date format into object date format. This is a transformer in the bizDocMapping.

getRevisedItemSeqId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes REVISED_ITEM_NUM, REVISION and ORG_NAME as input parameters to get the corresponding REVISED_ITEM_SEQUENCE_ID.

bomItemTypeLookup is a transformer for mapping the business document IData structure to the line interface IData structure. This finds the lookup code for the particular lookup type BOM_ITEM_TYPE.

getCommonRtgSeqId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes COMMON_ITEM_NUMBER, COMMON_ORG_NAME, and ALT_RTG_DSG as input parameters to get the corresponding ROUTING_SEQUENCE_ID.

getComponentSeqId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ASSEMBLY_ITEM_NUMBER, ITEM_COMPONENT_NUMBER, OPERATION_SEQ_NUM, EFFECTIVE_DATE, ORG_NAME, and ALT_BOM_DSG as input parameters to get the corresponding COMPONENT_ SEQUENCE_ID.

setBillsAndRouteTxn inserts data into the Bills and Route interface tables.

importBillsAndRoute imports data to the production table from the interface table. To monitor the import process, it then sequentially invokes the services execBillsAndRouteConcProg, checkBillsAndRouteImportStatus, and getBillsAndRouteImport_ERR. If the status of execution is FAILED, this step maps the dbErrorMsg and concProgMsg record list. Otherwise, it checks for data errors that occurred during the import, and maps them to errorsDoc.

execBillsAndRouteConcProg inserts data into the production table. It picks up data from the Interface tables corresponding to Bills And Route Interface and inserts data into the production tables.

checkBillsAndRouteImportStatus queries the MTL_INTERFACE_ERRORS table to find the number of erroneous rows for the passed REQUEST ID.

getBillsAndRouteImport_ERR gets the error message that occurs during the data import to the production table from the interface table.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

Business Document Structure

This service uses the business document BOMBizDoc. Its structure is as follows:

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

2.0. BOM_OP_ROUTINGS

2.1. MTL_RTG_ITEM_REVS

2.2. BOM_OP_SEQUENCES

2.2.1. BOM_OP_RESOURCES

1.0. BOM_BILL_OF_MTLS (Maps to BOM_BILL_OF_MTLS_INTERFACE)

Field Name	Maps to Column	Description
BILL_SEQUENCE_ID		Not used for Bills of Material inbound transactions.
ITEM_NUMBER	ITEM_NUMBER	Required. Concatenated segments.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
COMMON_ITEM_NUMBER	COMMON_ITEM_NUMBER	Required if referencing a common Bill of Materials.
COMMON_ORG_NAME	COMMON_ORGANIZATION_ ID	Required if referencing a common Bill of Materials. Use HR_ALL_ ORGANIZATION _UNITS to derive COMMON_ ORGANIZATION_ID.
ALTERNATE_BOM_DESIGNATOR	ALTERNATE_BOM_DESIGNATOR	Required if creating an alternate Bill of Materials.
SPECIFIC_ASSEMBLY_COMMENT	SPECIFIC_ASSEMBLY_COMMENT	Specific assembly comment about Bill of Materials.
PENDING_FROM_ECN	PENDING_FROM_ECN	Engineering Change notice that created this Bill of Materials.
ASSEMBLY_TYPE	ASSEMBLY_TYPE	Required for Create. Use: 1 for Manufacturing. 2 for Engineering.
DEMAND_SOURCE_LINE	DEMAND_SOURCE_LINE	For ATO.
SET_ID	SET_ID	Set identifier for ATO.
DEMAND_SOURCE_TYPE	DEMAND_SOURCE_TYPE	For ATO.
DEMAND_SOURCE_ HEADER_ID	DEMAND_SOURCE_ HEADER_ID	Demand source header identifier.
NEXT_EXPLODE_DATE	NEXT_EXPLODE_DATE	Next date when pre- explosion will be refreshed.
REVISION	REVISION	Bill revision.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Create. Update. Delete.
UOM		Not used for Bills of Material inbound transactions.

1.1. MTL_ITEM_REVISIONS (Maps to MTL_ITEM_REVISIONS_INTERFACE)

Field Name	Maps to Column	Description
BILL_SEQUENCE_ID		Not used for Bills of Material inbound transactions.
ITEM_NUMBER	ITEM_NUMBER	Required. Concatenated segments.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_UNITS to derive ORGANIZATION_ID.
REVISION	REVISION	Required. Item revision code.
CHANGE_NOTICE	CHANGE_NOTICE	Engineering change order number.
ECN_INITIATION_DATE	ECN_INITIATION_DATE	Engineering Change order initiation date.
IMPLEMENTATION_DATE	IMPLEMENTATION_DATE	Engineering change order implementation date.
EFFECTIVITY_DATE	EFFECTIVITY_DATE	Revision effective date.
REVISED_ITEM_ SEQUENCE_ID	REVISED_ITEM_ SEQUENCE_ID	Revised Item sequence ID.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Create. Update. Delete.

1.2. BOM_INVENTORY_COMPS (Maps to BOM_INVENTORY_COMPS_INTERFACE)

Field Name	Maps to Column	Description
BILL_SEQUENCE_ID		Not used for Bills of Material inbound transactions.
ASSEMBLY_ITEM_ NUMBER	ASSEMBLY_ITEM_ NUMBER	Required. Inventory item number of manufactured assembly.
ALTERNATE_BOM_ DESIGNATOR	ALTERNATE_BOM_ DESIGNATOR	Required if alternate Bill of Materials.
REFERENCE_DESIGNATOR	REFERENCE_ DESIGNATOR	Component reference designator.
ORGANIZATION_NAME	ORGANIZATION_ ID	Required. Use HR_ALL_ ORGANIZATION_UNITS to derive ORGANIZATION_ID.
COMPONENT_ITEM_ NUMBER	COMPONENT_ITEM_ NUMBER	Required.
OPERATION_SEQ_ NUM	OPERATION_SEQ_ NUM	Required. Operation sequence number.
ITEM_ NUM	ITEM_ NUM	Item sequence within Bill of Materials structure.
EFFECTIVITY_DATE	EFFECTIVITY_ DATE	Required. Effective date.
LOCATION_NAME	LOCATION_ NAME	Supply locator name.
SUBSTITUTE_COMP_ NUMBER	SUBSTITUTE_COMP_ NUMBER	Concatenated item segments of the substitute component.
COMPONENT_QUANTITY	COMPONENT_ QUANTITY	Required. Quantity of component in Bill of Materials.
COMPONENT_ YIELD_FACTOR	COMPONENT_ YIELD_FACTOR	Required. Factor used to multiply component quantity with to obtain required component quantity.
COMPONENT_REMARKS	COMPONENT_ REMARKS
CHANGE_NOTICE	CHANGE_ NOTICE	Engineering change order number.
IMPLEMENTATION_DATE	IMPLEMENTATION_ DATE	Date on which engineering change order was implemented.
DISABLE_DATE	DISABLE_ DATE
PLANNING_FACTOR	PLANNING_ FACTOR	Required. Factor used to multiply component quantity with to obtain planning quantity.
QUANTITY_RELATED	QUANTITY_ RELATED	Required. Indicates whether this component has quantity related reference designators. Use: 1 for Yes. 2 for No.
SO_BASIS	SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order. Use: 1 for Yes. 2 for No.
OPTIONAL	OPTIONAL	Flag indicating if component is optional in bill. Use: 1 for Yes. 2 for No.
MUTUALLY_ EXCLUSIVE_OPTIONS	MUTUALLY_ EXCLUSIVE_ OPTIONS	Flag indicating if one or more children of component can be picked when taking an order. Use: 1 for Yes. 2 for No.
INCLUDE_IN_COST_ ROLLUP	INCLUDE_IN_ COST_ROLLUP	Required. Flag indicating if this component is to be used when rolling up costs. Use: 1 for Yes. 2 for No.
CHECK_ATP	CHECK_ATP	Required. Flag indicating if ATP check is required. Use: 1 for Yes. 2 for No.
SHIPPING_ ALLOWED	SHIPPING_ ALLOWED	Flag indicating if component is allowed to ship. Use: 1 for Yes. 2 for No.
REQUIRED_TO_ SHIP	REQUIRED_TO_ SHIP	Flag indicating if component is required to ship. Use: 1 for Yes. 2 for No.
REQUIRED_FOR_ REVENUE	REQUIRED_FOR_ REVENUE	Flag indicating if component is required for revenue. Use: 1 for Yes. 2 for No.
INCLUDE_ON_ SHIP_DOCS	INCLUDE_ON_ SHIP_DOCS	Flag indicating if component is displayed on shipping documents. Use: 1 for Yes. 2 for No.
LOW_QUANTITY	LOW_QUANTITY	Minimum quantity allowed on an order.
HIGH_QUANTITY	HIGH_QUANTITY	Maximum quantity allowed on an order.
ACD_TYPE	ACD_TYPE	Set action for component on an engineering change order. Use: 1 for Add. 2 for Change. 3 for Disable.
REVISED_ITEM_NUMBER	REVISED_ITEM_ SEQUENCE_ID	Revised Item Number, Organization Name, and version gets REVISED_ITEM_SEQUENCE_ID.
REVISION
OLD_OPERATION_ SEQ_NUM	OLD_ COMPONENT_ SEQUENCE_ID	Operation sequence number and value of effective date in the original component record that an Engineering Change Order (ECO) affects uses to get the identifier of original component row an ECO effects.
OLD_EFFECTIVITY_DATE
WIP_SUPPLY_TYPE	WIP_SUPPLY_TYPE	WIP supply type code. Use: 1 for Push. 2 for Assembly Pull. 3 for Operation Pull. 4 for Bulk. 5 for Supplier. 6 for Phantom. 7 for Based on Bill.
SUPPLY_SUBINVENTORY	SUPPLY_SUBINVENTORY
NEW_OPERATION_ SEQ_NUM	NEW_OPERATION_SEQ_NUM	Updated value for the operation_seq_num.
NEW_EFFECTIVITY_DATE	NEW_EFFECTIVITY_DATE	Updated value for the effective date.
BOM_ITEM_TYPE	BOM_ITEM_TYPE	Type of item (de-normalized from BOM Item Type in MTL_SYSTEM_ITEMS). Use: 1 for Model. 2 for Option class. 3 for Planning. 4 for Standard. 5 for Product Family.
OPERATION_LEAD_ TIME_PERCENT	OPERATION_LEAD_ TIME_PERCENT	Operation offset from first operation in routing.
ASSEMBLY_TYPE	ASSEMBLY_TYPE	Assembly type of the parent bill.
INTERFACE_ENTITY_ TYPE	INTERFACE_ ENTITY_TYPE	Record used for Bill or Engineering Change Order open interface. Use BILL or ECO.
TRANSACTION_ TYPE	TRANSACTION_ TYPE	Required. Use: Create. Update. Delete.
UOM		Not used in Bills of Material inbound transactions.

1.2.1. BOM_SUB_COMPS (Maps to BOM_SUB_COMPS_INTERFACE)

Field Name	Maps to Column	Description
BILL_SEQUENCE_ID		Not used for Bills of Material inbound transactions.
SUBSTITUTE_COMPONENT_ NUMBER	SUBSTITUTE_COMP_ NUMBER	Required.
SUBSTITUTE_ITEM_ QUANTITY	SUBSTITUTE_ITEM_ QUANTITY	Required.
ACD_TYPE	ACD_TYPE	Indicates add or delete for an engineering change order.
CHANGE_NOTICE	CHANGE_NOTICE	Engineering change order number.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
ASSEMBLY_ITEM_NUMBER	COMPONENT_ SEQUENCE_ID	Required. Inventory item number of manufactured assembly, alternate Bill of Materials designator code, inventory item number of component, manufacturing operation sequence number, effective date, and ORGANIZATION_ NAME derive COMPONENT_ SEQUENCE_ID.
ALTERNATE_BOM_DESIGNATOR
COMPONENT_ITEM_NUMBER
OPERATION_SEQ_NUM
EFFECTIVITY_DATE
NEW_SUB_COMP_NUMBER	NEW_SUB_COMP_NUMBER	New substitute component number.
INTERFACE_ENTITY_TYPE	INTERFACE_ENTITY_TYPE	Inventory item type.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Create. Update. Delete.
UOM		Not used in Bill of Material inbound transactions.

1.2.2. BOM_REF_DESGS (Maps to BOM_REF_DESGS_INTERFACE)

Field Name	Maps to Column	Description
BILL_SEQUENCE_ID		Not used for Bill of Material inbound transactions.
COMPONENT_REFERENCE_ DESIGNATOR	COMPONENT_ REFERENCE_ DESIGNATOR	Required.
REF_DESIGNATOR_ COMMENT	REF_DESIGNATOR_ COMMENT	Reference designator comment.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
ASSEMBLY_ITEM_NUMBER	COMPONENT_ SEQUENCE_ID	Required. Assembly item number, alternate Bill of Materials identifier, manufacturing operation sequence number, date on which functionality will be enabled, and ORGANIZATION_CODE derive COMPONENT_ SEQUENCE_ID.
ALTERNATE_BOM_DESIGNATOR
COMPONENT_ITEM_NUMBER
OPERATION_SEQ_NUM
EFFECTIVITY_DATE
CHANGE_NOTICE	CHANGE_NOTICE	Engineering change order number.
ACD_TYPE	ACD_TYPE	Set the action for a engineering change order by using: 1 for Add. 2 for Change. 3 for Disable.
NEW_DESIGNATOR	NEW_DESIGNATOR	Updated value for the old reference designator.
INTERFACE_ENTITY_TYPE	INTERFACE_ ENTITY_TYPE	Record used for Bill or engineering change order open interface. Use: BILL. ECO.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Create. Update. Delete.

2.0. BOM_OP_ROUTINGS (Maps to BOM_OP_ROUTINGS _INTERFACE)

Field Name	Maps to Column	Description
ROUTING_SEQUENCE_ID	ROUTING_SEQUENCE_ID
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
ASSEMBLY_ITEM_NUMBER	ASSEMBLY_ITEM_NUMBER	Required. Concatenated item segments.
ALTERNATE_ROUTING_ DESIGNATOR	ALTERNATE_ROUTING_ DESIGNATOR	Required to identify alternate Bill of Materials.
ROUTING_TYPE	ROUTING_TYPE	Required for Insert. Use: 1 for Manufacturing. 2 for Engineering.
COMMON_ITEM_NUMBER	COMMON_ITEM_NUMBER	Concatenated item segments of the common routing.
COMMON_ORG_NAME	COMMON_ROUTING_ SEQUENCE_ID	Derived from columns COMMON_ITEM_NUMBER,COMMON_ORG_NAME, and ALTERNATE_ROUTING_ DESIGNATOR.
ROUTING_COMMENT	ROUTING_COMMENT
COMPLETION_ SUBINVENTORY	COMPLETION_ SUBINVENTORY	Destination subinventory for assembly.
DEMAND_SOURCE_LINE	DEMAND_SOURCE_LINE	Demand source line used for ATO.
SET_ID	SET_ID	Set identifier used for ATO.
PROCESS_REVISION	PROCESS_REVISION	Routing revision.
DEMAND_SOURCE_TYPE	DEMAND_SOURCE_TYPE	Demand source type used for ATO.
DEMAND_SOURCE_ HEADER_ID	DEMAND_SOURCE_ HEADER_ID	Demand source header identifier used for ATO.
LOCATION_NAME	LOCATION_NAME	Concatenated location segments.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Insert. Update. Delete.
LINE_CODE	LINE_CODE	Name of WIP line.
MIXED_MODEL_ MAP_FLAG	MIXED_MODEL_ MAP_FLAG	Use this routing in mixed model map calculations. Use: 1 for Yes. 2 for No.
PRIORITY	PRIORITY
CFM_ROUTING_FLAG	CFM_ROUTING_FLAG	Continuous flow or traditional routing. Use: 1 for Yes. 2 for No.
TOTAL_PRODUCT_ CYCLE_TIME	TOTAL_PRODUCT_ CYCLE_TIME	Total time that an assembly takes along the primary path in the operation network calculated by Flow Manufacturing.
CTP_FLAG	CTP_FLAG	Flag indicating capacity must be checked when item is ordered.

2.1. MTL_RTG_ITEM_REVS (Maps to MTL_RTG_ITEM_REVS_INTERFACE)

Field Name	Maps to Column	Description
ROUTING_SEQUENCE_ID		Not used in inbound transactions.
PROCESS_REVISION	PROCESS_REVISION	Required. Routing revision code.
CHANGE_NOTICE	CHANGE_NOTICE	Engineering change order number.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_UNITS to derive ORGANIZATION_ID.
ECN_INITIATION_DATE	ECN_INITIATION_DATE	Engineering Change order initiation date.
IMPLEMENTATION_DATE	IMPLEMENTATION_DATE	Engineering change order implementation date.
EFFECTIVITY_DATE	EFFECTIVITY_DATE	Revision effective date.
INVENTORY_ITEM_ NUMBER	INVENTORY_ITEM_ NUMBER	Required. Concatenated item segments.
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Insert. Update. Delete.

2.2. BOM_OP_SEQUENCES (Maps to BOM_OP_SEQUENCES_INTERFACE)

Field Name	Maps to Column	Description
ROUTING_SEQUENCE_ID		Not used for inbound transactions.
OPERATION_SEQ_ NUM	OPERATION_ SEQ_NUM	Required. Operation sequence number.
OPERATION_LEAD_TIME_ PERCENT	OPERATION_ LEAD_TIME_ PERCENT	Indicates the amount of overlap its lead time has with the parent's lead time.
MINIMUM_TRANSFER_ QUANTITY	MINIMUM_ TRANSFER_ QUANTITY	Minimum operation transfer quantity.
COUNT_POINT_ TYPE	COUNT_POINT_ TYPE	Use: 1 for Yes auto charge. 2 for No auto charge. 3 for No direct charge.
OPERATION_ DESCRIPTION	OPERATION_ DESCRIPTION
EFFECTIVITY_ DATE	EFFECTIVITY_ DATE	Required. Date operation is effective.
DISABLE_DATE	DISABLE_DATE	Date operation is no longer effective. Effective operation lasts until the end of the disable date.
BACKFLUSH_ FLAG	BACKFLUSH_ FLAG	Indicates whether operation requires backflushing. Use: 1 for Yes. 2 for No.
OPTION_DEPENDENT_FLAG	OPTION_ DEPENDENT_ FLAG	Indicates whether to use the operation in all configuration routings, even if no components of the configuration are used in this routing. Use: 1 for Yes. 2 for No.
ALTERNATE_ROUTING_ DESIGNATOR	ALTERNATE_ ROUTING_ DESIGNATOR	Required.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
ASSEMBLY_ITEM_NUMBER	ASSEMBLY_ITEM_ NUMBER	Required. Concatenated item segments.
DEPARTMENT_CODE	DEPARTMENT_ CODE	Required for Insert. Department name.
OPERATION_CODE	OPERATION_ CODE	Standard operation code.
RUN_TIME_OVERLAP_PERCENT	LINE_OP_ SEQ_ID	Optional. Run time overlap percentage.
TRANSACTION_TYPE	TRANSACTION_ TYPE	Required. Use: Insert. Update. Delete.
NEW_OPERATION_SEQ_NUM	NEW_OPERATION_ SEQ_NUM	Added to facilitate updates because it is part of the primary key.
NEW_EFFECTIVITY_DATE	NEW_EFFECTIVITY_ DATE	Added to facilitate updates because it is part of the primary key.
ASSEMBLY_TYPE	ASSEMBLY_ TYPE	Not used in open interface.
OPERATION_TYPE	OPERATION_ TYPE	Use Process, Line Operation, or Event.
REFERENCE_FLAG	REFERENCE_ FLAG	If the Standard Operation is referenced or copied, then the operation can not be updated. Use: 1 for Yes. 2 for No.
PROCESS_OP_SEQ_ID	PROCESS_OP_ SEQ_ID	Operation sequence identifier of parent process (only applies to events).
LINE_OP_SEQ_ID	LINE_OP_ SEQ_ID	Operation sequence identifier of the parent line operation (only applies to events).
YIELD	YIELD	Process yield at this operation.
CUMULATIVE_YIELD	CUMULATIVE_ YIELD	Cumulative process yield from beginning of routing to this operation.
REVERSE_CUMULATIVE_YIELD	REVERSE_ CUMULATIVE_ YIELD	Cumulative process yield from end of routing to comparable operation.
LABOR_TIME_CALC	LABOR_TIME_ CALC	System-calculated run time attributable to labor.
MACHINE_TIME_CALC	MACHINE_TIME_ CALC	System-calculated run time attributable to machines.
TOTAL_TIME_CALC	TOTAL_TIME_ CALC	System-calculated run time attributable to both labor and machines.
LABOR_TIME_USER	LABOR_TIME_ USER	User-calculated run time attributable to labor.
MACHINE_TIME_USER	MACHINE_TIME_ USER	User-calculated run time attributable to machines.
TOTAL_TIME_USER	TOTAL_TIME_ USER	User-calculated run time attributable to both labor and machines.
NET_PLANNING_PERCENT	NET_ PLANNING_ PERCENT	Cumulative planning percents derived from the operation network.
INCLUDE_IN_ROLLUP	INCLUDE_ IN_ROLLUP	Indicates whether operation yield should be considered in cost rollup.
OPERATION_YIELD_ENABLED	OPERATION_ YIELD_ENABLED	Indicates whether operation yield should be considered during costing.
RESOURCE_CODE1	RESOURCE_ CODE1
RESOURCE_CODE2	RESOURCE_ CODE2
RESOURCE_CODE3	RESOURCE_ CODE3
INSTRUCTION_CODE1	INSTRUCTION_ CODE1
INSTRUCTION_CODE2	INSTRUCTION_ CODE2
INSTRUCTION_CODE3	INSTRUCTION_ CODE3

2.2.1. BOM_OP_RESOURCES (Maps to BOM_OP_RESOURCES_INTERFACE)

Field Name	Maps to Column	Description
ROUTING_SEQUENCE_ID		Not used in inbound transactions.
RESOURCE_SEQ_NUM	RESOURCE_SEQ_NUM	Resource sequence number.
STANDARD_RATE_FLAG	STANDARD_RATE_FLAG	Use standard rate for shop floor transactions. Use: 1 for Yes. 2 for No.
ASSIGNED_UNITS	ASSIGNED_UNITS	Resource units assigned.
USAGE_RATE_OR_AMOUNT	USAGE_RATE_OR_AMOUNT	Resource usage rate.
USAGE_RATE_OR_ AMOUNT_INVERSE	USAGE_RATE_OR_ AMOUNT_INVERSE	Resource usage rate inverse.
BASIS_TYPE	BASIS_TYPE	Basis type identifier. Use: 1 for Item. 2 for Lot. 3 for Resource Units. 4 for Resource Value. 5 for Total Value. 6 for Activity.
SCHEDULE_FLAG	SCHEDULE_FLAG	Schedule the resource. Use: 1 for Yes. 2 for No. 3 for Prior. 4 for Next.
RESOURCE_OFFSET_ PERCENT	RESOURCE_OFFSET_ PERCENT	Resource offset percent from the start of the routing.
AUTOCHARGE_TYPE	AUTOCHARGE_TYPE	Auto charge type for shop floor moves. Use: 1 for WIP move. 2 for Manual. 3 for PO receipt. 4 for PO move.
ALTERNATE_ROUTING_ DESIGNATOR	ALTERNATE_ROUTING_ DESIGNATOR	Required.
OPERATION_SEQ_NUM	OPERATION_SEQ_NUM	Required. Operation sequence number.
EFFECTIVITY_DATE	EFFECTIVITY_DATE	Required. Effective date.
ORGANIZATION_NAME	ORGANIZATION_ID	Required. Use HR_ALL_ ORGANIZATION_ UNITS to derive ORGANIZATION_ID.
ASSEMBLY_ITEM_NUMBER	ASSEMBLY_ITEM_NUMBER	Required. Concatenated item segments.
RESOURCE_CODE	RESOURCE_CODE
ACTIVITY	ACTIVITY
TRANSACTION_TYPE	TRANSACTION_TYPE	Required. Use: Create. Update. Delete.
NEW_RESOURCE_SEQ_NUM	NEW_RESOURCE_SEQ_NUM	New resource sequence number, which facilitates updates because it is part of the primary key.