1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

GL_BALANCES_V is not displaying any data

Discussion in 'Oracle Apps Technical' started by sambuduk, Jan 23, 2014.

  1. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi All,

    I want to display YTD balances in my custom report. For this I am planning to use GL_BALANCES_V, but when I query this view it gives no data.

    Do we need to set any context (some thing like mo_global.set_policy_context() ) for this ???


    Regards
    Sambasiva Reddy.K
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,127
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi sambudu,

    Check the following link once, It may help you.

    Link