OBIA 11g Incorrect Data In "Top 10 GPA By Degrees" Report
(Doc ID 2017755.1)
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
The report "Top 10 GPA by Degrees" is displaying incorrect data.
For example in the W_SIA_ACADPLAN_SUMM_F table and W_SIA_ACADPLAN_SUMM_FS table you have a specific number of records each for a specific scholar_id. Each record has a GPA equal a value. So the report would have a value of GPA*Number of Records, however, in the source if you have only one row for a scholar id in PS_ACAD_DEGR the output of he report should be 2863 just 1*GPA
Basically the GPA for any scholar_id should be one figure. It shouldn't be multiplied by the number of records that scholar has which is what is being done.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!