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 Move Transaction Service
 
Receive Move Transaction Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: workInProcess1227.intoOA.moveTransaction:receiveMoveTransaction.
This service imports moved items.
The concurrent process of the Move Transaction Manager is scheduled from the Oracle Applications system. Generally, managers run continuously at regular process intervals determined at startup. They control the number of transaction workers, processing intervals, and transactions processed by the worker. The mode of operation for these managers is governed by the setting of profile options prefixed by the letters TP (transaction processing). Therefore, this inbound transaction has no custom package.
Database Scripts
This service uses the following database scripts:
Script
Description
wm_install_into_movetrans.sql
Runs the scripts listed below, except the uninstall script.
wm_into_movetrans_seq.sql
Creates the following component:
*WM_WIP_TRANS_ID_S, which creates the TRANSACTION_ID sequence
wm_drop_into_movetrans.sql
Uninstalls all components created by wm_install_into_movetrans.sql.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definitions:
*setMoveTransactionTxn1227.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 moved items:
*specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
*bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
*pickSequence generates the current sequence number from the sequence WM_WIP_TRANS_ID_S.
*getOASystemDateObject returns the Oracle Applications system date as a date object.
*getOracleAppsUserId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.
*getOrgIdAndCode returns the ORGANIZATION_ID and ORGANIZATION_CODE corresponding to the supplied ORGANIZATION_NAME. This service is a transformer in bizDicMapping.
*getInventoryItemId returns the INVENTORY_ITEM_ID corresponding to the supplied ITEM_CODE and the ORGANIZATION_NAME. This service is a transformer in bizDocMapping.
*getAcctPeriodId returns the ACCOUNT_PERIOD_ID corresponding to the supplied ACCOUNT_PERIOD_NAME and ORGANIZATION_NAME. This service is a transformer in bizDocMapping.
*getCodeCombinationId returns the SCRAP_ACCOUNT_ID corresponding to the supplied SCRAP_ACCOUNT_NUMBER and the SET_OF_BOOKS_NAME. This service is a transformer in bizDocMapping.
*getKanbanCardId returns the KANBAN_CARD_ID corresponding to the supplied KANBAN_CARD_NUMBER. This service is a transformer in bizDocMapping.
*getWIPEntityId returns the WIP_ENTITY_ID corresponding to the supplied WIP_ENTITY_NAME and ORGANIZATION_NAME. This service is a transformer in bizDocMapping.
*getWIPEntityType returns the ENTITY_TYPE corresponding to the supplied WIP_ENTITY_NAME and ORGANIZATION_NAME.
*convertToDateObject returns the outDate as a date object corresponding to the supplied inDate, which is in text format. This service is a transformer in bizDocMapping.
*setMoveTransactionTxn inserts data into the interface table. It takes data from the IData structure that results from the bizDocMapping service, and puts the data into the interface table in Oracle Applications for Open Move Interface.
For more details on receive transactions, see Overview of Receive Service Transaction Processing.
Business Document Structure
This service uses the business document MoveTransactionBizDoc. Its structure is as follows:
*1.0. WIP_MOVE_TXN
*1.1. CST_COMP_SNAP
1.0. WIP_MOVE_TXN (Maps to WIP_MOVE_TXN_INTERFACE)
Filed Name
Maps to Column
Description
SOURCE_CODE
SOURCE_CODE
Code of the shop floor control system that generated the transaction record; it is null if created by Oracle Work In Process.
SOURCE_LINE_ID
SOURCE_LINE_ID
Identifier used by source shop floor control system; it is null if created by Oracle Work In Process.
TRANSACTION_TYPE
TRANSACTION_TYPE
Transaction type. Use:
*1 for Move transaction.
*2 for Move completed transaction.
*3 for Move return transaction.
ORGANIZATION_NAME
ORGANIZATION_ID
Organization identifier.
SET_OF_BOOKS_NAME
WIP_ENTITY_NAME
WIP_ENTITY_NAME
Required. WIP job or repetitive assembly name.
PRIMARY_ITEM_CODE
PRIMARY_ITEM_ID
Inventory item identifier for assembly that the job or schedule creates.
LINE_CODE
LINE_CODE
Required for repetitive manufacturing transactions.
TRANSACTION_DATE
TRANSACTION_
DATE
Required. Date when transaction was performed.
ACCT_PERIOD_NAME
ACCT_PERIOD_ID
Accounting period identifier.
FM_OPERATION_SEQ_NUM
FM_OPERATION_
SEQ_NUM
From operation sequence number. Required for Move and Move Completion transactions. It must be an enabled intra-operation step.
FM_OPERATION_CODE
FM_OPERATION_
CODE
From operation code.
FM_DEPARTMENT_CODE
FM_DEPARTMENT_
CODE
From department code.
FM_INTRAOPERATION_
STEP_TYPE
FM_INTRAOPERATION_
STEP_TYPE
From intra–operation step. Required for Move and Move Completion transactions. It must be an enabled intraoperation step.
TO_OPERATION_SEQ_NUM
TO_OPERATION_
SEQ_NUM
To operation sequence number. Required when performing Move and Move Return transactions. It must be an enabled intraoperation step.
TO_OPERATION_CODE
TO_OPERATION_
CODE
TO_DEPARTMENT_CODE
TO_DEPARTMENT_
CODE
TO_INTRAOPERATION_
STEP_TYPE
TO_INTRAOPERATION_
STEP_TYPE
To operation step type. Required when performing Move and Move Return transactions. It must be an enabled intraoperation step.
TRANSACTION_QUANTITY
TRANSACTION_QUANTITY
Required. Transaction quantity between operations.
TRANSACTION_UOM
TRANSACTION_UOM
Required. Unit of measure used in transaction.
PRIMARY_QUANTITY
PRIMARY_QUANTITY
Quantity of assembly being moved between operations expressed in the assembly’s primary unit of measure.
PRIMARY_UOM
PRIMARY_UOM
Primary unit of measure for the assembly.
SCRAP_ACCOUNT_NUMBER
SCRAP_ACCOUNT_ID
General Ledger account charged when material is scrapped.
REASON_NAME
REASON_NAME
Standard transaction reason name
REFERENCE
REFERENCE
Transaction reference descriptive text.
QA_COLLECTION_ID
QA_COLLECTION_ID
Collection identifier for quality results.
KANBAN_CARD_NUMBER
KANBAN_CARD_ID
OVERCOMPLETION_
TRANSACTION_QTY
OVERCOMPLETION_
TRANSACTION_QTY
Overcompletion quantity specified in the transaction unit of measure.
OVERCOMPLETION_
PRIMARY_QTY
OVERCOMPLETION_
PRIMARY_QTY
Overcompletion quantity derived in the primary unit of measure.
1.1 CST_COMP_SNAP (Maps to CST_COMP_SNAP_INTERFACE)
Field Name
Maps to Column
Description
OPERATION_SEQ_NUMBER
OPERATION_SEQ_NUMBER
Required. Operation sequence number.
NEW_OPERATION_FLAG
NEW_OPERATION_FLAG
Indicates whether this operation was added after the job was released.
PRIMARY_QUANTITY
PRIMARY_QUANTITY
Required. Quantity in primary unit of measure.
QUANTITY_COMPLETED
QUANTITY_COMPLETED
Required. Number of units completed by the operation.
PRIOR_COMPLETION_QUANTITY
PRIOR_COMPLETION_QUANTITY
Total number of units completed for the job before this transaction.
PRIOR_SCRAP_QUANTITY
PRIOR_SCRAP_QUANTITY
Total number of units scrapped for the job before this transaction.