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:
- Upload p12349210_72_Generic.zip to the server and unzip it
- Run chmod 755 *
- Run dos2unix against all text files to convert them to the correct format
- Update the params.conf with required info
- 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 |