Not All Exceptions Record Are Listed In ARXAIEXP, When Try To Query Using The "error Exist" Check (Doc ID 2199354.1)

Last updated on NOVEMBER 14, 2016

Applies to:

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

Goal

The exceptions/errors listed in 'Interface Lines' form after query with the "error exist" check box are different than when a SQL query is ran from the back end against table RA_INTERFACE_ERRORS_ALL:

SELECT * FROM RA_INTERFACE_ERRORS_ALL  
WHERE interface_line_id IN ( SELECT interface_line_id
FROM RA_INTERFACE_LINES_ALL
WHERE  interface_line_attribute1 = '&sales_order_number'  AND
NVL(org_id, -99)= &org_id ) AND
NVL(org_id, -99)= &org_id


For this specific case, sales credit exceptions were the ones omitted.
Expectation was that 'Interface Lines' form should list all the errors when the "error exist" check box is checked.
 

Solution

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