Revenue Contingency Analyzer, Does Not Implicit Post Billing Acceptance

(Doc ID 2052963.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

Issue:
======
In Order management customer acceptance status not change. when try to click customer
acceptance. system show an ERROR  
"Acceptance/Rejection failed. Error:"

There is some other transaction where Customer Acceptance was done, but in Sales Order
status are not changed.i.e There are some records where Status is "Pending post-billing
acceptance" , but if we go for Fulfillment Acceptance , All the Fields are accepted and 
checkbox in disabled, AR Transaction also showing revenue. But the status not yet updated.

Contingency is not removed on invoice post billing acceptance.

Created a line with Post Billing Acceptance. The contingency has been defined to expire after 'Shipped Days +1'.
The line is shipped and Invoiced.

When an Explicit Acceptance is performed on the same SO line then the line gets closed. The issue is with the Concurrent Program 'Revenue Contingency Analyzer' which does not pick the SO line. The program is owned by AR (invokes ar_revenue_management_pvt.periodic_sweeper).

From the investigation done by OM side, we find that there is no data inar_deferred_lines or ar_line_conts_all.
Data has been interfaced from OM to AR interface tables (both ra_interface_lines_all and AR_INTERFACE_CONTS_ALL). But during Auto Invoice, AR processes the data in
ra_interface_lines_all but not the contingency related data in AR_INTERFACE_CONTS_ALL.


Observed that the Batch Source used is 'ORACLE OM' but the INTERFACE_LINE_CONTEXT
in both the interface tables is 'ORDER ENTRY'.
.
Analysis:
=======
Reviewed the data in ra_cust_trx_line_gl_dist (GLD) Table and found that found that REV
records are missing in ra_cust_trx_line_gl_dist (GLD) Table.

Fix Approach:
============
Undo accounting has to be done and distributions have to be deleted and recreated in
ra_cust_trx_line_gl_dist (GLD) Table.

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