My Oracle Support Banner

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

Last updated on MARCH 05, 2019

Applies to:

Oracle Financial Services Price Creation and Discovery - 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

Symptoms

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.

ACTUAL BEHAVIOR
Stochastic Rate Index Rule drop down is blank for Default Parameters.

EXPECTED BEHAVIOR
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;

STEPS
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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.