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

Last updated on APRIL 20, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms