FDI: After Importing RPD into SME via External Merge Application, While Publishing Encounters Error: '\n[38079] Foreign Key'
(Doc ID 3038639.1)
Last updated on AUGUST 22, 2024
Applies to:
Fusion Data Intelligence - Version 24.R1.x and laterInformation in this document applies to any platform.
Symptoms
Import Custom RPD into Semantic model extension through External merge Application and when try to publish, it reads following error
Consistency Errors Found:
ERRORS:\n\n\n\nGLOBAL: \n[38079] Foreign key
"Oracle_Data_Warehouse".."OAX$OAC".
"XXXXXXXXXXXX"."XXXXXXXXXXXX_CA_FiscalYear_Foreign Key_XXXXXXXX"
: A comparison is being carried out between non-compatible types VARCHAR and INTEGER. \n[38079] Foreign key
"Oracle_Data_Warehouse".."OAX$OAC"."XXXXXXXXXXXXXXXXXX"."Fact_DW_AP_SLA_LIAB_PMT_CF_FiscalYear_Foreign
Key_XXXXXXXXXXXXXX" : A comparison is being carried out between non-compatible types VARCHAR and INTEGER.
\n[38079] Foreign key "Oracle_Data_Warehouse".."OAX$OAC"."XXXXXXXXXXXX"."XXXXXXXXXXXXX_Foreign Key#58"
: A comparison is being carried out between non-compatible types DOUBLE PRECISION and VARCHAR. \n\n\n
ERRORS:\n\n\n\nGLOBAL: \n[38079] Foreign key
"Oracle_Data_Warehouse".."OAX$OAC".
"XXXXXXXXXXXX"."XXXXXXXXXXXX_CA_FiscalYear_Foreign Key_XXXXXXXX"
: A comparison is being carried out between non-compatible types VARCHAR and INTEGER. \n[38079] Foreign key
"Oracle_Data_Warehouse".."OAX$OAC"."XXXXXXXXXXXXXXXXXX"."Fact_DW_AP_SLA_LIAB_PMT_CF_FiscalYear_Foreign
Key_XXXXXXXXXXXXXX" : A comparison is being carried out between non-compatible types VARCHAR and INTEGER.
\n[38079] Foreign key "Oracle_Data_Warehouse".."OAX$OAC"."XXXXXXXXXXXX"."XXXXXXXXXXXXX_Foreign Key#58"
: A comparison is being carried out between non-compatible types DOUBLE PRECISION and VARCHAR. \n\n\n
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 |