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

Last updated on AUGUST 07, 2020

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

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

Operating Unit B -
Customer Account - SampleCustomer123

Run scoring engine for Operating Unit A and SampleCustomer123 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 SampleCustomer123 and a score of 50

Run scoring engine for Operating Unit B and SampleCustomer123 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 SampleCustomer123 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;