OUT: Planning Schedule (830/DELFOR) Going To Error - SQL Error Message ORA-01722:
(Doc ID 2264277.1)
Last updated on NOVEMBER 23, 2023
Applies to:
Oracle Supplier Scheduling - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run the concurrent request: CSPSO module: OUT: Planning Schedule (830/DELFOR), the following error occurs.
ERROR
CSPSO module: OUT: Planning Schedule (830/DELFOR)
+---------------------------------------------------------------------------+
**Starts**
ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001:
ORA-06512: at "APPS.ECE_SPSO_TRANS1", line 268
ORA-06512: at line 1
The SQL statement being executed at the time of the error was: SELECT
R.Conc_Login_Id, R.Request_Id, R.Phase_Code,
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program Info: Beginning Outbound Planning Schedule (SPSO) process.
Program Info: Run ID: 67375
Program level SPSO2B-10-1230: Please check the log file, correct the problem,
and try again.
SQL error message ORA-01722: invalid number.
Program level SPSO2B-10-1230: Please check the log file, correct the problem,
and try again.
SQL error message ORA-20001: .
Program level SPSO2B-10-1230: Please check the log file, correct the problem,
and try again.
SQL error message ORA-20001: .
Program level SPSO2B-10-1230: Please check the log file, correct the problem,
and try again.
SQL error message ORA-20001: .
Program level SPSO-10-1040: Please check the log file, correct the problem,
and try again.
SQL error message ORA-20001: .
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Purchasing.
2. Request: Run the program 'ECSPSO Planning Schedule '
3. The request completed with the mentioned error
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 |
References |