Retail Price Management (MOSC)

MOSC Banner

Duplicated price change events

Hi All,

We are using RPM v15.0.

We are importing price change events data into RPM_STAGE_PRICE_CHANGE table.

Sometimes I could saw 2 price change events for same item/zone_id, effective_date(vdate+1) combination (user mistake).

Running the RPM batches (PEE and PEERMS) will approve one event and for other one will raise the error message 'CONFLICT_EXISTS' having price_change_id value bigger than the approved one.

The final table (PRICE_HIST) it is not updated with the price change event.

Could be this the reason for not having PRICE_HIST table updated?

Thank you,

Adriana

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