FTP Migration ORA-02291: integrity constraint (FK_FSI_TP_PROC_TABLES_1) and (FK_FSI_TP_SELCTD_COLUMNS_1) violated - parent key not found Errors

(Doc ID 2330331.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Upgrade
Migration Scripts

Symptoms

When running the import portion of the FTP migration 6.1.1.1 to 8.0.4, although the export is successful, there are several errors in the import_into_target.log:

ERRORS
1. executing file:/db/migrate/21223521/scripts/extract/atomic/fsi_tp_proc_tables.sql

FSI_TP_PROC_TABLES
MERGE INTO FSI_TP_PROC_TABLES TAB
USING (
SELECT 'CONS_LOAN_ALS' TABLE_NAME
,177913 TP_PROCESS_SYS_ID FROM DUAL ) PROXY
ON (TAB.TABLE_NAME = PROXY.TABLE_NAME
AND TAB.TP_PROCESS_SYS_ID = PROXY.TP_PROCESS_SYS_ID)
WHEN NOT MATCHED THEN INSERT (TABLE_NAME
, TP_PROCESS_SYS_ID) VALUES (PROXY.TABLE_NAME
, PROXY.TP_PROCESS_SYS_ID)'
  Error:ORA-02291: integrity constraint (FK_FSI_TP_PROC_TABLES_1) violated - parent key not found

2. Executing file:/db/migrate/21223521/scripts/extract/atomic/fsi_tp_selctd_columns.sql
FSI_TP_SELCTD_COLUMNS

Error:ORA-02291: integrity constraint (FK_FSI_TP_SELCTD_COLUMNS_1) violated - parent key not found

3. Error :ORA-00904: "PRODUCT_1_ID": invalid identifier
For: MERGE INTO DIM_PRODUCT_1_B TAB USING ( SELECT
CREATED_BY
,CREATION_DATE
,DEFINITION_LANGUAGE
,ENABLED_FLAG
,LAST_MODIFIED_BY

The issue can be reproduced at will with the following steps:
1. Run the export scripts for FTP migration from 6.1.1.1 to 8.0.4
2. Run the import scripts for FTP migration from 6.1.1.1 to 8.0.4

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms