My Oracle Support Banner

Understanding and Troubleshooting Revenue Recognition in Oracle Receivables (Doc ID 1121944.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Executable:RAXMTR - AutoInvoice Master Program
Executable:RAXTRX - AutoInvoice Import Program
Form:ARXTWMAI.FMB - Transactions
ConcurrentProgram:ARBARL_NON_SRS2 - Revenue Recognition Execution Report
ConcurrentProgram:ARBARL_NON_SRS - Revenue Recognition from GL Transfer Program


Purpose

Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1121944.1

Oracle Receivables (AR): Transactions Workbench Information Center > Note 1121944.1

Oracle Receivables provides the flexibility of defining a schedule of how you want the revenue for your invoices to be recognized, this is controlled by specifying Invoicing and Accounting rules to indicate to the Revenue Recognition program the desired schedule of recognizing revenue.

This note was created to provide troubleshooting tips for issues involving Revenue Recognition. It is suggested that you also review Note 1116934.1, How To Setup And Troubleshoot Invoicing Rules and Accounting Rules, because these topics are tightly integrated.

EBS Oracle Receivables Reconciliation Analyzer DocID 2255895.1

The EBS Oracle Receivables Reconciliation Analyzer is a self-service health-check script that reviews Receivables related data, analyzes current configurations and settings for the environment and provides feedback and recommendations on best practices.
Analyzers may also be used as data collection tools by Support Engineers.

 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Overview of Revenue Recognition
 2. Using Revenue Recognition
    a. Standalone process in batch mode.
    b. Online in Transactions form
    c. Implicitly via the transfer to General Ledger
 3. Underlying table information and code supporting Revenue Recognition
 4. Illustration of impact of running Revenue Recognition
    a. Illustration of an Invoice without rules
    b. Illustration of an Invoice with rules
 5. Troubleshooting Revenue Recognition
    a. Check that the period associated to the Accounting Rule you are using is the same period associated to your Ledger.
    b. Validate GL periods
    c. Validate the status of fields impacted by Revenue Recognition
    d. Printer setup
    e. Cannot specify Print Format (Detailed or Summary) when running Revenue Recognition through General Ledger Transfer or Submit Accounting
    f. Data Corruption Issues
         i) null ACCOUNTING_RULE_DURATION
    g. Aborting Revenue Recognition
    h.  Multi-Reporting Currency (MRC) Issues (11.5 only)
         i) arp_auto_rule.create_other_plug() error
 Please ensure your version of glcauts.pls is at least 115.11.
         ii) ORA-00001 UNIQUE CONSTRAINT (AR.RA_MC_TRX_LINE_GL_DIST_U1) VIOLATED
     i. Running Create Accounting raises error
     j. Revenue Recognition process stays in Pending/Standby status
     k. GL date or Transaction date issues
 6. How to enable debugging and tracing for Revenue Recognition
    a. Enabling trace
    b. Enabling FND debugging
 7. Code Bugs
 8. Still have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.