Why Does The Last Payment Amount Remain Blank While Last Payment Date Is Populated? (Doc ID 956200.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Advanced Collections - Version: 12.0.4 to 12.0.6
Information in this document applies to any platform.
IEXRCALL

Goal

If you run the following query against AR_TRX_BAL_SUMMARY you will see the last_payment_amount is showing in the table as expected. However, the value does not show in the IEXRCALL header. Why?

select last_payment_amount,
last_payment_date,
last_payment_number
from AR_TRX_BAL_SUMMARY
where cust_account_id = <&yourcust_account_id>;

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