ECSPSO: OUT: Planning Schedule (830/DELFOR) Program Fails ECE_ERROR_CODE (ERROR_CODE=-1461) (Doc ID 2584760.1)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

ECSPSO: OUT: Planning Schedule (830/DELFOR)
[08-AUG-2019 14:36:50]: **Starts**
[08-AUG-2019 14:36:54]: **SQL error and free**
[08-AUG-2019 14:36:54]: 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

Program level ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT: Please check the log file, correct the problem, and try again.
Program level FILEB-WR-1130: Please check the log file, correct the problem, and try again.
ECE_ERROR_CODE (ERROR_CODE=-1461)
SQL error message ORA-01461: can bind a LONG value only for insert into a LONG column.
Program Error: PL/SQL position not found for to_char(l_count).
Program Info: Value: &VALUE (COLUMN_NAME=p_interface_tbl(l_count).value)
Program Info: Data Type: &DATA_TYPE (COLUMN_NAME=p_interface_tbl(l_count).data_type)
Program Info: Column Name: p_interface_tbl(l_count).base_column
Program level SPSOB-50-1810: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
Program level SPSO-10-1060: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
We have observed that we receive this issue in SPSO extension when we keep WIDTH of extension field filed ECE_INTERFACE_COLUMNS > 900. program works fine if we reduce WIDTH of extended record less then or equal to 900.


Insert statement used :

Insert into ECE_INTERFACE_COLUMNS
(
STAGING_COLUMN,
INTERFACE_COLUMN_ID,
INTERFACE_TABLE_ID,
INTERFACE_COLUMN_NAME,
BASE_TABLE_NAME,
BASE_COLUMN_NAME,
COLUMN_NAME,
RECORD_NUMBER,
POSITION,
WIDTH,
CONVERSION_SEQUENCE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
RECORD_LAYOUT_CODE,
RECORD_LAYOUT_QUALIFIER,
EXTERNAL_LEVEL,
MAP_ID
)
Select
'FIELD500',
ECE_INTERFACE_COLUMN_ID_S.NEXTVAL,
EIT.INTERFACE_TABLE_ID,
NULL,
NULL,
NULL,
'XXC_PO_REL_DETAIL',
4910,
10,
4000,
NULL,
1,
SYSDATE,
1,
SYSDATE,
NULL,
'XI',
'XIR',
3,
(select map_id from ece_mappings where map_code = 'EC_SPSO_FF')
from ECE_INTERFACE_TABLES EIT
where EIT.TRANSACTION_TYPE = 'SPSO'
and EIT.INTERFACE_TABLE_NAME = 'ECE_SPSO_ITEM_DET'

Table Altered :

ALTER TABLE EC.ECE_SPSO_ITEM_DET_X
ADD
(
XXXX_PO_REL_DETAIL VARCHAR2(4000)
);

Cause

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