QP.QP_DOCUMENTS - How To Control Size Of LOB SEGMENT (XML_CONTENT)? (Doc ID 3064644.1)

Last updated on DECEMBER 20, 2024

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.

Goal

How does one manage the size of LOB segment on table QP.QP_DOCUMENTS (XML_CONTENT) as it keeps growing?

Summary of Questions
---------------------------------
This table has data from 2012. Understand that this table contains price books but looking for recommendations from Oracle to purge data from the table:

Question 1: Are there any standard Oracle EBS API(s) or programs available to 'purge' data in this table?

Question 2: What would the functionality impact be for deleting rows manually from this table?

Question 3: Are there any Public APIs that can be used to 'delete' data from this table?

Question 4: How to regenerate the price books after deletion, if one needs them?

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

References

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

QP.QP_DOCUMENTS - How To Control Size Of LOB SEGMENT (XML_CONTENT)? (Doc ID 3064644.1)

Applies to:

Goal

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!