R12: AP: The Profile “CE: Available Transactions Range for ECC” Is Not Available and the Child Program ECC Run Data Load Ends With the Error “ORA-20001: Value for the Profile Option “CE: Available Transactions Range for ECC” Is Not Set in Correct Format”
(Doc ID 3020257.1)
Last updated on JUNE 13, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
When attempting to Cash Management Command Center Data Load program, the following error occurs in the log of child program ECC Run Data Load
ORA-20001: Value for the profile option "CE: Available Transactions Range for ECC" is not set in correct format. Please set the date value in DD-MON-RRRR (Example 01-JAN-2020) format and run the data load ORA-06512: at "APPS.CE_ECC_UTIL_PVT", line 2731 ORA-06512: at line 1 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
The issue can be reproduced at will with the following steps:
- Log into ECC Developer responsibility
- Run the Cash Management Command Center Data Load program
- Review the log of child program ECC Run Data Load
- The patch 35824939 was applied (solution from Doc ID 2981480.1 - R12 AP: ECC Data Load Error: "ORA-20001: No value is set for the profile option CE: Available Transactions Range for ECC") but the profile name "CE: Available Transactions Range for ECC" is not in the list of values from System Administrator responsibility - Profile - System
Changes
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 |