InjectorPriceEventBatch Status=N Event_type=CL Stuck After BULK CC
(Doc ID 2674559.1)
Last updated on MAY 28, 2020
Applies to:Oracle Retail Price Management - Version 16.0.1 and later
Information in this document applies to any platform.
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:
- Run the Injector batch for 5k clearances.
- After batch completed 5K records in RPM_STAGE_CLEARANCE table: 4999 in A status, 1 in W - CONFLICT_EXISTS status.
- RPM_BULK_CC_PE_THREAD has 5000 entries with status 'C' -- so all completed.
- However RPM_BULK_CC_PE table still shows status 'I'.
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