The Contract Account Is Locked Twice (Doc ID 1173473.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
Oracle Solaris on SPARC (64-bit)

Symptoms

Billing: Customers and Contracts are locked, whereas only customer should be locked

Billing batch process is done in 2 steps:

· First, we run billing for all contracts (subordinates)
· Then, we run billing for all customers (parent payment responsible)

During billing of contracts, each contract is locked (OK).

During billing of customers:

· The customer account is locked (OK)

· All contracts (already billed) are also locked => this is useless and painful for performance. Contracts have been already billed – there’s no reasons for locking those accounts as the bill for each contract, even if not finalized, is already frozen and cannot be changed anyway.

Impacts:

·  Billing performance for customers is impacted.

·  Locking the contracts has also an impacts on REL update => while contracts are locked, REL updater is locked, waiting for the contract to be unlocked.

Solution: Lock only the customer (not all the contracts) while billing customers. If unbilled contracts are found, the unbilled contract will be billed and inside this sub-billing activity, the contract will be locked and it is fine.


Cause

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