My Oracle Support Banner

Questions About Upgrading PFT and FSDF Application Packs to 8.0.5 (Doc ID 2362330.1)

Last updated on FEBRUARY 23, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 to 8.0.5 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Data Foundation (FSDF) previously known as Oracle Financial Services Data Warehouse (FSDW)
Upgrade Installation

Goal

Question 1: From Chapter 5: Upgrading the OFS PFT Application Pack.  Download the pack file: p26744949_80000_Linux-x86-64.zip after unzip, have a folder: OFS_PFT_PACK

$ cd OFS_PFT_PACK
$ $ ll
total 240
drwxr-x--- 10 ofsaa ofsaa 8192 Sep 18 01:52 .
drwx------ 3 ofsaa ofsaa 8192 Jan 30 17:20 ..
drwxr-x--- 2 ofsaa ofsaa 8192 Sep 14 06:13 bin
drwxr-x--- 2 ofsaa ofsaa 8192 Sep 14 06:13 conf
drwxr-x--- 2 ofsaa ofsaa 8192 Sep 14 06:13 logs
drwxr-x--- 3 ofsaa ofsaa 8192 Sep 14 06:13 OFS_AAAI
drwxr-x--- 21 ofsaa ofsaa 8192 Sep 14 06:13 OFS_AAAI_PACK
drwxr-x--- 5 ofsaa ofsaa 8192 Sep 14 06:13 OFS_AAI
drwxr-x--- 7 ofsaa ofsaa 8192 Sep 14 06:14 OFS_PFT
-rwxr-x--- 1 ofsaa ofsaa 48052 Sep 17 07:16 ofspft_80500_readme.html
drwxr-x--- 9 ofsaa ofsaa 8192 Sep 14 06:13 schema_creator

=============================================================

Where is the SILENT.template file located?
 
Question 2: On step 9, execute ./setup.sh SILIENT
Should it be: ./setup.sh SILENT?
Which setup.sh should be executed (or where is this setup.sh)?
 
Question 3: For upgrading, all that is needed is just chapter 5?
 
Question 4: In Chapter 6, there are directions for configuring excludeURLList.cfg. What is this file used for?
 
Question 5: FSDF also has a Silent.props file (OFS_BFND_PACK/OFS_BFND/conf) to update.

SEGMENT_CODE: Is it mandatory to populate this value.  If using the default value, what is the default value?
 
Question 6: In the ETL_ sections, starting with ETL_APPSRC_TYPE. Should this be set to 1 and ignore the rest?
 
Question 7: How to resolve PFT 8.0.5 upgrade error:

[Thu 08/2/2018 01:44:15] [OFS_PFT] [ INFO] - Executing file:/u03/app/ofsaa/scripts/atomic/insert/dim_credit_rating.sql
[Thu 08/2/2018 01:44:15] [OFS_PFT] [ERROR] - Query:'MERGE INTO DIM_CREDIT_RATING T

...

 VALUES
  (S.N_CREDIT_RATING_SKEY,S.V_CREDIT_RATING_NAME,S.V_CREATED_BY,S.D_CREATED_DATE,S.V_LAST_MODIFIED_BY,S.D_LAST_MODIFIED_DATE,S.V_CREDIT_RATING_AGENCY,S.V_CREDIT_RATING_CODE,S.V_CREDIT_RATING_DESC,S.V_RATING_TYPE_IDENTIFIER,S.F_ST_LT_RATING_FLAG,S.N_RATING_RANK,S.V_RATING_SRC_CODE,S.V_RATING_SRC_DESC,S.F_LATEST_RECORD_INDICATOR,S.FIC_MIS_DATE,S.D_RECORD_START_DATE,S.D_RECORD_END_DATE,S.V_AGENCY_RATING_CODE )'
Error:ORA-00904: "V_AGENCY_RATING_CODE": invalid identifier
 

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.