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

Last updated on FEBRUARY 15, 2021

Applies to:

Symptoms

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.
   
   

Changes

Cause

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