Archives

now browsing by author

 

Oracle Apps SCM Functional Videos

Oracle Apps SCM Training Videos

We Provide Oracle Apps SCM Self Paced Videos along with 3 Months R12 Remote Access for Practice.

Oracle Apps SCM Self Paced Videos – 35 Sessions Videos of 22+ Hours of Recordings with 3 Months R12 Remote Access for your Practice, Cost – 15,000 INR

Please Contact sridevikoduru@oracleappstechnical.com | training@oracleappstechnical.com | +91 9581017828

Oracle Apps Financial Functional Videos

Oracle Apps R12 Financial Functional Tutorial

We Provide Oracle Apps Financials Self Paced Videos along with 3 Months R12 Remote Access for Practice.

Oracle Apps Financials Self Paced Videos – 33 Sessions Videos of 20+ Hours of Recordings with 3 Months R12 Remote Access for your Practice, Cost – 12,500 INR

Please Contact sridevikoduru@oracleappstechnical.com | training@oracleappstechnical.com | +91 9581017828

Oracle Apps Technical Training Videos

Oracle Apps Technical Training Tutorial Videos

We Provide Oracle Apps Technical Self Paced Videos along with 3 Months R12 Remote Access for Practice.

Oracle Apps Technical Self Paced Videos – 24 Sessions Videos of 16+ Hours of Recordings with 3 Months R12 Remote Access for your Practice, Cost – 12,500 INR

Please Contact sridevikoduru@oracleappstechnical.com | training@oracleappstechnical.com | +91 9581017828

Oracle Apps Technical Online Training (One to one)

Oracle Apps Technical Online Training Details (One to One)

Duration : 25 Sessions

Each Session Duration : 1 HR

Oracle Apps Technical Online training Course Content

Introduction To ERP

• Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
• Using TOAD

Types Of Roles

• Functional Consultant and Roles
• Technical Consultant and Roles
• Techno-Functional Consultant and Roles
• Oracle Application DBA and Roles

Application Object Library

• System Administration and Application Object Library (AOL)
• Defining an Applications User and Assigning the Responsibilities.
• Understanding AOL and its Components
• WHO columns
• Creating Responsibilities
• Request group creation
• Menu Creation

Application Development

• Defining concurrent program
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets

Registration Of Custom Objects

• Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL

Interfaces and Conversions

• Introduction to Interfaces
• Difference Between Interfaces and Conversions
• Outbound Interfaces
o Using UTL_FILE package
• Inbound Interfaces
o Using SQL * Loader tool
• SQL * Loader Concepts o Data File.
o Control File.
o Bad File.
o Discard File.
o Log File.
• Working with staging table script
• Developing validations package
• Standards to be followed in conversions
• Using oracle API’s in Interfaces and Conversions
• Interface Tables and Error Tables

Flex Fields

• Overview of flex fields
• Types of Flex Fields
o Descriptive Flex Fields
o Key Flex Fields
• Step in creation of DFF
• Flex fields tables and relations

Profiles

• Overview of profile options
• Different levels in Setting profiles
• Steps in setting a profile option
• Some important profile options
• Some important API’s of profiles

Value Sets

• Overview of value sets
• Options in value sets
• Types of value sets
• Creation of value set
• Overview of value set tables
• Usage of $FLEX and $PROFILE

Multi Org Concepts

• What is Multi Org and why we need.
• Multi Org Tables.
• Multi Org Views.

Functional Modules Overview

• Overview of Procure to Pay Flow (P2P Cycle)
• Overview of Order to Cash Flow (O2C Cycle)
• Major setups and transactions
• Overview of important tables in PO,INV,OM,AP,AP,GL

Reports In Oracle Applications

• Introduction and Usage of USER_EXITS.
• Developing a Report from scratch as per Client Requirement.
• Developing a Report based on MD 50 Document.
• Customization of Oracle Standard Reports.
• Reports Registration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps

Forms In Oracle Applications

• New Form Development Process
• Form Registration in Oracle Applications.
• Calling one Form to another Form by using Button
• Master-Detailed Forms
• Form Personalization in Oracle Applications
• Form Personalization v/s Form Customization

Development Of XML Reports

FAQS In Oracle Apps Technical

For Better Understanding of Your Oracle Apps Technical Training Sessions We have Furnished the Training Contents as Session by Session

Session 1

• Definition of ERP
• Introduction to Oracle Applications
• Types of Data

Session 2

• Functional Consultant and Roles
• Technical Consultant and Roles
• DBA and Roles
• Types of Projects

Session 3

• Oracle Application Architecture
• Data Base Structure of Oracle Applications
• Introduction to Rice Components

Session 4

• System Administration and Application Object Library (AOL)
• Defining Application Users and Assigning the Responsibilities.
• Creating Responsibilities
• FND Tables and Understanding AOL and its Components

Session 5

• Registration of Tables
• Using AD_DD Package
• Procedures to Register Database Tables in AOL Module

Session 6

• Report Registration Steps
• Register the Report in AOL Module
• Executable Creation of Reports
• Defining the Concurrent Program
• Creation of Request Group

Session 7

• Register the Parametric Report in AOL Module
• Introduction to Report Parameters
• Types of Parameters
• Creating Value Sets
• Value Set Default Types

Session 8

• Developing a Report from Scratch as per Client requirement
• Default Report Styles
• Customization of Oracle Standard Reports

Session 9

• Introduction to Forms
• Form registration in Oracle Applications

Session 10

• Creating Functions in AOL Module
• Creation of New Menu
• Oracle Application Default Menus

Session 11

• Introduction to Template.FMB
• Appstand.FMB
• Introduction to Predefined Objects in Template.FMB

Session 12

• Creating of New Template
• Creating of New Block, Canvas in Template
• Registration Steps for Template

Session 13

• Overview of Flex Fields
• Types of Flex Fields
• Introduction to Key and Descriptive Flex Fields

Session 14

• Steps for Creation of DFF
• Flex Field Tables and Relations

Session 15

• Overview of Profiles Options
• Different Levels in Setting Profiles
• Some Important Profile Options
• Steps in Setting Profile Options

Session 16

• Multiple Organization Concepts
• Introduction to Multi Org
• What is Multi Org and Why we need it
• Defining Multi Org Structure

Session 17

• Multi Org Tables
• Overview of Procure to Pay (P2P Cycle)
• Overview of Order to Cash (O2C Cycle)
• Overview of Important Tables in PO, Inventory, OM, AP, AR, GL

Session 18

• Introduction to Interfaces
• Difference between Interfaces and Conversions
• Types of Interfaces
• Inbound Interfaces
• Using SQL * Loader

Session 19

• Working with Staging Table Scripts
• Developing Validations Package
• Interface Tables and Error Tables

Session 20

• Introduction to Conversions
• Conversion Flow

Session 21

• Introduction to AIM Documentation
• Preparation of AIM Documents

Session 22

• Introduction to Business Documents
• Preparation of MD 50 Documents, MD 70 Documents etc.

Session 23

• Functional Flows of GL, AP, AR
• Back End Tables

Session 24

• Introduction of XML Reports
• Developing XML Reports

Session 25

• Steps for Registering the XML Reports in AOL Module
• Back End Tables
• FAQS in Oracle Apps Technical

Oracle Apps SCM Week End Online Training (One to One)

Oracle Apps SCM Week End Online Training (One to One Online Training)

Week End Online Training Will be held on Every Saturday and Sunday

Duration : 20 Sessions

Each Session Duration : 1.5Hrs

Oracle R12 Purchasing

Procure to Pay

. Procure to Pay Purchasing Overview
. Overview of Purchasing Process
. Integration with other Oracle Applications

Suppliers

. Overview of Suppliers
. Supplier Information
. Supplier Site Information

Locations, Organizations, Units of Measure and Items

. Enterprise Structure
. Defining Locations
. Inventory Organizations
. Establishing Inventory Parameters
. Units of Measure
. Item Categories
. Item Attributes
. Defining and Maintaining Items

RFQs and Quotations

. Request for Quotation Lifecycle
. Request for Quotation Lifecycle Implementation

Requisitions

. Requisition Lifecycle
. Requisition Structure
. Creating and Maintaining Requisitions

Purchase Orders

. Purchase Order Types
. Standard Purchase Order Elements
. Blanket Purchase Agreements
. Contract Purchase Agreements

Automatic Document Creation

. Creating Purchase Documents from Requisitions
. Automatic Release Generation

Receiving

. Receiving Locations
. Receipt Routing
. Receipt Processing Methods

Oracle R12 Oracle Inventory

Inventory Overview

. Inventory Overview
. Inventory Capabilities
. Oracle Inventory Applications Integration
. Integration of Oracle Inventory to Financials Applications

Receipt to Issue

. Understanding the Receipt to Issue Lifecycle
. 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

Defining Inventory Organizations

. Organization Access Overview
. Organization Access Setup
. Copying Inventory Organizations

Units of Measure

. Units of Measure Overview
. Units of Measure Class Overview
. Defining Unit of Measure Class
. Defining Unit of Measure
. Defining Unit of Measure Conversions
. Lot Level Units of Measure Overview
. Lot-Level Unit of Measure Conversions Overview

Defining and Maintaining Items, Overview

. Defining Items, Overview
. Item Attributes and Statuses, Overview
. Assigning Items to Organizations, Overview
. Defining and Maintaining Items, Fundamentals
. Defining Items
. Item Relationships
. Item Categories
. Item Category Sets
. Item Cross References

Subinventories

. Subinventory Overview
. Defining Subinventory
. Restrict Items to Subinventories

Inventory Controls, Concepts

. Explaining Locator Control
. Explaining Revision Control
. Explaining Lot Control
. Explaining Serial Control

Inventory Controls, Fundamentals

. Defining Subinventories
. Defining Locator Control
. Defining Revision Control
. Defining Lot Control
. Generating Serial Numbers

Transacting Inventory, Concepts

. Explaining Transaction Flows
. Explaining Transaction Types
. Explaining Move Orders
. Explaining Shortage Alerts and Notifications
. Explaining Mobile Transactions

Transaction Setup

. Explaining Transaction Sources
. Setting Up Transactions Sources
. Explaining Transaction Types
. Setting Up Transactions Types
. Explaining Transaction Reasons
. Setting Up Transactions Reasons
. Explaining Account Alias
. Setting Up Account Alias
. Open Inventory Account Periods

Issuing and Transferring Material

. Miscellaneous Receipts
. Miscellaneous Issues
. Subinventory Transfers

Move Order

. Explaining Move Order
. Creating Manual Move Order
. Creating Requisition Move Order
. Requisition Move Order Approval Process
. Creating Pick Wave Move Order
. Creating Replenish Move Order

Inter-Org Transfer

. Shipping Methods
. Shipping Network
. Transit times for Shipping Methods
. Entering inter-org transfer charge
. Entering Freight Charges
. Direct Inter-Organisation Transfer

Replenishing Inventory, Fundamentals

. Performing Reorder-point Planning
. Performing Min-max Planning
. Performing Replenishment Counting
. Inventory Accuracy, Concepts
. Explaining Inventory Accuracy
. Explaining ABC Analysis
. Explaining Cycle Counting
. Explaining Physical Inventory

Inventory Accuracy, Fundamentals

. Creating an ABC Compile
. Defining and Maintaining a Cycle Count
. Defining Cycle Count Scheduling and Requests
. Defining Recounts, Adjustments, and Approvals

Oracle R12 Order Management

. Overview of Oracle Order Management
. Order to Cash Lifecycle Overview
. Ordering Process
. Pricing Process
. Shipping Process
. Autoinvoice Process
. Receivables Process

Inventory Organizations

. Create a Unit of Measure
. Create a Location
. Create an Inventory Organization
. Create a SubInventory
. Define Shipping Parameters

Enter Items

. Create an Item
. Create a Material Transaction
. Add an Item to a Price List

Manage Parties and Customer Accounts

. Explaining Collectors
. Defining Collectors
. Explaining Statement Cycle
. Defining Statement Cycle
. Explaining Payment Terms
. Defining Payment Terms
. Explaining Customer Profile Class
. Defining Customer Profile Class
. Defining Customer

Accounts Receivables Transaction Setups

. Explaining Transaction Type
. Defining Transaction Type
. Explaining Transaction Source
. Defining Transaction Source

Shipping

. Pick Release Sales Orders
. Ship Confirm a Delivery
. Define a Pick Slip Grouping Rule
. Define a Release Sequence Rules

Order Management Transaction Setups

. Explaining Order Transaction Type
. Defining Order Transaction Type
. Explaining Line Transaction Type
. Defining Line Transaction Type
. Explaining Document Sequence
. Defining Document Sequence

Enter Orders

. Create a Sales Order Header
. Create a Sales Order Line
. Schedule an Order
. Book an Order
. Copy a Sales Order

Managing Order

. Work with Order Organizer
. Update a Sales Order
. Create a Hold Name
. Apply a Hold
. Release a Hold
. Cancel an Order Line

Basic Pricing

. Create a Price List
. Adjust a Price List
. Add items to the Price List

Process Invoice

. Create an Invoice
. Copy an Invoice
. Create a Credit Memo

Process Invoice Using Autoinvoice

. Order to Cash Life Cycle Implementation
. Drop Shipment Implementation
. Back to Back Order Implementation
. Internal Sales Order Implementation

Return Material Authorization Implementation

. Return With Credit No Receipt
. Return With Receipt Only
. Return With Receipt, Credit Auto Invoice

FAQS in Oracle Apps SCM

Oracle Apps Financial Functional Week End Online Training (One to One)

Oracle Apps Financial Functional Week End Online Training (One to One Online Training)

Week End Online Training Will be held on Every Saturday and Sunday

Duration : 16 Sessions

Each Session Duration : 1.5 Hr

Oracle Apps Financial Functional Course Content

Introduction to ERP

. What is Oracle
. What is E-Business Suite
. Versions in Oracle
. Modules in Oracle Application
. ERPs Available in Market
. What is Implementation Process

General Ledger

. Descriptive Flex field
. Key Flex Fields
. Segments
. Design Char of Accounts
. Currency. Value Sets
. Ledger
. Calendar
. Journal Source
. Open/Close Periods
. Journals
. Journal Category
. Reverse Journals
. Journal Batch
. Recurring Journals
. Suspense Journals
. Auto Reversal
. Auto Posting
. Statistical Journal
. Mass Allocation
. Sequential Numbering
. Inter Company Journals
. Tax Journals
. Journal Approval Process
. Rollup Groups
. Budgets
. Translation
. Summary Templates
. Reporting Currency
. Revaluation
. Consolidation
. Secondary Ledger
. Cross Validation Rules
. Financial Statement Generator
. Account Alias
. Security Rules
. Definition Access Set
. Data Access Set, Code Combinations

Purchasing

. Financial Options
. Overview of the Procure to Pay Process
. Buyers
. Purchasing Options
. Approval Groups
. Approval Assignments
. Requisitions
. Document Types
. Quotations and Auto Create Quotations
. RFQs and Auto Create RFQs
. Purchase Orders and Auto Create Purchase Order
. Quote Analysis and Auto Create Quotation Analysis
. Inspection
. Receiving
. Returns to Supplier
. Delivery
. Matching Options and Receipt Routing Methods

Inventory

. Receiving Options
. Flex Fields
. Setup System Item Values
. Setup Item Category Values. Define Master Item
. Define Item Category Codes
. Maintain Inventory Periods
. Assign Item to Organization
. Define Hazard Classes
. Copy Attributes from Item
. View Item On-had Quantity
. Define UN Numbers

Accounts Payables

. Payable Options
. Financial Options
. Accounting Periods
. Payable System setups
. Payment Terms
. Run the Validate Application Accounting Definitions Program
. Special Calendars
. Distribution Sets
. Banks Creation
. Payment Format
. Bank Account Creation
. Bank Branches Creation
. Supplier Merge
. Supplier
. Standard Invoice
. Supplier Bank Creation
. Debit Memo
. Credit Memo
. Interest Invoice
. Prepayment Invoice
. Retainage Invoice
. Recurring Invoice
. Quick Match
. Withholding Tax Invoice
. Payment
. PO Match, Invoice Batch
. Payment Batch
. Auto Create Invoice
. Pay group
. Invoice Created against Receipt.
. Invoice created against PO
. Employee Expense Reports
. Third Party Payments
. System Holds
. Manual Holds
. MOAC(Multi Organization Access Control)

Accounts Receivables

. Key Flex Fields
. Sales Tax Location
. Territory
. Run the Validate Application Accounting Definitions Program
. Statement Cycle
. System Options
. Remittance-to Address, Payment Terms
. MOAC Setups for AR
. Dunning Letters
. Collector
. Application Rule Set
. Customers
. Auto Cash Rule Set
. Memo Lines
. Customer profile Class
. Transaction Sources
. Customer Bank Creation
. Transactions/Sales Invoice
. Transaction Types
. Credit Memo Invoice
. Auto Accounting
. Guarantee Invoice
. Debit Memo Invoice
. Transactions Batch
. Deposit Invoice
. Invoice Rules
. Charge Bank Invoice
. Receipt Class
. Accounting Rules
. Receipts
. Receivables Activities
. Receipt Reversal
. Receipt Source
. Receipt Write Off
. Miscellaneous Receipts
. Balance Forward Billing Cycle
. Remittance Receipts

Fixed Assets

. Flex Fields
. System Controls
. Financial Year Calendar
. Values
. Prorate Convention Calendar
. Depreciation Calendar
. Book Controls
. Depreciation Methods
. Asset Additions
. Depreciation
. Asset Books
. Asset Categories
. Changes
. Asset Transfer
. Reinstatement
. Revaluation
. Create Accounting
. Mass Additions
. Retirement

Cash Management

. System Parameters
. Reconciliation
. Bank Statements
. Forecasting
. Un Reconciliation
. Banks Charges
. Bank Transfers

Introduction to HRMS

FAQS in Oracle Apps Financial Functional

Oracle Apps Technical Week End Online Training Details (One to One)

Oracle Apps Technical Week end Online Training (One to One Online Training)

Oracle Apps Technical Week End Online Training Will be held on Every Saturday and Sunday

Duration : 16 Sessions

Each Session Duration : 1.5 Hr

Oracle Apps Technical Course Content

Introduction to ERP

• Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
• Using TOAD

Types of Roles

• Functional Consultant and Roles
• Technical Consultant and Roles
• Techno-Functional Consultant and Roles
• Oracle Application DBA and Roles

Application Object Library

• System Administration and Application Object Library (AOL)
• Defining an Applications User and Assigning the Responsibilities.
• Understanding AOL and its Components
• WHO columns
• Creating Responsibilities
• Request group creation
• Menu Creation

Application development

• Defining concurrent program
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets

Registration of Custom Objects

• Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL

Interfaces and Conversions

• Introduction to Interfaces
• Difference Between Interfaces and Conversions
• Outbound Interfaces
o Using UTL_FILE package
• Inbound Interfaces
o Using SQL * Loader tool
• SQL * Loader Concepts o Data File.
o Control File.
o Bad File.
o Discard File.
o Log File.
• Working with staging table script
• Developing validations package
• Standards to be followed in conversions
• Using oracle API’s in Interfaces and Conversions
• Interface Tables and Error Tables

Flex Fields

• Overview of flex fields
• Types of Flex Fields
o Descriptive Flex Fields
o Key Flex Fields
• Step in creation of DFF
• Flex fields tables and relations

Profiles

• Overview of profile options
• Different levels in Setting profiles
• Steps in setting a profile option
• Some important profile options
• Some important API’s of profiles

Value sets

• Overview of value sets
• Options in value sets
• Types of value sets
• Creation of value set
• Overview of value set tables
• Usage of $FLEX and $PROFILE

Multi Org Concepts

• What is Multi Org and why we need.
• Multi Org Tables.
• Multi Org Viiews.

Functional Modules Overview

• Overview of Procure to Pay Flow (P2P Cycle)
• Overview of Order to Cash Flow (O2C Cycle)
• Major setups and transactions
• Overview of important tables in PO,INV,OM,AP,AP,GL

Reports in Oracle Applications

• Introduction and Usage of USER_EXITS.
• Developing a Report from scratch as per Client Requirement.
• Developing a Report based on MD 50 Document.
• Customization of Oracle Standard Reports.
• Reports Registration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps

Forms in Oracle Applications

• New Form Development Process
• Form Registration in Oracle Applications.
• Calling one Form to another Form by using Button
• Master-Detailed Forms
• Form Personalization in Oracle Applications
• Form Personalization v/s Form Customization

Development of XML Reports

FAQS in Oracle Apps Technical

D2K | Oracle Forms and Reports Online Training Details

D2K | Oracle Forms and Reports Online Training Details (One to One Online Training)

Duration : 10 Sessions

D2K Course Content

Forms 6i

. Introduction and Role in Oracle APPS
. Fundamentals of D2K

Types of Blocks

. Creation of blocks Through wizard and Manually
. Creation of Master-Detail Data Blocks

Canvases

. Creation of Different Types of Canvases and Working with Canvases

Windows

. Types of windows and working with windows and changing windows properties

Triggers in Forms

. Different types of Triggers
. Working with Triggers and Applying to Different Controls

Alerts

. Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts

Editors

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

Creation of Object Groups

. Creating and Using Object Groups
. Creating and Using Object Libraries

Using Image Items

. Storing and Retrieving Images
. Working With Image Items

Record Groups

. Creation of Record Groups Based On Query and Using Static Values

Lovs

. Creation of Lov through wizard and Manually
. Working with Lov Properties

Menus

. Creation of Menus, popup Menus and attaching menus to Forms

Program Units

. Working with Procedures, Functions and Packages in Forms

PL/SQL Libraries

. Usage of PL/SQL Libraries in Forms and Attached Libraries
. Using Database Objects and Creating Database objects through forms.

Reports 6i

. Introduction
. Fundamentals of Reports
. Advantages, Features and role of Reports in D2K

Creation of Reports using Wizards

. Creation of Different types of Reports
. Creation of Reports Manually
. Creation of Reports with different Parameters
. User Parameters
. System Parameters
. Manual Reports
. Creation of Reports through Data Model SQL Query
. Working with Formula Columns
. Working with Summary Columns
. Working with Place Holder Columns
. Working with Data links
. Working with Cross Products
. Creating Report With Parameters

Reports in Triggers

. Before Parameter Form
. After Parameter Form
. Before Report
. Between Pages
. After Report

Creation of Templates

. Creation of Layout in Reports
. Drill Down Reports
. Calling Reports from Forms
. Calling Reports from Reports

FAQS in D2K

PLSQL Online Training Details (One to One)

PLSQL Online Training Details (One to One Personal Online Training)

Duration : 6 Sessions

PLSQL Online Training Course Content

. Introduction to PL/SQL

. Data Types

. Constructs

. Exception

. Cursors

. Sub Programs
Procedures
Functions
Packages

. Triggers

FAQS in PLSQL