Retail Price Management (MOSC)

MOSC Banner

Get price_event_id on a custom conflict check.

edited Feb 18, 2019 10:50AM in Retail Price Management (MOSC) 5 commentsAnswered

Hi,

I'd like to know how to get JUST the "price_event_id" which is under conflict check in a custom conflict check process.

Any one knows to explain about the code below that is present on all conflict check packages?

e.g.:

select * from rpm_future_retail_gtt

where price_event_id  NOT IN (select ccet.price_event_id

                                         from table(cast(L_error_tbl as conflict_check_error_tbl)) ccet);

Also what data comes in the "conflict_check_error_tbl" table during the conflict check process?

Thanks.

Uilber

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