"OFSAAI Upgrade Completed with Errors" During Upgrade from OFSAA PFT 8.0.3 to OFSAA PFT 8.0.4 With no PCD installed (Doc ID 2282280.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.3 and later
Information in this document applies to any platform.
OFSAA - Oracle Financial Services Analytical Applications
OFSAAI - Oracle Financial Services Analytical Applications Infrastructure
PFT - Oracle Financial Services Profitability Management
PCD - Oracle Financial Services Price Creation and Discovery

Goal

During upgrade to OFSAA 8.0.4 PFT Pack from existing OFSAA 8.0.3 version there are some Ora errors in the log files and the message in the OFSAAIUpgrade.log reads "OFSAAI Upgrade Completed with Errors".
Are these errors normal ? Can be ignored?
Error like:

update rev_dimensions_b set start_range=(select max(relationship_manager_id)+1 from dim_relationship_manager_b) where member_b_table_name='DIM_RELATIONSHIP_MANAGER_B'
Error at Command Line : 85 Column : 94
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"

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