IIRF Online > Office Productivity > Oracle > Oracle E-Business Suite > Oracle Apps R12 Financials Course Plus 11 Add On Courses
Oracle Apps R12 Financials Course Plus 11 Add On Courses by Udemy
Oracle Financials Online Training Videos along with 11 Additional Add On Courses (120 Hours)
Course Highlights
- Oracle Apps R12 Financials Course, Financials Interview Q&A Course
- Oracle Apps R12 Technical Course, Technical Interview Q&A Course
- Oracle Apps R12 SCM Course
- Oracle Apps R12 Manufacturing Course
- Oracle Apps R12 HRMS Course
- Oracle SQL Course, Oracle PLSQL Course
- Oracle TCA Course
- Oracle AIM Course
Skills you will learn!
Curriculum
2 Topics
Oracle Apps R12 Financials Demo Session
Introduction to ERP Versions in Oracle Apps Modules in Oracle Application
14 Topics
Oracle Apps R12 General Ledger Demo Session
Introduction to GL Module Key Flex Fields Segments
Define Currency and Calender
Define Primary Ledger
Creation of Journals Open/Close Periods Reverse Journals Journal Batch
Recurring Journals Suspense Journals Statistical Journals
Mass Allocation
Budgets
Inter-company Journals Journal Approval Process Tax Journals
Currency Translation Reporting Currency Revaluation
Consolidation
Consolidation Session Continued
Cross Validation Rules Standard Report (Trail Balance)
FSG (Financial Statement Generator) Account Alias Security Rules Access Set
12 Topics
Oracle Apps R12 Accounts Payable Demo Session
Account Payable's Overview Payable Options Financial Options
Payable System Setups Payment Terms Distribution Sets
Defining Suppliers Standard Invoice
Debit Memo Credit Memo Prepayment Invoice
Invoice Created Against PO Introduction to Expense Reports
Employee Expense Reports
Withholding Tax Payment
Payment Format Bank Creations Bank Account Creation Bank Branch Creation
Multi Organization Structure
Business Group Setup
Defining Operating Units Defining Inventory Organizations
9 Topics
Oracle Apps R12 Accounts Receivable Demo Session
Account Receivables Introduction Key Flex Fields Sales Tax Location
Customer Creation Auto Cash Role Set Customer Profile Class
Transaction Types Invoice Transaction Credit Memo Deposit transaction
Receipt Classes Receipt Sources
Creating Invoice Applying the Receipt to Invoice Raise the Credit memo
Creating Deposit Invoice and Applying the Deposit to Invoice
Miscellaneous Receipts Remittance Receipts
Month Ending Process
6 Topics
Oracle Apps R12 Fixed Assets Demo Session
Fixed Assets introduction Flex Field System Controls
Financial Year Calendar Values Prorate Conversion Calendar
Depreciation Methods Asset Categories Changes Additions Create accounting
Asset Transfer Revaluation Mass Additions Retirement
Mass additions and Retirements continued
6 Topics
Oracle Apps R12 P2P Demo Session
Purchasing Overview Financial Option Overview of Procure to Pay Process
Requisitions Document Types and RFQ's
Quotations Purchase Orders
Receipt Creation Matching Options and Receipt Routing Methods
Invoice and Payment Creation
5 Topics
Oracle Apps R12 Cash Management Demo Session
Oracle R12 Cash Management Introduction System Parameters
Creation of New Bank Creation of New Branch Creation of Bank Account
Bank Statements and Reconciliation
Forecasting Vs Reconciliation Bank Charges Bank Transfer
1 Topic
Introduction to Oracle HRMS
1 Topic
Oracle Financials Study Material
19 Topics
How many flex fields are there in Oracle Financials
What is segment qualifier Implication of dynamic inserts
What is key flex field qualifier Types of key flex field qualifiers
What is short hand aliases What is a period in oracle general ledger and types
What is value set security type What are the types of value sets
What are the cross validating rules What is a value set and value set list type
What are the types of flex fields
What are the essential components of GL primary ledger
What are concepts used during definition
What is retained earnings account What is the purpose of translation adjustment
Different statuses of accounting periods
What are the steps for creating primary ledger Ledger options
What are the journal types
Define Accounting cycle
What is accounts payable What is the meaning of invoice
Sample process flow for p2p cycle Pay cycle
What is invoice Types of invoice
Types of AP invoices Difference between debit memo and credit memo
What is invoice validation process
28 Topics
Introduction to oracle apps technical
Definition of ERP Introduction to Oracle Applications Types of Data
Functional Consultant and Roles Technical Consultant and Roles DBA and Roles
Oracle Application Architecture Data Base Structure of Oracle Applications
System Administration and Application Object Library (AOL)
FND Tables and Understanding AOL and its Components
Report Registration Steps Register the Report in AOL Module
Defining the Concurrent Program Creation of Request Group
Register the Parametric Report in AOL Module Introduction to Report Parameters
Developing a Report from Scratch as per Client requirement
Introduction to Forms Form registration in Oracle Applications
Creating Functions in AOL Module Creation of New Menu
Introduction to Template.FMB Appstand.FMB
Creating of New Template Creating of New Block Canvas in Template
Overview of Flex Fields Types of Flex Fields
Steps for Creation of DFF Flex Field Tables and Relations
Overview of Profiles Options Different Levels in Setting Profiles
Multiple Organization Concepts Introduction to Multi Org
Defining Multi Org Structure Continued in this Session
Multi Org Tables Overview of Procure to Pay (P2P Cycle)
Introduction to Interfaces Difference between Interfaces and Conversions
Working with Staging Table Scripts Developing Validations Package
Introduction to Conversions Conversion Flow
Introduction to AIM Documentation Preparation of AIM Documents
Introduction to Business Documents Preparation of MD 50 and MD 70 Documents
Functional Flows of GL AP AR Back End Tables
Introduction of XML Reports Developing XML Reports
Steps for Registering the XML Reports in AOL Module Back End Tables
1 Topic
Oracle Apps Technical Study Material
48 Topics
What is ERP Architecture of ERP
What are the Different Types of API'S for Customer Interface
What are the Steps Required for Customizing the Form
What is Data Link In which Tables the Flexfields are Stored
What is the Difference Between Key Flexfield and Descriptive Flexfield
What is the Difference between Flexfield Qualifier and Segment Qualifier
What is Apps Schema. Differentiate Apps Schema and other Schemas
Explain Custom.pll forms reports sql loader control file
How do you find whether Multiorg is Installed What are the Data Handlers
What are the Steps for Customizing the Standard Oracle Report
How to find the Report short name for customizing the report
How to migrate the custom tables from 11.5.10 to r12
How to register a table and columns through backend
What are Cursors where we have to use
Explain about the Report triggers What is token
What are the Steps Required for Registering the Report into Apps
What are Security Attributes Profiles
What are Profile Options. At what level we setup the profile options
What is the Relation between Responsibility Menu and Request Group
What are the Supported Version of Forms and Reports
What is a Data Group and where we have to use What is Responsibility
What is E Business Suite What are Different Types of Responsibilities
What is a Template What is the adhoc report
What is Value Set What are the Different Validations Types
What is Multi Org Structure
What is Primary Ledger How can we call standard interface program
Where can you find the release name from backend
Where do we create tables sequence
What is Formula Column and Summary Column TCA (Trading Community Architecture)
What is Flex Mode and Confine Mode What is Place holder Column
What is Apps Architecture What are the API's
Difference between Application Developer and System Administrator
Use of Triggers in Forms and Types of Triggers What is TCA (Trading Community
Difference Between Inbound and Outbound Interfaces Form Personalization
What is MRC (Multiple Reporting Currency)
What is the Difference between Operating Unit and Inventory Organization
What is XML Report. Difference between BI Publisher and XML
How do you Display the Company Logo
What is a Data Template
Name Some Business Cases in BI Reports
What is the Role of Work Flow in Oracle Applications
How We Can Download the Work Flow Files from Oracle Applications without Backend
What are the Steps Involved in Developing of Oracle Work Flow
What is Work Flow and Benefit's of Using Work Flow
What is Performer in Oracle Work Flow
Where do you Register Data and Layout Templates
What does Lexical Section Contains
How Do You Move Your Layout and Data Template Across Instances
12 Topics
Introduction to RDBMS Introduction to SQL
Oracle data types Classification of sql
DDL and DML Commands
DDL and DML Commands Continued
Integrity Constraints
SQL Functions Character Functions Number Functions
SQL Functions Continued Date Functions Group Functions
Joins
Sub Queries and Clauses
Database Objects
Database Objects Continued
DCL and TCL Commands
10 Topics
Introduction to PL/SQL
Data Types and PL/SQL Blocks
Looping Structures
Looping Structure While and Nested Loops
Looping Structure Continuation
Conditional Statements
Cursors
Exceptions
Exceptions Continued
Procedures
19 Topics
Oracle D2K | Oracle Forms and Reports Demo Session
Introduction to Forms 10g and Role in Oracle Apps Fundamentals of D2K
Creation of Data blocks Through wizard and Manually
Different types of Triggers Working with Triggers
Creation of alerts and Calling of Alerts
Creation of Editors Types of Editors and Calling editors through Code
Creating and Using Object Groups Creating and Using Object Libraries
Creation of Lov through wizard and Manually Working with Lov Properties
Creation of Master-Detail Data Blocks
parameters
Creation of Menus and attaching menus to Forms
Working with Procedures Functions and Packages in Forms
Introduction to Reports Fundamentals of Reports Advantages Features and role
Creation of Different types of Reports Creation of Reports
Working with Formula Columns Working with Summary Columns
Working with Data Links
Reports in Triggers
Developing Reports Manually
Creation of Layout in Reports Drill Down Reports Calling Reports from Forms
1 Topic
Demo Session on Oracle Apps R12 SCM
15 Topics
Oracle Apps R12 Purchasing Demo Session
Procure to Pay cycle Overview Overview of Purchasing Process
Overview of Suppliers Supplier Information Supplier Site Information
Defining and Maintaining Items Item Categories Item Attributes
Enterprise Structure Locations Organizations Units of Measure and Items
Enterprise Structure Locations Session Continued
Requisition Life cycle Requisition Structure
Creation of RFQs and Quotations Request for Quotation Life cycle
Creation of Purchase Orders Purchase Order Types
Receiving Locations Receipt Routing Receipt Processing Methods
Receiving Locations Session Continued
Creation of Blanket Purchase Agreement
Creation of Contract Purchase Agreement
Planned Purchase Order Blind Receiving Transactions Express Transactions
Unordered Receipts and Cascade Transactions
21 Topics
Oracle Apps R12 Inventory Demo Session
Inventory Overview Inventory Capabilities
Understanding the Receipt to Issue Life cycle Understanding Receiving Inventory
Understanding the Inventory Organizations
Units of Measure Overview Units of Measure Class Overview
Defining and Maintaining Items Item Attributes and Statuses
Inventory Item Categories Category Codes item category sets
Item Relationships and Cross References
Subinventory Overview Defining Subinventory
Inventory Controls Explaining Lot Control(Item Level)
Lot Control (Org Level)
Explaining Serial Control (Item Level)
Explaining Serial Control (Org Level) Explaining Revision Control
Explaining Locator Control
Explaining Locator Control Session Continued
Subinventory Transfers Explaining Move Order
Creating Manual Move Order Creating Requisition Move Order
Miscellaneous Transactions Restrict Subinventories
Inter-Org Transfer Shipping Methods Shipping Network
Performing Reorder-point Planning Performing Min-max Planning
Explaining Cycle Counting Explaining Physical Inventory
15 Topics
Oracle Apps R12 Order Management Demo Session
Overview of Oracle R12 Order Management Order to Cash Life cycle Overview
Inventory Organizations Create a Unit of Measure Create a Location
Customer Creation Auto Cash Role Set Customer Profile Class
Transaction Types Invoice Transaction Credit Memo Deposit transaction
Creating Invoice Applying the Receipt to Invoice Raise the Credit memo
Creating Deposit Invoice and Applying the Deposit to Invoice
Enter Orders Create a Sales Order Header Create a Sales Order Line
Enter Orders Continued Create a Sales Order Header Create a Sales Order Line
Drop Shipment Implementation
Back to Back Order Implementation
Pick Release Sales Orders Ship Confirm a Delivery Define a Pick Slip Grouping
Order Management Transaction Setups Defining Order Transaction Type
Return Material Authorization Implementation Return With Credit No Receipt
Internal Sales Order Implementation
1 Topic
Oracle SCM Study Materal
4 Topics
Introduction to Oracle Apps R12 Manufacturing
Introduction to Oracle Applications Versions
Multi Org Structure
Introduction to P2P and O2C Cycles
12 Topics
Introduction to BOM
BOM Parameters
Resource Groups in BOM
Department Class and Standard Operation in BOM
Creation of Items and Assign Cost to Item
Overheads and Routings
Define Discrete Jobs
Define Bills
Types of Bills
Option Class Bill and Where we use item in BOM
Bill Comparison and Where we use the resource in BOM
Setup of Alternative Bills
12 Topics
Introduction to WIP
WIP Parameters
WIP Accounting Class
Schedule Groups in WIP
Supply Types
Supply Type Push
Supply Type Operation Pull
Supply Type Assembly Pull
Supply Type Bulk
Supply Type Panthom
Outside Processing Service (OPS)
Outside Processing Service (OPS) Continued
6 Topics
Demo Session on Oracle Apps R12 HRMS
What Is an ERP Introduction to Oracle Application
Understanding Multi-Org Concept in Oracle Application Understanding Oracle Apps
Creating Application Users Functional Security and Application Security
Creating Custom Menus Request Groups Data Groups
Profile Options in Oracle Applications Value Sets and Flex fields
8 Topics
Introduction to Core HR Oracle HRMS Solutions
Business Processes in Oracle HRMS Oracle HRMS Information Model
Creation of Locations and Organizations Overview
Representing Legal and Government Reporting Structures
Defining Descriptive Flex fields
Extra Information Types and Special Information Types and in Oracle HRMS
Extra Information Types and Special Information Types and in Oracle HRMS continu
Defining Job Grade and Position Hierarchy
7 Topics
Oracle Apps R12 Payroll Demo Session
Introduction to Payroll Processing Defining Payment Methods
Defining Payroll Elements Reductions Balances
Employee Creation Element link to Employee Flex Fields
Define Payroll Link Payroll to Element Payroll GL Flex field mapping
Employee Details Setup Introduction to Functions Menus Fast Formulas
Creation of Fast Formulas and Payroll Process Run
3 Topics
Introduction to Absence Management Setting Up Absence Management
Understanding the Accrual Plan Structure Managing Leaves
Administering Accrual Plans Register Employee with Plans Accrual Formulas
7 Topics
Oracle Apps R12 SSHR Demo Session
Introduction TO SSHR Functions and Features of SSHR
Fundamentals of SSHR Self-Service Basics User Access and Security
Configuring SSHR Functions Menus and Responsibilities
Configuring Functions Configuring Web Page Layouts
Approvals
Using SSHR Common SSHR Functions Employee Directory
9 Topics
Introduction to TCA
TCA Matters Before and After
TCA Data Model Components
TCA in R12 Includes
TCA in R12 MOAC (Multi Org Access Controls)
TCA in R12 Bank Account Model
TCA in R12 Legal Entities
TCA API's
TCA Tables
9 Topics
AIM Introduction
Project Types
Types of Server Instances
Project Phases
Data Conversion Strategies
Documents in AIM
Support Project Process
Period Close Process
Issue Priorities and Ticket Statuses
Oracle Apps R12 Financials Course Plus 11 Add On Courses
Related Oracle E-Business Suite Courses
Thank You!
Your review has been submitted successfully.