Price Event Execution Batch (PEE) Does Not Execute Some Approved Clearances/Clearance Reset

(Doc ID 2110046.1)

Last updated on JUNE 20, 2016

Applies to:

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

Symptoms

RPM Price Event Execution DOES NOT execute some Approved Clearances/Clearance Reset with effective date of VDATE+1.

After RPM Price Event Execution completes successfully, some Approved Clearances/Clearance Reset with effective date of VDATE + 1 are not executed and are still in Approved Status.

Steps to Reproduce:

  1. Create and approve few clearance for effective_Date = VDATE+1.
  2. Create and approve few clearance reset for effective_Date =VDATE+1.
  3. Modify the Thread_LUW_COUNT,NUM_THREAD for the price_event_execution batch so that a CL,CR are picked by the same thread.
  4. Run the PEE Batch.
  5. Verify the RPM_CLEARANCE table.
  6. Verify the RPM_CLEARANCE_RESET table.
  7. Verify the RPM_PRICE_EVENT_thread tables.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms