My Oracle Support Banner

R12 AP: Incremental Load for Payables Command Center Data Load Fails with Error: ORA-01843: not a valid month (Doc ID 2870266.1)

Last updated on MAY 20, 2022

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

After upgrade from 12.1.3 to 12.2.x and fresh implementation of ECC, when attempting to run Incremental Load for Payables 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 AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ap-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 AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ap-dispute for job 13,611java.sql.SQLDataException: ORA-01843: not a valid month at oracle.jdbc.drive

Steps to Reproduce:

Responsibility: Payables Manager
Navigation: View> Requests>

Submit Payables Command Center Data Load for INCREMENTAL_LOAD
Check the Log file> Error occurs

Changes

 Issue occurred after upgrade from 12.1.3 to 12.2.x and a fresh implementation of ECC

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
References


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