My Oracle Support Banner

R12: ECC: Payables Full Load Fails With ORA-01847: Day of Month Must be Between 1 and Last Day of Month (Doc ID 2792887.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

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

Symptoms

 While running Full Load for Accounts Payables ( AP ), on Enterprise Command Center ( ECC ) version 6 (V6) for the first time after implementation, below error is received:

ERROR
-----------------------

Caused by: oracle.jdbc.OracleDatabaseException: ORA-01847: day of month must be between 1 and last day of month

The issue can be reproduced at will with the following steps:
1. Go into the responsibility: ECC Developer.
2. Navigate to ECC Developer > Data Load Submission.
3. Fill in parameters: Application name = Payables, Dataset = Installments ( ap-trx ), Load Type = Full Load.
4. Click Submit button.
5. See above error.

ECC log is showing below error:

ERROR 2.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-trx for job TTTT
java.sql.SQLDataException: ORA-01847: day of month must be between 1 and last day of month
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
~[ojdbc8.jar:19.3.0.0.0]

 

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
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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