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 FEBRUARY 05, 2015

Applies to:

Oracle Advanced Collections - Version 12.1.2 and later
Information in this document applies to any platform.

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. 

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