When working with an Oracle BI Discoverer 184.108.40.206 Applications Mode EUL associated with an instance of Oracle EBS R12.2.4 that uses EBR (Edition-Based Redefinition or "online patching"), should all SQL in Discoverer custom folders follow the standard described on page 4-13 of the "Oracle E-Business Suite Concepts Release 12.2" guide (Part No. E22949-12) that states: "All code (Oracle E-Business Suite, custom, or third-party) must access Oracle E-Business Suite data via the cover layer: accessing the data model via the physical layer may result in obsolete data been returned ... The implementation of EBR for Oracle E-Business Suite requires all code to access the data model via the APPS synonym, which points to the editioning view (logical model)."
In other words, should all SQL in custom folders refer to APPS synonyms instead of referencing tables via schema names?
I think your question would be better addressed by EBS team.
I can tell you from a Discoverer perspective, you need to use EBS Secured views in order to use Row Level security. If you access EBS Tables directly, there is no EBS security.
Please consult EBS team for answer to your question.