"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:
- Load pricing staging tables with enough data to have multiple chunks in 1 thread.
- Make sure data in chunk 1 will be successfull, but chunk 2 will have data with errors.
- Run pricingeventprocess.ksh.
- 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