For Weekly Account If Pre Bill Day=7 and when the account is matured, ACC_DDT_RUN_DT_NEXT Not updated with DT_MAX in the last billing (Doc ID 2923526.1)

Last updated on JANUARY 26, 2023

Applies to:

Symptoms

For Weekly Account If Pre Bill Day=7 and when the account is matured, ACC_DDT_RUN_DT_NEXT Not updated with DT_MAX  in the last billing 

During accounts billing (Weekly Billing cycle case) , when maturity is reached and last bill is run, system is not setting the ACC_DDT_RUN_DT_NEXT as max i.e. 31-Dec-4000.
Hence these accounts are again picked up in next run by billing batch job under SET-TPE and hence batch is failing with error “ Txn Due Dt is greater than maturity Date”.

Note: For Weekly billing account, The issue is occurring only if Pre bill days = 7 .

For Weekly billing account, the issue will not occur and system will stamp ACC_DDT_RUN_DT_NEXT as DT_MAX i.e. 31-Dec-4000 when last bill is run on maturity if Prebill day < 7.

ERROR
-----------------------
Txn Due Dt is greater than maturity Date

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a weekly billing account with prebill days 7
2. Run all the billing till maturity
3. Check whether the batch job is successful
4. Create a weekly billing account with prebill days 6
5. Run all the billing till maturity
6. Check whether the batch job is successful

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.