5.5 Prereq Patch 12349210 Does Not Insert Rows into REV_TABLE_CLASSIFICATION_B (Doc ID 1333166.1)

Last updated on JULY 17, 2011

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version: 5.5 to 5.5 - Release: 5 to 5
Oracle Financial Services Profitability Management - Version: 5.5 to 5.5   [Release: 5 to 5]
Oracle Financial Services Asset Liability Management - Version: 5.5 to 5.5   [Release: 5 to 5]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.8 to 7.2.8   [Release: 7 to 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Analytical Applications (OFSAA) 7.2.8 / 5.5, after applying 5.5 prerequisite <>, no new rows are inserted into REV_TABLE_CLASSIFICATION_B or REV_TABLE_CLASSIFICATION_TL.  The following queries return a count of 0:

select count(*) from REV_TABLE_CLASSIFICATION_B
where TABLE_CLASSIFICATION_CD in (611,612,613);

select count(*) from REV_TABLE_CLASSIFICATION_TL where
TABLE_CLASSIFICATION_CD in (611,612,613);

Patch 12349210 is supposed to execute the atomic.sql and insert three rows into each table for TABLE_CLASSIFICATION_CD values of 611, 612, 613.

The following messages are output in the Unix console when applying the patch:

logs directory created successfully
Log file UpdateOFSAAI_20110602_120313.log generated at path:
/stage/ofsaa/ofsaa55/prereq/12349210/logs
7.2.8
7.2.8%
7.2.8
Proceed with applying patches
Applying Patch [ Thu Jun 2 12:03:14 USADT 2011 ]
************************************************
Reading environment variable from the setup
OFSAAI post Patch validation
OFSAAI 12349210 Patch successfully executed.
***********************************************************************

Below is the contents of UpdateOFSAAI_20110602_120313.log:

==================================================================================
Applying patch Started on Thu Jun 2 12:03:13 USADT 2011
==================================================================================



=================================================================================
Applying patch End on Thu Jun 2 12:03:19 USADT 2011
=================================================================================

Steps to Reproduce:
  1. Upload p12349210_72_Generic.zip to the server and unzip it
  2. Run chmod 777 *
  3. Run dos2unix against all text files to convert them to the correct format
  4. Update the params.conf with required info
  5. Run ./UpdateOFSAAI.sh
After running UpdateOFSAAI.sh, no new rows are inserted into REV_TABLE_CLASSIFICATION_B.

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