Process connector execution fails
(Doc ID 2738636.1)
Last updated on FEBRUARY 27, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.0.0.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |