Correction Upload Failing Due To Duplicate Columns. (Doc ID 2945048.1)

Last updated on MAY 03, 2023

Applies to:

Symptoms

When we are trying to upload correction in Excel where there are different values for the columns, it is getting failed. In the attached adjustment excel, the value of column V_CUST_REF_CODE is 'MSG' for the first account and 'OTH' for the other accounts.

Filename = nohup.out(Weblogic)
See the following error:

nonmandatoryPPDims:
alt table movesql:Insert into ADJ_STG_LOAN_CONTRACTS (fic_mis_date,V_ACCOUNT_NUMBER,v_gaap_code,n_load_run_id,V_CCY_CODE,V_LV_CODE,V_ACCR_INT_GL_CODE,N_ACCRUED_INTEREST,F_EXP_REVOLVING_FLAG,F_COLLATERAL_DEPENDENCY,V_CREDIT_QUALITY_TYPE_CODE,V_ORG_UNIT_CODE,V_HOLDING_TYPE,D_ORIGINATION_DATE,V_DATA_ORIGIN,V_PROD_CODE,V_CUST_REF_CODE,N_DELINQUENT_DAYS,V_ACCT_STATUS_CODE,V_LOAN_TYPE,V_INTEREST_TYPE,V_LOAN_TYPE,V_LOAN_TYPE,V_PROD_CODE,V_PROD_CODE,V_CUST_REF_CODE,F_TROUBLED_DEBT_RESTRUCRE_FLAG,V_CHANNEL_CODE,V_CREDIT_STATUS_CD,V_ACCOUNT_CLASSIFICATION_CD,V_ACCRUAL_STATUS_CODE,N_ORIG_LTV,D_MATURITY_DATE,N_JOINING_SCORE,V_LIEN_POSITION_CD, ADJUSTMENT_DEF_ID, ADJUSTMENT_TIMESTAMP) select fic_mis_date,V_ACCOUNT_NUMBER,v_gaap_code,0,V_CCY_CODE,V_LV_CODE,V_ACCR_INT_GL_CODE,N_ACCRUED_INTEREST,F_EXP_REVOLVING_FLAG,F_COLLATERAL_DEPENDENCY,V_CREDIT_QUALITY_TYPE_CODE,V_ORG_UNIT_CODE,V_HOLDING_TYPE,D_ORIGINATION_DATE,V_DATA_ORIGIN,V_PROD_CODE,V_CUST_REF_CODE,N_DELINQUENT_DAYS,V_ACCT_STATUS_CODE,V_LOAN_TYPE,V_INTEREST_TYPE,V_LOAN_TYPE,V_LOAN_TYPE,V_PROD_CODE,V_PROD_CODE,V_CUST_REF_CODE,F_TROUBLED_DEBT_RESTRUCRE_FLAG,V_CHANNEL_CODE,V_CREDIT_STATUS_CD,V_ACCOUNT_CLASSIFICATION_CD,V_ACCRUAL_STATUS_CODE,N_ORIG_LTV,D_MATURITY_DATE,N_JOINING_SCORE,V_LIEN_POSITION_CD,5022838,SYSTIMESTAMP from STG_LOAN_CONTRACTS where V_ACCOUNT_NUMBER='GL_364_88523' and n_load_run_id=0
java.sql.SQLSyntaxErrorException: ORA-00957: duplicate column name

Cause

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