Process connector execution fails (Doc ID 2738636.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Symptoms

On : 8.1 version,Metadata_OFSS

When attempting to execute process connector,
the following error occurs.

ERROR
-----------------------
Failed query text:
create table I$TARGET_FCT_ACCT_CUST_CHG_REL_39_V
(
N_MIS_DATE_SKEY,
V_ACCOUNT_NUMBER,
V_CUST_REF_CODE,
V_PREV_CUST_REF_CODE,
D_RELN_EFF_DATE
) as
select
1,
FCT_ACCT_CUST_CHG_REL.V_ACCOUNT_NUMBER,
FCT_ACCT_CUST_CHG_REL.V_CUST_REF_CODE,
FCT_ACCT_CUST_CHG_REL.V_PREV_CUST_REF_CODE,
FCT_ACCT_CUST_CHG_REL.D_RELN_EFF_DATE
from OFSAEPM.STG_ACCT_CUST_CHG_REL STG_ACCT_CUST_CHG_REL
where (1=1)
  

ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-OFSAEPM_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-OFSAEPM_UNIT (20)" failed because child task "create I$ table-IKM Oracle Insert Only (Ext Tab and DB)- (50)" is in error.
ODI-1228: Task create I$ table-IKM Oracle Insert Only (Ext Tab and DB)- fails on the target connection OFSAEPM.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "FCT_ACCT_CUST_CHG_REL"."D_RELN_EFF_DATE": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to execute process connector

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute process connector.

Cause

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