My Oracle Support Banner

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:

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 Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

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

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
Goal
Solution
References


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