ORACLE APPS TECHNICAL

Homepage
>
Courses Offered
>
Product
>
ORACLE APPS TECHNICAL

Duration : 40 Hrs

Download

We provide Oracle apps technical training online in India. At our online center Experts give online and offline training with latest technologies.

Introduction to ERP

Oracle Application Architecture.
Database structure of OA
Using TOAD

Modules Exposure

Inventory
Purchasing
Order Management
Account Payables
Account Receivables
HRMS

Oracle Reports

Report development
Report registration
Parametric report registration
Reports with repeating frames

Application Object Library(AOL)

Creating Users
WHO columns
Creating Responsibilities
Menu construction
Request group construction

Application development Defining concurrent program

Concurrent programs with parameters
Working with multiple concurrent programs
Scheduling the Concurrent Program
Concurrent Program incompatibilities
Creating Request Set
Procedure registration

Value Set Creation

Types of Value Sets with Example(8 TYPES)

(NONE,DEPENDENT,INDEPENDENT,TABLE, TRANSLATED INDEPENDENT,TRANSLATED DEPENDENT, SPECIAL,PAIR)

Using $FLEX$ in reports
Using $PROFILES$

Multi-Org Report

Profiles in apps
User Exists
Lexical Parameter

FND LOAD USING SQL *LOADER

Loading data using SQL * Loader(Flat Files to Staging Tables)

Interfaces

Introduction to Interfaces
Outbound Interfaces
Using UTL_FILE package
Inbound Interfaces
Using SQL * Loader tool

Conversions

Overview on conversions
Difference between Interfaces and conversions
Working with staging table script
Developing validations package
Standards to be followed in conversions

Flex Fields

Types of Flex Fields
- Descriptive Flex Fields
- Key Flex Fields

XML Publisher Reports

Introduction to XML Publisher
Generating XML file using reports
Creating Templates
Creating Data Definitions

Oracle Alerts

Event Based Alerts
Periodic Alerts

Form Personalization

Calling Messages
Calling Report
LOV Customization

Documentations

Technical Document (MD 70)
Functional Document (MD 50)
Unit Testing Document(TE 20)
Release document (MD 120)
Review Documents

Module Exposure Details:

Inventory
- Items Creation
- On Hand Quantity
- Miscellaneous Transaction
- Organization Assignment
- Organizations
- About Sub Inventories
Purchasing
- Pre-requisites
- P2P cycle(Requisition -->RFQ-->Quotations-->PO-->Receipts Invoice-->Payments-->GL)
- Types of Purchase Orders(PO)(Standard PO, Planned PO, Blanket PO, Contract PO)
- Reports from Purchasing

Account Payables
- Invoice Creation for a PO(Bank Setup--> Invoice--> Create Accounting--> Payment)

Order Management(Order to Cash)
- Pre-requisite setups
- O2C cycle(Order to Cash)(Entered-->Booked-->Pick Release-->Pick Confirm-->Ship Confirm-->Interfaced-->Invoice Creation)
- Types of Orders:-Standard, Drop Shipment, Back to Back, Return Order, Bill only, Ship Only

Account Receivables
- Invoice Creation for a SO (Invoice Creation--> Complete-->Receipt Creation-->Applied with Invoice)

HRMS (JML)
- 1. joiner 2. Mover and 3. leavers

Reviews

No reviews