Technology Stack - EBS (MOSC)

MOSC Banner

Oracle Retail PRICE MANAGEMENT -- Purging payload tables

edited Aug 20, 2021 11:20AM in Technology Stack - EBS (MOSC) 1 commentAnswered
Hi ALL,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center