My Oracle Support Banner

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

Last updated on APRIL 02, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.5 to 5.5 [Release 5]
Oracle Financial Services Profitability Management - Version 5.5 to 5.5 [Release 5]
Oracle Financial Services Asset Liability Management - Version 5.5 to 5.5 [Release 5]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 to 7.2.8 [Release 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 <Patch 12349210>, 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 755 *
  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

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
Symptoms
Cause
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.