Pricing Center is Unable To Open Product Created Using Pricing Design Center

(Doc ID 2101607.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On :  BRM 7.5.0.0.0 version, Pricing Center

Issue :
     Not able to open a product created using Pricing Design Center (PDC)

Scenario :

1. In PDC, create charge offer for rating data events (or, any usage event that is going to be rated in ECE)
2. Submit the charge offer, ensure that RRE and BRE are up and running, so that the charge offer will be synched to BRM database
3. Now launch Pricing Center and try to open the charge offer (product).
4. Pricing Center throws an error.
    Note : As an alternate option, even if the brm opcode PCM_OP_PRICE_GET_PRODUCT_INFO is used to read the product details, same error is thrown as shown in cm pinlog below
5. Below error is produced in cm pinlog :

W Fri Jan 29 07:25:42 2016 DEV cm:11382 cm_utils.c(146):1920 1:TEST-IN:UnknownProgramName:0:AWT-EventQueue-0:657:1454082649:0
CM DM->FM opcode PCM_OP_EXEC_SPROC, opflags=0x0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_PROC_EXEC:200>
<field num=0:0,0 recid=0 reserved=20100 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Fri Jan 29 07:25:42 2016 DEV cm:11382 fm_price_get_pipeline_rateplan_info.c:785 1:TEST-IN:UnknownProgramName:0:AWT-EventQueue-0:657:1454082649:0
Error retrievig data, Rate plan code not valid for time OR Invalid Rate plan code: test_charge

<location=PIN_ERRLOC_FM:5 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=3 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

6. Below error is produced in dm_oracle pinlog :

E Tue Jan 26 04:04:30 2016  DEV
 dm:19152  dm_subr.c(165):3672
1:TEST-IN:UnknownProgramName:0:AWT-EventQueue-0:657:1453811375:0
ORACLE error: do_proc_execute : PINStmtExecute: code 20100, op 0
=ORA-20100: Invalid Rate plan Exception occurred in Get_Rateplan_Info Function :User-Defined Exception
ORA-06512: at "PIN03.PRICING_TAILORMADEPLAN", line 488
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01403: no data found

E Tue Jan 26 04:04:30 2016  DEV dm:19152  dm_ops.c(258):11733 1:TEST-IN:UnknownProgramName:0:AWT-EventQueue-0:657:1453811375:0
op_exec_sproc : do_exec_sproc returned error for the procedure ("PRICING_TAILORMADEPLAN.GET_RATEPLAN_INFO")

Note :

*  Below business parameter is already enabled :              
   <BusParamsPricing>
   <PriceDesignCenterInst>enabled</PriceDesignCenterInst>
   </BusParamsPricing>
                
*  The procedure create_pricing_tailormadeplan_procedures.pl  has already been loaded into database.

Question :

How can we address the error and be able to open the product (created from PDC) in Pricing Center ?
The purpose is to just allow multiple testers, for example, to login to Pricing Center with same user credentials and have read-only access to pricing data.

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