My Oracle Support Banner

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

Last updated on MAY 11, 2021

Applies to:

Oracle Communications Pricing Design Center - Version to [Release 11.1.0]
Information in this document applies to any platform.


We are using PDC version. In Pricing Design Center  Installation and system admin Guide, it is mentioned that login as <USER> and run
the following script to clean up real-time and batch-time data.


But we are not able to run the above script with .
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 <USER> 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.