Unable To Successfully Create Billable Charges Using A Multi-threaded Batch Process (Doc ID 2158571.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.1.0 and later
Information in this document applies to any platform.

Goal

A batch program was created to retrieve contracts and create a billable charge for each contract. Whenever this program is run on a single thread, no error is encountered. When it is run on multiple threads, the following errors are encountered:
- Duplicate Key Error
- Null Pointer Exception
- Unable to load newly added entity BillableCharge_Id

The following happen on a multi-threaded process:
- A certain contract ID gets processed twice in one thread.
- A contract that is allocated to a certain thread number seems to get used for processing in other threads. For example, Contract_1 is allocated to Thread number 2 but billable charges get created for Contract_1 in thread numbers 3 and 5.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms