My Oracle Support Banner

"pricingeventprocess.ksh" Performs ROLLBACK On Chunks With No Issues (Doc ID 2750383.1)

Last updated on FEBRUARY 15, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.


When the pricingeventprocess.ksh chunks data into multiple chunks for a single thread value and it processes the first chunk with no errors, but if the second chunk as an error a ROLLBACK is issued which gets rid of all the data updated/inserted by the first chunk, Then updates the status of records only in the second chunk and does a commit.

Steps to Recreate:

  1. Load pricing staging tables with enough data to have multiple chunks in 1 thread.
  2. Make sure data in chunk 1 will be successfull, but chunk 2 will have data with errors.
  3. Run pricingeventprocess.ksh.
  4. Notice that all records in SVC_PRICING_EVENT_HEAD for chunk 1 are in 'X' status and all records in SVC_PRICING_EVENT_TEMP are in 'N' status. Records in chunk 2 are in 'E' status and 'P' status correctly.




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

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