My Oracle Support Banner

Injector Price Changes Getting Error Item_locs_in_price_event_are_locked And Stuck Conflict Check (Doc ID 2965138.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle Retail Price Management - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

 Injector price changes are getting error item_locs_in_price_event_are_locked without other events to justify it.
After attempting to reprocess, they are sometimes processed entirely without problems, other times partially and other times fail completely again.
Issue is mostly verified with several dozens or hundreds of price changes.
Usually around half are processed, and the remaining half is not processed staying part in worksheet status in RPM_PRICE_CHANGE (with item_locs_in_price_event_are_locked error) and part in conflict checking, despite injector job having finished.
The issue seems to be happening just for prices changes at zone level when the respective zone is base and has secondary zones associated.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
  
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.