PeopleSoft Courses

This course serves as a prerequisite for other PeopleSoft HCM application classes and covers the key concepts behind the PeopleSoft HCM Suite. You will learn how to access and search through the PeopleBooks online help, navigate the HCM module, interpret specific HCM PeopleSoft tables, perform basic HCM transactions, and use Process Scheduler as a reporting tool. You will also be introduced to Fluid pages.

This course provides a solid foundation for implementing PeopleSoft Human Capital Management (HCM) for your organization. This course focuses on the flexibility that PeopleSoft HCM has to offer and provides implementation team members with a solid foundation on which to base implementation decisions. Through examples and activities, participants learn about and set up the core HCM foundation tables After setting up these tables, students learn about data permission security, adding workers into the system manually and through the creation of template-based SMART hire. Lastly, they learn to maintain employment history for the workforce.

This course provides a solid foundation for implementing PeopleSoft’s Base Benefits functionality for your organization. Implementation team members examine benefit plans including health (medical, dental, vision), life (group life, supplemental life, dependent life), disability (LTD, STD), savings (401k, profit sharing), leave (vacation, sick, personal), and flexible spending accounts (FSAs). Activities include enrolling employees in benefit plans, setting up dependent and beneficiary data, running the Payroll Interface program to calculate benefit deduction amounts, and creating and retrieving historical benefit data.

This course provides a solid foundation for implementing PeopleSoft’s Base Benefits functionality for your organization. Implementation team members examine benefit plans including health (medical, dental, vision), life (group life, supplemental life, dependent life), disability (LTD, STD), savings (401k, profit sharing), leave (vacation, sick, personal), and flexible spending accounts (FSAs). Activities include enrolling employees in benefit plans, setting up dependent and beneficiary data, running the Payroll Interface program to calculate benefit deduction amounts, and creating and retrieving historical benefit data.

This class helps to understand the purpose of PeopleSoft Time and Labor Describe shifts, work schedules, time reporter data, and time reporting templates. Learn how to create shifts, workdays, schedule templates in Time and Labor, and enroll a time reporter. You will also learn about workgroups as well as static and dynamic groups. You will learn how to define group creation security, create static and dynamic groups, report rapid time, generate Time Card reports, retrieve Absences from Global Payroll, describe and use self-service components, and report time using PeopleSoft Time and Labor. In addition, you will learn how to describe exceptions, adjust payable and paid time for time reporters, approve time, and view payable time summaries, work schedules, shift details, and holiday schedules.

The Payroll for North America US course covers how to use the functionality available in Oracle’s PeopleSoft Enterprise Payroll for North America. Learn how to set up earnings codes, deduction codes, pay groups, holiday schedules, and tax locations. Set up and maintain employee tax data, additional pay, general deductions, and direct deposits. Set up balance IDs, pay calendars, and pay run IDs, and create and update pay sheets automatically, manually, or by rapid entry method. Calculate payroll, review calculation results, identify and correct errors, and confirm payroll. Produce paychecks and generate other payroll reports. In addition to typical on-cycle payroll processing, Payroll for North America provides functionality for a variety of off-cycle payroll events and other payroll requirements. Find out how to reverse a paycheck, record a manual check, produce online checks and final checks, and create a gross up check. Set up and process mid-period job changes and multiple jobs. Set up and process benefits deductions and garnishments. Learn about the employee self-service options available in PeopleSoft Enterprise ePay.

This two-day course is designed to teach you the basics of PeopleSoft Query and introduce you to the commonly used tables within PeopleSoft Human Resource Applications. You will create simple queries, utilize expressions, joins, aggregate features, and calculations, and understand the basics of table structure by the end of this course. All of these concepts will be reinforced by activities.

This course will guide you through the major features of PeopleSoft Manage Profiles and provide you with a conceptual structure on which to base further learning when you return to your business environment. As the instructor leads you through the necessary implementation procedures, you will receive hands-on experience working with the major features, functions, and processes of the system.

This course provides a solid foundation for implementing PeopleSoft’s performance management functionality for your organization. PeopleSoft ePerformance is a self-service performance management application for managers, employees, and Human Resources (HR) administrators. In this course, your implementation team learns how to first configure a performance management system using ePerformance’s template functionality both manually and profile-driven. Then, they create and manage performance documents as employee, manager, and administrator. Lastly, the class learns ePerformance’s reporting and administrative functionality.

With PeopleSoft’s Variable Compensation functionality, you can create and manage multiple bonus incentive plans in a variety of ways to fit your organization’s needs. For each plan you create, you decide whether to administer the plan using groups at the individual level or on an Ad Hoc basis. You can decide what type of plan to set up, define the rules for the plan, and decide how you would like to manage the approvals.

This course provides a solid foundation for implementing PeopleSoft’s base compensation and budgeting functionality for your organization. It gives participants the required information for setting up and administering salary compensations. You will learn how to define salary plans, grades, steps, and salary matrices in greater detail than the foundation table level. Lastly, you will be able to define salary budgets and plan salary increases accordingly and in detail.

In this class students review the framework of the core Global Payroll product, starting with an examination of the overall organizational and processing framework of the system. During the class, students will set up absence entitlement and absence take elements to support PTO, special leave, and study leave. In each lesson, after students set up the basic absence components, they implement different rules of either the entitlement or the take element demonstrating the flexibility of the system. Students also see how absences feed data to the payroll system through generated positive input, and how changes to a payee’s job record causing segmentation can affect how absences are calculated.

The Introduction to PeopleSoft for Financials and SCM course introduces students to concepts used in all PeopleSoft Financial and SCM products. Students will learn how to navigate the PeopleSoft menu structure and how to personalize the display of content. Students are introduced to PeopleSoft table structure and the sharing of data across several tables through tableset sharing. Effective dating and row statuses are also covered in this course. Besides concepts common to most PeopleSoft applications, this course also introduces Financials and SCM-specific topics such as ChartField accounting and PS/nVision reporting. The course also covers high-level integration points between financials and SCM products.

This course teaches the fundamental concepts and features of PeopleSoft General Ledger (GL). Students gain working knowledge of the issues involved in a standard General Ledger implementation. They will learn how to implement GL, as well as establish, process, and report on financial transactions. Through real-life examples and hands-on lab activities, participants will establish their own GL business units and follow their unit through the implementation and processing of data. They will establish common setup options, and enter and post journals to their own ledgers. In addition, they will close year-end books and create financial reports with PS/nVision.

This course discusses the entire PeopleSoft Treasury Management solution. The products discussed are Cash Management, Deal Management, and Risk Management. In addition, banking and bank reconciliation processes are discussed. In this class, you will learn to set up and maintain bank information and processes, and to establish bank account reconciliation methods. You will also learn to create and forecast cash needs and perform cash management duties such as analyzing account fees, creating facilities, transferring funds, defining funds settlement instructions, netting transactions, and managing treasury-specific accounting entries. Finally, you will learn to manage a deals instrument library and create and administer deal accounting. If you would like a 3 day course focusing only on Cash Management try our PSF644 course.

This course is a subset of the PeopleSoft Treasury course. The products discussed are Cash Management, banking, and bank reconciliation. In this class, you will learn to set up and maintain bank information and processes and to establish bank account reconciliation methods. You will also learn to create and forecast cash needs and perform cash management duties such as analyzing account fees, creating facilities, transferring funds, defining funds settlement instructions, netting transactions, and managing treasury-specific accounting entries.

In this course, students are introduced to the entire PeopleSoft Payables process, from setting up system tables to running Payables reports. Students will create their own business units and vendors to use throughout the class. Students will learn the different voucher types and how to copy information into vouchers using purchase orders. This course also introduces students to contract vouchers and recurring vouchers. This course processes vouchers through PayCycle and posting payments. Students learn how to manage data through mass updates and inquiries. Students also learn the basics of Journal Generator and how to send accounting entries to the general ledger. This course also covers how to review accounting entries and other Payables information.

This course guides you through the major features of PeopleSoft Enterprise Receivables and provides you with a conceptual structure on which to base further learning when you return to your own business environment. You are guided through the necessary implementation procedures, and you learn how to efficiently process the transactions that affect customer account balances. Hands-on implementation activities guide you through defining receivables processing controls and entering customer information. In this course you perform standard receivables functions such as entering items and deposits, and applying payments to open items. You learn how to manage item maintenance and update customer history and aging, as well as create collection inquiries and generate statements. Activities also show you how to use the PeopleSoft Enterprise Receivables automatic processes for applying payments, automatically maintaining receivables items, and posting open items.

This course teaches you to use Enterprise Billing to customize, calculate, and submit invoices in multiple currencies and languages. Learn to manage bill cycles and streamline processes, creating a billing system that reflects the way you do business. You will learn to maintain customers, enter bills online, create consolidated and recurring bills, use accumulations, and generate invoices, deferred revenue, and unbilled revenue accrual. In addition, you will learn to create InterUnit customers and bills, manage installment bills, use multiple currencies, and run reports.

This course covers concepts related to the PeopleSoft Expenses application. Upon completion of this course, you will be able to understand the system setup and perform, approve, and process expense transactions.

This advanced level course teaches the fundamental concepts and features of the Grants solution. In this course, participants will perform the steps required to set up the Grants system enabling you to create a proposal, generate an award, manage the award budget, generate invoices, and recognize revenue for the award transactions and any associated facilities and administration costs. Managing cost sharing, awarding advances, and protocols will also be covered in this course. Using workflow, participants will process proposals and protocols through the review and approval process. Through lessons and hands-on activities, participants will learn the necessary skills to implement and process grants in accordance with their business needs.

The Project Costing course covers the features, functions, and processes supported by PeopleSoft Project Costing. Learn how to use project data to support budgeting, staffing, and analysis of project activity. Learn how to allocate transaction costs from the general ledger to projects or between projects. In addition to the functionality provided within the Project Costing application, learn how to set up and execute Project Costing integration with other PeopleSoft Applications to track projects, such as Travel and Expense, Payables, Inventory, and Maintenance Management. Set up and capitalize assets. Learn how to price cost transactions, generate billing transactions, and prepare to integrate with PeopleSoft Contracts.

This course teaches the fundamental concepts and features of the PeopleSoft Contracts application. Participants will learn how to define the rules for creating and maintaining a contract, enabling them to create billing and revenue recognition plans and process associated transactions, generate prepaid associated to contract lines, and manage renewable services.

The PeopleSoft Commitment Control course covers control budget setup and budget management. Learn to budget check source transactions originating from PeopleSoft applications or third-party systems and to report on results. In addition, understand the control budget close process. Gain an understanding of Commitment Control features enabled in PeopleSoft subsystems.

This course will guide you through the major features of PeopleSoft eSettlements and will provide you with a conceptual structure on which to base further learning when you return to your own business environment. You will be guided through the necessary implementation procedures while receiving hands-on experience using major system features and processes.

There is a focus on implementation considerations for PeopleSoft Asset Management throughout this course, along with asset depreciation, asset accounting, and reporting. They learn how to manage both capital and operating leases as well as define and maintain parent-child assets. Integration of Asset Management with other PeopleSoft applications is explored. Through detailed activities, participants learn how to configure the system and process transactions for asset depreciation, allocations, capital acquisition planning and tracking, like-kind exchanges, and tax reporting. You will learn to define your asset management system structure, add assets and perform asset maintenance, process depreciation and period-end close, inquire and report on asset information, integrate asset management with other PeopleSoft applications, and set up and maintain capital acquisition plans.

This two-day course is designed to teach you the basics of PeopleSoft Query and introduce you to the commonly used tables within PeopleSoft Financial Management Applications. You will create simple queries, utilize expressions, joins, aggregate features, and calculations, and understand the basics of table structure by the end of this course. All of these concepts will be reinforced by activities.

This PeopleSoft Inventory training course is an excellent introduction to the features and functions of the PeopleSoft Enterprise Inventory system. Learn how to set up basic options for all of the major features of PeopleSoft Inventory, including, creating inventory item definitions and constructing inventory business units to reflect the structure of your warehouses or other storage locations. You learn the basics of how to setup and use the PeopleSoft Cost Management system to properly record your inventory costs and create accurate accounting entries. This course guides you through the setup and use of all major inventory transactions, including; stocking inventory into your warehouse (putaway), tracking warehouse movement, adjusting stock levels, calculating replenishment quantities, transferring stock between warehouses, and conducting a physical count of stock. This course teaches you how to design the shipping processes of PeopleSoft Inventory (demand fulfillment) to match the physical shipping processes within your organization. Using the fulfillment engine, PeopleSoft Inventory provides every option from express shipment methods to detailed shipping steps used to reserve, pick, pack, and ship stock.

This course will cover several of the basic features and functions of PeopleSoft Enterprise Purchasing. It also covers several advanced features such as, creating and using purchasing contracts and using commitment control in PeopleSoft Enterprise Purchasing. Plus, the key integration points with other PeopleSoft applications are discussed. With the knowledge you gain from taking the course and exercising the extensive amount of activities in the course, you will leave the class having a good overall understanding of the Purchasing application and the other PeopleSoft Enterprise applications that integrate with Purchasing. Then once you are back in your environment you will be able to use this knowledge to begin an implementation of PeopleSoft Enterprise Purchasing.

In this course, you learn about the basic setup required for implementing PeopleSoft eProcurement. This set up includes the business unit, vendors, and purchasing items. You gain knowledge of how the requisition to purchase order process flow is completed. This perspective helps you with implementation decisions on how to set up your system, and also helps you in creating your business process practices. This course also covers direct connect setup, and how the system handles the changes created for requisitions. You learn how approval workflow is utilized with the PeopleSoft eProcurement application. The topics that cover process flows are designed to give you the overall vision of what the product can do for you to aid with your decision-making during implementation.

The PeopleSoft Strategic Sourcing course enables you to develop RFx strategies and documents, including weighted, user-defined, non-price sourcing factors such as warranty, lead time, and defect rate as well as auctions for buying or selling. You will learn how to set up and define purchasing events for named suppliers and the general public to participate, and you will receive a date and time stamp when a response is submitted and create automated proposal tabulation and scoring. You will also create and understand sealed events and the ability to define and perform what-if analysis by adjusting key event parameters, bid factors, weighting, and scores.

Supplier Contract Management provides you with the framework to create and manage the transactional procurement contracts used for executing purchases, as well as providing robust document management authoring capabilities to create and manage the written contract document using Microsoft Word. The system also provides a structured method to develop and manage the contract clause library and the life cycle and approval processing for documents.

PeopleSoft eSupplier Connection is a self-service Web application that features employee (internal) and supplier (external) facing transactions that enable your suppliers to view and modify their own business information at their convenience. Upon completion of this course, you will be able to understand the system setup, supplier/employee transactions, supplier inquiries, and supplier/employee analytics.

This course teaches how the SQR programming language and SQL are used with your PeopleSoft system. SQR is a flexible and powerful programming tool for manipulating data, including the creation of interfaces and generating custom-formatted reports. Hands-on activities give participants practice with every concept covered. Participants write SQR programs that incorporate SQL and programmatic logic to manipulate data and generate reports that are essential to PeopleSoft implementation.

This course teaches participants how to create SQL queries using basic and advanced features of the PeopleSoft Query tool. Students will learn the fundamentals of Query Manager, including how to retrieve information from multiple tables, define criteria, use aggregate functions, and accept data input by users for filtering results. Students will also learn how to create various types of joins, expressions, subqueries, and unions. The hands-on activities in this course are created using real-world examples and data.

PeopleTools I is the prerequisite for all other PeopleTools courses. In this course, participants work with Application Designer to construct web-based Peoplesoft applications, from the database tables to the graphical interface. By the end of this course, participants will be able to create a complete Peoplesoft application using field record definitions, tables, pages and components.

This course takes your PeopleSoft development skills to the next level, covering advanced topics and techniques for more sophisticated applications and customizations. Participants will gain a deeper understanding of how Peoplesoft applications are constructed and customized for specific requirements. Hands-on activities allow the participants to practice and master what they learn.

Accelerated virtual training on PeopleTools I/II. Combining exercises from our PSF140 and PSF141 into one hands on course. PeopleTools I PeopleTools I is the prerequisite for all other PeopleTools courses. In this course, participants work with Application Designer to construct web-based Peoplesoft applications, from the database tables to the graphical interface. By the end of this course, participants will be able to create a complete Peoplesoft application using field record definitions, tables, pages and components. PeopleTools II This course takes your PeopleSoft development skills to the next level, covering advanced topics and techniques for more sophisticated applications and customizations. Participants will gain a deeper understanding of how Peoplesoft applications are constructed and customized for specific requirements. Hands-on activities allow the participants to practice and master what they learn.

The PeopleTools Functional Overview course is designed to teach the functional project team to work more effectively with the technical staff when addressing configuration versus customization discussions. In this course, participants work with Application Designer to examine and modify fields, records, pages and understand the necessity of implementing security with these applications. By the end of this course, participants will be able to understand the eight steps of customization design methodology and provide the necessary skills to complete the analysis to work effectively in a project setting.

This course introduces participants to the various PeopleSoft technologies available for integrating with other PeopleSoft systems and third-party systems. Participants will take an in-depth look at PeopleSoft Integration Broker and practice configuring and administering the Integration Network using the Integration Network WorkCenter. Hands-on activities will allow participants to send and receive asynchronous and synchronous service operations as well as monitor and troubleshoot integrations. The course also covers providing and consuming web services.

After a brief review of the integration network configuration and administration, this course focuses on document technology and Restful web services. Participants will use Document Builder to create document messages and will test sending and receiving document-based service operations. Hands-on activities will allow participants to become familiar with providing and consuming REST services. The course will also cover Component Interfaces. Participants will create, test, and implement component interfaces using PeopleCode. Participants will also use the Excel-to-Component Interface Utility as another method of entering data into the PeopleSoft application.

Contact us for more information.

This course provides participants with essential skills in the use of the PeopleCode programming language, which is used throughout your applications. Participants will learn how to write and modify PeopleCode programs to validate data with custom business rules, maintain the referential integrity of the data in the database, execute SQL commands, and customize the look and feel of PeopleSoft applications dynamically at run-time. This course includes a thorough explanation of object-oriented PeopleCode (objects, properties, and methods), with hands-on activities. We provide a solid grounding in the techniques for traversing the buffer hierarchy (Rowsets, Rows, Records, and Fields).

Approval Framework is delivered as part of Enterprise Components in PeopleSoft Applications being available across multiple product lines. Pre-defined approval processes are provided within each product line. In this course, students will be taught how to configure the approval routings to match the organizational criteria and hierarchy of their own companies.

This course provides participants with essential knowledge of security within a PeopleSoft system. Participants will learn the different aspects of security as well as best practices for implementing and maintaining security in a PeopleSoft database. This course includes a thorough explanation of functional and technical topics including data permission security for PeopleSoft applications.

This course is intended to guide students to gaining an overview understanding of security for PeopleSoft Financials. Students will be taught the basics of application security and reporting security. The course focuses on setting up and maintaining data permission security using the many available options. Those who need more technical details about how to implement LDAP and other security components may want to look at the PeopleSoft PeopleTools Security course.

Overview of security for PeopleSoft HRMS. Students will be taught the basics of application security and reporting security. The course focuses on setting up and maintaining data permission security using the many available options.

This course provides participants with the knowledge and hands-on practice that is essential to successfully use the Application Engine tool. Application Engine is a programming tool that allows technical developers to create programs that incorporate both SQL and PeopleCode to manipulate and maintain the data in your PeopleSoft System. It was developed by PeopleSoft to tie into the definitions that exist in your PeopleTools tables. Through hands-on activities, participants will learn how to write, maintain, and debug Application Engine programs. Participants will also work with File Layout definitions and use PeopleCode in Application Engine programs to import and export data in various formats.

The course covers the development of new PeopleSoft applications that take advantage of the PeopleSoft Fluid User Interface. The Fluid User Interface uses Responsive technology which allows the pages to scale automatically based on the device screen size. In this class, students will create and deploy Fluid pages and components. It is designed for students familiar with PeopleSoft development using the classic interface.

This course provides an introduction to PeopleSoft Campus Solutions for implementation and upgrade teams. Topics include a general introduction to PS Terminology, Basic Concepts, Navigation, Security, Table Structure, and Module Area Overviews including Faculty Center and Student Center. The course will also covers how to view a variety of student information including Bio-demographical information (name, address, e-mail etc.), Program/Plan (Major), Schedule, and Service Indicators (Holds). This course is recommended for project leaders and team leads that will be interfacing with student records within Campus Solutions. The purpose of this course is to provide a context for campus to begin to have cross-functional conversations in Campus Solutions.

PeopleSoft Fluid User Interface in Campus Solutions 9.2 allows users to perform transactions via multiple platforms. In this course, students will learn about Fluid, what it is, what is currently available and how to customize it to fit your needs.

In this course participants complete activities that develop their knowledge of implementing academic structure for PeopleSoft Enterprise Campus Solutions as they revise and update an academic structure through online pages and Tree Manager. Participants learn about the difference between a single and multi-institution setup and how to define and use campus and location values and facilities as they relate to scheduling and facility groupings. Participants learn how to define academic careers as well as academic programs, plans, and sub-plans and look at the rules for defining academic terms and sessions and all related dates and time periods within an academic structure. Discussions abound about how each piece of the academic structure interacts with the others to form an interdependent system of rules and regulations that give business processes the foundation upon which they rely. Through a discussion of dynamic dates, students learn that many term and session dates affect more than one area of PeopleSoft Campus Solutions. Participants look at the association between setting up and organizing PeopleSoft Tree Manager and how security can then be established for specific departmental use of the course catalog, based on this hierarchy.

Participants learn how to set up 3C security for each of the 3Cs and how to manage 3Cs data including how tot use the Communication Generation process and use the PeopleSoft 3C engine. Communications tasks include creating, assigning, updating and verifying communications, and generating letter and email communications. Checklists tasks include creating, assigning, and updating checklists for individuals, organizations, or events. Comments tasks include designing comments, and setting up and creating comment records. This class also covers how to use the 3C engine to automatically assign 3Cs in PeopleSoft Enterprise Campus Solutions.

During the course, the recruiter learns to set up recruiting events and other core admissions setup values. The recruiter interacts with prospects through recruiting events eventually applications and corresponding supporting materials are submitted to PSUNV for admission. Through course lessons and activities, we enter application materials into the system and process test scores. Applicants are admitted and matriculated. The majority of the course centers on the recruiting and entering of prospects, tracking of applicants, and ultimate matriculation. The course also covers localization features for New Zealand, Australia, and the Netherlands.

Participants in this four-day course learn how to prepare for enrollment and how to enroll students. They learn how to set up the course catalog, schedule classes and set up dynamic dating. Participants also learn how to generate class permissions, create enrollment appointments, and add and activate student records. Finally, they learn how to enroll students, including how to resolve error messages and use wait lists.

This course presents the information you need to answer that all-important question: has this student completed his/her degree requirements? You will use your knowledge of an institution’s academic structure, catalog offerings, and your understanding of the institution’s degree requirements to organize and define the academic requirements in Oracle’s PeopleSoft Academic Advisement application. You will explore a number of ways to create rules, from identifying conditions that must be satisfied, to listing courses that can be used to satisfy a requirement, to grouping rules that must be satisfied before a student can graduate, to establishing limits and other restrictions. You will also create ad hoc advisement reports to assist in the advisement process. You will also learn how to make exceptions for a student or groups of students, how to run a what-if scenario, and how to use expanded conditions.

This course covers the processes for maintaining a student’s academic information. Through discussion and activities, participants learn how to maintain program, plan and sub plan data for students. They also learn how to process student withdrawals and cancellations, and award degrees. Participants learn how to generate grade rosters. They learn about the various ways to enter and post grades, and they learn how to assign midterm grades and lapse incomplete grades. Participants also learn how to create transcript types and process transcript requests and enrollment verifications, as well as how to perform end of term activities such as repeat checking, academic standing and honors and awards.

This two day course examines the advantages of using Equation Engine as a method to specify rules or equations as part of your business process. It describes the Equation Engine’s capability to read any table for which you have security access and to perform various arithmetic operations and external call subroutines. During the course, you learn the about the structure of an equation, writes some basic equations, then edit and test a range of equations. The course is designed for functional users with a minimum of 6 months experience using PeopleSoft Campus Solutions and who have an understanding of SQL. It is designed to provide a basic understanding of PeopleSoft Equation Engine and introduce users to the ability to write equations.

This course provides participants with the knowledge and hands-on practice that is essential to successfully use the Application Engine tool. Application Engine is a programming tool that allows technical developers to create programs that incorporate both SQL and PeopleCode to manipulate and maintain the data in your PeopleSoft System. It was developed by PeopleSoft to tie into the definitions that exist in your PeopleTools tables. Through hands-on activities, participants will learn how to write, maintain, and debug Application Engine programs. Participants will also work with File Layout definitions and use PeopleCode in Application Engine programs to import and export data in various formats.

This 2 day course is designed to teach you the basics of PeopleSoft Query and introduce you to the commonly used tables within PeopleSoft Campus Solutions Applications. You will create simple queries, utilize expressions, joins, aggregate feature and calculations and understand the basics of table structure by the end of this course. All of these concepts will be reinforced by activities.

This course is designed for course authors, editors, and others who need to know how to record and edit content in the UPK – User Productivity Kit. Through hands-on exercises, participants will learn how to create courses by adding modules, sections, and topics to the outline. They will learn how to record content in their application, and use the Topic Editor to enhance and/or customize recorded content. After recording and editing topics, participants will preview them in the available playback modes and then publish a complete course. They will explore the various deployment options and then review the Browser-based Player in detail. They will also create knowledge learning paths from published content and assigned users and users groups that can enroll in these knowledge paths. Many reports can be run and created to track knowledge paths data.

This course is an introduction and overview of Dimensional Modeling. The course covers data warehousing, data design, and  dimensional models.

Many DBAs and database implementers are very familiar with a concept known as “normalization”. However, for a data warehouse, which is the type of data that is the most efficient for reporting in tools such as OBIEE, a“denormalized” model is the best solution, and many DBAs and database designers are less familiar with denormalized models, or why they are important in the data warehouse for analysis system. This course will also help DBAs and database implementers to understand these models.

The class is also quite appropriate for those who will be building the OBIEE metadata repository. A knowledge of dimensional modeling and an understanding of how to build an OBIEE repository will be complementary techniques that will play off each other in terms of building a really effective OBIEE system.

Deliver meaningful real-time metrics, measurements and facts to your business users when you master the components in Oracle Business Intelligence Enterprise Edition (OBIEE). Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. This Administration course teaches the attendee how to set up and administer the three layers of an Oracle BI Repository – the Physical layer, the Business layer, and the Presentation layer. Attendees will learn to import schemas, design and build logical business models, and expose business models to users in Oracle BI Answers. Business users, data architects and developers – every member of your
team will contribute to the success of your next BI project.

**This course is appropriate for users of OBIEE 11g or OBIEE 12c.**

Deliver meaningful real-time metrics, measurements and facts to your CEO, CFO, and other business users when you master the components in Oracle Business Intelligence Enterprise Edition (OBIEE). Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. Business users, data architects and developers – every member of your team will contribute to the success of your next BI project. In this course, students use hands-on exercises to learn how to create tables, charts, narratives, pivot tables, and many other content objects available in OBIEE Answers, then learn to use OBIEE Dashboards to display those objects effectively.

**The full 5 day course includes both KPI functionality and Maps 4 day course can include ether Maps or KPI functionality 3 day course does not include Maps and KPI functionality.

In this course, students use hands-on exercises to learn the new features in the 12c version of the Oracle Business Intelligence suite. In addition to enhancements to existing functions such as tables, pivot tables, and charts, students will also be introduced to new features such as Master-Detail linking, Key Performance Indicators, Scorecards, and a variety of other new functionality.

In this class, we will explore several advanced OBIEE topics, many of which require interaction between the criteria columns, results views, and dashboard prompts.

Oracle Visual Analyzer (VA) and its client-based sibling version called Oracle Data Visualizer Desktop (DVD) are components of Oracle’s Business Intelligence product line directed toward users whose interactions with data may be typically characterized as more “ad-hoc” in nature than those users who typically use OBIEE (Oracle Business Intelligence Enterprise Edition). Featuring an interface that is styled after products like Tableau, VA and DVD provide a means of analyzing data quickly, without a lot of ramp-up time for education. In this course, we will explore only the Oracle Visual Analyzer. Our exploration will encompass two broad categories: Data: How do we find (and/or potentially prepare) data that we want to analyze with VA? Presentation: How do we create visualizations of that data?

Oracle BI Publisher is a template-based publishing solution available within the Oracle Business Suite, within PeopleSoft, and also in a  standalone version. Students familiar with desktop tools such as Adobe Acrobat, Microsoft Excel, and Microsoft Word will learn to create and maintain their own reports via the BI Publisher architecture. This class will cover the different options available within the BI Publisher Enterprise reporting portal and how to create a BI Publisher Enterprise online reporting application from scratch.

**This course covers features of BI Publisher Enterprise through release 12c

This course provides participants with the essential skills in using, maintaining, and developing PeopleSoft BI Publisher reports. Through detailed explanations, classroom discussions, and hand-on activities, participants will learn how to register data sources, define report templates, and create report definitions. They will learn how to configure BI Publisher and set up BI Publisher security. This course also includes a thorough explanation of running and deploying BI Publisher reports, and trouble-shooting common BI Publisher errors.

This course is designed to show the common tasks within a BI Applications 11g implementation using Oracle Data Integrator (ODI) and corresponding system components such as OBIEE, Functional Setup Manager, and Configuration Manager. The intended audience for this course ranges from System Administrators to Data Warehouse Architects. Attendees should have experience in Dimensional Modeling and Database design as well as a thorough understanding of SQL.

Note that this course does not include information about Informatica, which was used as the ETL tool for BI Applications in 7.9.6.x, and Oracle does not currently have a migration utility to support this.

The Essbase Administration course is designed to take students through the steps needed to set up and implement Oracle Essbase. Users work with Essbase in an interactive case study over five days that illustrates setting up and maintaining Oracle Essbase.

After a general overview of Essbase, the class focuses on designing applications, databases, outlines and dimensions. Students then learn how to optimize the dimension structure, create dimension build rules files and load data. Data Storage and calculation is also covered followed by a section on Smart View. Next, students create calculation scripts and attribute dimensions. The class wraps up with an overview of the Aggregate Storage Option and additional topics such as shared services.

The Administrator Training for Oracle Hyperion Planning is designed to guide students through the typical steps to build and administer on premises Planning applications. Students develop and deploy Planning as an interactive case study over five days.

After a general overview of Planning and Essbase, the course focuses on creating applications and currencies, followed by sections on data forms and task lists. Smart View is covered extensively including using data forms and creating ad hoc reports. Maintaining Security, managing the approval process, and lifecycle management are then discussed.

Students learn about financial reporting, creating basic reports and building batches and books. The course format consists of lecture plus a great deal of interaction doing exercises and workshops to build a real-world Planning application.

The Oracle Planning and Budgeting Cloud Service (“PBCS”) course is designed to guide students through the steps required to set up and configure the PBCS environment. Students will create and configure metadata and add custom dimensions. Next, they set up member formulas and create smart lists followed by refreshing the application.

Next, students create simple and complex data forms and add validation formulas. They then enter data via the forms and go on to create ad hoc forms and task lists to manage their data forms in a more organized fashion. Students will engage in a series of hand-on exercises to solidify concepts throughout each section so they will be prepared to implement their application.

Setting up and managing security is then introduced followed by a discussion about process management. The next topic brings all the concepts together by investigating the reporting tools. These include Dashboards, Smart View, Financial Reporting Studio and Reporting Web Studio where students create dashboards, reports and charts to analyze data.

Finally, Data Management is covered and the students set up a import format file, review mapping tables, and finally load a data file into the PBCS application.

This class begins with an orientation to the EPBCS environment and provides a brief overview of the Financials, Workforce, Projects and Capex business processes that make up its framework.  We then review the built-in functionality, configuration wizards, and Oracle Planning leading practice concepts such as incremental enablement, upgradable while maintaining configurability, and user empowerment.

More granularly, the class then covers how to set up and configure the EPBCS environment, create and configure your base financials workflow metadata, and set up basic member formulas.  We then address how to set up security, create forms, set up and manage the approval process, and load and analyze data.  Students will engage in a series of hand-on exercises to solidify concepts throughout each section so they will be prepared to implement their application.

The class then focuses on Smart View, Financial Reporting Studio and Reporting Web Studio.  Students will build ad hoc reports, work further with data forms, and learn how to enter data and manage metadata using Smart View.

In this course, Report Developers and Power Users learn how to create and manage reports using Oracle Hyperion Financial Reporting Studio 11.1.2.4.x. Using Planning as the data source, students create basic reports and then add advanced member selections and report objects.

They go on to create more advanced reports and then create books, and batches. As part of the process, students also learn how to format reports, customize grids, and add auto calculations and mathematical functions to enhance their reports and books.

The Hyperion Smart View course is designed to take users through the steps required to access and analyze data using Smart View. Working with Smart View in an interactive case study, Planning and Essbase users learn how to enter data into grids, work with task lists, manage the Planning approval process, take data forms offline, and use ad hoc tools to analyze Planning data.

HFM users learn how to query, consolidate, and analyze data from Financial Management applications followed by creating ad hoc queries, free-form grids, and advanced reports. Essbase only users learn to query, analyze, and share data stored in Essbase databases. Users connect to data sources and create ad hoc queries and free-form grids.

Then, by embedding dynamic data points into Microsoft Word, all users will bring their data into documents and learn how to import Workspace content into Microsoft Excel, Word, and PowerPoint.

The Administration Training for Oracle Hyperion Financial Management (HFM) is designed to guide students through the typical steps required to build and administer HFM. Students will develop and deploy HFM as an interactive case study that illustrates how to build a classic application and then convert it to EPM, thus addressing pertinent issues for both the administrator who is upgrading, and the new implementer.

After a general overview of HFM and EPM Architecture, the course focuses on creating applications and metadata. Fundamental metadata management techniques are introduced. Students then set up the HFM dimensions. Hands-on workshops include defining applications and dimensions, maintaining alternate hierarchies, attributes, and importing/exporting data using data files, forms and grids.

Designing and creating basic rules is then taught along with security. Currency translation, intercompany reporting, process control, member and task lists are also addressed. Finally, building reports using Smart View and Hyperion Financial Reports is taught using the interactive case study. The course format consists of lecture plus exercises and workshops.

Power Users are staff that use Oracle Hyperion Financial Management (HFM) nearly every day to enter, manipulate and/or analyze data, and to create or modify reports. They may even have limited administrative responsibilities.

This course provides Power Users a comprehensive and interactive experience with HFM. After an HFM overview, users learn to load and manipulate data using data files, data forms and data grids.

The next section focuses on journals and the consolidation process. Finally, Power Users will learn to analyze data using Smart View and Reports.

In this course, Report Developers and Power Users learn how to create and manage reports using Financial Reporting. Using Planning as the data source, users create reports, report objects, books, and batches. Topics such as formatting reports, customizing grids, and adding auto calculations and functions are also covered.

The Creating Rules Using Calculation Manager Oracle Hyperion Financial Management (HFM) course is designed to guide seasoned HFM Administrators and Power Users through an in-depth and practical approach to building new rules, from the basic to the advanced, and to understanding and enhancing current rule sets within applications.

Starting with a rules introduction, students will extract, backup and perform basic rules editing from within an existing application. Once these basic concepts are understood, the student will learn specific techniques for rules creation, such as utilizing Member Lists, dynamic rules creation, and utilizing variables.

The student will then be introduced to advanced rules writing techniques. Topics such as Beginning Retained Earnings roll forward, transferring Current Net Income to the Balance Sheet, Translation – dollar override, forecasting, and ratios. After completing these topics, the student will work through an in depth case study enabling them to apply their newly acquired skills to developing a basic cash flow.

This course is very intense and not intended for the new HFM user or Administrator.

The Financial Data Quality Management Enterprise Edition (FDMEE) course is designed to take users who are new to FDMEE through the steps needed to implement and support Oracle Financial Data Quality Management Enterprise Edition. Users work with FDMEE in an interactive case study that illustrates loading source data from disparate systems into target analytical applications.

After a general overview of FDMEE, the class focuses on defining system, application and user profiles, performing integration tasks, and creating import formats. Users then set up locations, and add period, category and data load mappings. Then, users define data load rules and load data to target applications. Next, security is added to the integration model. Once users validate loaded target system data through check rules and check entities, batch processing and reports are covered. Creating mapping and event scripts are discussed. Lastly, users learn FDMEE integration with other source systems.