My Oracle Support Banner

Revenue Recognition Issue: Invoices Which Were Previously Incomplete, But are Complete Now are Ignored (Doc ID 1320443.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Report:ARBARL.RDF - Revenue Recognition


Invoices with rules (Advanced or Arrears) are not getting picked up by the Revenue Recognition process when run with Submit Accounting Process.

Steps to Reproduce

  1. Responsibility: Receivables Manager
    : Transactions >Transactions
  2. Generate Invoice with Rules (Save) (Complete).
  3. Run following script which shows Invoice in the be processed by Revenue Recognition, and confirm that the invoice is listed.

  4. Incomplete the Invoice.
  5. Run following the same SQL script and confirm the invoice is still in the queue.
  6. Perform Submit Accounting, this will call Revenue Recognition Master Program as part of its process. Since the Invoice created above is incomplete, Revenue Recognition will not process it, and this is correct.
  7. Run the same SQL script again. This time you will note that the Invoice has been removed from the queue.
  8. Now go back to the Transaction form and Complete the Invoice
  9. Run the same SQL script again, and verify that the Invoice was not added back to the queue.
  10. At this point if you run Submit Accounting again, the Revenue Recognition Process will not see this invoice in the queue, and will not create the proper distributions for it.




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
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
 Still Have Questions?

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