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!

Unable to Access Object in Middle ware side when we create object in Custom Schema

Discussion in 'Oracle Apps Technical' started by harinathv, Nov 10, 2014.

  1. harinathv

    harinathv Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello Experts,

    Greetings for the day!!!

    We are using the EBS R12.2.4 latest version, as per the Oracle standards they mentioned don't use any schema name with in the packages. Actually we are using the some custom schema for accessing respective object.

    Example :- xxx.<Custom table type object>> as input parameter.

    When we user XXX.custom_object_table then only Middle ware will access these particular table type from Apps schema, if we remove it they are not able to access it getting problem.

    Can you please guide me how can we go ahead and fix it


    Thanks
    Hari
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: Unable to Access Object in Middle ware side when we create object in Custom Schem

    Synonyms? Grants?
     
  3. harinathv

    harinathv Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Re: Unable to Access Object in Middle ware side when we create object in Custom Schem

    Middle ware unable to access the Table type Object, we have created private synonyms for it and given grants to apps schema.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: Unable to Access Object in Middle ware side when we create object in Custom Schem

    What do you mean when you say Middleware can't access the object? Is that Forms? Are you saying that if you open a Forms session and log into the xxx schema that you can't see any of the xxx objects?