Out: Planning Schedule (830/Delfor) Fails With SPSOB-10-1500 and ORA-01422
(Doc ID 1363134.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Supplier Scheduling - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
ConcurrentProgram:ECESPSI - Planning Sequence (830, DELFOR)
Symptoms
When running ECSPSO module: OUT: Planning Schedule (830/DELFOR),
you see the following error:
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,
---------------------------------------------------------------------
Program level SPSOB-10-1500: Please check the log file, correct the problem, and try again.
SQL error message ORA-01422: exact fetch returns more than requested number of rows.
Program level SPSO-10-1030: Please check the log file, correct the problem, and try again.
SQL error message 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,
---------------------------------------------------------------------
Program level SPSOB-10-1500: Please check the log file, correct the problem, and try again.
SQL error message ORA-01422: exact fetch returns more than requested number of rows.
Program level SPSO-10-1030: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
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 |