Will calls to fnd_global work in a BI Publisher Enterprise report?
I have created a report in BI Publisher Enterprise with the following sql Data Model. However, no data is returned even though I am logged in as a user that is a manager and should have data returned by this query. Will a call to fnd_global.user_id work within Bi Publisher Enterprise?
Thanks,
Ellen
select CHCW_MASTER_EMPLOYEE_V.COMPANY as COMPANY,
CHCW_MASTER_EMPLOYEE_V.ORG_CODE as ORG_CODE,
CHCW_MASTER_EMPLOYEE_V.DIV_BG as DIV_BG,
CHCW_MASTER_EMPLOYEE_V.HR_REPRESENTATIVE as HR_REPRESENTATIVE,
CHCW_MASTER_EMPLOYEE_V.PRIMARY_SUPERVISOR_GEN as PRIMARY_SUPERVISOR_GEN,