Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Doron de Jong
    Report needed for default expense account
    Topic posted August 10, 2017 by Doron de JongRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip 
    510 Views, 5 Comments
    Title:
    Report needed for default expense account
    Summary:
    Report needed for default expense account
    Content:

    Hi

     

    I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find the field for the employees default expense account, what would this be please on OTBI?

    it is the accounting string that they use xx-xxxx-xxxx-xxxxxxx-xx-***

    Doron

    Document:
    Doc2.docx (133KB)

    Comment

     

    • Wendy Ware

      Hi Doron,

      I have not been able to find Employee Default Expense Account in the BI Subject Areas.  Hopefully, someone else will chime in with that answer.  Personally, I obtain that information with the below SQL against the ApplicationDB_FSCM tables.  Best, Wendy

       

      select

      pu.username,

      paex.full_name,

      GL.SEGMENT1||'.'||GL.SEGMENT2||'.'||GL.SEGMENT3||'.'||GL.SEGMENT4||'.'||GL.SEGMENT5||'.'||GL.SEGMENT6||'.'||GL.SEGMENT7||'.'||GL.SEGMENT8||'.'||GL.SEGMENT9||'.'||GL.SEGMENT10 "Default Expense"

      from

      per_users pu,

      per_employees_x paex,

      GL_CODE_COMBINATIONS GL

      where

      pu.person_id = paex.person_id

      and GL.CODE_COMBINATION_ID (+)= paex.DEFAULT_CODE_COMB_ID

      order by

      paex.full_name

    • MShrini

      Please let us know which subject areas are taken to develop this OTBI report.

    • Joshua Vincent

      This was very helpful for us, thank you.

    • Meshack Rakumakoe

      Thank You So Much

    • Jesus Nolasco

      Since the Default Expense Account technically falls under Expenses, that is found under the ‘Expenses – Employee Expense Overview Real Time’ Subject Area.

      The column you're looking for is called: 'Employee Default Expense Account Concatenated Segments' to give you the values in numbers.