My Oracle Support Banner

PFT 8.1 Pre and Post Scripts Data Model Patch 31484076 (Doc ID 2737595.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.1.0 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

User is upgrading from PFT 8.0.7.4 to PFT 8.1. As part of the upgrade, user will be executing <Patch 31484076> PROFITABILITY 8.1.0.0.0 ERWIN DATA MODEL.

The patch readme has the following steps to follow:

OFS_PFT_Datamodel.erwin files provided in this patch can be used for customizing/merging the data model as per the requirement.
Extract all the files from the archive.
Follow the following steps for uploading the customized/merged data model.

1) For erwin version 9.8, get OFS_PFT_Datamodel.erwin file from \31484076\Data Model\erwin_v9.8 folder and open it using erwin tool.
2) Customize/merge the xxxx.erwin file as per the requirement.
3) Save as xml in "AllFusion Repository Format" ex:- "OFS_PFT_Datamodel.xml".
4) Copy the xml to the erwinXML folder ex:- PFTshare//erwin/erwinXML/.
5) Before uploading the model execute SQL Scripts available at \31484076\Data Model\SQLScripts
    a. For Fresh Installer execute scripts under \SQLScripts\fresh\pre\ .
    b. For upgrade Installer execute scripts under \SQLScripts\upgrade\pre\. 
6) Trigger model upload.
7) After uploading the model execute SQL Scripts available at \31484076\Data Model\SQLScripts
    a. For Fresh Installer execute scripts under \SQLScripts\upgrade\post.
    b. For upgrade Installer execute scripts under \SQLScripts\upgrade\post.

Note: For Unix, Grant Execute permission (740) permissions for all files under the patch folder.


Is step 5b, drop and re-create tables needed? Can it be skipped? 
Some of the tables that being drop and re-create contains large number of data and user has not done customization.
For example STG_CUSTOMER_RELATION is being drop and re-create in Prescript_Backup_Drop_Tables_81.sql. 

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.