Powered by RND
PodcastsEnsinoOracle University Podcast

Oracle University Podcast

Oracle Corporation
Oracle University Podcast
Último episódio

Episódios Disponíveis

5 de 127
  • Modernize Your Business with Oracle Cloud Apps – Part 2
    In this episode, hosts Lois Houston and Nikita Abraham welcome back Cloud Delivery Lead Sarah Mahalik for a detailed tour of the four pillars of Oracle Fusion Cloud Applications: ERP, HCM, SCM, and CX.   Discover how Oracle weaves AI, analytics, and automation into every layer of enterprise operations. Plus, learn how Oracle Modern Best Practice is redefining digital workflows.   Oracle Fusion Cloud Applications: Process Essentials https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-hcm/146870 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundations-enterprise-resource-planning-erp/146928/241047 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-scm/146938 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-cx/146972   Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ------------------------------------------------------------- Episode Transcript:   00:00   Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started!   00:25   Lois: Hello and welcome to the Oracle University Podcast! I’m Lois Houston, Director of Innovation Programs with Oracle University, and joining me is Nikita Abraham, Team Lead: Editorial Services.     Nikita: Hi everyone! Last week, we spoke about Oracle Cloud Apps and the Redwood design system. Today, we’ll take a closer look at the four key pillars of Oracle Cloud Apps.    Lois: And we’re so excited to have Sarah Mahalik back with us. Sarah is a Cloud Delivery Lead here at Oracle. Hi Sarah! In the last episode, we briefly spoke about the various Oracle Cloud Apps offerings and their capabilities. For anyone who missed that episode, can you give us a quick introduction?   01:06   Sarah: Oracle Cloud Applications is an incredibly broad suite that covers many of the most important business functions, from Human Capital Management, Supply Chain Management, to Enterprise Resource Planning and Customer Experience. The products in the Oracle Fusion Cloud Applications suite are organized by functional groups or pillars. All of these applications sit on Oracle Cloud Infrastructure, a foundation built from scratch to support mission-critical applications.    Oracle Fusion Applications deliver a single source of truth, enabling quick responses to disruptions and market opportunities. With unified data and consistent business rules, teams can build streamlined end-to-end processes, access real time analytics, and make faster data-driven decisions for improved outcomes.   01:52   Nikita: Ok, let’s actually get into each of these areas. I think we can start with Human Capital Management.   Sarah: Oracle Human Capital Management is an end-to-end solution that allows you to manage all aspects of people data from hire to retire. It all starts with recruiting, or requisitions are used to advertise vacant positions, and candidates are managed through the hiring process. After recruitment, successful candidates are transferred to the human resources module.   You can configure the organization structure to mirror that of your business. And this allows for easy reorganization whenever the structure changes. People data is a staple element of HCM. Therefore, as part of this product, an HR specialist can manage everything about the employee life cycle, including promotions, transfers, general assignment changes, and terminations.   A robust self-service offering allows employees and managers to take ownership and responsibility for the data pertaining to themselves and their teams. By removing the burden of simple data processing from the HR specialists, it not only eases the pressure on the HR department but allows them to concentrate on more specialized tasks.   03:00   Lois: And how are the core products of HCM categorized?   Sarah: The core products of Human Capital Management are categorized into four main groupings according to their logical purpose. First up, we have our human resources. This grouping includes the elements for implementing and maintaining the enterprise and workforce structure and employee life cycle data. This is where you would configure the organization structure as well as manage an employee's data from the HR specialist point of view. In addition, modules such as benefits, work life, workforce modeling and planning, and advanced HCM controls also sit within this category.   This brings us to talent management. This category is one of the largest because it includes recruiting, learning, goals and performance management, career development, succession planning, talent reviews, and compensation. In addition to that, dynamic skills and opportunity marketplace are also included in this grouping. Within workforce management, you'll find absence management and time and labor.   These naturally sit together because most organizations that implement both configure it so that an employee can enter both work time and absences on a time card, instead of having to visit two different entry points. You'll also find workforce health and safety here. And finally, payroll. All aspects of payroll are included here, whether you're simply using global payroll or localizations, such as UK, Canada, and Mexico.   It also encompasses payroll interface for those organizations that run their payroll from another system, and just need to extract and migrate the relevant data from Fusion HCM Cloud. When talking about HCM systems, we cannot forget the employee self-service aspect of the product. For this, there's an employee experience module called Oracle Me. Here you'll find options, such as HCM communicate, touchpoints, journeys, HR help desk, and Oracle digital assistant.   All of these combined enable an employee to take control and ownership of their own data, and use the many self-help options to get the information they need quickly and efficiently. In order to control how the system behaves and how users interact with it and perform the various processes, there are configuration options. These options allow organizations to define such things as the user experience, workflows, and approval policies based on their business requirements. And to meet the constant need for reporting, there's analytics, planning, and data modeling.   And in addition to all of that, you can use configuration options, such as extensibility, integration, or import and extracts, security, and adaptive intelligence to help enhance the system and have it working and looking the way you need. Of course, much of these latter configuration items are not exclusive to HCM but are available for the Oracle Fusion Cloud as a whole.   05:47   Lois: That’s great. Ok, let’s move on to Oracle Enterprise Resource Planning, or ERP.   Sarah: This is a complete modern Cloud ERP suite that provides your teams with advanced capabilities, such as AI, to automate the manual processes that slow them down, analytics to react to market shifts in real time, and automatic updates to stay current and gain a competitive advantage.   Oracle Cloud ERP automates the entire Record to Report process and provides a common repository of information for global financial reporting and compliance. Within ERP, we have the broadest and deepest suite offering everything you need, from financials, project management, enterprise performance management, risk management and compliance, and analytics.    06:34   Nikita: Sarah, could you break down the different modules within ERP?   Sarah: First, we have Financials, which is a global financial platform that connects and automates your financial management processes, including payables, receivables, fixed assets, expenses, and reporting for a clear view into your total financial health. Oracle Project Management offers a single project cloud solution designed to help you gain a complete picture of your organization's project finances and operations. It's seamlessly integrated across the enterprise with the Oracle Fusion Cloud ERP, HCM, and SCM applications.   Oracle Fusion Cloud Enterprise Performance Management, or EPM, helps you model and plan across finance, HR, supply chain and sales, streamline the financial close process, and drive better decisions. Oracle Fusion Cloud Risk Management and Compliance is a security and audit solution that controls user access to your Oracle Cloud ERP financial data, monitors user activity, and makes it easier to meet compliance regulations through automation.   Oracle Risk Management Compliance uses AI and ML to strengthen financial controls to help prevent cash leaks, enforce audit, and protect against emerging risks, saving you hours of manual work. Oracle Analytics for Cloud ERP complements the embedded analytics in Cloud ERP to provide pre-packaged use cases, predictive analysis, and KPIs based on variance analysis and historical trends.    08:06   Lois: And what about Supply Chain Management?   Sarah: Oracle Supply Chain Management empowers organizations to plan, source, make, deliver, and service goods with agility and resilience. It offers a solution that integrates advanced capabilities, such as AI/ML and blockchain, to optimize the supply chain life cycle from start to finish.   08:31   Adopting a multicloud strategy is a big step towards future-proofing your business and we’re here to help you navigate this complex landscape. With our suite of courses, you'll gain insights into network connectivity, security protocols, and the considerations of working across different cloud platforms. Start your journey today to multicloud today by visiting mylearn.oracle.com.    08:58   Nikita: Welcome back! Sarah, what makes Oracle Fusion SCM so powerful?   Sarah: When it comes to planning, you can leverage strategic, tactical, and operational processes for accurate forecasting and resource alignment. Sourcing and manufacturing help you streamline procurement and production to meet supply and demand efficiently. Inventory and warehousing processes ensure the right goods are available, stored, and managed effectively.   Fulfillment is also known as the pick, pack, and ship part of the supply chain and delivery entails order tracking and receipt. Having connected processes in place ensures that billing and revenue recognition are applied correctly on the goods and services. Great customer service models provide accurate tracking of customer orders and deliveries. And this can provide insight for an accurate picture of future planning, manufacturing, and inventory forecasts. This is a constant cycle because information and analytics feed into the planning process.   Oracle Supply Chain Management is designed to seamlessly integrate and optimize every step of the supply chain process, ensuring businesses can adapt to dynamic market conditions and customer expectations. The solution supports end-to-end supply chain processes and leverages cutting-edge technologies to transform how organizations manage their operations.   In planning, Oracle SCM empowers businesses with advanced planning tools to align supply and demand effectively. Sourcing and manufacturing assists in streamlining procurement and manufacturing workflows to drive efficiency. Inventory and warehousing optimizes inventory and warehouse management processes with intelligent capabilities.   Fulfillment delivery helps to accelerate order fulfillment and delivery operations to meet customer needs. And servicing allows you to maintain strong customer relationships through seamless post-sale servicing. Oracle SCM ensures an agile and resilient supply chain with the help of technologies like AI, ML, and blockchain. These tools empower organizations to stay competitive in a fast-paced environment while exceeding customer expectations.   11:03   Lois: To round out our discussion, let’s talk about Oracle Customer Experience.   Sarah: Customer Experience, or CX, provides the platform and products necessary to capture all customer touch points and interactions. This platform also automates the business process from interest and lead generation to the sale and provision of products and services. The major product areas are marketing, sales, service, and CX platform.    11:32   Nikita: Could you dive a bit deeper into its key areas?   Sarah: Oracle Marketing solutions allow you to create targeted cross-channel marketing campaigns, optimize lead generation activities, personalize customer and prospect communication, and automate marketing activities. Use real-time data-driven insights to engage, convert, and nurture buyer relationships to increase sales. Featured products include Eloqua Marketing Automation, Responsys Campaign Management, CrowdTwist Loyalty and Engagement, Infinity Behavioral Intelligence, Unity Customer Data Platform, and more.   With Oracle Sales, you can deliver responsive selling across all touchpoints. Oracle Sales guides sellers with intelligent recommendations and gives them a faster path to critical records to help them focus on the right prospects at the right time. The modern, unified selling and buying approach of Oracle CX connects sales and commerce to service, marketing, and the entire customer experience. Featured products include Salesforce Automation, Sales Planning, Sales Performance Management, Configure, Price, and Quote, Subscription Management, Partner Relationship Management, and Customer Data Management.   Oracle Service enables you to help customers when and where they need you with automated workflows for customer self-service, agent-assisted service, and Field Service engagements. You can accelerate the resolution of service issues with AI-driven recommendations, unified data visibility, and cross-organization and cross-channel collaboration tools.   At Oracle, we make every customer interaction matter by using a suite of CX Cloud applications that connect marketing, sales, customer service, Field Service, and e-commerce. Oracle connects our customer experience systems with finance, supply chain, and HR on a unified cloud platform for a single, dynamic 360-degree view of the customer.   13:31   Lois: Before we wrap up, how does Oracle Modern Best Practice, or OMBP, fit into Oracle Cloud Apps?   Sarah: OMBP illustrates common business processes optimized to leverage the latest applications and technologies in Oracle Fusion Applications.   Oracle Modern Best Practice comprises reimagined industry standard business processes powered by Oracle technology. Engineered into Fusion Applications, OMBP simplifies and streamlines workflows, enabling organizations to leverage modern, efficient, and scalable practices. As we align more assets with OMBP, there will be a stronger connection between global process owners and business process innovation within a customer's organization.   OMBP was derived from over 10,000 successful delivery projects. To publish an OMBP, past Oracle projects were analyzed for successful and unsuccessful processes. Successful processes were reviewed and optimized by product experts, engineers, customers, and key users. Optimized processes were published to OMBP to make them available to other customers.   14:40   Lois: Well, that’s it for this episode. Thank you, Sarah, for all of your incredible insights.    Nikita: If you want to learn more about what we discussed today, head over to mylearn.oracle.com and take a look at the Oracle Fusion Cloud Applications Process Essentials courses. Until next time, this is Nikita Abraham…   Lois: And Lois Houston, signing off!   15:01   That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.  
    --------  
    15:30
  • Modernize Your Business with Oracle Cloud Apps – Part 1
    Join hosts Lois Houston and Nikita Abraham, along with Cloud Delivery Lead Sarah Mahalik, as they unpack the core pillars of Oracle Fusion Cloud Applications—ERP, HCM, SCM, and CX.   Learn how Oracle’s SaaS model, Redwood UX, and built-in AI are reshaping business productivity, adaptability, and user experience. From quarterly updates to advanced AI agents, discover how Oracle delivers agility, lower costs, and smarter decision-making across departments.   Oracle Fusion Cloud Applications: Process Essentials https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-hcm/146870 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundations-enterprise-resource-planning-erp/146928/241047 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-scm/146938 https://mylearn.oracle.com/ou/course/oracle-fusion-cloud-applications-foundation-cx/146972   Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. -------------------------------------------------------------- Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I’m Nikita Abraham, Team Lead: Editorial Services with Oracle University, and with me is Lois Houston, Director of Innovation Programs.  Lois: Hi everyone! In our last two episodes, we explored the Oracle Cloud Success Navigator platform. This week and next, we’re diving into Oracle Fusion Cloud Applications with Sarah Mahalik, a Cloud Delivery Lead here at Oracle. We’ll ask Sarah about Oracle’s cloud apps suite, the Redwood design system, and also look at some of Oracle’s AI capabilities.  01:02 Nikita: Yeah, let’s jump right in. Hi Sarah! How does Oracle approach the SaaS model? Sarah: Oracle's Cloud Applications suite is a complete enterprise cloud designed to modernize your business. Our cloud suite of SaaS applications, which includes Enterprise Resource Planning, or ERP, Supply Chain Management, or SCM, Human Capital Management, or HCM, and Customer Experience, or CX, brings consistent processes and a single source of truth across the most important business functions.  At Oracle, we own all of the technology stacks that power our suite of cloud applications. Oracle Cloud Applications are built on Oracle Cloud Infrastructure and ensure the performance, resiliency, and security that enterprises need. Your business no longer needs to worry about maintaining a data center, hardware, operating systems, database, network, or all of the security. With deep integrations, a common data model, and a unified user interface, these applications help improve customer engagement, increase agility, and accelerate response to change. Oracle's Cloud Applications are updated quarterly with new features and improvements. These updates are based on our deep understanding of customer's functional needs, as well as modern technologies such as artificial intelligence, machine learning, blockchain, and digital assistants. Expectations for user experience only go up. Oracle's Redwood User Experience methodology ensures those expectations are matched and exceeded by including powerful and predictive search, a look and feel that actually helps users see what they need to in the order they need to see it, and by providing conversational and micro-interactions. Oracle, as a SaaS provider, puts the customer first by having enough dedicated resources to ensure zero downtime and increasing the speed of implementation by eliminating much of the hardware and software setup activity. 02:59 Nikita: What are the advantages of adopting Oracle Cloud Apps? Sarah: First off, Oracle provides automatic quarterly updates, and they're usable immediately. Customers can focus on leveraging the new functionality instead of spending cycles on installing it. There's much more accessibility because Oracle hosts the heavy part of the applications and customers access it via thin clients. The applications can be used from nearly anywhere and on a wide range of devices, including smartphones and tablets. Another great advantage is speed and agility. A lot of the benefits you see here result from Oracle's provider model. That means customers aren't spending time on customization, application testing, and report development. Instead, they work on the much lighter and faster tasks of configuration, validation, and leveraging embedded analytics. And finally, it's just better economics. Because of the pricing model, it is easy to compare an on-premises implementation cost. While upfront costs are almost always lower, overall operational costs and risk are usually lower as well. This translates to better total cost of ownership and improved overall economics and agility for your business. 04:10 Lois: Sarah, in your experience, why do customers love Oracle Cloud Apps? Sarah: At Oracle, we empower you with embedded AI that drives real breakthroughs in productivity and efficiency, helping you stay ahead of the curve. With the power of Oracle Cloud Infrastructure, you get the best of performance, security, and scalability, making it the perfect foundation for your business. Our modern user experience is intuitive and designed with your needs in mind, while our relentless innovation is focused on what truly matters to you. Above all, our commitment to your success is unwavering. We're here to support you every step of the way, ensuring you thrive and grow with Oracle. 04:49 Lois: Let’s talk about Oracle’s Redwood design system. What is it? And how does it enhance the user experience?  Sarah: Redwood is the name of Oracle's next-generation user experience. Redwood design system is a collection of prefabricated components, templates, and patterns to enable developers to quickly create very sophisticated and polished interactions that are upgrade safe. It provides a consumer grade-plus experience, where you have high-quality functionality that can be used across multiple devices. You have access to insightful data readily at your fingertips for quick access and decision making, with the option to personalize your application to create your own state of the art experience. Processes and entry time will now be more efficient and streamlined by having fewer clicks and faster downloads, which will lead to high productivity in areas that matter the most. The Redwood design is intelligent, meaning you have access to AI, where you will receive recommendations and guidance based on your preferences and business processes. It's also adaptable, allowing you to use the same tools to create new experiences by using the Business Rule Framework with modern UX components. Oracle's Redwood user experience will help you to be more productive, efficient, and engaged with a highly personalized experience. 06:11 Are you keen to stay ahead in today's fast-paced world? We’ve got your back! Each quarter, Oracle rolls out game-changing updates to its Fusion Cloud Applications. And to make sure you’re always in the know, we offer New Features courses that give you an insider’s look at all of the latest advancements. Don't miss out! Head over to mylearn.oracle.com to get started.  06:37 Nikita: Welcome back! Sarah, you said the Redwood design system is adaptable. Can you elaborate on what you mean by that?  Sarah: In a nutshell, this means that developers can extend their applications using the same development platform that Oracle Cloud Applications are built on. Oracle Visual Builder Studio is a robust application development platform that enables users to rapidly create and extend web, mobile, and progressive web interfaces using a visual development environment. It streamlines application development and reduces coding, while also providing flexibility and support for popular build and testing frameworks. With Oracle Visual Builder Studio, users can build apps for the web, create progressive web apps, and develop on-device mobile apps. The tool also offers access to REST services and allows for planning and managing development processes, as well as managing the code lifecycle. Additionally, Oracle Visual Builder Studio provides hosting for apps along with easy publishing and version management. Changes made using Visual Builder Studio are called Application Extensions.  Visual Builder Studio Express Mode has two key components: Business Rules and Constants. Use Business Rules, which is the Redwood equivalent to Transaction Design Studio for responsive pages, to leverage delivered best practices or create your own rules based on various criteria, such as country and business unit. Make fields and regions required or optional, read-only or editable, and show or hide fields in regions, depending on specific criteria. Use the various delivered Constants to customize your Redwood pages to best fit your specific business needs, such as hide the evaluation panel and connections or reorder the columns in the person search result table. 08:23 Lois: Sarah, here’s a question that's probably on everyone's mind—what about AI for Fusion Applications? Sarah: Oracle integrates AI into Fusion Applications, enabling faster, better decision making and empowering your workforce. With both classic and generative AI embedded, customers can access AI-driven insights seamlessly within their everyday software environment. In HCM, AI helps to automate routine tasks. It's also used to attract and manage talent more efficiently by doing things like reducing the time to hire and performing automatic skill matching for job vacancies. It also uses some of that skill matching for existing employees to optimize their engagement, improve productivity, and maximize career growth. All the while, it provides suggested actions so that those tasks are quick, accurate, and easy. In SCM, AI helps predict order cycle times by analyzing historical data and trends, allowing for more accurate planning. It also generates item descriptions automatically and uncovers potential suppliers by analyzing market data, thereby improving efficiency and sourcing decisions. With ERP, it's all about delivering efficiencies and improving strategic contributions. You can use AI to automate some of the core processes and provide guided actions for users in the rest of the processes. This is our recipe for improved efficiency and reduced human error. For example, in Payables, you can use AI features to accelerate and simplify invoice processing and identify duplicate transactions. And in CX, AI helps you to identify which sales leads offer the greatest potential, provides real-time news alerts, and then recommends actions to ensure that reps are working on the right opportunity at the right time and improving conversion to sale. 10:11 Lois: Everyone’s heard about AI agents, but I’ve always wondered how they work.  Sarah: AI agents are a combination of large language models and other advanced technologies that interact with their environments, automate complex tasks, and collaborate with employees in real time. Reasoning capabilities in these LLMs differentiate AI agents from the brittle rules-based automation of the past. Since they can make judgment calls, AI agents can create action plans and manage workflows, either independently or with human supervision. At the core of their functionality is the capability to learn from previous interactions, use data from internal systems, and collaborate with both people and other agents. This ability to continuously adapt makes AI agents particularly valuable for complex business environments, where flexibility and scalability are key. 11:01 Nikita: And how do they work specifically in Fusion Apps? Sarah: Oracle Fusion AI agents are autonomous assistants designed to help organizations streamline operations, improve decision making, and reduce manual workloads. They can assist with simple or complex tasks and work across departments. 11:19 Lois: Sarah, what are the different types of AI agents? Sarah: Functional agents act as digital assistants for different personas within the enterprise and perform domain-specific tasks. Supervisory agents manage other agents, overseeing complex workflows and making decisions on whether human intervention is needed. Utility agents perform routine low-risk tasks such as retrieving data, sending notifications, or running reports. They're often optimized to help with specific roles, so an AI agent or collection of agents might act as a finance clerk, hiring manager, or a customer service representative. 11:54 Nikita: Can you give us some real-world use cases? Sarah: In human resources, agents will assist employees with benefit inquiries and policy clarifications. In finance, agents will automate invoice approvals and help optimize financial workflows. In supply chain management, a field service agent can guide technicians through repairs by providing real-time diagnostic data, troubleshooting steps, and automating orders for parts. In customer experience, the contracts researcher agent enables sales teams to automate routine contract workflows and approvals so they can focus on selling rather than administrative tasks. Oracle Fusion AI agents represent a leap beyond traditional AI. They don't just automate, they collaborate with human workers, making AI agents more than just tools. By integrating advanced AI within business systems, Oracle continues to lead the way in improving productivity and operational efficiency. As AI technology evolves, expect to see even more sophisticated AI agents capable of managing entire business processes autonomously, giving your team the freedom to focus on strategic, high-impact activities. 13:04 Nikita: Thank you so much for taking us through all that, Sarah. We’re really excited to have you back next week to continue this discussion.  Lois: And if you liked what you heard today, head over to mylearn.oracle.com and take a look at the free Oracle Fusion Cloud Applications Process Essentials courses to learn more. Until next time, this is Lois Houston… Nikita: And Nikita Abraham, signing off! 13:27 That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.
    --------  
    13:56
  • Oracle Cloud Success Navigator – Part 2
    Hosts Lois Houston and Nikita Abraham continue their discussion with Mitchell Flinn, VP of Program Management for the CSS Platform, by exploring how Oracle Cloud Success Navigator helps teams align faster, reduce risk, and drive value.   Learn how built-in quality benchmarks, modern best practices, and Starter Configuration tools accelerate cloud adoption, and explore ways to stay ahead with a mindset of continuous innovation.   Oracle Cloud Success Navigator Essentials: https://mylearn.oracle.com/ou/course/oracle-cloud-success-navigator-essentials/147489/242186 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ----------------------------------------------------------------- Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started! 00:25 Lois: Welcome to the Oracle University Podcast! I’m Lois Houston, Director of Innovation Programs with Oracle University and with joining me today is Nikita Abraham, Team Lead of Editorial Services.  Nikita: Hi everyone! In our last episode, we gave you a broad overview of the Oracle Cloud Success Navigator platform—what it is, how it works, and its key features and benefits. Today, we’re continuing that discussion with Mitchell Flinn. Mitchell is VP of Program Management for Oracle Cloud Success Navigator, and in this episode, we’re going to ask him to walk us through some of the core components of the platform that we couldn’t get into last week. 01:04 Lois: Right, Niki. Hi Mitchell! You spoke a little about Cloud Quality Standards in our last episode. But how do they contribute or align with the vision of Oracle Cloud Success Navigator?  Mitchell: The vision for Navigator is to support customers throughout every phase of their cloud journey, providing timely advice to help improve outcomes to reduce cost and increase overall value. This model is driven through Oracle Cloud Quality Standards. These standards are intended to improve the transparency and collaboration between customer, partner, and Oracle members of a project. This is a project blueprint to include the ability for business and IT users to align on project coordination, expectations, and ultimately drive tighter alignment. Tracking key milestones and activities can help visualize and measure progress. You can build assessments and help answer questions so that at the right time, you have the right resources to make the right decisions for an organization. Cloud Quality Standards represent the key milestone dates and accomplishments along the journey. You can leverage these to increase project transparency, reduce risk, and increase the overall collaboration. Cloud Quality Standards are proactive list of must haves leveraged by customers, partners, and Oracle. They're a collection of knowledge and lessons learned from thousands of implementations globally. Cloud Quality Standards are partner agnostic and complimentary to all SI methodologies and tool sets. And they've been identified to address delivery issues before they happen and reduce the risk of implementations. 02:34 Lois: Ok, and a crucial component of Oracle Cloud Success Navigator is Oracle Modern Best Practice, or OMBP, right? Can you tell us more about what this is?  Mitchell: Oracle Modern Best Practices are based on distilled knowledge of our customers' needs gained from 10,000 successful delivery projects. They illustrate the business process components and their optimization to take advantage of the latest Oracle applications and technologies. Oracle Modern Best Practices comprise industry best practices and processes powered by Oracle technology. Engineered in Fusion Applications, OMBPs simplify and streamline workflows. They enable organizations to leverage modern, efficient, and scalable practices. As we align our assets with OMBPs, there's a stronger connection between global process owners and business process innovation within a customer's organization. 03:21 Nikita: And how do they help deliver end-to-end success for businesses?  Mitchell: An OMBP approach involves a digital business process, so evolving and adapting in real time to changing market dynamics. End-to-end across the organization, so we're breaking down silos and ensuring there's operational agility and a seamless collaboration between departments. We're leveraging emerging technologies, so utilizing AI, other cutting-edge technologies to automate routine tasks, enabling greater human creativity and unlocking new value and insights. And radically superior results, driving a significant improvement in measurable outcomes. OMBPs are dynamic, and when regularly updated, they meet evolving customer needs and technologies. They're trusted, tested, and validated by Oracle experts and publicly available and download on oracle.com. If you go to oracle.com and search modern best practice, you'll find more detailed introduction to Oracle Modern Best Practices. You'll also find Oracle Modern Best Practice business processes for domains such as ERP, EPM, Supply Chain, HCM, and Customer  Experience. We also have Oracle Modern Best Practices for specific industries. 04:25 Nikita: What are the key benefits of OMBP? Mitchell: Revolutionary new technologies are available for organizations and business leaders. You might wonder how existing business processes are optimized with old technology and how they can drive the best solution. With more emerging technologies reaching commercial availability, existing best practices become outdated. And to stay competitive, organizations need to continuously innovate and incorporate new technology within their best practices. In Oracle's definition of OMBPs, common business processes are considered historic input, but we also factor in what could be done with new technologies. And based on this approach, Oracle Modern Best Practices help us evolve with the organizational needs as market dynamics change, work end to end across organizations to eliminate department silos and ensure agility. It allows us to use technologies such as AI to automate the mundane and unlock human creativity for new value and insight. This allows us to incorporate next generation digital technologies to enable radically superior, measurable results. To achieve these, Oracle makes use of key differentiators such as analytics and AI and machine learning. Analytics are also known as business intelligence provides you with information in the form of pre-built dashboards, showing your key metrics in real time. Embedded analytic capabilities enable you to monitor business performance and make better decisions. 05:44 Lois: And what about AI and machine learning? Mitchell: These focus on building systems that learn or improve performance based on the data that they consume. Smart digital assistants, recommendation engines, predictive analytics, they're all used within AI and machine learning to help organizations automate operations and drive innovation, and ultimately make better decisions faster. 06:02 Nikita: Mitchell, let’s move on to the Starter Configuration. Can you explain what it is and how it helps during a cloud implementation? Mitchell: Starter Configuration is a predefined configuration of Oracle Cloud Applications aligned with the Oracle Modern Best Practices. It's very comprehensive and includes business processes in several domains, such as ERP, HCM, Supply Chain, EPM, and so on. It includes sample, master, and transactional data, and predetermined usernames, which aligns and tests based on the same use cases you saw in Oracle Modern Best Practices in Cloud Success Navigator. Customers can request deployment of a Starter Configuration into their test environment. Oracle will run an automated process for replicating the configuration, master data, transaction data, and predetermined usernames from Oracle to the Oracle Cloud Applications Test Environment of the customer's choice. For best user experience, customers can add a basic level of personalization, such as their customer name, limited number of employees, suppliers, customers, and a few other items. Starter Configuration’s delivered with predetermined step guides for comprehensive set of use cases. Using these, customers can relay the same use cases they've seen in Oracle Modern Best Practices and Success Navigator. In the Oracle Cloud Applications Test Environment Customer, we've been able to enable an in-app guidance using Oracle Guided Learning. This helps to make it easier for navigation through the business processes supported by the application. Oracle can deploy the Starter Configuration in days, not weeks or months, which means the implementation partners don't need to invest time and effort for the first configuration of an Oracle Cloud Application environment before they can even get the chance to show it to a customer. In turn, once Starter Configuration is deployed, it's ready to be used for solution familiarization and design activities. Using Starter Configuration of Oracle Cloud Applications early in the cloud journey will offer several benefits to customers. 08:00 Lois: What are these benefits? Mitchell: The first, it helps to cut down on environment configuration time from several weeks or months to potentially just days. Next, implementation partners can engage stakeholders early, and get them familiar with Oracle Cloud Applications, especially those that maybe have never participated in the sales cycle. Because customer stakeholders actually see what Oracle Cloud solutions might look like in the future, it becomes easier to take design decisions. Starter Configuration provides hands-on familiarization with Oracle Cloud Applications and Oracle Leading Practices. This makes it easier to understand what leading practices and standard features can be adopted to support future business processes. It also reduces the level of customization and accelerates implementation. 08:45 Transform the way you work with Oracle Database 23ai! This cutting-edge technology brings the power of AI directly to your data, making it easier to build powerful applications and manage critical workloads. Want to learn more about Database 23ai? Visit mylearn.oracle.com to pick from our range of courses and enroll today!   09:10 Nikita: Welcome back! Mitchell, how can customers and implementation partners best use the Starter Configuration?  Mitchell: Customers and implementation partners will work in close collaboration to make the implementation successful. Hence, Oracle recommends that customers and implementation partner discuss how the best use of Starter Configuration will take place. This is one of the key activities in the mobilize stage of the cloud journey. First, Oracle recommends to use Starter Configuration to prepare the customer stakeholders for the project. Customer stakeholders who participate in the project should go to the Oracle Modern Best Practice section of Success Navigator platform in order to learn more about the modern best practices, business processes, personas, leading practices, and use cases. Project team can request Starter Configuration early in the project to allow customer stakeholders to get their hands-on experience with performing use cases in the Starter Configuration. Customer stakeholders will perform use cases in Starter Config to learn more about modern best practices. They'll use the step-by-step guides and Guided Learning to easily perform the use cases within the Starter Configuration. This is how they'll visualize use cases in Oracle Cloud Applications and get a good understanding of Oracle Modern Best Practices. Next, mobilize stage of the journey, project team can use Starter Configuration to visualize the solution and make design decisions with confidence. First, by requesting Starter Configuration, implementation partners can engage stakeholders early and create the space to get familiar with Oracle Applications. This applies especially to those that may have not participated during the sales cycle. You could personalize Starter Configuration to enhance the user experience to help the customer connect to the application and, for example, change the company name, the logo, few supplier names, customer names, employee names, etc. And implementation partners are going to be able to run sessions to familiarize the customer with modern best practices and show how cloud applications support use cases. For structured guidance, the implementation partners can use the step guides. It includes screenshots of OGL within cloud applications environments. And you could run design workshop and use Starter Configuration, show and explain which design decisions must take place to define a customer-centric configuration. Finally, you can show use cases that help you explain what the impact of design decisions might be. 11:20 Lois: Mitchell, before we wrap up, can you take us through how the Release Readiness features facilitate innovation?  Mitchell: In order to innovate with the Release Readiness features, it's important to learn about the new features in a one-stop shop, and then connect with the capability. The first item is to be able to find and familiarize yourself with the content as they exist within Release Notes. From there, it's important to be able to actually experience those items by looking at the text, and pictures, and the Oracle University videos that we provide in the Feature Overviews, as well as additional capabilities that will be coming with the Navigator in the preview environment, your ability to get your hands on in a demo experience through Cloud Success Navigator. Furthermore, it's important for you to be able to explore across theme-based items, which we call Adoption Centers, currently ready for AI in Redwood. This gives you the ability to span across Release Notes and different releases in order to understand the themes of the trends around AI and Redwood, and how those capabilities in our technology can advance your innovation in the Cloud. And finally, you need to be able to understand those opportunities based off of business processes, data insights, and industry benchmarks. That way, you can understand the capabilities as they exist, not just for your business specifically, but in the context of the broader industry and technology trends. From there, it's important for you to then think about your ability to collaborate to drive continuous innovation. We want to be able to leverage Cloud Success Navigator to drive collaboration to increase confidence across all members of the project team, whether it be you as a customer, our partners, or the Oracle team. It should also be able to drive an increased efficiency within decision making, driving greater value and readiness as you think about the proposed adoption changes. Finally, we want to think about the ability to reduce cycles related to features and decisions so that you can more quickly adapt, and adjust, and consume innovations as they're produced on a quarterly basis.  13:09 Nikita: I think we can end with that. Thank you so much, Mitchell, for taking us through the Navigator platform. Lois: And if you liked what you heard today, head over to mylearn.oracle.com and take a look at the Oracle Cloud Success Navigator Essentials course to learn more. It’s available for free! Until next time, this is Lois Houston…. Nikita: And Nikita Abraham, signing off! 13:33 That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.  
    --------  
    14:02
  • Oracle Cloud Success Navigator – Part 1
    In this episode of the Oracle University Podcast, Lois Houston and Nikita Abraham are joined by Mitchell Flinn, VP of Program Management for the CSS Platform, to explore Oracle Cloud Success Navigator.   This interactive platform is designed to help customers optimize their cloud journey, offering best practices, AI tools, and personalized guidance from implementation to innovation. Don’t miss this insider look at maximizing your Oracle Cloud investment!   Oracle Cloud Success Navigator Essentials: https://mylearn.oracle.com/ou/course/oracle-cloud-success-navigator-essentials/147489/242186 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ---------------------------------------------------------------- Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I’m Nikita Abraham, Team Lead of Editorial Services with Oracle University, and joining me is my co-host Lois Houston, Director of Innovation Programs.  Lois: Hi everyone! Today is the first of a two-part special on Oracle Cloud Success Navigator. This is a tool that provides you with a clear path to cloud transformation and helps you get the most out of your cloud investment. 00:52 Nikita: And to tell us more about this, we have Mitchell Flinn joining us today. Mitchell is VP of Program Management for Oracle Cloud Success Navigator. In this episode, we’ll ask Mitchell about the ins and outs of this powerful platform, its benefits, key features, and the role it plays in streamlining cloud journeys. Lois: Yeah. Hi Mitchell! What is Oracle's approach to cloud technology and customer success, and how does the Cloud Success Navigator support this philosophy? 01:22 Mitchell: Oracle has an amazing amount of industry-leading enterprise cloud technologies across our entire portfolio. All of this is at your disposal. That, coupled with the sole focus of your success, forms the crux of the company's transformational journey. In other words, we put your success at the heart of everything we do. For each organization, the path to achieve maximum value from our technology is unique. Success Navigator reflects our emphasis on being there with you throughout the entire journey to steer you to success.  01:53 Nikita: Ok, what about from a business’s viewpoint? Why would they need the Navigator? Mitchell: Businesses across every industry are moving mission-critical applications to the cloud. However, business leaders understand that there's no one-size-fits-all model for cloud development and deployment. Some fundamentals for success are your need to ensure new technologies are seamlessly integrated into day-to-day operations and continually optimize to align with evolving business requirements. You must ensure stakeholder visibility through the journey with updates at every stage. Building system efficiencies into other key tasks, which has to be done at the forefront when considering your cloud transformation. You also need to quickly identify risks and address them during the implementation process and beyond. Beyond the technical execution, cloud deployments also require significant process and organizational changes to ensure that adoption is aligned with business goals and delivers tangible benefits. Moreover, the training process for new features after cloud adoption can be an organization wide initiative that needs special attention. These requirements or more can be addressed through Oracle Cloud Success Navigator, which is a new interactive digital platform to guide you through all stages of your cloud journey. 03:09 Lois: Mitchell, how does Cloud Success Navigator platform enhance the user experience? How does it support customers at different stages of their cloud journey? Mitchell: Platform is included for free for all cloud application customers. And core to Success Navigator is the goal of increasing transparency among customers, partners in the Oracle team, from project kickoff through quarterly releases. Included in the platform are implementation best practices, Oracle Modern Best Practices focused on solutions provided by our applications, and guidance on living within the cloud.   Success Navigator supports you for every stage of your Oracle journey. You can first get your bearings and understand what's possible with your cloud solution using preconfigured starter environments to support your design decisions. It helps you chart a proven course by providing access to Oracle expertise and Oracle Modern Best Practices, so you can use cloud quality standards to guide your implementation approach. You can find value from quarterly releases using AI assistants and preview environments to experience and adopt latest features that matter to you. And you can blaze new trails by building your own cloud roadmap based on your organization's goals, keeping you focused on the capabilities you need for day-to-day and the road ahead. 04:24 Nikita: How does the Navigator cater to the needs of all the different customers? Mitchell: For customers just getting started with Oracle implementations, Navigator provides a framework with success criteria for each stakeholder involved in the implementation, and provides recommended milestones and checklists to keep everyone on track. For existing customers and experienced cloud customers thriving in the cloud, it provides contextually relevant insights based on your cloud landscape. It prepares you for quarterly releases and preview environments, and enables the use of AI and optimization within your cloud investment. For our partners, it allows Oracle to work in a collaborative way to really team up for our customers. Navigator gives transparency to all stakeholders and helps determine what success criteria we should be thinking about at each milestone phase of the journey. And it also helps customers and partners get more out of their Oracle investment through a seamless process. 05:20 Lois: Right. Mitchell, can you elaborate on the use cases of the platform? How does it address challenges and requirements during cloud implementations? Mitchell: We can create transparency and alignment between you, your partner, and the Oracle team using shared view of progress measured through standard criteria. We can incorporate recommended key milestones and activities to help you visualize and measure your progress. And we can use built-in assessments, remove risk, and ask the right questions at the right time to make the right implementation decisions for your organization. Additionally, we can use Starter Configuration, which allows you to experience the latest capabilities and leading practices to enrich design decisions for your organization with Starter Configuration. This can activate Starter Configuration early in your journey to understand what delivered capability can do for you. It allows you to evaluate modern best practices to determine how your design process can work in the future. And it empowers and educates your organization by interacting with real capability, using real processes to make the right decisions for your cloud implementation. You're able to access new features in Fusion updates. You can do this to learn what you need to know about new features in a one-stop shop and connect your company in a compelling capacity. You can find, familiarize, and prioritize new and existing features in one place. And you can experience new features in hands-on preview environments available with you with each quarterly release. You can explore new theme-based approaches using adoption centers for AI and Redwood to understand where to start and how to get there. And you can understand innovation opportunities based on business processes, data insights, and industry benchmarks. 07:01 Nikita: Now that we’ve covered the basics, can you walk us through some of the key features of the platform? Let’s start with the Home page. Mitchell: This is the starting point of the customer journey and the central location for everything Navigator has to offer, including best practice content. You'll find content focused on implementation phase, the innovation phase, and administrative elements like the team structure, program and projects, and other relevant tips and tricks. Cloud Quality Standards provides learning content and checklists for successful business transformation. This helps support the effective adoption and adherence to Cloud Quality Standards and enables individuals to leverage AI and predictive insights. The feature Sunburst allows capability for features to be reviewed in an interactive graphic, illustrating new features by pillar, other attributes, which enable customers to review features curated to identify and adopt new features that meet their needs. It helps you understand recommended features across your application base based off of a production profile, covering mandatory adoption requirements, efficiency gains, innovation capabilities like AI and Redwood to drive business change. Next is the Adoption Center, which addresses the need of our existing and implementing customers. It covers the concept of how Redwood is an imperative for our application customers, what it means, and how, and when we could translate some of the requirements to a business user or an IT user. Roadmap is an opportunity for the team to evaluate which features are most interesting at any given moment, the items that they would like to adopt next, and save features or items that they might require later. 08:36 Lois: That’s great. Mitchell, I know we have two new features rolling out in 2025. Can you tell us a little bit about them? Mitchell: Preview Environment. This allows users to explore new features and orderly release through a shared environment by logging into Navigator, eliminating potential regression needs, data adjustments and loads, and other common pre-work. You can explore the feature directly with the support of Oracle Guided Learning. The second additional feature for 2025 is AI Assist. We've taken everything within Navigator and trained an LLM to provide customers the ability to inquire about best practices, solutions, and features within the applications and ultimately make them smarter as they prepare for areas like design workshops, quarterly release readiness, and engaging across our overall Oracle team. Customers can use, share, and apply Oracle content knowledge to their day-to-day responsibilities. 09:32 Have you mastered the basics of AI? Are you ready to take your skills to the next level? Unlock the potential of advanced AI with our OCI Generative AI Professional course and certification that covers topics like Large Language Models, the OCI Generative AI Service, and building Q&A chatbots for real-world applications. Head over to mylearn.oracle.com and find out more.  10:01 Nikita: Welcome back! Mitchell, how can I get started with the Navigator? Mitchell: To request customer access to Success Navigator's environment, you need to submit a request form via the Success Navigator page on oracle.com.  You need to be able to provide your customer support identifier with the help icon around the CSI number. If you don't have your CSI number, you can still submit your request and a member of the Success Navigator team will reach out and coordinate with you to understand the information that's required. Once access is granted, you'll receive a welcome email to Oracle Cloud Success Navigator. 10:35 Lois: Alright, and after that’s done? Mitchell: Before implementing Oracle Cloud Applications in your organization, you need to think of a structure that helps you organize and manage that implementation. To implement a solution footprint for a relatively small organization operating in a single country, and with an implementation time of only a few months, defining a single project might be a good enough organization to manage the implementation. For example, if you're implementing Core Human Capital Management applications, you could define a single project for that. But if you're implementing a broad solution footprint for a large business across multiple organizational entities in multiple countries, and with an implementation time of several years, a single project isn't enough. In such cases, organizations typically define a structure of a program with multiple underlying projects that reflect the scope, approach, timelines of business transformation. For example, you're implementing both HCM and ERP applications in a two-phased approach. You might decide to define a program with two underlying projects, one for HCM and one for ERP. For large, international business transformations, you can define multiple programs, each with multiple underlying projects. For example, you might first need to define a global design for a common way of working with HCM and then start rolling out that global design to individual countries. In such a scenario, you might define a program called HCM Transformation with a first project for global design, followed by multiple projects associated with individual countries. You could do the same for ERP. 12:16 Nikita: Mitchell, we’ve mentioned “cloud journey” a few times in this conversation, but can you tell us a little more about it? How can teams use it to guide their work? Mitchell: The main purpose of Oracle's cloud journey is to provide leading practices and actionable guidance to customers and implementation partners for successful implementations, operations within the cloud, and innovation through Oracle Cloud solutions. These are defined in terms of stages, activities, topics, and milestones. They focus on, how do you do the right things at the right time the first time. For customers, implementation partners in the cloud journey, this allows us to facilitate collaboration and transparency, accelerate the journey, and visualize and measure our progress. 12:59 Lois: We’ll stop here for today. Join us next week as we continue our discussion on Oracle Cloud Success Navigator.  Nikita: And if want to look at some demos of everything we touched upon today, head over to mylearn.oracle.com and take a look at the Oracle Cloud Success Navigator Essentials course. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off! 13:22 That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.
    --------  
    13:52
  • Oracle GoldenGate 23ai: Parameters, Data Selection, Filtering, & Transformation
    In the final episode of this series on Oracle GoldenGate 23ai, Lois Houston and Nikita Abraham welcome back Nick Wagner, Senior Director of Product Management for GoldenGate, to discuss how parameters shape data replication. This episode covers parameter files, data selection, filtering, and transformation, providing essential insights for managing GoldenGate deployments.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. --------------------------------------------------------------- Podcast Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let’s get started! 00:25 Lois: Hello and welcome to the Oracle University Podcast! I’m Lois Houston, Director of Innovation Programs with Oracle University, and with me is Nikita Abraham, Team Lead: Editorial Services.  Nikita: Hi everyone! This is the last episode in our Oracle GoldenGate 23ai series. Previously, we looked at how you can manage Extract Trails and Files. If you missed that episode, do go back and give it a listen.  00:50 Lois: Today, Nick Wagner, Senior Director of Product Management for GoldenGate, is back on the podcast to tell us about parameters, data selection, filtering, and transformation. These are key components of GoldenGate because they allow us to control what data is replicated, how it's transformed, and where it's sent. Hi Nick! Thanks for joining us again. So, what are the different types of parameter files? Nick: We have a GLOBALS parameter file and your runtime parameter files. The global one is going to affect all processes within a deployment. It's going to be things like where's your checkpoint table located in name, things like the heartbeat table. You want to have a single one of these across your entire deployment, so it makes sense to keep it within a single file. We also have runtime parameter files. This are going to be associated with a specific extract or replicat process. These files are located in your OGG_ETC_HOME/conf/ogg. The GLOBALS file is just simply named GLOBALS and all capitals, and your parameter file names for the processes themselves are named with the process.prm. So if my extract process is EXT demo, my parameter file name will be extdemo.prm. When you make changes to parameter files, they don't take effect until the process is restarted. So in the case of a GLOBALS parameter file, you need to restart the administration service. And in a runtime parameter file, you need to restart that specific process before any changes will take effect. We also have what we call a managed process setting profile. And this allows you to set up auto restart profiles for each process. And the GoldenGate Gate classic architecture, this was contained within the GLOBALS parameter file and handled by the manager. And microservices is a little bit different, it's handled by the service manager itself. But now we actually set up profiles. 02:41 Nikita: Ok, so what can you tell us about the extract parameter file specifically?  Nick: There's a couple things within the extract parameter file is common use. First, we want to tell what the group name is. So in this case, it would be our extract name. We need to put in information on where the extract process is going to be writing the data it captures to and that would be our trail files, and extract process can write to one or more trail files. We also want to list out the list of tables and schemas that we're going to be capturing, as well as any kind of DDL changes. If we're doing an initial load, we want to set up the SQL predicate to determine which tables are being captured and put a WHERE clause on those to speed up performance. We can also do filtering within the extract process as well. So we write just the information that we need to the trail file. 03:27 Nikita: And what are the common parameters within an extract process? Nick: There are a couple of common parameters within your extract process. We have table to list out the list of tables that GoldenGate is going to be capturing from. These can be wildcarded. So I can simply do table.star and GoldenGate will capture all the tables in that database. I can also do schema.star and it will capture all the tables within a schema. We have our EXTTRAIL command, which tells GoldenGate which trail to write to. If I want to filter out certain rows and columns, I can use the filter cols and cols except parameter. GoldenGate can also capture sequence changes. So we would use the sequence parameter. And then we can also set some high-level database options for GoldenGate that affect all the tables and that's configured using the tranlog options parameter.  04:14 Lois: Nick, can you talk a bit about the different types of tranlogoptions settings? How can they be used to control what the extract process does? Nick: So one of the first ones is ExcludeTag. So GoldenGate has the ability to exclude tagged transactions. Within the database itself, you can actually specify a transaction to be tagged using a DBMS set tag option. GoldenGate replicat also sets its transactions with a tag so that the GoldenGate process knows which transactions were done by the replicat and it can exclude them automatically. You can do exclude tag with a plus. That simply means to exclude any transaction that's been tagged with any value. You can also exclude specific tags.  Another good option for TranLogOptions is enable procedural replication. This allows GoldenGate to actually capture and replicate database procedure calls, and this would be things like DBMS AQ, NQ operations, or DQ operations. So if you're using Oracle advanced queuing and you need GoldenGate to replicate those changes, it can.  Another valuable tranlogoption setting is enable auto capture. Within the Oracle Database, you can actually set ALTER TABLE command that says ALTER TABLE, enable logical replication. Or when you create a table, you can actually do CREATE TABLE statement and at the end use the enable logical replication option for that CREATE TABLE statement. And this tells GoldenGate to automatically capture that table. One of the nice features about this is that I don't need to specify that table and my parameter file, and it'll automatically enable supplemental logging on that table for me using scheduling columns. So it makes it very easy to set up replication between Oracle databases.  06:01 Nikita: Can you tell us about replicat parameters, Nick? Nick: Within a replicat, we'll have the group name, some common other parameters that we'll use is a mapping parameter that allows us to map the source to target table relationships. We can do transformation within the replicat, as well as error handling and controlling group operations to improve performance. Some common replicat parameters include the replicat parameter itself, which tells us what the name of that replicat is. We have our map statement, which allows us to map a source object to a target object. We have things like rep error that control how to handle errors. Insert all records allows us to change and convert, update, and delete operations into inserts. We can do things like compare calls, which helps with active-active replication in determining which columns are used in the GoldenGate WHERE clause. We also have the ability to use macros and column mapping to do additional transformation and make the parameter file look elegant. 07:07 AI is being used in nearly every industry…healthcare, manufacturing, retail, customer service, transportation, agriculture, you name it! And it’s only going to get more prevalent and transformational in the future. It’s no wonder that AI skills are the most sought-after by employers. If you’re ready to dive in to AI, check out the OCI AI Foundations training and certification that’s available for free! It’s the perfect starting point to build your AI knowledge. So, get going! Head on over to mylearn.oracle.com to find out more. 07:47 Nikita: Welcome back! Let’s move on to some of the most interesting topics within GoldenGate… data mapping, selection, and transformation. As I understand, users can do pretty cool things with GoldenGate. So Nick, let’s start with how GoldenGate can manipulate, change, and map data between two different databases. Nick: The map statement within a Replicat parameter allows you to provide specifications on how you're going to map source and target objects. You can also use a map and an extract, but it's pretty rare. And that would be used if you needed to write the object name. Inside the trail files is a different name than the actual object name that you're capturing from. GoldenGate can also do different data selection, mapping, and manipulation, and this is all controlled within the Extract and Replicat parameter files. In the classic architecture of GoldenGate, you could do a rudimentary level of transformation and filtering within the extract pump. Now, the distribution service is only allowing you to do filtering. Any transformation that you had within the pump would need to be moved to the Extract or the Replicat process.  The other thing that you can do within GoldenGate is select and filter data based on different levels and conditions. So within your parameter clause, you have your Table and Map statement. That's the core of everything. You have your filtering. You have COLS and COLSEXCEPT, which allow you to determine which columns you're going to include or exclude from replication. The Table and Map statement works at the table level. The FILTER works at the row level. And COLS and COLSEXCEPTs works at the column level. We also have the ability to filter by operation type too. So GoldenGate has some very easy parameters called GitInserts, GitUpdates, GitDeletes, and conversely ignore updates, ignore deletes, ignore inserts. And that will affect the operation type. 09:40 Lois: Nick, are there any features that GoldenGate provides to make data replication easier? Nick: The first thing is that GoldenGate is going to automatically match your source and target column names with a parameter called USEDEFAULTS. You can specify it inside of your COLMAP clause, but again, it's a default, so you don't need to worry about it. We also handle all data type and character set conversion. Because we store the metadata in the trail, we know what that source data type is like. When we go to apply the record to the target table, the Replicat process is going to look up the definition of that record and keep a repository of that in memory. So that when it knows that, hey, this value coming in from the trail file is going to be of a date data type, and then this value in the target database is going to be a character data type, it knows how to convert that date to a character, and it'll do it for you. Most of the conversion is going to be done automatically for data types. Things where we don't do automatic data type conversion is if you're using abstract data types or user-defined data types, collections arrays, and then some types of CLOB operations. For example, if you're going from a BLOB to a JSON, that's not really going to work very well. Character set conversion is also done automatically. It's not necessarily done directly by GoldenGate, but it's done by the database engine. So there is a character set value inside that source database.  And when GoldenGate goes to apply those changes into the target system, it's ensuring that that character set is visible and named so that that database can do the necessary translation. You can also do advanced filtering transformation. There's tokens that you can attach from the source environment, database, or records into a record itself on the trail file. And then there's also a bunch of metadata that GoldenGate can use to attach to the record itself. And then of course, you can use data transformation within your COLMAP statement. 11:28 Nikita: Before we wrap up, what types of data transformations can we perform, Nick?  Nick: So there's quite a few different data transformations. We can do constructive or destructive transformation, aesthetic, and structural. 11:39 Lois: That’s it for the Oracle GoldenGate 23ai: Fundamentals series. I think we covered a lot of ground this season. Thank you, Nick, for taking us through it all.  Nikita: Yeah, thank you so much, Nick. And if you want to learn more, head over to mylearn.oracle.com and search for the Oracle GoldenGate 23ai: Fundamentals course. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off! 12:04 That’s all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We’d also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.
    --------  
    12:34

Mais podcasts de Ensino

Sobre Oracle University Podcast

Oracle University Podcast delivers convenient, foundational training on popular Oracle technologies such as Oracle Cloud Infrastructure, Java, Autonomous Database, and more to help you jump-start or advance your career in the cloud.
Site de podcast

Ouça Oracle University Podcast, 6 Minute English e muitos outros podcasts de todo o mundo com o aplicativo o radio.net

Obtenha o aplicativo gratuito radio.net

  • Guardar rádios e podcasts favoritos
  • Transmissão via Wi-Fi ou Bluetooth
  • Carplay & Android Audo compatìvel
  • E ainda mais funções

Oracle University Podcast: Podcast do grupo

Aplicações
Social
v7.22.0 | © 2007-2025 radio.de GmbH
Generated: 8/5/2025 - 8:15:20 AM