Database Script | Description |
wm_install_from_pickdetails.sql | Runs all the scripts listed below, except the uninstall script. |
wm_from_pickdetails_vw.sql | Creates the views for Pick Detail:  WM_PICK_DETAILS_VWWM_PICK_DETAILS_QRY_VW |
wm_from_pickdetails_trg.sql | Creates the WM_MTL_MATERIAL_TXN_TEMP_D_TRG trigger for writing to the WM_TRACKCHANGES table to indicate a new or updated document. |
wm_drop_from_pickdetails.sql | Uninstalls all components created by wm_install_pickdetails.sql. |
getPickDetailTxn1227.txpspecifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.lockTxnCtrl determines whether the sendPickDetail service is ready for execution. That is, it determines whether there is no other instance of this service already in process.If the lockTxnCtrl service returns False, it indicates that another instance of this service is already in process. The service exits and waits for next scheduled execution.If the lockTxnCtrl service returns true, it indicates that the service is ready to execute, the PICKDETAIL row in the control table is locked and updated, and the status is changed to INPROCESS. This prevents any other PickDetail service from executing.The getPickDetailTxn service queries the Oracle Applications database for any Pick Detail 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 during a business document transfer, then the error information is sent back to the sendPickDetail calling service. 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 sendPickDetail calling service.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 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.The insertTransferERRInfo service inserts a new record in the WM_TRACKCHANGES table if an error occurs while transferring the business document, so this document can be picked up during the next polling interval.The unlockTxnCtrl service releases the lock on the custom control table so that the next polling instance of the sendPickDetail service can begin.PICK_DETAILSDocument Field | Oracle Applications Table/View Name | Column Name | Description |
WEB_TRANSACTION_ ID | |||
DOCUMENT_TYPE | PICK_DETAILS will be populated in this field. | ||
DOCUMENT_STATUS | INSERT will be populated in this field. | ||
TRANSACTION_ID | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ SET_ID | Transaction identifier. |
MOVE_ORDER_ NUMBER | MTL_TXN_ REQUEST_ HEADERS | REQUEST_NUMBER | Number assigned to a move order on creation. |
SCHEDULED_SHIP_ DATE | OE_ORDER_ LINES_ALL | SCHEDULE_ SHIP_DATE | Scheduled ship date. |
ACCT_PERIOD_ NAME | ORG_ACCT_ PERIODS | PERIOD_NAME | Accounting period name. |
ACTUAL_COST | MTL_MATERIAL_ TRANSACTIONS | ACTUAL_COST | |
COST_GROUP_NAME | CST_COST_GROUPS | COST_GROUP | Cost group identifier. |
COSTED_FLAG | MTL_MATERIAL_ TRANSACTIONS | COSTED_FLAG | Identifies whether the transactions are costed. |
CURRENCY_CODE | MTL_MATERIAL_ TRANSACTIONS | CURRENCY_CODE | |
CURRENCY_ CONVERSION_DATE | MTL_MATERIAL_ TRANSACTIONS | CURRENCY_ CONVERSION_ DATE | |
CURRENCY_ CONVERSION_RATE | MTL_MATERIAL_ TRANSACTIONS | CURRENCY_ CONVERSION_ RATE | |
CURRENCY_ CONVERSION_TYPE | MTL_MATERIAL_ TRANSACTIONS | CURRENCY_ CONVERSION_ TYPE | |
DEPARTMENT_CODE | BOM_DEPARTMENTS | DEPARTMENT_ CODE | Department identifier. |
DISTRIBUTION_ ACCOUNT_NUMBER | GL_CODE_ COMBINATIONS_ KFV | CONCATENATED_ SEGMENTS | Distribution account number. |
EMPLOYEE_CODE | MTL_MATERIAL_ TRANSACTIONS | EMPLOYEE_CODE | |
ENCUMBRANCE_ ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | ENCUMBRANCE_ ACCOUNT | Encumbrance account identifier for purchase order transactions. |
ENCUMBRANCE_ AMOUNT | MTL_MATERIAL_ TRANSACTIONS | ENCUMBRANCE_ AMOUNT | Total encumbrance amount. |
EXPENDITURE_ TYPE | MTL_MATERIAL_ TRANSACTIONS | EXPENDITURE_ TYPE | Oracle Projects expenditure type. |
FLOW_SCHEDULE | MTL_MATERIAL_ TRANSACTIONS | FLOW_SCHEDULE | Indicates whether the WIP transaction is a flow or a schedule type transaction. |
FREIGHT_CODE | MTL_MATERIAL_ TRANSACTIONS | FREIGHT_CODE | In-transit shipment freight code. |
INVENTORY_ ITEM_CODE | MTL_SYSTEM_ ITEMS_B_KFV | CONCATENATED_ SEGMENTS | Inventory item identifier. |
INVOICED_FLAG | MTL_MATERIAL_ TRANSACTIONS | INVOICED_FLAG | Indicates whether the transactions are invoiced. |
TO_LOCATION_ DESCRIPTION | MTL_ITEM_LOCATIONS | DESCRIPTION | Locator identifier. |
LPN_NUMBER | WMS_LICENSE_ PLATE_ NUMBERS | LICENSE_PLATE_ NUMBER | License plate number. |
MASTER_SCHEDULE_ UPDATE_CODE | MTL_MATERIAL_ TRANSACTIONS | MASTER_ SCHEDULE_ UPDATE_CODE | |
MATERIAL_ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | MATERIAL_ACCOUNT | |
MATERIAL_ OVERHEAD_ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | MATERIAL_ OVERHEAD_ ACCOUNT | |
MOVE_ORDER_ TYPE_NAME | MFG_LOOKUPS | MEANING | |
NEW_COST | MTL_MATERIAL_ TRANSACTIONS | NEW_COST | Item cost after the transaction processing. |
NUMBER_OF_ CONTAINERS | MTL_MATERIAL_ TRANSACTIONS | NUMBER_OF_ CONTAINERS | |
OPERATION_ SEQ_NUM | MTL_MATERIAL_ TRANSACTIONS | OPERATION_ SEQ_NUM | Operation sequence number in a routing. |
TO_ORGANIZATION_ NAME | ORG_ ORGANIZATION_ DEFINITIONS | ORGANIZATION_ NAME | Organization name to which the material transaction has taken place. |
OUTSIDE_ PROCESSING_ ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | OUTSIDE_ PROCESSING_ ACCOUNT | Indicates the account to be charged for outside processing. |
OVERCOMPLETION_ PRIMARY_QTY | MTL_MATERIAL_ TRANSACTIONS | OVERCOMPLETION_ PRIMARY_QTY | Over completion primary quantity. |
PICKING_RULE_ NAME | MTL_PICKING_ RULES | PICKING_RULE_NAME | |
PICK_SLIP_NUMBER | MTL_MATERIAL_ TRANSACTIONS | PICK_SLIP_NUMBER | Pick slip number for the transaction line. |
PRIMARY_QUANTITY | MTL_MATERIAL_ TRANSACTIONS | PRIMARY_QUANTITY | Transaction quantity in terms of primary unit of measure of the item. |
PRIOR_COST | MTL_MATERIAL_ TRANSACTIONS | PRIOR_COST | Item cost before the transaction. |
PRIOR_COSTED_ QUANTITY | MTL_MATERIAL_ TRANSACTIONS | PRIOR_COSTED_ QUANTITY | Costed quantity before this transaction. |
PROJECT_NAME | PA_PROJECTS_ALL | NAME | |
QUANTITY_ADJUSTED | MTL_MATERIAL_ TRANSACTIONS | QUANTITY_ ADJUSTED | Standard cost quantity adjusted. |
REASON_NAME | MTL_ TRANSACTION_ REASONS | REASON_NAME | Transaction reason name. |
RECEIVING_ DOCUMENT | MTL_MATERIAL_ TRANSACTIONS | RECEIVING_ DOCUMENT | |
RESOURCE_ ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | RESOURCE_ ACCOUNT | |
REVISION | MTL_MATERIAL_ TRANSACTIONS | REVISION | Inventory item revision code. |
SHIPMENT_COSTED | MTL_MATERIAL_ TRANSACTIONS | SHIPMENT_ COSTED | Indicates if the shipment transaction has been processed by the cost worker. |
SHIPMENT_NUMBER | MTL_MATERIAL_ TRANSACTIONS | SHIPMENT_ NUMBER | In-transit shipment identifier. |
TO_SUBINVENTORY_ CODE | MTL_MATERIAL_ TRANSACTIONS | SUBINVENTORY_ CODE | Transaction secondary inventory to which the material transaction has taken place. |
TASK_NAME | PA_TASKS | TASK_NAME | |
TO_PROJECT_NAME | PA_PROJECTS_ALL | NAME | |
TO_TASK_NAME | PA_TASKS | TASK_NAME | |
TRANSACTION_ ACTION_NAME | MFG_LOOKUPS | MEANING | Use values such as subinventory transfer or staging transfer. |
TRANSACTION_ COST | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ COST | Cost entered by the use during a transaction. |
TRANSACTION_ DATE | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ DATE | |
TRANSACTION_ QUANTITY | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ QUANTITY | |
TRANSACTION_ REFERENCE | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ REFERENCE | Transaction reference code. |
TRANSACTION_ SOURCE_NAME | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ SOURCE_NAME | Transaction source identifier. |
TRANSACTION_ SOURCE_TYPE_ NAME | MTL_TXN_ SOURCE_TYPES | TRANSACTION_ SOURCE_TYPE_ NAME | Transaction source type identifier. |
TRANSACTION_ TYPE_NAME | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_ TYPE_NAME | Transaction type identifier. |
TRANSACTION_ UOM | MTL_MATERIAL_ TRANSACTIONS | TRANSACTION_UOM | Transaction unit of measure. |
FROM_COST | MTL_MATERIAL_ TRANSACTIONS | TRANSFER_COST | Transfer cost specified for transfers between organizations. |
FROM_COST_ DIST_ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | TRANSFER_ COST_DIST_ ACCOUNT | Transaction transfer cost distribution account. |
FROM_COST_ GROUP_NAME | CST_COST_ GROUPS | COST_GROUP | Transfer cost group identifier |
FROM_LOCATION_ DESCRIPTION | MTL_ITEM_ LOCATIONS | DESCRIPTION | Subinventory locator identifier from which the material transaction takes place. |
FROM_ ORGANIZATION_ NAME | ORG_ ORGANIZATION_ DEFINITIONS | ORGANIZATION_ NAME | Organization name from which material transaction has taken place. |
FROM_ SUBINVENTORY_ CODE | MTL_MATERIAL_ TRANSACTIONS | TRANSFER_ SUBINVENTORY | Subinventory code from which material transfer has been initiated. |
TRANSPORTATION_ COST | MTL_MATERIAL_ TRANSACTIONS | TRANSPORTATION_ COST | Transfer transportation cost. |
TRANSPORTATION_ DIST_ACCOUNT | MTL_MATERIAL_ TRANSACTIONS | TRANSPORTATION_ DIST_ACCOUNT | Transfer transportation distribution account. |
USSGL_ TRANSACTION_ CODE | MTL_MATERIAL_ TRANSACTIONS | USSGL_ TRANSACTION_ CODE | USSGL transaction code. |
VALUE_CHANGE | MTL_MATERIAL_ TRANSACTIONS | VALUE_CHANGE | Value change used for average cost update. |
VARIANCE_AMOUNT | MTL_MATERIAL_ TRANSACTIONS | VARIANCE_AMOUNT | Used for average cost update transactions. |
VENDOR_LOT_ NUMBER | MTL_MATERIAL_ TRANSACTIONS | VENDOR_LOT_ NUMBER | Supplier lot number. |
WAYBILL_AIRBILL | MTL_MATERIAL_ TRANSACTIONS | WAYBILL_AIRBILL | Air bill/waybill number. |