The Parameters (Admin -> P -> Parameter) Pages Does not Load For Specific Parameters

(Doc ID 2412436.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

Why is the following happening?

The parameters (Admin -> P -> Parameter) pages does not load at at for specific parameters.

For example if an Add and Edit parameter which has values greater then 200, the load is very slow. If the Add and Edit for a parameter which has values greater than 500, the page does not open.

Based on the query below:


select price_parm_cd,count(1) from CI_PRICE_PARM_VAL group by price_parm_cd;
Results
DEPOT 5400
COUNTRY 256
TIER 100

Add and Edit never opens for DEPOT
Add and Edit takes 2 minutes for COUNTRY
Add and Edit works fine for TIER

Based on the BPA script(C1_PriceParm) and logs show that BO(C1_PRICE_PARM) read was successful but the UI Map never opens.

Similarly priceItem chars also take lot of time to load the chars.
 

Solution

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