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

Last updated on FEBRUARY 08, 2024

Applies to:

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

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