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.