Not All Exceptions Record Are Listed In ARXAIEXP, When Try To Query Using The "error Exist" Check
Last updated on NOVEMBER 14, 2016
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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
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.
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