By MMCasey-Oracle on Aug 11, 2014
Oracle Receivables has just launched our latest Analyzer, the AutoAccounting Analyzer. This new analyzer is a self-service health-check script that reviews the current configurations and settings for your AutoAccounting set-up and provides feedback and recommendations to address errors you are encountering. Your data is NOT altered in any way when you run the Analyzer. It does not perform INSERTS, UPDATES or DELETES.
So how does it work? When creating a transaction via the Transaction Form or via AutoInvoice, and AutoAccounting raises errors, this Analyzer could assist you in identifying the cause and how to fix it. This list shows sample error messages, you may get variations of the error messages below:
- Please complete the offset account assignments
- Please correct the receivables account assignment
- Please correct the revenue account assignment
- APP-AR-42536 This transaction is associated with at least one invalid or end-dated GL Account.
Currently the AutoAccounting Analyzer handles issues with the following AutoAccounting Types, values in () are what you would enter as p_account_type_in parameter when running the Analyzer:
- Revenue (REV)
- Receivable (REC)
- Unearned Revenue (OFFSET)
- Unbilled Receivable (OFFSET)
- AutoInvoice Clearing (OFFSET)
How do you download and use this Analyzer? The AutoAccounting Analyzer can be run via SQL*Plus or as a Concurrent Request. For step by step details on how to download and run see DocID: 1904785.1 Oracle Receivables AutoAccounting Analyzer
The note includes two short videos on how to install the Analyzer as well as how to use the Output of the Analyzer.
Below is a small portion of the sample output.