My Oracle Support Banner

Collections Center Performance Issue: Agent Task List Tab (Doc ID 2153974.1)

Last updated on AUGUST 30, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


On : version, Collections Manager

In the Collections Center agent tasks list tab, when CSRs refresh to get the list of tasks, it was taking around 2 minutes to display.

As identified, the underlying SQLs were not complex as shown below:

  1. select distinct collections_action_t.poid_DB, collections_action_t.poid_ID0, collections_action_t.poid_TYPE, collections_action_t.poid_REV, .....   from collections_action_t ,billinfo_t where collections_action_t.scenario_obj_ID0 = billinfo_t.scenario_obj_ID0;
  2. select poid_DB, poid_ID0, poid_TYPE, poid_REV, agent_obj_DB, agent_obj_ID0, agent_obj_TYPE, agent_obj_REV, config_scenario_obj_DB, config_scenario_obj_ID0, config_scenario_obj_TYPE, config_scenario_obj_REV, overdue_t, overdue_amount from collections_scenario_t where collections_scenario_t.poid_id0 = :1
  3. select scenario_name, profile_obj_DB, profile_obj_ID0, profile_obj_TYPE, profile_obj_REV from config_collections_scenario_t where obj_id0 = :1
  4. select poid_DB, poid_ID0, poid_TYPE, poid_REV, account_no from account_t where account_t.poid_id0 = :1
  5. select rec_id, first_name, middle_name, last_name from account_nameinfo_t where obj_id0 = :1
  6. select poid_DB, poid_ID0, poid_TYPE, poid_REV, currency, pay_type, payinfo_obj_DB, payinfo_obj_ID0, payinfo_obj_TYPE, payinfo_obj_REV, bill_info_id, status from billinfo_t where billinfo_t.poid_id0 = :1

It looks like the Collections Center was executing the SQLs from 2 to 6 for each collection action. So, if there were 10K tasks, for each task, these SQLs would be executed repeatedly and causing the performance issue.

Improvement of performance.




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

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