Incremental Load for Receivables Command Center Data Load Fails with Error: ORA-01843: not a valid month on ECC Receivables V6 Version
(Doc ID 2795217.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.4 and laterOracle Receivables - Version 12.2.4 and later
Information in this document applies to any platform.
Symptoms
After upgrade from 12.1.3 to 12.2.8 and fresh implementation of ECC V6 Version, when attempting to run Incremental Load for Receivables Command Center Data Load, the following error occurs in the Log file:
ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ar-period-close for job 13,611java.sql.SQLDataException: ORA-01843: not a valid month at oracle.jdbc.driver
ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ar-dispute for job 13,611java.sql.SQLDataException: ORA-01843: not a valid month at oracle.jdbc.drive
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: View> Requests>
- Submit Receivables Command Center Data Load for INCREMENTAL_LOAD
- Check the Log file> Error occurs
Changes
Issue occured after upgrade from 12.1.3 to 12.2.8 and a fresh implementation of ECC V6 Version
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 |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
References |