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

Last updated on FEBRUARY 18, 2019

Applies to:

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

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