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