OBIA 11g Incorrect Data In "Top 10 GPA By Degrees" Report
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.
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