What is the exact question? Presumably Apex is not installed in the EBS database, so you probably need a database link created on the APEX database to connect to EBS.
Then you just query like:
select * from table@dblinkname
Or if your apex installation is in the same DB, and your apex parsing schema is not APPS (shouldn't be, this is mentioned in the white paper) then you'll have to create synonyms for the objects you require in the APPS schema and provide your parsing shema the correct grants.
We're just guessing. As Scott says, you didn't really throw a lot of usable info our way. You've read the whitepaper, great. Did you perform any other steps?
Hi Scott and Tom,
Sorry about this.
My Apex is installed in the same instance as my EBS. I assume this means they are in the same DB? So if this is the case, can I just query with the EBS table name and the APEX application will know its EBS table and not APEX table?
Hope this is clearer. Sorry for not being clear on my issue.
Sorry, this is my bad. I realised I can just query directly which the EBS table names. Sorry for all the troubles caused.