Viewing Pending Job Transactions
You can use the Transaction Summary window to determine if there are pending transactions or unprocessed documents associated with a job. You cannot purge or close jobs if pending transactions or unprocessed documents exist. In some instances, you also cannot change a job from one status to another. For example, you cannot change jobs from a Released to an Unreleased status if pending information exists.
To view pending transactions and conditions for a job:
1. Select a queried job in the Discrete Jobs, View Discrete Jobs, Close Discrete, or Purge Discrete Jobs window. See: Finding Discrete Jobs.
If a restriction exists, the check boxes indicating the type of restrictions is marked. An explanation of each restrictive condition follows:
Uncosted Material Transactions: There are uncosted transaction records in the MTL_MATERIAL_TRANSACTIONS table. You can check to see if transactions are uncosted, the costed indicator is off, using the Material Transactions window. See: Viewing Material Transactions and Oracle Inventory Technical Reference Manual, Release 11.
Pending Material Transactions: There are unprocessed material transaction records in the MTL_MATERIAL_TRANSACTIONS_TEMP table. You can view, update, and resubmit these records in the Pending Transactions window in Oracle Inventory. See: Viewing Pending Transactions and Oracle Inventory Technical Reference Manual, Release 11.
Resource Transactions: Resources have been charged and there are records in the WIP_OPERATIONS_RESOURCES table.
Pending Resource Transactions: There are pending resource and overhead transaction records in the WIP_COST_TXN_INTERFACE table. You can view and resubmit these records using the Pending Resource Transactions window. See: Processing Pending Resource Transactions and Oracle Work in Process Technical Reference Manual, Release 11.
Pending Move Transactions: There are pending move transaction records in the WIP_MOVE_TXN_INTERFACE table. You can view and resubmit these records using the Pending Move Transactions window. See: Processing Pending Move Transactions and Oracle Work in Process Technical Reference Manual, Release 11.
PO Requisitions: There are purchase requisitions in the PO_REQUISITION_LINES table. See: Reviewing Requisitions and Oracle Purchasing Technical Reference Manual, Release 11.
Pending PO Requisitions: There are unprocessed records in the PO_REQUISITION_ INTERFACE table. See: Requisition Import Process and Oracle Purchasing Technical Reference Manual, Release 11.
See Also
Changing Discrete Jobs
Closing Discrete Jobs
Purging Discrete Jobs
Viewing Discrete Job Information