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

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 11.5.10.2 [Release 11.5]
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