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

Last updated on APRIL 13, 2023

Applies to:

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: .

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.