PDC Installation - Cleaning Up Sample BRM Data (Doc ID 1520457.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Pricing Design Center - Version 11.1.0.2.0 to 11.1.0.2.0 [Release 11.1.0]
Information in this document applies to any platform.
Checked for relevance on 29-Aug-2014

Goal

Part of PDC documentation:

1. Go to the PDC_Home/apps/syncpdc/scripts directory, where PDC_Home is the directory in which you installed PDC.
2. Enter the following command, which opens SQL*Plus:
sqlplus user_name/password@database_Name
where:
  user_name is the PDC database user name.
  password is the PDC database user password.
  database_Name is the service name or database alias of the PDC database.
Enter the following commands to clean up BRM data:
  To clean up real-time data:
  update_pin_tables.sql
  To clean up batch-rating data:
  update_ifw_tables.sql
The sample BRM data is cleaned up.

End of this part.

Qn1:
We should connect as PDC user. If we do so , the IFW tables can't be found (there is no such table like IFW_SERVICE in PDC schema, there is also no synonym and no DB link created) why ?
 
Qn2: If one connect as IFW user several inserts cannot be done from PDC script (too many characters: current 25, maximum 10)
SQL> Insert into IFW_RUMGROUP
(RUMGROUP,NAME,TYPE,ENTRYBY,ENTRYDATE,MODIFBY,MODIFDATE,MODIFIED,RECVER)
 values ('ServiceTelcoGprs_RumGroup','ServiceTelcoGprs_RumGroup','S',0,to_timestamp('23-FEB-09','DD-MON-RR
 HH.MI.SSXFF AM'),null,to_timestamp('23-FEB-09','DD-MON-RR HH.MI.SSXFFAM'),1,0);

ERROR at line 1:
ORA-12899: value too large for column "INTEGRATE00"."IFW_RUMGROUP"."RUMGROUP"
(actual: 25, maximum: 10)

 

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