My Oracle Support Banner

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

Last updated on JULY 05, 2018

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

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
Goal
Solution
 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.