MSAMM
Back to course

Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 2 · Security, roles and what you are allowed to see

What breaks: the three security failures you will meet

Lesson 20 of 177 · 2 min

Three failures, in the order you will actually meet them — symptom first, cause second, because that is how they arrive. One. "The report is broken." It runs, it returns nothing, and the person who says it is broken is not wrong from where they are standing. The cause is almost always a missing data access set or business unit assignment, and the tell is that the same report returns rows for you. Nothing about the symptom points at security, which is why this one gets escalated to a reporting consultant and sits with them for a day. Two. "It worked in test." A role granted in the test environment and never in production, or granted in production before a refresh overwrote it. Role assignments live in the environment, and a P2T copies the source's assignments over the target's — so an access grant made in test the day before

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 2 · Security, roles and what you are allowed to see

  1. 1Roles, privileges and duties
  2. 2Data security versus function security
  3. 3Data access sets and business unit security
  4. 4The security diagnostic sequenceFree preview
  5. 5Reading the security console
  6. 6Security for reporting: the part people miss
  7. 7Custom roles: when, and how to survive an update
  8. 8Provisioning and role assignment at scale
  9. 9What breaks: the three security failures you will meet
  10. 10Lab briefing · Diagnosing three access failures