Questions on the Upgrade of PFT and ALM 802 to PFT 804 Followed by ALM 804

(Doc ID 2314176.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Goal

Question 1:  PFT 804 upgrade on newly created PFT+ALM 802:

As per install guide for PFT 804, the following note indicate a complete model re-build
=====
"Bug 23251358-Object Registration is failing with duplicate Constraint Names is regularized in this OFS AAAI application pack 8.0.4.0.0. This is bundled as a utility - Update Constraints Utility, and is executed as part of the 8.0.4.0.0 patch installation. You must perform the steps listed below and apply the change before you proceed further with the patch upgrade.
Backup the atomic schema for each Information Domain in the OFSAA instance before applying the patch.
Execution of the utility is a memory intense process as the entire steps involved for performing a full model upload is carried out as part of the utility for each of the Infodom. The OFSAA installation server needs to have twice the allocated memory, which is assigned using parameter X_ARGS_APPS.
======

What does the above do? Does it perform model upload with "complete mode rebuild" model?? If yes, where does it pick the complete data model from as the installer will only have the slice model for PFT 804?
 
Question 2: FTP Web Service Configuration , jdbc/FTPWS.
When does this configuration to be done? Is it mandatory?
 
Question 3: Is <Patch 25777667> mandatory? What exactly does this patch do?
 
Question 4: Model_Prescripts.sql. The Model_Prescripts_804.sql has already been run as part of PFT 804 and <Patch 25561603> is already installed.
Does this script need to be run again as part of ALM 804 installation? if yes, which patch should the script be run from, <Patch 25589028> or <Patch 25457961>?
 
Question 5: Can the following errors generated after PFT 8.0.4 -> ALM 8.0.4 upgrade in OFS_ALM_patch_installation_2.log be ignored?

[Thu 14/9/2017 01:34:25] [OFS_ALM] [ INFO] - Executing file:/opt/ofsa/ofsaahome/scripts/atomic/create/dm_alm_create_8.0.4.0.0.sql
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'create table FSI_INDEX_ADJ_TYPE_CD
(
 INDEX_ADJ_TYPE_CD NUMBER(5) not null
)'
 Warning:Object already exists
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_INDEX_ADJ_TYPE_CD
 add constraint PK_FSI_INDEX_ADJ_TYPE_CD primary key (INDEX_ADJ_TYPE_CD)'
 Warning:Table already has a primary key
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'create table FSI_INDEX_ADJ_TYPE_MLS
(
 MLS_CD VARCHAR2(10 CHAR) not null,
 INDEX_ADJ_TYPE_CD NUMBER(5) not null,
 INDEX_ADJ_TYPE VARCHAR2(40 CHAR),
 DESCRIPTION VARCHAR2(255 CHAR)
)'
 Warning:Object already exists
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_INDEX_ADJ_TYPE_MLS
 add constraint PK_FSI_INDEX_ADJ_TYPE_MLS primary key (MLS_CD, INDEX_ADJ_TYPE_CD)'
 Warning:Table already has a primary key
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_INDEX_ADJ_TYPE_MLS
 add constraint FK_FSI_INDEX_ADJ_TYPE_MLS_1 foreign key (INDEX_ADJ_TYPE_CD)
 references FSI_INDEX_ADJ_TYPE_CD (INDEX_ADJ_TYPE_CD)'
 Warning:Table already has a referential constraint with same name
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_INDEX_ADJ_TYPE_MLS
 add constraint FK_FSI_INDEX_ADJ_TYPE_MLS_2 foreign key (MLS_CD)
 references FSI_MLS (MLS_CD)'
 Warning:Table already has a referential constraint with same name
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'create table FSI_CAP_PROTECTION_CAT_CD
(
 CAP_PROTECTION_CATEGORY_CD NUMBER(5) not null
)'
 Warning:Object already exists
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_CAP_PROTECTION_CAT_CD
 add constraint PK_FSI_CAP_PROTECTION_CAT_CD primary key (CAP_PROTECTION_CATEGORY_CD)'
 Warning:Table already has a primary key
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'create table FSI_CAP_PROTECTION_CAT_MLS
(
 MLS_CD VARCHAR2(10 CHAR) not null,
 CAP_PROTECTION_CATEGORY_CD NUMBER(5) not null,
 CAP_PROTECTION_CATEGORY VARCHAR2(40 CHAR),
 DESCRIPTION VARCHAR2(255 CHAR)
)'
 Warning:Object already exists
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_CAP_PROTECTION_CAT_MLS
 add constraint PK_FSI_CAP_PROTEC_CAT_MLS primary key (MLS_CD, CAP_PROTECTION_CATEGORY_CD)'
 Warning:Table already has a primary key
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_CAP_PROTECTION_CAT_MLS
 add constraint FK_FSI_CAP_PROTEC_CAT_MLS_1 foreign key (CAP_PROTECTION_CATEGORY_CD)
 references FSI_CAP_PROTECTION_CAT_CD (CAP_PROTECTION_CATEGORY_CD)'
 Warning:Table already has a referential constraint with same name
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'alter table FSI_CAP_PROTECTION_CAT_MLS
 add constraint FK_FSI_CAP_PROTEC_CAT_MLS_2 foreign key (MLS_CD)
 references FSI_MLS (MLS_CD)'
 Warning:Table already has a referential constraint with same name
[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'ALTER TABLE FSI_M_PROD_CHARACTERISTICS ADD INDEX_ID NUMBER(10)'
 Error:ORA-01430: column being added already exists in table

[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'ALTER TABLE FSI_M_PROD_CHARACTERISTICS ADD INDEX_ADJ_TYPE_CD NUMBER(5)'
 Error:ORA-01430: column being added already exists in table

[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'ALTER TABLE FSI_M_PROD_CHARACTERISTICS ADD CAP_PROTECTION_CATEGORY_CD NUMBER(5)'
 Error:ORA-01430: column being added already exists in table

[Thu 14/9/2017 01:34:25] [OFS_ALM] [ERROR] - Query:'ALTER TABLE FSI_M_PROD_CHARACTERISTICS ADD INFLATION_ADJUSTMENT_FLG NUMBER(1)'
 Error:ORA-01430: column being added already exists in table

[Thu 14/9/2017 01:34:26] [OFS_ALM] [ INFO] - # of errors in file=4

Solution

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