RPT_RES_M_ALLOC_FTE_V. ALLOC_PERCENT value seems inflated.
If you analyze the database view definition, it is a union statement that in the first select statement correctly puts criteria for the period type "c.period_type = 'MONTHLY", but in the second select statement, the WHERE clause does not specify the period type.
If you add the following criteria at the end of the second select statement for the inner join on the 'rpt_calendar' table, the numbers are calculated as expected
INNER JOIN rpt_calendar c ON al_s.slice_date = c.start_date and c.PERIOD_TYPE ='MONTHLY'
This issue may be exhibited in other RPT database views as well. Please be sure to check all database views that provide similar output.
Steps to Reproduce:
Expected Result: Correct output
Actual Result: Incorrect output
Our sustaining team reviewed CLRT-73294 and closed it as they are not planning to make any changes to this area of the product.
Create or Update the Database view to include criteria for correct period type.
Add the following criteria at the end of the second select statement for the inner join on the 'rpt_calendar' table, the numbers are calculated as expected
INNER JOIN rpt_calendar c ON al_s.slice_date = c.start_date and c.PERIOD_TYPE ='MONTHLY'
This issue may be exhibited in other RPT database views as well. Please be sure to check all database views that provide similar output.
For more details please review the Customer Reported Defect Resolution Policy