Oracle Apps R12 Financials Course

Introduction to ERP, Versions in Oracle Apps, Modules in Oracle Application
Oracle Apps R12 Financials Demo Session

Oracle Apps R12 General Ledger

Oracle Apps R12 General Ledger Demo Session
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
Introduction to GL Module, Key Flex Fields, Segments

Oracle R12 Accounts Payable

Oracle Apps R12 Accounts Payable Demo Session
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
Account Payable's Overview, Payable Options, Financial Options

Oracle R12 Accounts Receivable

Oracle Apps R12 Accounts Receivable Demo Session
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
Account Receivables Introduction, Key Flex Fields, Sales Tax Location

Oracle R12 Fixed Assets

Oracle Apps R12 Fixed Assets Demo Session
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
Fixed Assets introduction, Flex Field, System Controls

Oracle R12 Procure to Pay Cycle

Oracle Apps R12 P2P Demo Session
Requisitions, Document Types and RFQ's
Quotations, Purchase Orders
Receipt Creation, Matching Options and Receipt Routing Methods
Invoice and Payment Creation
Purchasing Overview, Financial Option, Overview of Procure to Pay Process

Oracle R12 Cash Management

Oracle Apps R12 Cash Management Demo Session
Creation of New Bank, Creation of New Branch, Creation of Bank Account
Bank Statements and Reconciliation
Forecasting Vs Reconciliation, Bank Charges, Bank Transfer
Oracle R12 Cash Management Introduction, System Parameters

Introduction to Oracle HRMS

Oracle Financials Study Material

Oracle Apps R12 Financials Interview Questions and Answers

How many flex fields are there in Oracle Financials
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
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
What is segment qualifier, Implication of dynamic inserts
What is retained earnings account, What is the purpose of translation adjustment

Oracle Apps R12 Technical Concepts

Introduction to oracle apps technical
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
Definition of ERP, Introduction to Oracle Applications, Types of Data

Oracle Apps R12 Technical Interview Questions and Answers

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
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
What is Apps Schema. Differentiate Apps Schema and other Schemas
Where can you find the release name from backend
P
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
Where can you find the release name from backend

Oracle 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
Introduction to RDBMS, Introduction to SQL

Oracle 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
Introduction to PL/SQL

Oracle D2K Concepts (Oracle Forms and Reports 10g)

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
Oracle D2K | Oracle Forms and Reports Demo Session

Oracle Apps R12 SCM Concepts

Demo Session on Oracle Apps R12 SCM

Oracle Apps R12 SCM (Purchasing Module)

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

Oracle Apps R12 SCM (Inventory Module)

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)
Oracle Apps R12 Inventory Demo Session
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

Oracle Apps R12 SCM (Order Management Module)

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
Oracle Apps R12 Order Management Demo Session

Oracle Apps R12 Manufacturing Concepts

Introduction to Oracle Applications, Versions
Multi Org Structure
Introduction to P2P and O2C Cycles
Introduction to Oracle Apps R12 Manufacturing

Oracle R12 Manufacturing (Bill of Materials 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
Introduction to BOM

Oracle Apps R12 Manufacturing (Oracle Work in Process 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
Introduction to WIP

Oracle Apps R12 HRMS Concepts

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
Demo Session on Oracle Apps R12 HRMS

Oracle Apps R12 HRMS (Core HR)

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
Introduction to Core HR, Oracle HRMS Solutions

Oracle Apps R12 HRMS (Payroll)

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
Oracle Apps R12 Payroll Demo Session

Oracle Apps R12 HRMS (Absence Management)

Understanding the Accrual Plan Structure, Managing Leaves
Administering Accrual Plans, Register Employee with Plans, Accrual Formulas
Introduction to Absence Management, Setting Up Absence Management

Oracle Apps R12 HRMS (SSHR)

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
Oracle Apps R12 SSHR Demo Session
Using SSHR, Common SSHR Functions, Employee Directory

Oracle TCA (Trading Community Architecture)

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
Introduction to TCA

Oracle AIM (Application Implementation Methodology)

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
AIM Introduction

Popular Searches

Oracle Apps R12 Financials Course Online Training

Online

₹ 449 2499

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

What you will learn

The syllabus

Oracle Apps R12 Financials Course

Oracle Apps R12 General Ledger

Oracle R12 Accounts Payable

Oracle R12 Accounts Receivable

Oracle R12 Fixed Assets

Oracle R12 Procure to Pay Cycle

Oracle R12 Cash Management

Introduction to Oracle HRMS

Oracle Financials Study Material

Oracle Apps R12 Financials Interview Questions and Answers

Oracle Apps R12 Technical Concepts

Oracle Apps R12 Technical Interview Questions and Answers

Oracle SQL

Oracle PL/SQL

Oracle D2K Concepts (Oracle Forms and Reports 10g)

Oracle Apps R12 SCM Concepts

Oracle Apps R12 SCM (Purchasing Module)

Oracle Apps R12 SCM (Inventory Module)

Oracle Apps R12 SCM (Order Management Module)

Oracle Apps R12 Manufacturing Concepts

Oracle R12 Manufacturing (Bill of Materials BOM)

Oracle Apps R12 Manufacturing (Oracle Work in Process WIP)

Oracle Apps R12 HRMS Concepts

Oracle Apps R12 HRMS (Core HR)

Oracle Apps R12 HRMS (Payroll)

Oracle Apps R12 HRMS (Absence Management)

Oracle Apps R12 HRMS (SSHR)

Oracle TCA (Trading Community Architecture)

Oracle AIM (Application Implementation Methodology)

Instructors

Articles

Popular Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone