Planning AutoSchedule With Error ORA-00001: unique constraint (EC.ECE_SPSO_ITEMS_U1) (Doc ID 2064279.1)

Last updated on OCTOBER 08, 2015

Applies to:

Oracle EDI Gateway - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Error executing the concurrent program “Planning AutoSchedule” that points to a unique constraint violated.

ECSPSO module: OUT: Planning Schedule (830/DELFOR)


Program Info: Beginning Outbound Planning Schedule (SPSO) process.
Program Info: Run ID: 550986
Program level ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl: Please check the log file, correct the problem, and try again.
Program level xProgress: Please check the log file, correct the problem, and try again.
ECE_ERROR_CODE
SQL error message ORA-00001: unique constraint (EC.ECE_SPSO_ITEMS_U1) violated.
Program Error: PL/SQL position not found for to_char(g_error_count).
Program Info: Value: p_apps_tbl(g_error_count).value
Program Info: Data Type: p_apps_tbl(g_error_count).data_type
Program Info: Column Name: to_char(g_error_count).base_column_name
Program level SPSOB-10-1560: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
Program level SPSO-10-1030: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .

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