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:
Oracle Financial Services Lending and Leasing Cloud Service - Version 14.12.0.0.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |