System Not Updating Acc_term_pd for Accounts After Payments (Doc ID 2995406.1)

Last updated on DECEMBER 28, 2023

Applies to:

Symptoms

 ACTUAL BEHAVIOR
---------------
System Not Updating Acc_term_pd for Accounts After Payments

For a few accounts, its observed that system is not incrementing acc_term_pd on the accounts. 

Looks like data from migration did not make it to accounts table for acc_term_pd column.

EXPECTED BEHAVIOR
-----------------------
System should migrate the account paid term data correctly to the accounts table so that the same will be shown in the customer service tab and also payment posted will be equal to the paid balances.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Load data in Migration ITABLES.

2)Set Acc_term_pd =40 in iaccounts for a sample account.

3)After running ACCAAI_BJ_100_01. Check in accounts table acc_term_pd is setting to zero.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the payment posted equal to the paid balances and paid term details in the account details.

Cause

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