My Oracle Support Banner

pin_rel Incorrect Account Balance In A Multi-Database Setup (Doc ID 1319944.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.
Currency check on 25-Jun-2014


When loading an EDR on a multi schema environment using pin_rel, the balance was set incorrectly in some cases.

Consider the following scenario:
1. Have a multidb setup with 1 secondary schema.
2. Set the increment_by_value to 2 and batch size as 5 in pin_rel /
3. Create a standard GSM account, with Balance Impact = 45 Euro and 3600 Free Seconds.
4. Process an EDR with more that 5 balance impact records, e.g.


5. Check account's balance after running REL

Expected Result

Balance Impact = 73.8 Euro, which is same as theoretically computed values.

Actual Result

Balance would be less than the theoretically computed values.


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.