Total Pageviews

November 5, 2015

11/05/2015 04:28:00 AM
Oracle APPS: Period Closing  Error Resolution Checks
--------------------------------------------------------------------------
Oracle Transactions are passed from Module to Module via Interfaces
Each interface can be viewed as a potential “Point of Failure”



Transaction Name
Transaction Name
Interface Table Name
Interface Table Name
Unprocessed Material
• Material transactions “halfway”
processed and stuck in the material temporary table. 
Usually shipment/RMA transactions. 
This is an internal Oracle
 table. 
MTL_MATERIAL_TRANSACTON_TEMP
View Transactions->Pending transactions
Uncosted Material •
Material transactions where the quantity movement has been completed, but the accounting entries have not been recorded.  The Oracle Cost Manager
creates the accounting entries for the material transactions.  
MTL_MATERIAL_ TRANSACTIONS where the costed_flag = ‘N’ or ‘E’

• View Transactions> Material Transactions, query up all entries where the “Costed” field displays “No” or “Error”
Pending WIP Costing

• WIP resource, OSP resource, and job close transactions that are pending or erred. The  Oracle Cost Manager creates the accounting entries for the resource, overhead, OSP and job close
transactions.  This table may be used to populate
 external resource costs into the Oracle Applications. 
WIP_COST_TXN_ INTERFACE

• View Transactions>  Pending Resource Transactions
Unprocessed Shipping Transactions

• Pending shipments not yet processed.  To clear these, assuming no underlying data issues, you normally request Supply Chain to process the Trip Stop Interface, using the Order Management module > Shipping > Trip Stop SRS selection and run the trip stop interface.  If this does not work, there may be underlying data issues.
WSH_DELIVERY_ DETAILS

• Go to a Shipping or OM Responsibility > Interface > Run > Trip Stop SRS to run the Trip Stop interface
Pending Receiving

• PO Receipt Transactions that have erred out.  The receiving transactions always use this interface table, sometimes, for unexplained reasons, a stray transaction will error out.  This table may be used to populate external receiving transactions
RCV_TRANSACTIONS_ INTERFACE

• There is a Receiving Interface Errors Report using the Purchasing Responsibility
Pending Material
.
• Pending material transactions from an external system, such as EDI or bar-coding or LSP files.  Note that the shipment transactions initially load this table, then clear it, and load the pending material transactions interface, MTL_MATERIAL_ TRANSACTIONS_TEMP
MTL_TRANSACTIONS_INTE RFACE


• View Transactions>  Transaction Open Interface
Transaction Name
Transaction Name
Interface Table Name
Interface Table Name
Pending Shop Floor Move

• Pending WIP shop floor move transactions, internal or external to Oracle. 
WIP_MOVE_TXN_INTERFACE

. • View Transactions>  Pending Move Transactions
Pending WSM Interface
• If you use Oracle Shop Floor Management, you can split or merge WIP lots as necessary, according to your business requirements.  Using the WIP Lot Transaction Form you can do lot splitting, lot merging, lot bonus (add quantity to an existing lot), lot translation to another assembly or item, or split a lot into child lots.   .  
WSM_SPLIT_MERGE_TXN_INTERFACE WSM_STARTING_JOBS_INTERFACE
WSM_RESULTING_JOBS_INTERFACE

• To see Pending WSM transactions go to: Shop Floor Manager responsibility > Lot Transactions > WIP Lot Transactions and choose Costed No or Erro
Pending WIP Costing

• WIP resource, OSP resource, and job close transactions that are pending or erred. The  Oracle Cost Manager creates the accounting entries for the resource, overhead, OSP and job close transactions.  This table may be used to populate
 external resource costs into the Oracle Applications. 
WIP_COST_TXN_ INTERFACE

• View Transactions>  Pending Resource Transactions
Unprocessed Shipping Transactions

• Pending shipments not yet processed.  To clear these, assuming no underlying data issues, you normally request Supply Chain to process the Trip Stop Interface, using the Order Management module > Shipping > Trip Stop SRS selection and run the trip stop interface.  If this does not work, there may be underlying data issues.
WSH_DELIVERY_ DETAILS

• Go to a Shipping or OM Responsibility > Interface > Run > Trip Stop SRS to run the Trip Stop interface
Pending Receiving

• PO Receipt Transactions that have erred out.  The receiving transactions always use this interface table, sometimes, for unexplained reasons, a stray transaction will error out.  This table may be used to populate external receiving transactions
RCV_TRANSACTIONS_ INTERFACE

• There is a Receiving Interface Errors Report using the Purchasing Responsibility
Pending Material
.
• Pending material transactions from an external system, such as EDI or bar-coding or LSP files.  Note that the shipment transactions initially load this table, then clear it, and load the pending material transactions interface, MTL_MATERIAL_ TRANSACTIONS_TEMP
MTL_TRANSACTIONS_INTE RFACE


• View Transactions>  Transaction Open Interface

               
 
Transaction Name
Transaction Name
Interface Table Name
Interface Table Name
Unprocessed Material
• Material transactions “halfway”
processed and stuck in the material temporary table.
Usually shipment/RMA transactions.
This is an internal Oracle
table.
MTL_MATERIAL_TRANSACTON_TEMP
View Transactions->Pending transactions
Uncosted Material •
Material transactions where the quantity movement has been completed, but the accounting entries have not been recorded. The Oracle Cost Manager
creates the accounting entries for the material transactions.
MTL_MATERIAL_ TRANSACTIONS where the costed_flag = ‘N’ or ‘E’
• View Transactions> Material Transactions, query up all entries where the “Costed” field displays “No” or “Error”
Pending WIP Costing
• WIP resource, OSP resource, and job close transactions that are pending or erred. The Oracle Cost Manager creates the accounting entries for the resource, overhead, OSP and job close
transactions. This table may be used to populate
external resource costs into the Oracle Applications.
WIP_COST_TXN_ INTERFACE
• View Transactions> Pending Resource Transactions
Unprocessed Shipping Transactions
• Pending shipments not yet processed. To clear these, assuming no underlying data issues, you normally request Supply Chain to process the Trip Stop Interface, using the Order Management module > Shipping > Trip Stop SRS selection and run the trip stop interface. If this does not work, there may be underlying data issues.
WSH_DELIVERY_ DETAILS
• Go to a Shipping or OM Responsibility > Interface > Run > Trip Stop SRS to run the Trip Stop interface
Pending Receiving
• PO Receipt Transactions that have erred out. The receiving transactions always use this interface table, sometimes, for unexplained reasons, a stray transaction will error out. This table may be used to populate external receiving transactions
RCV_TRANSACTIONS_ INTERFACE
• There is a Receiving Interface Errors Report using the Purchasing Responsibility
Pending Material
.
• Pending material transactions from an external system, such as EDI or bar-coding or LSP files. Note that the shipment transactions initially load this table, then clear it, and load the pending material transactions interface, MTL_MATERIAL_ TRANSACTIONS_TEMP
MTL_TRANSACTIONS_INTE RFACE
• View Transactions> Transaction Open Interface
Transaction Name
Transaction Name
Interface Table Name
Interface Table Name
Pending Shop Floor Move
• Pending WIP shop floor move transactions, internal or external to Oracle.
WIP_MOVE_TXN_INTERFACE
. • View Transactions> Pending Move Transactions
Pending WSM Interface
• If you use Oracle Shop Floor Management, you can split or merge WIP lots as necessary, according to your business requirements. Using the WIP Lot Transaction Form you can do lot splitting, lot merging, lot bonus (add quantity to an existing lot), lot translation to another assembly or item, or split a lot into child lots. .
WSM_SPLIT_MERGE_TXN_INTERFACE WSM_STARTING_JOBS_INTERFACE
WSM_RESULTING_JOBS_INTERFACE
• To see Pending WSM transactions go to: Shop Floor Manager responsibility > Lot Transactions > WIP Lot Transactions and choose Costed No or Erro
Pending WIP Costing
• WIP resource, OSP resource, and job close transactions that are pending or erred. The Oracle Cost Manager creates the accounting entries for the resource, overhead, OSP and job close transactions. This table may be used to populate
external resource costs into the Oracle Applications.
WIP_COST_TXN_ INTERFACE
• View Transactions> Pending Resource Transactions
Unprocessed Shipping Transactions
• Pending shipments not yet processed. To clear these, assuming no underlying data issues, you normally request Supply Chain to process the Trip Stop Interface, using the Order Management module > Shipping > Trip Stop SRS selection and run the trip stop interface. If this does not work, there may be underlying data issues.
WSH_DELIVERY_ DETAILS
• Go to a Shipping or OM Responsibility > Interface > Run > Trip Stop SRS to run the Trip Stop interface
Pending Receiving
• PO Receipt Transactions that have erred out. The receiving transactions always use this interface table, sometimes, for unexplained reasons, a stray transaction will error out. This table may be used to populate external receiving transactions
RCV_TRANSACTIONS_ INTERFACE
• There is a Receiving Interface Errors Report using the Purchasing Responsibility
Pending Material
.
• Pending material transactions from an external system, such as EDI or bar-coding or LSP files. Note that the shipment transactions initially load this table, then clear it, and load the pending material transactions interface, MTL_MATERIAL_ TRANSACTIONS_TEMP
MTL_TRANSACTIONS_INTE RFACE
• View Transactions> Transaction Open Interface