Hi,
I am using Apex 5.1 and am running into an issue on our application. We recently moved applications to a different environment which uses two schemas. One is FOOD and the other is FOOD_APEX. The FOOD schema contains the data/tables, and the FOOD_APEX is the parsing schema on the apex application. In order to connect the two, we created synonyms on the FOOD_APEX account. (Previously we used the FOOD schema for both tables and apex application).
The error we get when referencing a synonym is table is not found on page load.
My Question:
Is it possible to reference a synonym in the automatic row fetch process? I don't see it when using the pop-up view because it lists only tables/views . If not, we may need to customize all of the row fetching/row processing processes, which is why I am seeing if there is a known alternative.
Also note: We created private synonyms and do not have permission for creating public ones. Would that possibly be a solution?
Edit. We cannot use a view since we are updating/deleting/inserting onto this table as well with the automatic processing as well.
Please let me know if I can provide anymore details.
Thanks,