My Oracle Support Banner

OBIA 11g Incorrect Data In "Top 10 GPA By Degrees" Report (Doc ID 2017755.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Business Intelligence Applications Consumer - Version 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.