Allocation Static Driver ORA-00942: table or view does not exist Errors After Applying Patch 22446566 (Doc ID 2134547.1)

Last updated on MAY 05, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)

Symptoms

On PFT 6.1.0.3, after applying <Patch 22446566>, Static Driver allocations are now giving error messages in the log files when running.

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [60] - odescr() SQL
Function: [4] -
SELECT Oracle Error: ORA- 00942: table
or view does not exist Driver Function:
drv_oci::SetColInfoFromResults() SQL Statement:
SELECT distinct TABLE_SYS_ID
FROM fsi_m_alloc_table_id_values
WHERE TABLE_SYS_ID = (
SELECT TABLE_SYS_ID
FROM FSI_M_ALLOC_DETAILS
WHERE ALLOC_ELEMENT_SYS_ID = (
SELECT DRIVER_SYS_ID
FROM FSI_M_ALLOCATION_RULE
WHERE ALLOCATION_SYS_ID = 278179.000000 ) )


The issue can be reproduced at will with the following steps:
1. to run Static Driver allocation after applied patch 22446566

Cause

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