Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Dave Dengate
    Cost Center Description
    Topic posted April 19, 2017 by Dave DengateBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion Financial reporting, Public Sector 
    802 Views, 4 Comments
    Title:
    Cost Center Description
    Summary:
    Link from GL_CODE_COMBINATIONS table to Cost Center Description
    Content:

    Using BI Publisher I need to get from the GL_CODE_COMBINATIONS Table to a Table which contains the Cost Center Description. The Cost Center is held in SEGMENT2 of the GL_CODE_COMBINATIONS Table.

    Thanks

    Dave

    Comment

     

    • Jon Hayes

      Hi Dave,

      You can grab the description from FND_VS_VALUES_VL - this table lists all value set values, so you can query your other segments there should you need to (columns "VALUE" and "DESCRIPTION" are what you're after).

      Hope this helps.

      Kind Regards,

      Jon

    • Arun Raj

      You can use FND_ID_FLEX_SEGMENTS, GL_CODE_COMBINATIONS, FND_FLEX_VALUES_VL and GL_LEDGERS to get the desired result.

      Here is a query. I have not tested it, but it should work. You have to provide the ledger name. 

      select ffvv.flex_value, ffvv.description
      from fnd_id_flex_segments fifs,
      gl_code_combinations gcc,
      fnd_flex_values_vl ffvv,
      gl_ledgers l
      where fifs.segment_num = 2 --segment2
      and id_flex_code = 'GL#'
      and fifs.id_flex_num = l.chart_of_accounts_id
      and l.name = <Ledger Name>
      and ffvv.flex_value_set_id = fifs.flex_value_set_id
      and gcc.chart_of_accounts_id = l.chart_of_accounts_id

      and ffvv.flex_value = gcc.segment2

       

      Thanks,

      Arun

    • Manish Pesswani

      Hi,

      I hope below query which is using seeded package to get segments decription will be helpfull

       SELECT gl_flexfields_pkg.get_description_sql (GCC.CHART_OF_ACCOUNTS_ID,
                                                      2,
                                                      GCC.SEGMENT2) cos_center_desc FROM GL_CODE_COMBINATIONS gcc;

    • Jairo Rojas Mendez

      Great!