How Does Archiving Price Lists Processing Work?

(Doc ID 549572.1)

Last updated on JUNE 08, 2018

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

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?

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