Overview of Oracle Cloud Security Architecture

• Abstract, Duty, and Job Roles
• Role Inheritance and Role Hierarchies
• Provisioning roles using Security Console
• Creating custom job/duty roles
• Assigning roles to users and user account creation
• Data Security Policies & Business Unit level restrictions

• Using "Structure" and "Page Composer"
• User-level vs Role-level changes
• Hiding/unhiding fields and reordering sections
• Real-time personalization use cases

• Oracle Approval Management Framework
• Configuring Approval Rules via BPM Worklist
• Sequential vs parallel workflows
• Using conditions (Amount, BU, Supplier, etc.)
• Delegation, Escalation, and Reassignment rules
• Notifications and tracking approval history

• Overview of Subledger Accounting Engine
• Pre-seeded accounting rules vs custom rules
• Setting up Accounting Methods and JERS, JLR
• Event classes and event types
• Using Mapping Sets and Account Rules
• Assigning SLA rules to applications
• Simulation and validation of accounting entries
• Use of Journal Descriptions and Balancing segments

✅ OTBI (Oracle Transactional Business Intelligence)

• Subject areas and data sources
• Creating dashboards, prompts, and charts
• Real-time ad hoc analysis for functional users

✅ BI Publisher (BIP)

• Data model creation (SQL/XML)
• Report layout templates (RTF, Excel)
• Schedule and burst reports to users

• Overview of Oracle FBDI (File-Based Data Import)
• Format, structure, and template download
• ADFdi (ADF Desktop Integration) vs FBDI
• UCM (Universal Content Manager) file upload
• Error handling and validation report interpretation
• Best practices: Data mapping, cleanup, cutover planning

• Difference between BRD, FSD, and TSD
• Structure of a standard FSD:
• Objective, background, scope
• Input sources, logic, rules
• Output format, users, report layouts