But I still do not have much idea on how do I query for data from ebs. What I am trying to achieve is to query for a table in EBS and put the data as a httpresponse
Previously, I was creating an application process in the following manner
element_List varchar2(4000) := '';
for i in (select END_MEASURE from SCS_ELEMENT_DATA where ATTRIBUTE10 = :P9_ASSET_ID) loop
element_List := element_List || i.END_MEASURE || ' ';
exception when no_data_found then null;
My table structure in EBS is something like this:
XXEAM_LAM_ELEMENTS (lam_element_id, csi_instance_id, element_name, element_desc, label, type, continuous, reference, shared, start_measure, end_measure, lat_long)
Would appreciate any advice as I'm new to both APEX and EBS.
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.