My Oracle Support Banner

Pin_inv_accts With Regen Option And Brand Pin.conf Is Searching For Bills Irrespective Of Brand (Doc ID 2412293.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management (BRM) version 7.5.0.17.0, when running "pin_inv_accts -regen" with a brand pin.conf instead of root, it is using search template to retrieve bills irrespective of brand. This slows down the process since the search result will be having bills of not just that particular brand of pin.conf but all the bills that satisfy the query condition irrespective of brands.

Below is the sample search template from pin_inv_accts pinlog for a brand which is not using any brand specific filter:

select X from /bill 1 where 1.F1 > V1 and  1.F2.id > V2 and bill_t.invoice_obj_id0 > 0 order by bill_t.poid_id0 asc

This search will lead to performance issue where the search results will contain the bills of all the accounts irrespective of brand.

It is expected that, when pin_inv_accts -regen is run with a brand pin.conf, it should look for the bills related to only that brand instead of going through all the available bills irrespective of brand.

Why is BRM as a Multi-threaded Application(MTA) looking through all the bills?

The can be reproduced  with the following steps:

1. Create a brand in the BRM 7.5 PS 17 system
2. Create few accounts under the brand
3. Do a bill run and invoicing
4. Run pin_inv_accts with brand login (i.e. brand pin.conf) and check the MTA log for the bill search template

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.