My Oracle Support Banner

How Does Archiving Price Lists Processing Work? (Doc ID 549572.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.
FORM:QPXARCHV.FMB - Archive Pricing Entities


Goal is to address the following questions around this processing.

Q1:  One has 4 million obsolete price list lines and want to archive them.
       What happens when one archives the obsolete price lists?

Q2: One knows that the lines will be removed from the
      QP(Advanced Pricing) tables.  Where do they go?

Q3: Can one access the archiving tables?
       Meaning, can one rollback the archived records to Advanced Pricing tables 
       at any point of time?

Q4: Will the system performance become better by archiving price lists?

Q5: How does one go about archiving and purging price lists?


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.