Question Executing Model_Prescripts_804.sql During Upgrade to OFS PFT 804 Installation (Doc ID 2295966.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 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)

Goal

Currently attempting to complete step 9 of the "Oracle Financial Services Profitability Application Pack Installation and Configuration Guide Version 8.0.4.0.0" that reads:

9. The Datamodel xml released with 8.0.4.0.0 IR has change of sequence in the primary key of FCT_COMMON_ACCOUNT_SUMMARY. Uploading of this model leads to dropping of Foreign Keys and FKs are not reinstated. Hence, you must copy OFS_PFT_Datamodel.xml which is available in the patch 25561603_GENERIC.zip to installer kit for 8.0.4.0.0 installation. This xml is available in the /OFS_PFT_PACH/OFS_PFT/DataModel folder in the installer kit. Also, execute the Model_Prescripts_804.sql that is available in 25561603_GENERIC.zip file before installing the Profitability Pack 8.0.4.0.0.

However, when attempting to execute the Model_Prescripts_804.sql there are errors reflected saying that the table being updated does not exist (REV_TAB_CONSTRAINT_COLUMNS).

DECLARE
V_SQL CLOB;
BEGIN
FOR I IN (SELECT DISTINCT CONSTRAINT_NAME, TABLE_NAME
FROM REV_TAB_CONSTRAINT_COLUMNS
WHERE TABLE_NAME IN ('FCT_CRM_ACCOUNT_SUMMARY',
'FCT_CREDITRISK_ACCOUNT_SUMMARY',
'FCT_LLFP_ACCOUNT_SUMMARY',
'FCT_PFT_ACCOUNT_SUMMARY',
'FCT_FTP_ACCOUNT_SUMMARY',
'FCT_ALM_ACCOUNT_SUMMARY',
'FCT_ECO_CAP_ACCOUNT_SUMMARY',
'FCT_LRM_ACCOUNT_SUMMARY')
AND CONSTRAINT_NAME NOT IN
(SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS)
ORDER BY CONSTRAINT_NAME) LOOP

Error report:
ORA-06550: line 6, column 20:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 13:
PL/SQL: SQL Statement ignored
ORA-06550: line 22, column 12:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 21, column 5:
PL/SQL: SQL Statement ignored
06550. 00000 "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

What step was missed during installation?

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