My Oracle Support Banner

Seeking a Method to Eliminate/Delete Closed Purchased Products and Purchased Discounts From Accounts (Doc ID 2992650.1)

Last updated on DECEMBER 20, 2023

Applies to:

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

Goal

Looking for a method to delete closed purchased products and purchased discounts from accounts.

How can the old/closed records be purged from purchased_product_t, the Audit and sub-tables? In other words, how to purge the existing entries with status=3 in the purchased_product_t table?

Solution

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
Goal
Solution


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