My Oracle Support Banner

Billing Care : Incorrect Search Template In Billing Care OOB Code (Doc ID 2871681.1)

Last updated on FEBRUARY 08, 2024

Applies to:

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

Symptoms

On Billing and Revenue Management (BRM) 12.0.0.4.0 version, after installing Billing Care (BC) <Patch 33453483>, an issue has been found during testing.

As part of the code flow from Out-Of-The-Box (OOTB) BC code (TemplateSearchWorker.class) a search template is being used with the intent to get the account_no of the particular accounts.

This search template basically translates to the following SQL query :

select account_no, poid_DB, poid_ID0, poid_TYPE, poid_REV from account_t where account_t.poid_TYPE in ('/account','162435134869');

Since the search template is incorrect, BRM is returning ALL the accounts present in the Database(DB).

For an environment having approximately 15 million accounts, due to such huge number of accounts being returned, BC is timing out.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.