Issue In Master Customer Statement -- Payment Allocation Record (Doc ID 2674366.1)

Last updated on APRIL 19, 2021

Applies to:

Symptoms

Master statment file is not getting generated fails with error due to issue in txn date format( MM/DD/YYYY)

ERROR
-----------------------
Ora Error Msg : ORA-01843: not a valid month

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create master and associate account.
2. Run the billing batch job
3. Post payment for both accounts.
4. Run the billing batch job
5. Run the Set-ODD2 batch job- MASTER CUSTOMER STATEMENT GENERATION
6. Run the SET-ODD3 batch job - CREATE OUTPUT DATA DUMP FILES
7. Check in Output folder for  master statment is generated.
8. Check whether payment txn date is showing in the format MM/DD/YYYY

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customers not able to generate the statement for accounts

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.