Oracle Apps R12 Financials Course Plus 11 Add On Courses

Oracle Financials Online Training Videos along with 11 Additional Add On Courses (120 Hours)

What you'll learn

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

Requirements

Basic Knowledge on ERP

Description

Oracle Apps R12 Financials Course Online Training Videos along with 11 Additional Add On Courses (120 Hours of Recorded Videos) The Course Bundle Includes 11 Add On Courses1) Oracle Apps R12 Financials CourseFrom this course, you get a clear idea ofIntroduction to ERP, Versions in Oracle Apps, Modules in Oracle Application, What is Implementation Process, General Ledger, Introduction to GL Module, Key Flex Fields, Segments, Design Charts of Accounts, Value Sets, Define Currency and Calendar, 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, Cross Validation Rules, Standard Report (Trail Balance), FSG (Financial Statement Generator), Account Alias, Security Rules, Access Set, Purchasing overview, Financial Option, Overview of Procure to Pay Process, Purchasing Options, Requisitions, Document Types, RFQs, Quotations, Purchase Orders, Receipt Creation, Matching Options and Receipt Routing Methods, Invoice and payment creation, Account Payable's overview, Payable Options, Financial Options, Accounting Periods, Payable System Setups, Payment Terms, Distribution Sets, Defining Suppliers, Standard Invoice, Debit Memo, Credit Memo, Prepayment Invoice, Invoice Created Against PO, Introduction to Expense report, Employee Expense Reports, Withholding Tax Payment, Payment Format, Bank Creations, Bank Account Creation, Bank Branch Creation, overview of multi organization structure, business group setup, Defining Operating units, Defining Inventory organizations, Defining Sub Inventories, Account Receivables Introduction, Key Flex Fields, Sales Tax Location, Territory, Statement Cycle, System Options, Remittance to Address, Payment Terms, Introduction to Dunning Letters, Collectors, Customer Creation, Auto Cash Role Set, Customer Profile Class, Customer Bank Creation, Transaction Types, Invoice Transaction, Credit Memo, Deposit transaction, Bills receivable, Guarantee, Chargeback, transaction Sources, Receipt Classes, Receipt Sources, Creating Invoice, Applying the Receipt to Invoice, Rise the Credit memo, Creating Deposit Invoice and Applying the Deposit to Invoice, Applying the receipt, Miscellaneous Receipts, Remittance Receipts, month ending process, Fixed Assets introduction, Flex Field, System Controls, Financial Year Calendar, Values, Prorate Conversion Calendar, Depreciation Calendar, Book Controls, Depreciation Methods, Asset Categories, Changes, Additions, Create accounting, Asset Transfer, Mass Additions, Retirement, Cash Management, 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, Introduction to HRMS.2) Oracle Apps R12 Financials Q&A CourseFrom this course, you get a clear idea ofHow many flex fields are there in Oracle FinancialsWhat are the benefits of flex fieldsWhat is segment qualifierImplication of dynamic insertsWhat is key flex field qualifierTypes of key flex field qualifiersWhat is short hand aliasesWhat is a period in oracle general ledger and types of periodsWhat is value set security typeWhat are the types of value setsWhat are the cross validating rulesWhat is a value set and value set list typesWhat are the types of flex fieldsDifference between key and descriptive flex fieldsWhat are the essential components of GL primary ledgerWhat are concepts used during definition How many types of conversion rates are there in general ledgerWhat is retained earnings accountWhat is the purpose of translation adjustment accountDifferent statuses of accounting periodsWhat is a adjusting period and its implicationWhat are the steps for creating primary ledgerLedger optionsWhat are the journal typesIntegrating journal entries with general ledger moduleDefine Accounting cycleWhat is accounts payableWhat is the meaning of invoiceP2P cycle flowSample process flow for p2p cyclePay cycleHow many types of purchase orders and agreements are thereDifference between AP invoice and AR invoiceWhat is invoiceTypes of invoiceDifference between standard invoice and mixed invoiceWhat is pre payment in APTypes of AP invoicesDifference between debit memo and credit memoWhat is invoice validation processExplain the receipt routing methodsWhat are the purchasing modes in receivingWhat are the different matching levels, explain themWhat is payment terms and how to define payment termsWhat are the different types of transaction types in receivables 3) Oracle Apps R12 Technical CourseFrom this course you will get a clear idea ofTypes of Roles, Application Object Library, Application Development, Registration of Custom Objects, Interfaces and Conversions, Flex fields, Profiles, Value Sets, Multi-org Concepts, Functional Modules Overview, Reports and Forms in Oracle Applications and development of XML Reports.There are incredible job opportunities for the desired aspirants with highest paid salary range. It will be a great career advantage by taking Oracle Apps Technical Course.4) Oracle Apps R12 Technical Q&A CourseFrom this course you will get a clear idea ofWhat is ERPWhat is Architecture of ERPWhat are the Different Types of API'S for Customer InterfaceWhat are the Parameters in PLSQL Stored ProceduresWhat are the Steps Required for Customizing the FormWhat are the Steps Required for Attaching Report with Oracle ApplicationsWhat is Data LinkIn which Tables the Flexfields are StoredWhat is the Difference Between Key Flexfield and Descriptive FlexfieldWhich Procedure should be called to enable a Descriptive FlexfieldWhat is the Difference between Flexfield Qualifier and Segment QualifierWhere do the Concurrent Request Logfile and Output file goWhat is Apps Schema. Differentiate Apps Schema and other SchemasWhat is the Purpose of US Folder in Appl DirectoryExplain Custom.pll, forms, reports, sql loader, control fileWhen will we use custom.pllHow do you find whether Multiorg is InstalledWhat are the Data HandlersWhat are the Steps for Customizing the Standard Oracle ReportDifference between Bind Parameter and Lexical ParameterHow to find the Report short name for customizing the reportwhat is the structure of visapplHow to migrate the custom tables from 11.5.10 to r12What is the Difference between Conversion and InterfaceHow to register a table and columns through backendExplain the Functions fnd_req, submit_reqWhat are Cursors, where we have to useExplain about the Report triggersWhat is tokenWhat are the Steps Required for Registering the Report into AppsWhat are Security Attributes, ProfilesWhat are the Steps for Developing the FlexfieldsWhat are Profile Options. At what level we setup the profile optionsHow can you know the form(fmb) nameWhat is the Relation between Responsibility, Menu and Request GroupWhat is a Function, Appl_topWhat are the Supported Version of Forms and Reports Used for Developing an Oracle Apps Release 11i/r12What is the responsibility, request group, dffWhat is a Data Group and where we have to useWhat is ResponsibilityWhat is E Business Suite What are Different Types of Responsibilities What is a TemplateWhat is the adhoc reportWhat is Value SetWhat are the Different Validations TypesWhat is Multi Org StructureWhat is the Maximum number of records we can display in one page in xml reports What is Primary LedgerHow can we call standard interface program Where can you find the release name from backendTell me what are the base tables  in AR ModuleWhere do we create tables, sequenceWhere do we create views, procedures and new profile optionsWhat is Formula Column and Summary ColumnTCA (Trading Community Architecture)What is Flex Mode and Confine Mode  What is Place holder ColumnWhat is Apps ArchitectureWhat are the API'sDifference between Application Developer and System AdministratorUse of Triggers in Forms and Types of Triggers  What is TCA (Trading Community Architecture)Difference Between Inbound and Outbound Interfaces  Form PersonalizationWhat is MRC (Multiple Reporting Currency)What are the Different Types of InterfacesWhat is the Difference between Operating Unit and Inventory OrganizationWhat is Item Validation OrganizationWhat is XML Report. Difference between BI Publisher and XMLHow do you Display the Company LogoWhat is a Data TemplateName Some Business Cases in BI ReportsWhat is the Role of Work Flow in Oracle ApplicationsHow We Can Download the Work Flow Files from Oracle Applications without BackendWhat are the Steps Involved in Developing of Oracle Work FlowWhat is Work Flow and Benefit's of Using Work FlowWhat is Performer in Oracle Work FlowWhere do you Register Data and Layout TemplatesWhat does Lexical Section ContainsHow Do You Move Your Layout and Data Template Across Instances5) Oracle Apps R12 SCM CourseFrom this course, you get a clear idea ofProcure to Pay Cycle Overview, Overview of Purchasing Process, Integration with other Oracle Applications, 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, Defining Locations, Inventory Organizations, Establishing Inventory Parameters, Requisition Life cycle, Requisition Structure, Creating and Maintaining, Creation of RFQs and Quotations, Request for Quotation Life cycle, Request for Quotation Life cycle Implementation, Creation of Purchase Orders, Purchase Order Types, Standard Purchase Order Elements, Blanket Purchase Agreements, Contract Purchase, Planned purchase order, Receiving Locations, Receipt Routing, Receipt Processing Methods, Creation of Blanket Purchase Agreement, Creation of Contract Purchase Agreement, Planned Purchase Order, Blind Receiving Transactions, Express Transactions, Unordered Receipts and Cascade transactions, Inventory Overview, Inventory Capabilities, Oracle Inventory Applications Integration, Integration of Oracle Inventory to Financials, Understanding the Receipt to Issue Life cycle, Understanding Receiving Inventory, Defining Inventory Organizations, Understanding the Inventory Organizations, Understanding the Structure of an Inventory Organization, Understanding Locations, Defining Locations, Difference between Master and Child Organization, Units of Measure Overview, Units of Measure Class Overview, Defining Unit of Measure Class, Defining Unit of Measure, Defining Unit of Measure Conversions, Defining and Maintaining Items, Item Attributes and Statuses, Assigning Items to Organizations, Sub inventories, Defining Subinventory, Inventory Controls, Concepts, 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, Subinventory Transfers, Explaining Move Order, Creating Manual Move Order, Creating Requisition Move Order, Requisition Move Order Approval Process, Transact Move Orders with 2 Methods, Miscellaneous Transactions, Restrict Subinventories, Inter-Org Transfer, Shipping Methods, Shipping Network, Transit times for Shipping Methods, Entering inter-org transfer charge, Entering Freight Charges, Direct Inter-Organisation Transfer, Performing Reorder-point Planning, Performing Min-max Planning, Explaining Cycle Counting, Explaining Physical Inventory, Defining and Maintaining a Cycle Count, Defining Cycle Count Scheduling and Requests, Overview of Oracle Order Management, Order to Cash Life cycle Overview, Ordering Process, Inventory Organizations, Define Shipping Parameters, Customer Creation, Auto Cash Role Set, Customer Profile Class, Customer Bank Creation, Transaction Types, Transaction Sources, Creating Invoice, Creating Deposit Invoice and Applying the Deposit to Invoice, Enter Orders, Managing Order, Drop Shipment Implementation, Back to Back Order Implementation, Pick Release Sales Orders, Ship Confirm a Delivery, Define a Pick Slip Grouping Rule, Define a Release Sequence Rules, Order Management Transaction Setups, Defining Order Transaction Type, Defining Line Transaction Type, Defining Document Sequence, Return Material Authorization, Return With Credit No Receipt, Return With Receipt Only, Return With Receipt, Credit Auto Invoice, Internal Sales Order Implementation..6) Oracle Apps R12 Manufacturing CourseFrom this course, you will get a clear idea ofIntroduction to Oracle Apps R12 Manufacturing, Introduction to Oracle Applications, Versions, Multi Org Structure, Introduction to P2P and O2C Cycles, Inventory Overview, Inventory Capabilities, Oracle Inventory Applications Integration, Integration of Oracle Inventory to Financials Applications, Understanding the Receipt to Issue Life cycle, Understanding Receiving Inventory, Defining Inventory Organizations, Understanding the Inventory Organizations, Units of Measure Overview, Units of Measure Class Overview, Defining Unit of Measure Class, Defining Unit of Measure, Defining Unit of Measure Conversions, Defining and Maintaining Items, Item Attributes and Statuses, Assigning Items to Organizations, 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, Subinventory Transfers, Explaining Move Order, Creating Manual Move Order, Creating Requisition Move Order, Requisition Move Order Approval Process, Transact Move Orders with two Methods, Miscellaneous Transactions, Restrict Subinventories, Inter-Org Transfer, Shipping Methods, Shipping Network, Transit times for Shipping Methods, Entering inter-org transfer Charges, Entering Freight Charges, Direct Inter-Organisation Transfer, Performing Reorder-point Planning, Performing Min-max Planning, Explaining Cycle Counting, Explaining Physical Inventory, Defining and Maintaining a Cycle Count, Defining Cycle Count Scheduling and Requests, Introduction about BOM, BOM parameters, Resource Groups, Department Class, 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, Where we use resource in bill, Setup of Alternative bills, Introduction to WIP, WIP Parameters, WIP Accounting Class, Schedule groups, Supply Types, Supply Type Push, Supply Type Operation Pull, Supply Type Assemble Pull, Supply Type Bulk, Supply Type Panthom, OSP.7) Oracle Apps R12 HRMS CourseFrom this course you will get an idea of Oracle R12 HRMS FundamentalsOracle R12 Core HROracle R12 PayrollOracle R12 Absence ManagementOracle R12 SSHR8) Oracle SQL CourseFrom this course you will get a clear idea ofIntroduction 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 9) Oracle PLSQL CourseFrom this course you will get a clear idea ofIntroduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages.10) Oracle D2K (Forms and Reports) CourseFrom this course you will get a clear idea of Forms 10g and Role in Oracle Apps, Fundamentals of D2K, Creation of Data blocks Through wizard and Manually, Creation of Different Types of Canvases and Working with Canvases, Types of windows and working with windows and changing windows properties, Different types of Triggers, Working with Triggers and Applying to Different Controls, Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using 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 Record Groups Based On Query and Using Static Values, Creation of Master-Detail Data Blocks, Parameters, Creation of Menus and attaching menus to Forms, Working with Procedures, Functions and Packages in Forms, Usage of PL/SQL Libraries in Forms and Attached Libraries, Reports 10g, Introduction to Reports, Fundamentals of Reports, Advantages, Features and role of Reports in D2K, Creation of Different types of Reports, Creation of Reports with different Parameters, User Parameters, System Parameters, Working with Formula Columns, Working with Summary Columns, Working with Place Holder Columns, Working with Data links, Developing Reports Manually, Reports in Triggers, Creation of Layout in Reports, Drill Down Reports, Calling Reports from Forms, Calling Reports from Reports.11) Oracle TCA CourseThis Course includes What is TCA, TCA Matters Before and After, TCA Data Model Components, TCA in R12 Includes, TCA in R12 MOAC, TCA in R12 Bank Account Model, TCA in R12 Legal Entities, TCA API's, TCA Tables.12) Oracle AIM CourseThis Course Covers 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

Overview

Section 1: Oracle Apps R12 Financials Course

Lecture 1 Oracle Apps R12 Financials Demo Session

Lecture 2 Introduction to ERP, Versions in Oracle Apps, Modules in Oracle Application

Section 2: Oracle Apps R12 General Ledger

Lecture 3 Oracle Apps R12 General Ledger Demo Session

Lecture 4 Introduction to GL Module, Key Flex Fields, Segments

Lecture 5 Define Currency and Calender

Lecture 6 Define Primary Ledger

Lecture 7 Creation of Journals, Open/Close Periods, Reverse Journals, Journal Batch

Lecture 8 Recurring Journals, Suspense Journals, Statistical Journals

Lecture 9 Mass Allocation

Lecture 10 Budgets

Lecture 11 Inter-company Journals, Journal Approval Process, Tax Journals

Lecture 12 Currency Translation, Reporting Currency, Revaluation

Lecture 13 Consolidation

Lecture 14 Consolidation Session Continued

Lecture 15 Cross Validation Rules, Standard Report (Trail Balance)

Lecture 16 FSG (Financial Statement Generator), Account Alias, Security Rules, Access Set

Section 3: Oracle R12 Accounts Payable

Lecture 17 Oracle Apps R12 Accounts Payable Demo Session

Lecture 18 Account Payable's Overview, Payable Options, Financial Options

Lecture 19 Payable System Setups, Payment Terms, Distribution Sets

Lecture 20 Defining Suppliers, Standard Invoice

Lecture 21 Debit Memo, Credit Memo, Prepayment Invoice

Lecture 22 Invoice Created Against PO, Introduction to Expense Reports

Lecture 23 Employee Expense Reports

Lecture 24 Withholding Tax Payment

Lecture 25 Payment Format, Bank Creations, Bank Account Creation, Bank Branch Creation

Lecture 26 Multi Organization Structure

Lecture 27 Business Group Setup

Lecture 28 Defining Operating Units, Defining Inventory Organizations

Section 4: Oracle R12 Accounts Receivable

Lecture 29 Oracle Apps R12 Accounts Receivable Demo Session

Lecture 30 Account Receivables Introduction, Key Flex Fields, Sales Tax Location

Lecture 31 Customer Creation, Auto Cash Role Set, Customer Profile Class

Lecture 32 Transaction Types, Invoice Transaction, Credit Memo, Deposit transaction

Lecture 33 Receipt Classes, Receipt Sources

Lecture 34 Creating Invoice, Applying the Receipt to Invoice, Raise the Credit memo

Lecture 35 Creating Deposit Invoice and Applying the Deposit to Invoice

Lecture 36 Miscellaneous Receipts, Remittance Receipts

Lecture 37 Month Ending Process

Section 5: Oracle R12 Fixed Assets

Lecture 38 Oracle Apps R12 Fixed Assets Demo Session

Lecture 39 Fixed Assets introduction, Flex Field, System Controls

Lecture 40 Financial Year Calendar, Values, Prorate Conversion Calendar

Lecture 41 Depreciation Methods, Asset Categories, Changes, Additions, Create accounting

Lecture 42 Asset Transfer, Revaluation, Mass Additions, Retirement

Lecture 43 Mass additions and Retirements continued

Section 6: Oracle R12 Procure to Pay Cycle

Lecture 44 Oracle Apps R12 P2P Demo Session

Lecture 45 Purchasing Overview, Financial Option, Overview of Procure to Pay Process

Lecture 46 Requisitions, Document Types and RFQ's

Lecture 47 Quotations, Purchase Orders

Lecture 48 Receipt Creation, Matching Options and Receipt Routing Methods

Lecture 49 Invoice and Payment Creation

Section 7: Oracle R12 Cash Management

Lecture 50 Oracle Apps R12 Cash Management Demo Session

Lecture 51 Oracle R12 Cash Management Introduction, System Parameters

Lecture 52 Creation of New Bank, Creation of New Branch, Creation of Bank Account

Lecture 53 Bank Statements and Reconciliation

Lecture 54 Forecasting Vs Reconciliation, Bank Charges, Bank Transfer

Section 8: Introduction to Oracle HRMS

Lecture 55 Introduction to Oracle HRMS

Section 9: Oracle Financials Study Material

Lecture 56 Oracle Financials Study Material

Section 10: Oracle Apps R12 Financials Interview Questions and Answers

Lecture 57 How many flex fields are there in Oracle Financials

Lecture 58 What is segment qualifier, Implication of dynamic inserts

Lecture 59 What is key flex field qualifier, Types of key flex field qualifiers

Lecture 60 What is short hand aliases, What is a period in oracle general ledger and types

Lecture 61 What is value set security type, What are the types of value sets

Lecture 62 What are the cross validating rules, What is a value set and value set list type

Lecture 63 What are the types of flex fields

Lecture 64 What are the essential components of GL primary ledger

Lecture 65 What are concepts used during definition

Lecture 66 What is retained earnings account, What is the purpose of translation adjustment

Lecture 67 Different statuses of accounting periods

Lecture 68 What are the steps for creating primary ledger, Ledger options

Lecture 69 What are the journal types

Lecture 70 Define Accounting cycle

Lecture 71 What is accounts payable, What is the meaning of invoice

Lecture 72 Sample process flow for p2p cycle, Pay cycle

Lecture 73 What is invoice, Types of invoice

Lecture 74 Types of AP invoices, Difference between debit memo and credit memo

Lecture 75 What is invoice validation process

Section 11: Oracle Apps R12 Technical Concepts

Lecture 76 Introduction to oracle apps technical

Lecture 77 Definition of ERP, Introduction to Oracle Applications, Types of Data

Lecture 78 Functional Consultant and Roles, Technical Consultant and Roles, DBA and Roles

Lecture 79 Oracle Application Architecture, Data Base Structure of Oracle Applications

Lecture 80 System Administration and Application Object Library (AOL)

Lecture 81 FND Tables and Understanding AOL and its Components

Lecture 82 Report Registration Steps, Register the Report in AOL Module

Lecture 83 Defining the Concurrent Program, Creation of Request Group

Lecture 84 Register the Parametric Report in AOL Module, Introduction to Report Parameters

Lecture 85 Developing a Report from Scratch as per Client requirement

Lecture 86 Introduction to Forms, Form registration in Oracle Applications

Lecture 87 Creating Functions in AOL Module, Creation of New Menu

Lecture 88 Introduction to Template.FMB, Appstand.FMB

Lecture 89 Creating of New Template, Creating of New Block, Canvas in Template

Lecture 90 Overview of Flex Fields, Types of Flex Fields

Lecture 91 Steps for Creation of DFF, Flex Field Tables and Relations

Lecture 92 Overview of Profiles Options, Different Levels in Setting Profiles

Lecture 93 Multiple Organization Concepts, Introduction to Multi Org

Lecture 94 Defining Multi Org Structure Continued in this Session

Lecture 95 Multi Org Tables, Overview of Procure to Pay (P2P Cycle)

Lecture 96 Introduction to Interfaces, Difference between Interfaces and Conversions

Lecture 97 Working with Staging Table Scripts, Developing Validations Package

Lecture 98 Introduction to Conversions, Conversion Flow

Lecture 99 Introduction to AIM Documentation, Preparation of AIM Documents

Lecture 100 Introduction to Business Documents, Preparation of MD 50 and MD 70 Documents

Lecture 101 Functional Flows of GL, AP, AR,  Back End Tables

Lecture 102 Introduction of XML Reports, Developing XML Reports

Lecture 103 Steps for Registering the XML Reports in AOL Module, Back End Tables

Section 12: Oracle Apps Technical Study Material

Lecture 104 Oracle Apps Technical Study Material

Section 13: Oracle Apps R12 Technical Interview Questions and Answers

Lecture 105 What is ERP, Architecture of ERP

Lecture 106 What are the Different Types of API'S for Customer Interface

Lecture 107 What are the Steps Required for Customizing the Form

Lecture 108 What is Data Link, In which Tables the Flexfields are Stored

Lecture 109 What is the Difference Between Key Flexfield and Descriptive Flexfield

Lecture 110 What is the Difference between Flexfield Qualifier and Segment Qualifier

Lecture 111 What is Apps Schema. Differentiate Apps Schema and other Schemas

Lecture 112 Explain Custom.pll, forms, reports, sql loader, control file

Lecture 113 How do you find whether Multiorg is Installed, What are the Data Handlers

Lecture 114 What are the Steps for Customizing the Standard Oracle Report

Lecture 115 How to find the Report short name for customizing the report

Lecture 116 How to migrate the custom tables from 11.5.10 to r12

Lecture 117 How to register a table and columns through backend

Lecture 118 What are Cursors, where we have to use

Lecture 119 Explain about the Report triggers, What is token

Lecture 120 What are the Steps Required for Registering the Report into Apps

Lecture 121 What are Security Attributes, Profiles

Lecture 122 What are Profile Options. At what level we setup the profile options

Lecture 123 What is the Relation between Responsibility, Menu and Request Group

Lecture 124 What are the Supported Version of Forms and Reports

Lecture 125 What is a Data Group and where we have to use, What is Responsibility

Lecture 126 What is E Business Suite, What are Different Types of Responsibilities

Lecture 127 What is a Template, What is the adhoc report

Lecture 128 What is Value Set, What are the Different Validations Types

Lecture 129 What is Multi Org Structure

Lecture 130 What is Primary Ledger How can we call standard interface program

Lecture 131 Where can you find the release name from backend

Lecture 132 Where do we create tables, sequence

Lecture 133 What is Formula Column and Summary Column TCA (Trading Community Architecture)

Lecture 134 What is Flex Mode and Confine Mode, What is Place holder Column

Lecture 135 What is Apps Architecture, What are the API's

Lecture 136 Difference between Application Developer and System Administrator

Lecture 137 Use of Triggers in Forms and Types of Triggers, What is TCA (Trading Community

Lecture 138 Difference Between Inbound and Outbound Interfaces, Form Personalization

Lecture 139 What is MRC (Multiple Reporting Currency)

Lecture 140 What is the Difference between Operating Unit and Inventory Organization

Lecture 141 What is XML Report. Difference between BI Publisher and XML

Lecture 142 How do you Display the Company Logo

Lecture 143 What is a Data Template

Lecture 144 Name Some Business Cases in BI Reports

Lecture 145 What is the Role of Work Flow in Oracle Applications

Lecture 146 How We Can Download the Work Flow Files from Oracle Applications without Backend

Lecture 147 What are the Steps Involved in Developing of Oracle Work Flow

Lecture 148 What is Work Flow and Benefit's of Using Work Flow

Lecture 149 What is Performer in Oracle Work Flow

Lecture 150 Where do you Register Data and Layout Templates

Lecture 151 What does Lexical Section Contains

Lecture 152 How Do You Move Your Layout and Data Template Across Instances

Section 14: Oracle SQL

Lecture 153 Introduction to RDBMS, Introduction to SQL

Lecture 154 Oracle data types, Classification of sql

Lecture 155 DDL and DML Commands

Lecture 156 DDL and DML Commands Continued

Lecture 157 Integrity Constraints

Lecture 158 SQL Functions, Character Functions, Number Functions

Lecture 159 SQL Functions Continued, Date Functions, Group Functions

Lecture 160 Joins

Lecture 161 Sub Queries and Clauses

Lecture 162 Database Objects

Lecture 163 Database Objects Continued

Lecture 164 DCL and TCL Commands

Section 15: Oracle PL/SQL

Lecture 165 Introduction to PL/SQL

Lecture 166 Data Types and PL/SQL Blocks

Lecture 167 Looping Structures

Lecture 168 Looping Structure While and Nested Loops

Lecture 169 Looping Structure Continuation

Lecture 170 Conditional Statements

Lecture 171 Cursors

Lecture 172 Exceptions

Lecture 173 Exceptions Continued

Lecture 174 Procedures

Section 16: Oracle D2K Concepts (Oracle Forms and Reports 10g)

Lecture 175 Oracle D2K | Oracle Forms and Reports Demo Session

Lecture 176 Introduction to Forms 10g and Role in Oracle Apps, Fundamentals of D2K

Lecture 177 Creation of Data blocks Through wizard and Manually

Lecture 178 Different types of Triggers Working with Triggers

Lecture 179 Creation of alerts and Calling of Alerts

Lecture 180 Creation of Editors, Types of Editors and Calling editors through Code

Lecture 181 Creating and Using Object Groups, Creating and Using Object Libraries

Lecture 182 Creation of Lov through wizard and Manually, Working with Lov Properties

Lecture 183 Creation of Master-Detail Data Blocks

Lecture 184 parameters

Lecture 185 Creation of Menus and attaching menus to Forms

Lecture 186 Working with Procedures, Functions and Packages in Forms

Lecture 187 Introduction to Reports, Fundamentals of Reports, Advantages, Features and role

Lecture 188 Creation of Different types of Reports Creation of Reports

Lecture 189 Working with Formula Columns, Working with Summary Columns

Lecture 190 Working with Data Links

Lecture 191 Reports in Triggers

Lecture 192 Developing Reports Manually

Lecture 193 Creation of Layout in Reports, Drill Down Reports, Calling Reports from Forms

Section 17: Oracle Apps R12 SCM Concepts

Lecture 194 Demo Session on Oracle Apps R12 SCM

Section 18: Oracle Apps R12 SCM (Purchasing Module)

Lecture 195 Oracle Apps R12 Purchasing Demo Session

Lecture 196 Procure to Pay cycle Overview, Overview of Purchasing Process

Lecture 197 Overview of Suppliers, Supplier Information, Supplier Site Information

Lecture 198 Defining and Maintaining Items, Item Categories Item Attributes

Lecture 199 Enterprise Structure Locations, Organizations, Units of Measure and Items

Lecture 200 Enterprise Structure Locations Session Continued

Lecture 201 Requisition Life cycle, Requisition Structure

Lecture 202 Creation of RFQs and Quotations, Request for Quotation Life cycle

Lecture 203 Creation of Purchase Orders, Purchase Order Types

Lecture 204 Receiving Locations, Receipt Routing, Receipt Processing Methods

Lecture 205 Receiving Locations Session Continued

Lecture 206 Creation of Blanket Purchase Agreement

Lecture 207 Creation of Contract Purchase Agreement

Lecture 208 Planned Purchase Order, Blind Receiving Transactions, Express Transactions

Lecture 209 Unordered Receipts and Cascade Transactions

Section 19: Oracle Apps R12 SCM (Inventory Module)

Lecture 210 Oracle Apps R12 Inventory Demo Session

Lecture 211 Inventory Overview, Inventory Capabilities

Lecture 212 Understanding the Receipt to Issue Life cycle, Understanding Receiving Inventory

Lecture 213 Understanding the Inventory Organizations

Lecture 214 Units of Measure Overview Units of Measure Class Overview

Lecture 215 Defining and Maintaining Items Item Attributes and Statuses

Lecture 216 Inventory Item Categories, Category Codes, item category sets

Lecture 217 Item Relationships and Cross References

Lecture 218 Subinventory Overview, Defining Subinventory

Lecture 219 Inventory Controls, Explaining Lot Control(Item Level)

Lecture 220 Lot Control (Org Level)

Lecture 221 Explaining Serial Control (Item Level)

Lecture 222 Explaining Serial Control (Org Level), Explaining Revision Control

Lecture 223 Explaining Locator Control

Lecture 224 Explaining Locator Control Session Continued

Lecture 225 Subinventory Transfers, Explaining Move Order

Lecture 226 Creating Manual Move Order, Creating Requisition Move Order

Lecture 227 Miscellaneous Transactions, Restrict Subinventories

Lecture 228 Inter-Org Transfer, Shipping Methods, Shipping Network

Lecture 229 Performing Reorder-point Planning, Performing Min-max Planning

Lecture 230 Explaining Cycle Counting, Explaining Physical Inventory

Section 20: Oracle Apps R12 SCM (Order Management Module)

Lecture 231 Oracle Apps R12 Order Management Demo Session

Lecture 232 Overview of Oracle R12 Order Management, Order to Cash Life cycle Overview

Lecture 233 Inventory Organizations, Create a Unit of Measure, Create a Location

Lecture 234 Customer Creation, Auto Cash Role Set, Customer Profile Class

Lecture 235 Transaction Types, Invoice Transaction, Credit Memo, Deposit transaction

Lecture 236 Creating Invoice, Applying the Receipt to Invoice, Raise the Credit memo

Lecture 237 Creating Deposit Invoice and Applying the Deposit to Invoice

Lecture 238 Enter Orders, Create a Sales Order Header, Create a Sales Order Line

Lecture 239 Enter Orders Continued, Create a Sales Order Header, Create a Sales Order Line

Lecture 240 Drop Shipment Implementation

Lecture 241 Back to Back Order Implementation

Lecture 242 Pick Release Sales Orders, Ship Confirm a Delivery, Define a Pick Slip Grouping

Lecture 243 Order Management Transaction Setups, Defining Order Transaction Type

Lecture 244 Return Material Authorization Implementation, Return With Credit No Receipt

Lecture 245 Internal Sales Order Implementation

Section 21: Oracle SCM Study Material

Lecture 246 Oracle SCM Study Materal

Section 22: Oracle Apps R12 Manufacturing Concepts

Lecture 247 Introduction to Oracle Apps R12 Manufacturing

Lecture 248 Introduction to Oracle Applications, Versions

Lecture 249 Multi Org Structure

Lecture 250 Introduction to P2P and O2C Cycles

Section 23: Oracle R12 Manufacturing (Bill of Materials BOM)

Lecture 251 Introduction to BOM

Lecture 252 BOM Parameters

Lecture 253 Resource Groups in BOM

Lecture 254 Department Class and Standard Operation in BOM

Lecture 255 Creation of Items and Assign Cost to Item

Lecture 256 Overheads and Routings

Lecture 257 Define Discrete Jobs

Lecture 258 Define Bills

Lecture 259 Types of Bills

Lecture 260 Option Class Bill and Where we use item in BOM

Lecture 261 Bill Comparison and Where we use the resource in BOM

Lecture 262 Setup of Alternative Bills

Section 24: Oracle Apps R12 Manufacturing (Oracle Work in Process WIP)

Lecture 263 Introduction to WIP

Lecture 264 WIP Parameters

Lecture 265 WIP Accounting Class

Lecture 266 Schedule Groups in WIP

Lecture 267 Supply Types

Lecture 268 Supply Type Push

Lecture 269 Supply Type Operation Pull

Lecture 270 Supply Type Assembly Pull

Lecture 271 Supply Type Bulk

Lecture 272 Supply Type Panthom

Lecture 273 Outside Processing Service (OPS)

Lecture 274 Outside Processing Service (OPS) Continued

Section 25: Oracle Apps R12 HRMS Concepts

Lecture 275 Demo Session on Oracle Apps R12 HRMS

Lecture 276 What Is an ERP, Introduction to Oracle Application

Lecture 277 Understanding Multi-Org Concept in Oracle Application, Understanding Oracle Apps

Lecture 278 Creating Application Users, Functional Security and Application Security

Lecture 279 Creating Custom Menus, Request Groups, Data Groups

Lecture 280 Profile Options in Oracle Applications, Value Sets and Flex fields

Section 26: Oracle Apps R12 HRMS (Core HR)

Lecture 281 Introduction to Core HR, Oracle HRMS Solutions

Lecture 282 Business Processes in Oracle HRMS, Oracle HRMS Information Model

Lecture 283 Creation of Locations and Organizations Overview

Lecture 284 Representing Legal and Government Reporting Structures

Lecture 285 Defining Descriptive Flex fields

Lecture 286 Extra Information Types and Special Information Types and in Oracle HRMS

Lecture 287 Extra Information Types and Special Information Types and in Oracle HRMS continu

Lecture 288 Defining Job, Grade and Position Hierarchy

Section 27: Oracle Apps R12 HRMS (Payroll)

Lecture 289 Oracle Apps R12 Payroll Demo Session

Lecture 290 Introduction to Payroll Processing, Defining Payment Methods

Lecture 291 Defining Payroll Elements, Reductions, Balances

Lecture 292 Employee Creation Element link to Employee Flex Fields

Lecture 293 Define Payroll, Link Payroll to Element Payroll, GL Flex field mapping

Lecture 294 Employee Details Setup, Introduction to Functions, Menus, Fast Formulas

Lecture 295 Creation of Fast Formulas and Payroll Process Run

Section 28: Oracle Apps R12 HRMS (Absence Management)

Lecture 296 Introduction to Absence Management, Setting Up Absence Management

Lecture 297 Understanding the Accrual Plan Structure, Managing Leaves

Lecture 298 Administering Accrual Plans, Register Employee with Plans, Accrual Formulas

Section 29: Oracle Apps R12 HRMS (SSHR)

Lecture 299 Oracle Apps R12 SSHR Demo Session

Lecture 300 Introduction TO SSHR, Functions and Features of SSHR

Lecture 301 Fundamentals of SSHR, Self-Service Basics, User Access and Security

Lecture 302 Configuring SSHR Functions, Menus, and Responsibilities

Lecture 303 Configuring Functions, Configuring Web Page Layouts

Lecture 304 Approvals

Lecture 305 Using SSHR, Common SSHR Functions, Employee Directory

Section 30: Oracle TCA (Trading Community Architecture)

Lecture 306 Introduction to TCA

Lecture 307 TCA Matters Before and After

Lecture 308 TCA Data Model Components

Lecture 309 TCA in R12 Includes

Lecture 310 TCA in R12 MOAC (Multi Org Access Controls)

Lecture 311 TCA in R12 Bank Account Model

Lecture 312 TCA in R12 Legal Entities

Lecture 313 TCA API's

Lecture 314 TCA Tables

Section 31: Oracle AIM (Application Implementation Methodology)

Lecture 315 AIM Introduction

Lecture 316 Project Types

Lecture 317 Types of Server Instances

Lecture 318 Project Phases

Lecture 319 Data Conversion Strategies

Lecture 320 Documents in AIM

Lecture 321 Support Project Process

Lecture 322 Period Close Process

Lecture 323 Issue Priorities and Ticket Statuses

Any Professional with Basic Knowledge on ERP