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.
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. |