Oracle Applications Training

Hey buddy please let me know is Sunil Technologies also conduct Oracle Applications Training if yes will you please get some information?

[Kiran Chandar]

Yes buddy Sunil Technologies also conduct Oracle Applications Training and here I will get some information about it so that you can have idea.

Here is the certifications and program structure conducted by them
Course : Oracle Applications R12 Technical

Cost of the training: INR 30,000

Duration: 40 Hrs ( Approx )

Each Session : 1 hr 15 min

Introduction

Session 1 Demo session - Introduction of the trainer, explaining the course contents, pre-requisities, methodology of the training.

Session 2 Types of Roles , Types of projects, AIM documents

Session 3 Oracle Apps file structure, database structure and 3-tier architecture
Application Object Library

Session 4 Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities

Session 5 Menu construction, Defining concurrent program

Session 6 Concurrent program with parameters, Creating Value sets, incompatabilities

Session 7 Scheduling concurrent program, Creating request group, Creating request set

Session 8 Concurrent program creation using API
Module Overviews

Session 9 Inventory Module flow with base tables

Session 10 Accounts Payable module flow with base tables

Session 11 Accounts Receivable module flow with base tables

Session 12 Order Management module flow with base tables

Session 13 General Ledger module , Creating Ledger using ( Currency, Calendar
and COA )
Reports
Session 14 Report development process, Report registration process

Session 15 Bind parameters, lexical parameters, reports with value set, Building
report manually

Session 16 Using repeating frames, Summary columns , Formula columns, place holder column , Standard report customization
Interfaces

Session 17 Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package

Session 18 Inbound Interface process, Working with SQL*Loader tool

Session 19 Different option in SQL *Loader tool, bad file, discard file

Session 20 Using Interface table approach

Session 21 Using API Approach
Conversions

Session 22 Introduction to conversions, Creation of staging table

Session 23 Develoing the validation package, Explaining the real time project code.

Session 24 Completing the conversion task, Differences between Inbound interfaces and Conversions
Forms

Session 25 Form development process using TEMPLATE.FMB , Form registration
process

Session 26 Form personalization

Session 27 Using Custom.pll , implementing ZOOM functionality
Workflows

Session 28 Workflow Introduction, Workflow development process, running the workflow

Session 29 Sending notifications, branching the workflow using resultout variable
XML Publisher

Session 30 Introduction to XML publisher, Report development process

Session 31 Creating reports for multiple rows, Creating Data definitions, Creating
templates

Session 32 Converting standard rdf report to XML Report, Working with data
templates
Discoverer

Session 33 Introduction to Discoverer tool, Using Discoverer Administrator, Creating EUL, Creating Business Areas

Session 34 Creating Joins, Creating Item class, Using Discoverer Desktop, Creating workbooks, Discoverer report registration process
Flex fields

Session 35 Customizing DFF, Creating KFF
Functional Cycles

Session 36 P2P Cycle

Session 37 O2C Cycle

Course : Oracle Applications R12 Functional (Financials)

Cost of the training: INR 30,000

Duration: 45 Days ( Approx )

Each Session : 1 hr 15 min

Trainer: Mr. Raj

General Ledger
Introduction to Oracle ERP and Oracle Apps functional modules.
Define period type and calendar (4c concepts).
Flex field qualifiers and chart of accounts.
Accounting setup's
Define legal entity.
Define ledger.
Define accounting options.
Assigning balancing segment values(bsv) to legal entity.
Ledger sets, Data Access sets
Suspense journal.
Recurring journal, standard recurring journal, schedule recurring journal and skeleton recurring journal.
Intercompany and Intracompany.
Foreign Currency, Revaluation
Reporting currency ledger
Balance method ( Translation )
Journal method
Secondary ledger
Balance method
Journal method
Consolidation.
Budgets , Cross validation rules.

Accounts Payable (P2P Cycle )
Creating responsibility and assigning to user.
Business group, location from Hrms responsibility.
Chart of accounts, define accounting setup's, define operating unit.
Define security to Hrms, define master inventory org (p2p setups and process).
Multi org set up's for Hrms, Purchasing, Purchasing options, Document numbering.
Define jobs, positions, hierarchy, employees, approval group, approval assignments.
Define buyer, assign buyer to user.
Moac for inventory, creation of item, min-max planning.
Requisition import from inventory.
Manual requisition, assign position hierarchy to document type.
Auto create requisition and create a purchase order/approving purchase order. creating of sub inventory.

Receipt routing types -- Direct delivery, Standard and Inspection routing.
Creation of bank, branch, account number and check book.

Types of invoices
Standard Invoice
Credit memo
Debit memo
Mixed invoice
Prepayment
Expense report
Interest invoice
Refund
Quantity correction, price correction and amount correction.
Quick payments.

Accounts Receivables ( O2C cycle )
Moac setups , system options.
Define collector , payment terms, auto cash rule set.
Statement cycle, define customer.
Auto accounting, transaction type, remit to address.
Auto invoice and O2C setups.
O2C process (auto invoice process).
Credit memo, Debit memo.
Commitments, deposit, Guarantee.
Receivable activity.
Balance forward billing.
Adjustments , receipt write off.
Calculating interest base on charge schedule.

Fixed Assets ( FA to GL Cycle )
Flex field , system controls.
Fiscal year, calendar.
Depreciation.
Asset books.
Mass additions.
Mass retirements, revaluation.
Mass changes, Mass transfer.
Create accounting.

Address:-
Sunil Technologies
7-2-1165, SRT - 910,
Behind Police Station,
Sanath Nagar, Hyderabad - 500 018
India

Phone:-
+91 98497 97960.