Archive and Purging Strategy for Oracle Advance Pricing

In my last post I talk about Oracle Advance Pricing I have pointed out that we should always have Purge Strategy in place to purge the Unnecessary data (data from past promotions/discounts /campagins etc).

Best of Oracle is they already have Archive/Purge Strategy process in Place as part of Standard process.

1. Archive process will delete data from QP table and insert them into Archive table.
2. Purge process will delete data from Archive tables.

 Archive /Purge Process – Please note that Archive Process willdelete data from Modifier list lines and Price list lines, though it archive the Modifier and Price list header, but it still keep the Price list and Modifier header data.
Archive /Purge for Price List /Modifier will archive/purge their respective qualifiers too.

NOTE – Archive/Purge process will not archive/purge Qualifiers associated with the Modifiers Header as well and Qualifeir associated with the Price list

Most of time Organization has their customized Archive/Purge process in place based on their unique requirement. If you need to decide about archive policy fell free to conatct me.
Ask yourself below 4 questions if you are not able to decude about your strategy. Outcome of below question definitely help you to determine if you are still ready for Archiv/Purge or not.

• No. of Price List /Modifiers where Header is active and lines are expired.
• No. of Price List /Modifiers where Header is Inactive and lines are expired.
• No. of Price List /Modifiers where Header is Active and lines are NOT expired.
• No. of Price List /Modifiers where Header is Inactive and lines are NOT expired.