CC wise expense report in OTBI
Summary: we have tried to create an OTBI report for the expense total with break down by Cost Center with GL but it not showing any break down sum we can get only total sum of the expense report amount. is it possible to get the break down sum?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications25B (11.13.25.04.0)
Code Snippet (add any code snippets that support your topic, if applicable):
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_COLUMNAR_STORAGE_FOR_WORK_FILE=0,NEED_NOT_REPLACE_TIME_DIM=1;SELECT