Forum Stats

  • 3,783,605 Users
  • 2,254,809 Discussions
  • 7,880,480 Comments

Discussions

SQL in custom folders of Appilcations Mode EUL

TR7
TR7 Member Posts: 17 Blue Ribbon
edited Jan 9, 2020 8:27AM in Discoverer

When working with an Oracle BI Discoverer 11.1.1.7 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?

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116
    edited Jan 9, 2020 8:27AM

    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.

    Regards,
    Sharon

  • Andy Haack
    Andy Haack Member Posts: 16 Blue Ribbon
    edited Dec 19, 2020 11:34AM

    The answer is: Yes, also all EBS related SQL queries that are run through Discoverer should go through the policy restricted apps synonyms, as you might otherwise get duplicate data.

    You should remove any shema prefixes from tables, e.g. use mtl_system_items_b instead of inv.mtl_system_items_b