Pr_outputs_pricing_info is Invalid Due to ORA-00942 During Reveleus_parameter_master.Sql
(Doc ID 1449732.1)
Last updated on FEBRUARY 28, 2019
Applies to:
Oracle Financial Services Price Creation and Discovery - Version 5.2 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
PRICEMGMT
Symptoms
On Oracle Financial Services Pricing Management, Transfer Pricing Component (PRICEMGMT) 5.2, after installing Pricing Management the following error occurs in the SolutionsLOG.log:
ERROR
[ 04/04/2011 00:09:00 ] Executed 0 inserts successfully
[ 04/04/2011 00:09:00 ] Will start executing...........
[ 04/04/2011 00:09:00 ] Executing scriptfile:
/app/ofsaa72/SQLScripts/executables/AtomicSchema/REVELEUS_PARAMETER_MASTER.sql
[ 04/04/2011 00:09:00 ] Firing remaining 27 queries
[ 04/04/2011 00:09:00 ] Will load driver now:
oracle.jdbc.driver.OracleDriver
[ 04/04/2011 00:09:00 ] driver loaded
[ 04/04/2011 00:09:00 ] SQL Statement failed: alter table
REVELEUS_PARAMETER_MASTER disable all triggers
[ 04/04/2011 00:09:00 ] ORA-00942: table or view does not exist
When attempting to recompile the invalid PR_OUTPUTS_PRICING_INFO package, it is found that the REVELEUS_PARAMETER_MASTER is not available.
STEPS
The issue can be reproduced at will with the following steps:
1. Install Pricing Management
2. Check logs and attempt to compile invalid package: PR_OUTPUTS_PRICING_INFO.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |