UWQ Doesn't Show Scores by Operating Unit (Doc ID 1592463.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

UWQ when shown by Operating Unit, will show the same score for an account that is doing business in two Operating Units, even though the score may be different.

For example:

Operating Unit A -
Customer Account - Acme Pools

Operating Unit B -
Customer Account - Acme Pools

Run scoring engine for Operating Unit A and Acme Pools gets a score of 50
Run IEX: Populate UWQ Summary Table for Operating Unit A and you will see a row in the table for Acme Pools and a score of 50

Run scoring engine for Operating Unit B and Acme Pools gets a score of 10
Run IEX: Populate UWQ Summary Table for Operating Unit B and you will see a row in the table for Acme Pools in Operating Unit A for a score of 10
and a row for Operating Unit B for a score of 10

Operating Unit A should be 50.

If you look at the code you will see the Score does not have an Org_ID
IEX_UWQ_POP_SUM_TBL_PVT

Cursor:
  cursor c_account_score is
  SELECT sh.score_object_id, sh.score_value score,sh.score_id, sc.score_name
  FROM iex_score_histories sh,
  iex_pop_uwq_summ_gt temp,
 iex_scores sc
  WHERE sh.creation_date = (SELECT MAX(creation_date)
  FROM iex_score_histories sh1
  WHERE sh1.score_object_code = 'IEX_ACCOUNT'
  AND sh1.score_object_id = sh.score_object_id)
  -- AND rownum < 2
  AND sh.score_object_code = 'IEX_ACCOUNT'
  AND sh.score_object_id = temp.object_id
  and sc.score_id = sh.score_id;

Cause

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