Advanced Collections: Unable to Drill from the Collections Workbench IEXRCALL to the AR Transactions Workbench ARXTWMAI for Debit Memos (Doc ID 1508286.1)

Last updated on JULY 13, 2020

Applies to:

Symptoms

Unable to drill down from the Collections workbench IEXRCALL to the AR Transactions workbench ARXTWMAI for Debit Memos.  It displays a blank screen.
This behavior only exists for debit memos, but works successfully with invoices.

If the debit memos are queried in the ARXTWMAI workbench, it displays correctly.

The trace the drill down shows one of the selects traced is not fetching any data:

The where-clause is excluding classes DEP, GUAR or DM, this would explain the behavior. 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.