UWQ Doesn't Show Scores by Operating Unit
(Doc ID 1592463.1)
Last updated on FEBRUARY 03, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!