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 laterInformation 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 |