BI Publisher (MOSC)

MOSC Banner

Will calls to fnd_global work in a BI Publisher Enterprise report?

edited Sep 22, 2010 9:35AM in BI Publisher (MOSC) 8 commentsAnswered
Hi,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center