Default Parameters - Stochastic Rate Indexing Rule Drop Down is Blank in Pricing Management
Last updated on SEPTEMBER 06, 2012
Applies to:Oracle Financial Services Pricing Management, Transfer Pricing Component - Version 5.2 and later
Information 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
On Oracle Financial Services Pricing Management, Transfer Pricing Component (PRICEMGMT) 5.2.2, when attempting to choose a Stochastic Rate Index in the Default Parameters screen, the drop down is blank. The appears to be caused by incorrect query which checks the FSI_M_OBJECT_DEFINITION_B.LEAF_NUM_ID. Since Stochastic Rate Indexes are not product specific (like IRCS), there should not be a where clause for FSI_M_OBJECT_DEFINITION_B.LEAF_NUM_ID.
Stochastic Rate Index Rule drop down is blank for Default Parameters.
Expect all defined Stochastic Rate Index Rules to appear. The following query should be updated to remove c.leaf_num_id=4 from the where clause.
select distinct a.RATE_INDEX_SYS_ID,b.short_desc from FSI_M_RATE_INDEX a,fsi_m_object_definition_tl b, FSI_M_OBJECT_DEFINITION_b c where a.RATE_INDEX_SYS_ID = b.object_definition_id and a.RATE_INDEX_SYS_ID = c.object_definition_id and UPPER(NVL(c.deleted_flag,'N'))!= 'Y' and c.ID_TYPE = 315 and c.leaf_num_id=4 and c.folder_name = 'OFSAA52SEG' order by b.short_desc;
The issue can be reproduced at will with the following steps:
1. Pricing Management -> PM Maintenance -> Application Preference
2. Changed Product Dimension = 'Product' and Apply.
3. Pricing Management -> Parameter Specifications -> Default Parameters
==> drop down for 'Stochastic Rate Indexing Rule' is now blank
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