Tuesday, November 5
7:30 AM - 3:00 PM
Registration Open
8:00 AM - 9:00 AM
Breakfast
8:00 AM - 4:00 PM
Vendors Open
9:00 AM - 10:00 AM
Data Alchemy: Unleashing Business Insights With Oracle Fusion Analytics Warehouse for EPM and PPM
Prakash Malmarugan, NexInfo Solutions Inc.
Experience the dynamic integration of Oracle Fusion Analytics Warehouse (FAW) with EPM and PPM. Revolutionizing data mashup, this advanced analytics solution unlocks unparalleled business value. Delve into Oracle Analytics' visual appeal, showcasing predictive algorithms for project budget revisions. Explore multifaceted value additions transcending traditional boundaries. From enhanced collaboration to streamlined workflows and improved reporting, Oracle FAW reshapes the landscape, offering an unprecedented approach to harnessing business insights. Immerse in a transformative journey where data integration meets predictive analytics, shaping a new era of strategic decision-making.
E-Business Suite integration With Oracle Identity Management and Modern Cloud-Based Identity Management Solutions
Subhajit Das Chaudhuri, Pythian Services Inc.
As part of enhancing E-Business Suite R12.2 security to the next level, this session will provide a roadmap on ways to integrate enterprise Oracle Applications E-Business Suite with Oracle Identity Management, as well as other third party and cloud based emerging identity management solutions. We will discuss new enhancements in the implementation strategy. We will also review solutions to issues one might face during the implementation cycle. We will touch upon key concepts on SAML and OAUTH. The following identity products will be part of our architecture roadmap: Azure AD, OKTA, ForgeRock, Onelogin, Oracle IDCS, Active Directory, Oracle Access Manager, Oracle Internet Directory and Oracle Universal Directory and Pythian SSO solution.
Key Principles for Modernizing Your User Interface
Peter Koletzke, Independent
In the past the Graphics Department dictated, or tried to dictate, the look-and-feel of the user interface. These days, developers themselves are being tasked designing the application's UI. However, it's no longer good enough to just throw some fields onto the screen with a Submit button. Mobile apps have raised the expectations of business users, so they now expect applications at their offices to interact like the mobile apps they use daily, even if the business applications are not rendered on a mobile device.
Fortunately, there is help in the form of a set of principles that can guide the design of a modern user interface, regardless of the device on which it is displayed and regardless of the development tools and environments used like Oracle's APEX, JET, Visual Builder, Java, ADF and tools from other sources. This presentation explains these principles and shows examples of how they appear in working applications.
Relying on proven UI patterns is a key technique to accomplish the goal of a modern UI design. Toward this end, Oracle has developed a highly-evolved set of design principles and philosophies called "Oracle Redwood," which it uses for Oracle Fusion/Cloud application suites.
Oracle has released extensive information about Redwood, and these resources provide a good foundation to developers who create user interfaces. This presentation will also explain more about Oracle Redwood and will show how it provides assistance to developers who are creating custom applications or who are extending existing Oracle Cloud applications.
Use Slack and MS Teams to Observe and Control Oracle Databases
Sean Scott, Viscosity NA
Messaging apps do more than facilitate communication—they're hubs that accelerate work along its journey from idea through completion. Slack and MS Teams plugins shift the work once performed in dedicated tools into chat's single, familiar interface. What began as simple applications that connected people and teams are now indispensable platforms that join people to processes, increase productivity, and ignite collaboration.
One of the last frontiers for integration is connecting chat to databases—an idea that might seem to offer little value. Yet just as chat plugins streamlined other workflows, enabling database-to-chat communications revolutionizes how organizations access database resources. Simple, standardized APIs allow organizations to quickly build custom services on top of a trusted platform and leverage existing role-based access.
This session begins with an introduction to the database-to-chat integrations possible through Oracle built-in packages, including the new DBMS_CLOUD_NOTIFICATION package. You'll learn how to set up and secure passive notifications from an Oracle database to clients, then discover ways to extend this relationship, deploying a fully interactive platform that allows users to issue database commands directly from a chat client. The session concludes with example applications, a discussion of best practices, and coverage of security strategies and considerations.
Frustrated With Your Oracle Data Entry Options? You're Not Alone!
Sarah Conzemius, API Wizard
Is your Oracle data entry backlogged & taking too much of your time?
Oracle users across the world are frustrated with the amount of time and effort it takes them to process their data. The user interfaces Oracle provides are slow, cumbersome, complicated and inflexible. Oracle Forms and Screens are time consuming and prone to manual data entry errors. Web ADI, FBDI, ADFDI are limited, inflexible and difficult.
Users are spending hours every day entering invoices, creating and updating suppliers and customers, updating price lists, creating new inventory items, purchase orders, and other data that tends to pile up.
In this presentation we will discuss your data entry options in Oracle E-Business Suite and Cloud ERP (Fusion) and how they compare. We will review the business issues customers have faced and how they overcame these challenges. We will also discuss the benefits and ROI they experienced by using an automated tool that helped them increase their data accuracy and speed up processing time by up to 90%, benefitting both business users and IT.
10:15 AM - 11:15 AM
All Things Auditing: Oracle Database
Greg Garrison, AEM Corporation
Database auditing is one of the most important compliance and security components that should be set up for any system. Beginning with 12c, Oracle has started to make the initial configuration of auditing more simple with the introduction of Unified Auditing. But once that is configured, what are the next steps? You are collecting the correct audit data, but how do you make sense of that data and set up alerts to be able to properly monitor what is happening and be notified if an issue arises?
In this presentation, I will give a brief overview of how to properly configure Unified Auditing for a database that will meet stringent DoD STIG requirements while avoiding some common issues and pitfalls.
The second half of the presentation will focus on two ways to use this data. First, we will step through configuring Splunk to ingest the audit data and to create reports/alerts through the console. Second, we will walk through the steps to configure Oracle Audit Vault and Database Firewall (AVDF) and show how to let AVDF manage the unified audit trail.
APEX CI/CD From the Trenches
Roel Hartman, APEX Consulting
The debate on how to incorporate a repository-based development tool like APEX in a file-based development and deployment process has already been going on for years. Usually a solution is found by throwing in more rules, guidelines, tools and complexity, resulting in a well-known reduction in the development speed of APEX.
Learn how we set up a development process using just SQLcl and GitLab to match most of the CI/CD requirements without sacrificing development speed.
Filtering Sensitive Data in Flight During Database Replication
Valli Ramanathan, Freddie Mac
The session will elaborate on leveraging multiple complex functionalities of Golden Gate to accomplish complex filtering of sensitive data in flight during replication. With the amount of data breach happening these days, handling sensitive data for the client has become very critical. Large databases with sensitive information (PII & SPI) are being replicated and need data filters for the sensitive information. Filtering data in flight in a secure manner is highly desired. This presentation will explain filters with examples that can be easily implemented by all.
Practical Applications of Generative AI in Oracle Cloud Environments
Naresh Miryala, Meta Platforms (Facebook)
This presentation explores practical applications of generative AI across the Oracle Cloud stack. Attendees will learn use cases of large language models for natural language processing tasks like requirements gathering, documentation, query optimization, and data validation. Computer vision models can enable intelligent document processing, image analysis, and video analytics on Oracle Cloud Infrastructure (OCI). The session covers emerging areas like AI-assisted coding, synthetic data generation, and AI-powered testing/QA automation. It discusses strategies to integrate and optimize foundation models like GPT-3 on OCI. Real-world examples from Oracle's cloud services and customer case studies illustrate how enterprises are operationalizing generative AI on Oracle Cloud today. Best practices and governance frameworks for successfully leveraging this powerful technology will be provided.
Real World Problems Solving Using AI Teams
Craig Shallahamer, OraPub/Viscosity NA
Solving complex problems on your own can be tough. Having a team of experts can make a big difference, but they're not always available. So, what's the alternative? Enter AI, where a group of specially skilled AIs can lend a hand.
In this talk, I'll show you how to use detailed prompts and domain-specific documents to create AIs with unique skills and personalities.
Then, I'll demonstrate how you can guide these AIs using everyday conversational language to help develop plans for solving specific issues.
First, I'll use ChatGPT to moderate a lively discussion between two AIs, each playing a famous historical figure.
Next, with a downloadable Python program, I'll demonstrate how to set up an AI task force to tackle a complex Oracle application performance problem.
This task force will include experts in areas like Application Design, PL/SQL Tuning, Oracle Database internals, Operating System performance analysis,
Business Analysis, and an Application User.
Join me for this one-of-a-kind presentation to boost your problem-solving toolkit with a team of skilled AIs.
11:30 AM - 12:30 PM
APEX 24.1 New Features
Jayson Hanes, Oracle
APEX 24.1 will introduce many new roadmap features.
Graphs, Graph-RAG and Generative AI
Melliyal Annamalai, Oracle
Knowledge graphs can store complex information by capturing relationships between data entities. Data represented by such a graph provides additional information about data, derived from how data is connected to other entities. Instead of viewing data entities as standalone points, a graph data model views data as a set of connected entities. The nature of how data is connected enables new and additional insights about data. Capturing this information enables richer context to be provided to generative AI. Retrieval Augmented Generation (RAG) can be enhanced with graph-RAG. Join us to learn more about graphs, graph-RAG and the power of combining graphs and generative AI. We will demonstrate how easy this is to do using Graph and Vector technologies in Oracle Database.
Oracle Database: What's New, What's Next
Sean Stacey, Oracle
Get an update on the latest Oracle Database news and developments. Get a sneak preview—directly from the Oracle Database development team and find out what's coming next in the Oracle Database, including innovations in the area of Artificial Intelligence.
Whether you’re a Developer, DBA, or Data Scientist, whether your language of choice is SQL or NoSQL, or whether you’re storing relational information, Vectors or Graphs, or even JSON documents, there’s something for you. Attend this session and see what Oracle has in store for you.
Strategic Security Planning with EBS Panel: Cybersecurity Insurance Risks and Requirements
Susan Behn, CherryRoad Technologies
Bill Dunham and Michael Barone, OATC Inc.
In this engaging panel discussion, we elevate the discussion to the functional team level, delving into crucial EBS security planning topics. Join us for an insightful exploration of the following key areas, while also providing an open forum for your questions:
• Assessing Cybersecurity Insurance: Ensuring comprehensive coverage for releases in sustaining support.
• Beyond the Firewall: Mitigating inside threats.
• Unraveling the Patching Dilemma: Understanding security patch availability for databases below 19c.
• Proactive Contingency Planning: Safeguarding against the next log4j threat.
• Access Management in Compliance: Developing processes for seamless access during key user absences, aligning with SOX and other regulatory standards.
Signing E-Business Suite Jar Files in an HSM World
Michael Brown, BlueStar
Since June 2023, the rules for getting a code signing certificate have changed making it impossible for the E-Business Suite tools such as adadmin to automatically sign jar files for us during compilation. This session will discuss the changes in getting code signing certificates and the impact of having to use hardware based certificates for signing jar files. After an overview of the changes, it will go into one company's solution for signing as well as the shell scripts that are used to make the process relatively painless.
12:30 PM - 1:30 PM - Network with Aces Lunch
1:30 PM - 2:30 PM
(Free) Tools for Identifying and Diagnosing Database (and Not-The-Database) Issues
Sean Scott, Viscosity NA
"Every problem is a database problem until the DBA proves otherwise." — Plato, probably.
Whether conducting a proactive database review or firefighting an outage or performance issue, most of my work as a consultant revolves around a handful of free, open-source, and Oracle-provided utilities. In this session, I'll share these tools and show how I use them to find and solve database (and non-database) problems.
The first part of the session focuses on reactive tools that will help you quickly isolate, contain, and extinguish fires. In the second, we'll dive into proactive and diagnostic solutions, demonstrating how to use them to catch and repair problematic configurations before they cause problems!
AI for Data: Vector Search in Oracle Database 23ai
Kai Yu, Indpendent
A key AI feature introduced in Oracle database 23ai is the vector search. A vector is an array of numbers that represent the semantic content of data, instead of the words, pixels in the images. Vectors allow us to do the similarity search of the data based on the semantic contents. In this session, we will take a look at the vector search feature in Oracle 23ai database: how to store vector data in the database and how to do the similarity search using vector_distance function in a simple select query. We also will discuss how the vector search improves Generative AI and LLM and address the hallucination issue by augmenting prompts with private database content. we will discuss the two vector embedding generations methods that we can use to generate vectors to the Oracle 23ai database for the unstructured data such as words, images, etc. 1) Database native DBMS_DATA_MINING procedure to import ONNX(Open Neural Network eXchange embedding models ; 2) embedding models in LangChain. Using some examples, we will discuss using the LangChain framework for developing applications with Large Language Models (LLMs) and Using Oracle AI Vector Search to store and search vectors in Oracle Database 23ai.
Data Encryption and Java Code Signing For Oracle E-Business Suite
Michael Barone and David Channell, OATC Inc.
We will learn and discuss Data Encryption and Java Code Signing for the Oracle E-Business Suite (EBS) environment. We will be sharing information regarding Oracle Support Notes that will help you implement HTTPS certificates along with the TLS protocol. We will also talk a bit about Java Code Signing. During the session we will discuss and show some coding tips that should help in successfully implement Public Key Infrastructure (PKI) in your EBS environment.
How You Can Easily Leverage AI and Machine Learning in Existing Applications
Erik Benner, Mythics
Artificial Intelligence is changing how we work and live every day! In this engaging session, we will guide you through the transformative world of AI, focusing on key technologies and their applications that can revolutionize your organization. Generative AI is a new technology that can help you operate more efficiently while generating content or code for your agency. AI can also help almost any application better process and analyze the data regardless of where it lives. This session will show multiple examples of the technology, with a live demo using Generative AI technology combined with Oracle’s Autonomous Database.
Project Management in Today's Complex Cloud and On-Premise World
Bill Dunham, OATC Inc.
In this day and age, Enterprise Application projects should not be over-complicated. With the advent of Enterprise Applications running on cloud services as well as on-premise, the tasks required for a successful migration, upgrade or implementation to Cloud Services are well defined. This presentation will focus on the project management method used to ensure a successful project. We will review and break down the Conference Room Pilot Method phases, activities, tasks and work products to support a cloud services migration.
2:45 PM - Keynote
Analytics & AI - Assistants for All
Darren Grogan, Oracle
The keynote address will cover the cutting-edge innovations and announcements from the recent Oracle Cloud World event in Las Vegas, focusing on the Intelligent Data Lake architecture, AI and Analytics transforming our daily lives. The ECO conference’s exciting conclusion will highlight key technologies and applications, with a focus on the groundbreaking ‘GenAI Assistant’ feature within Oracle Analytics...a game-changing tool. The presentation will showcase multiple examples, complete with a couple of embedded demos and how to leverage Oracle’s 23ai database.
3:45 PM - Closing and Vendor Raffles