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

Last updated on NOVEMBER 06, 2015

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


Symptoms

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
    Navigation
    : Transactions >Transactions
  2. Generate Invoice with Rules (Save) (Complete).
  3. Run following script which shows Invoice in the queue.to 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms