My Oracle Support Banner

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 later
Oracle 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>

  1. Submit Receivables Command Center Data Load for INCREMENTAL_LOAD
  2. 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


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