Oracle Retail PRICE MANAGEMENT -- Purging payload tables
very new to this forum, and my first Question.
There was no community specific to ORACLE RETAIL.(that is the reason i added the question to Utilities
My question is about ORACLE RETAIL RPM. We have RPM with no-rib configuration for RMS. We are using RPM for pricing and promotions. There are many data in PAYLOAD tables in RPM (eg: RPM_PRICE_EVENT_PAYLOAD).
The PUBLISH_STATUS in RPM_PRICE_EVENT_PAYLOAD is 0 (as per data model 'not published').
As per operation guide the purge payload batch will not consider the data with publish_status 0.
Please let me know how i can puge these payload tables which has got huge data.