OUT: Planning Schedule (830/DELFOR) Going To Error - SQL Error Message ORA-01722: (Doc ID 2264277.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Supplier Scheduling - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, 830 Outbound Planning Schedule

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**21-DEC-2016 12:01:43
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

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms