How To Diagnose Inventory Accruals And Accrual Write Off Issues
(Doc ID 866733.1)
Last updated on MARCH 06, 2023
Applies to:Oracle Cost Management - Version 184.108.40.206 and later
Oracle Payables - Version 220.127.116.11 to 12.1.1 [Release 11.5 to 12.1]
Oracle Purchasing - Version 11.5.10 to 12.3 [Release 11.5 to 12.3]
Information in this document applies to any platform.
CSTACRLR: Accrual Reconciliation Load Program
CSTACRAP: AP and PO Accrual Reconciliation Report
CSTACRWO: Accrual Write-Off Report
POXACWRO: WIP Accrual Write-Off Report
AP AND PO Write Off Form
Miscellaneous Write Off Form
View Write Off Transactions
Accrual Write Off process identifies and writes off items that misstates the accrual balance on the Accrual Reconciliation Reports. Such transactions will also include non accrual transactions wrongly debited or credited to the Inventory AP Accrual Account. The following are potential transaction candidates to be written off : Differences between receipts and invoices with no intention of future invoicing, Discrepancies in supplier billing, A/P No PO Transactions - Invoices not matched to PO or incorrect data conversion invoices, A/P No Match-Valid Invoice with no corresponding receipt, Invoices Matched to Wrong PO or Receipt, Miscellaneous inventory or work in process transactions that do not belong to Accrual Accounts, Payable Entries for Sales Tax and freight that do not belong to Accrual Accounts.
The Write Off process is different from R12 and R11i. We will cover both and highlight the differences. In R12 Accrual Write Off excludes the write off transaction from the AP and PO Report and dynamically post to GL and excluded from the Net Accrual balance. Therefore the risks and problems associated with Manual Journals are avoided
For relevant Notes relating to Inventory Accrual Reconciliation process please refer to
the following Notes:
<Note.1107953.1> - R12 Accrual Balance Mismatch Between Accrual Reconciliation Report - Troubleshooting
<Note 728871.1> - R12 How To Diagnose And Reconcile Inventory AP Accrual Transactions Using Reconciliation Reports
<Note 824388.1> - R12 Account Requirements For Inventory Accrual Reconciliation
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Release 11i Write Off Process|
|Release 12 Write Off Process|
|R12 Process Flow By PO Example|
|Table Level Contrast R11i And R12|
|Accounts Requirement For Write Off|
|Data And Queries|
|Still Have Questions?|