EDI INO Extensible Architecture Implementation Issue After Upgrade to 12.2 - ORA-00904: "ECE_AR_TRX_HEADER_1_X"."XXC_INO_3079_EXT1": Invalid Identifier (Doc ID 1948046.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

You require INO (INOUT: Invoice (810/INVOIC)) extension to be implemented with desired extra columns in ECE_AR_TRX_HEADER_1_X  and Level 4 ECE_AR_TRX_LINES_X.

Accordingly, you altered EC.ECE_AR_TRX_HEADER_1_X And EC.ECE_AR_TRX_LINES_X tables to add extra columns.

After migrating to 12.2, ECEINO (810:Out) no longer produces output and generates and error

ECEINO

ECE_PARSING_ERROR (ERROR_POSITION=51)
...
ECE_ERROR_CODE (ERROR_CODE=-904)
SQL error message ORA-00904: "ECE_AR_TRX_HEADER_1_X"."XXC_INO_3079_EXT1": invalid identifier.
Program level 2231-60: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
Program level 2231-60: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .

Changes

Upgrade to 12.2

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