Hi all,
I just start to build my first APEX form. I want to create a new form based upon custom table in EBS.
Creating objects in EBS is performed differently.
We have a database schema called XX. In this schema I created a custom table XX_CONTRACTS. Since EBS always works with the APPS schema I have granted ALL priviliges on this table to APPS schema. I have created a synonym with the exact same name in APPS schema. This is how EBS wants you to create custom objects.
The next step is to create a view XX_CONTRACTS_V in database schema APPS. I have granted ALL priviliges on this view from APPS to XX. Last step is to create a synonym in XX schema with the exact same name as the view.
I can select records from the table and view in both database schemas. This all seems to works perfectly. My issue is that I am not able to select the SYNONYM in APEX that is related to the database view XX_CONTRACTS_V. When I query this view from within APEX I also can see the data.
Can APEX not refer to objects created with SYNONYM? Or is there another issue? I created a picture to show what I have created. I hope this explains what I have created.
Regards Roel