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!

how to retrieve data from oracle ebs database schema using standard select statement

Discussion in 'System Administration & Application DBA' started by anasosama, Aug 2, 2014.

  1. anasosama

    anasosama Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    55
    how to retrieve data from oracle ebs database schema using standard select statement??
    as i dont get "no row selected" when i make any query on any table such RA_CUSTOMER_TRX_ALL table

    please i need an urgent help
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: how to retrieve data from oracle ebs database schema using standard select statem

    Is your company have AR module?

    check any GL tables
     
  3. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: how to retrieve data from oracle ebs database schema using standard select statem

    You are querying a protected table directly w/o a session identifier which is why you're getting the no rows returned message.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Re: how to retrieve data from oracle ebs database schema using standard select statem

    In which schema (Schema Name) you are running the sql ?

    Can you please share the SQL you are running.