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

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

Cause

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