ECM BATCH EXECUTION Error - "CUST_IMP_LICENSE"&"MAX_LIC_ACTVY_AMT" INVALID IDENTIFIER (Doc ID 2754761.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

BD_CUST_IMP_LICENSE_EVNT and BD_CUST_IMP_LICENSE failed with create temp table error.

For DATAMOVEMENTCODE=BD_CUST_IMP_LICENSE_EVNT :-

java.sql.SQLException: ORA-20104: Create Temp Table failed
ORA-06512: at "<schema_name>.PKG_FCC_DM", line 220
ORA-06512: at line 1

For DATAMOVEMENTCODE=BD_CUST_IMP_LICENSE :-

java.sql.SQLException: ORA-20104: Create Temp Table failed
ORA-06512: at "<schema_name>.PKG_FCC_DM", line 220
ORA-06512: at line 1
ORA-06512: at "<schema_name>.PKG_FCC_DM", line 220

From the fcc_dm_error_details table we found the below :-

ORA-00904: "CUST_IMP_LICENSE"."MAX_LIC_ACTVY_AMT": invalid identifier

When client executed the below queries he received the below error:-
SELECT
max_lic_actvy_amt,
arc.*
FROM
cust_imp_license_arc arc;

SELECT
max_lic_actvy_amt,
lic.*
FROM
cust_imp_license lic;

ORA-00904: "CUST_IMP_LICENSE_ARC"."MAX_LIC_ACTVY_AMT": invalid identifier

Cause

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