My Oracle Support Banner

Revenue Recognition Issue: Completes with Warning and Shows 'Unprocessed or Partially Processed Transactions' (Doc ID 560515.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Receivables - Version 11.5.0 and later
Information in this document applies to any platform.
REPORT:ARBARL.RDF - Revenue Recognition
ConcurrentProgram:ARBARL_NON_SRS - Revenue Recognition from GL Transfer Program
REPORT:ARXGER.RDF - Unposted Items Report
ConcurrentProgram:ARXGER_NON_SRS - Unposted Items Report from GL Transfer Program
EXECUTABLE:ARGLTP - General Ledger Transfer Program

Purpose

Oracle Receivables (AR): Transactions Workbench Information Center > Understanding and Troubleshooting Revenue Recognition in Oracle Receivables > Note 560515.1

You are using Invoicing and Accounting Rules for your Oracle Receivables transactions, and you are encountering issues in the Revenue Recognition Process. This document describes basic steps to be verified from the User Interface in case you are experiencing the following:

  1. The Revenue Recognition Execution Report completes with a Warning Status, and there are invoices listed in the section Unprocessed or Partially Processed Transactions.

  2. The same transaction numbers listed above also appear on the Unposted Items Report from GL Transfer Program under the Category: Sales Invoices marked with '*' at the end of the line, which indicates 'The revenue distributions for this transaction have not been generated by the Revenue Recognition program.'

If both conditions are true Revenue Recognition was not able to successfully process this transaction and it is missing accounting lines.

Please also review the following notes for additional information:
Note 1121944.1, Understanding and Troubleshooting Revenue Recognition
Note 1116934.1, How To Setup And Troubleshoot Invoicing Rules and Accounting Rules

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. Identify the Accounting Rule, Duration and Start Date for Revenue Recognition
 2. Check the status of the Periods to be used by the Rule Associated to the Transaction
 3. Illustration of Various Scenarios
 a. Working Scenario: FEB-10 as current period
 b. Failing Scenario: FEB-10 as current period
 c. Failing Scenario: MAR-10 as current period
 d. Failing Scenario: Special Case with Not Opened Periods
 4. 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.