Oracle Financial Services Funds Transfer Pricing 6.1.1 Upgrade Fails With Unique Constraint Errors (Doc ID 2546979.1)

Last updated on OCTOBER 16, 2019

Applies to:

Goal

When upgrading FTP to 611 from 61 with OFSAAI 735. FTP 61 and PFT 61 and functional with OFSAAI 735.

There are many errors in the logs referring the unique constraint violations:
[Thu 07/2/2019 09:41:22] [OFSFTP] [ INFO] - Config Scripts
[Thu 07/2/2019 09:41:22] [OFSFTP] [ INFO] - Executing file:/app/ofsaai/scripts/config/insert/cssms_start_page.sql
[Thu 07/2/2019 09:41:22] [OFSFTP] [ERROR] - Query:'insert into CSSMS_START_PAGE_MASTER (START_PAGE_ID, START_PAGE_URL, START_PAGE_DESC,USR_MAPPED_INFODOM) values ('FUSION', 'fsapps/common/FSHome.jsp', 'Financial Services Applications','DEFAULT')'
  Error:ORA-00001: unique constraint (PK_START_PAGE_MASTER) violated

...

[Thu 07/2/2019 09:41:23] [OFSFTP] [ INFO] - Number of lines Read: 12
[Thu 07/2/2019 09:41:23] [OFSFTP] [ INFO] - Executing file:/app/ofsaai/scripts/config/insert/date_task_master.sql
[Thu 07/2/2019 09:41:23] [OFSFTP] [ERROR] - Query:'insert into DATE_TASK_MASTER (V_INFO_DOMAIN, V_TASK_ID, V_STEP_ID, V_STEP_STATUS, V_STEP_TYPE, V_EXT_PROC_FILE, V_STEP_PARAMETERS, V_PROCEDURE_NAME, V_USED_COLUMNS, V_USED_TABLES, V_JOIN_CONDITION, V_TFM_TYPE) values ('PFTINFO', 'Batch_Member_Load', 'Batch_Member_Load_1', 'N', 'S ', null, '(batch_run_id,mis_date,pDimensionId,pMemberId,pMode)', 'fsi_batchMemberLoad', null, null, null, 'DT')'
  Error:ORA-00001: unique constraint (PK_DATE_TASK_MASTER) violated

Can these be ignored?

Solution

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