How To Cleaning Up Sample BRM Data After Installing PDC? (Doc ID 1552775.1)

Last updated on MAY 16, 2013

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.

Goal

We are using PDC 11.1.0.2 version. In PDC Installation and system admin Guide, they mentioned that login as pdc user and run
the following script to clean up real-time and batch-time data.

update_pin_tables.sql
update_ifw_tables.sql

But we are not able to run the above script with pdc user.
When we are trying to run the update_pin_tables.sql script showing following error.

ERROR at line 1:
ORA-00942: table or view does not exist

1) So, should we login as pin01 and INTEGRATE user to clean-up the real-time and batch-time data respectively.

2) If we delete the sample data in BRM and PIPELINE, how does it effect the both databases?
Because script "update_pin_tables.sql" is removing the pricing data like beid and rum.

How does it effects the products and customers, whose data is already created in BRM?

Please confirm on the same.
 

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