12:35 – 1:25 pm ET
Workflow Setups that Make a Difference
Karen Brownfield, Infosemantics, Inc.
There are a few advanced, and mostly undocumented, setups that can increase your organization’s use and administration of workflow. These include: worklist flexfields and custom notification views, exporting notifications to Excel®, assistant administrators, using grants instead of worklist access to see SYSADMIN’s emails, controlling the LOV for the recipient for vacation rules and worklist access (12.2 only). Listen to Oracle® ACE and author explain how to install and use these setups. Many of these setups are available in R12.1.3, but the presentation will cover new setups available only in R12.2.
Objective 1: Obtain a high level overview of workflow in EBS.
Objective 2: Learn about setups that enhance administrator effectiveness.
Objective 3: Learn about setups that enhance security in managing notifications.
1:35 – 2:25 pm ET
Exploring Oracle Database 12c New Features and Best Practices for Database Developers and DBAs
Sponsored by OAUG
This session will explore new features and best practices for using various key new features and enhancements introduced in Oracle database 12c. The session will include exploring features that can be used to improve language functionality, usability and performance while reducing development time, making development simpler and improving the performance and speed of deployment. Participants will learn new SQL functions, SQL tuning enhancements, table and index enhancements, partitioning enhancements, using invisible columns, improved defaults, statistics improvements and PL/SQL new features.
Objective 1: Explore new features and best practices for using various key new features and enhancements introduced in Oracle database 12c.
Objective 2: Learn how to improve language functionality, usability and performance while reducing development time, making development simpler and improving the performance and speed of deployment.
Objective 3: Discover new SQL functions, SQL tuning enhancements, table and index enhancements, partitioning enhancements, using invisible columns, improved defaults, statistics improvements and PL/SQL new features.
2:40 – 3:30 pm ET
Segregation of Duties Controls in EBS
Skip Straus, Absolute Technologies
Segregation of Duties (SOD) in EBS mitigates financial risks. The auditor’s matrix clearly defines policies, but the EBS access model has twists and turns that make it difficult to know for sure who can do what. Once you know, how do you eliminate SOD violations? An EBS expert describes client SOD projects in the cloud, what can and cannot be done, and how the process continues on premises. The session includes real-world examples of how EBS customers create SOD policies and get compliant.
Objective 1: Identify challenges in setting policies and evaluating access. Can you trust SOD spreadsheets?
Objective 2: Map business activities to EBS users, responsibilities, menus and functions.
Objective 3: Look at processes and software tools that can be cloud-based compared to on-premises.
Objective 4: Analyze the stakeholders and participants in SOD projects, and the timeline for action.
Objective 5: Position SOD controls, set goals, and define success in the larger financial risk framework.
12:35 – 1:25 pm ET
EBS User Management for Dummies: Current Requirements and Features with Grants, Permissions, RBAC and Proxy Users
Susan Behn, Infosemantics, Inc.
Unravel the mysteries of role based access control, grants, and permissions to provide more granular function and data control. This presentation covers basic Oracle® E-Business Suite user management concepts, how to apply these concepts using real examples, and the required setups in 12.1 and 12.2. Also covered are the most recent improvements in proxy user functionality to reduce auditor concerns about this functionality.
Objective 1: Explain Role Based Access Control (RBAC), where it is required and where it is optional.
Objective 2: Describe how User Management (UMX) and RBAC work together to mitigate security risks within Release 12.
Objective 3: Show specific recommended examples on how to set up and use some of the key functionality.
3:05 – 3:55 pm ET
ADOP and Customizations – How to Create Custom Cross Edition Triggers
Mike Swing, Trutek
The Release 12.2.5 Upgrade: Online Patching and Customizations: Release 12.2 is the new standard for Oracle® E-Business Suite. What do you need to focus on to complete your 12.2 upgrade? Is it online patching or customizations? Ease your worries by attending this session. We’ll discuss ADOP, the Online Patching Utility, and how to create Online Patch compatible customizations.
Objective 1: Understand how to modify customizations to make them minimally online patch-compliant or fully online patch-enabled.
Objective 2: Learn about ADOP, the Online Patching Utility, the options and how to use the options.
Objective 3: Examine the required steps to fully enable custom code for online patching, including creating forward cross edition triggers and reverse cross edition triggers.