My Oracle Support Banner

InjectorPriceEventBatch Status=N Event_type=CL Stuck After BULK CC (Doc ID 2674559.1)

Last updated on MAY 16, 2022

Applies to:

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

Symptoms

InjectorPriceEventBatch status=N event_type=CL stuck after BULK CC and did not complete.


All the events got executed based on RPM_CLEARANCE table (except 1 worksheet which failed CC). Checked RPM_BATCH_LOG table and it also shows that everything went fine.
The update of RPM_BULK_CC_PE to 'C' is missed.

Please note: Nothing got written into RPM.log during the batch time period.

Steps to replicate:

  1. Run the Injector batch for 5k clearances.
  2. After batch completed 5K records in RPM_STAGE_CLEARANCE table: 4999 in A status, 1 in W - CONFLICT_EXISTS status.
  3. RPM_BULK_CC_PE_THREAD has 5000 entries with status 'C' -- so all completed.
  4. However RPM_BULK_CC_PE table still shows status 'I'.

 

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.