How Does Archiving Price Lists Processing Work?
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 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?
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