Default Parameters - Stochastic Rate Indexing Rule Drop Down is Blank in Pricing Management (Doc ID 1488527.1)

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