oracle apps technical training

Introduction to ERP

Definition of ERP

Types of Roles

Types of Projects

AIM documentation - MD70, TE40, Migration Document

Oracle Application Architecture

TOAD

Putty

WinSCP

Application Object Library

CrCreating Users

Creating Responsibilities

Request group construction

Creating Menu

Report Registration

Registration of SQL*Loader files

Registration of PL/SQL procedure

Application development

Defining concurrent program

Concurrent programs with parameters

Working with multiple concurrent programs

Scheduling the Concurrent Program

Concurrent Program incompatibilities

Creating Request Set

Package / Procedure registration

Value sets

Overview of value sets

Options in value sets

Types of value sets

Creation of value set

Overview of value set tables

Flex Fields

Descriptive Flex Field

Key Flex Field

Profiles

Overview of profile option

Different levels in setting profile

Steps in setting a profile option

Oracle Alert

Event Alert

Periodic Alert

XML Publisher Reports

Introduction to XML Publisher

Generating XML file using reports

Creating Templates

Creating Data Definitions

Report development

Report registration

Parametric report registration

Reports with repeating frames

Using variables in template

Development of custom xml templates for seeded reports

Some mandatory reports for every project like Check printing, Electronic fund transfer, Positive pay, AP and AR aging reports, GL trial Balance reports

Module Overviews

P2P (Procure to Pay) Business Flow

O2C (Order to Cash) Business Flow

Interface

Introduction to Interfaces

Outbound Interfaces - Using UTL_FILE package

Inbound Interfaces - Using SQL * Loader tool

Sample code for practice

Conversions

Overview on conversions

Difference between Interfaces and conversions

Working with staging table sql * loader script

Developing validations package

Standards to be followed in conversions

Sample code for practice

Oracle cloud - fusion financial

Introduction

OER - Oracle Enterprise repository

File based Interfaces and Conversions

OTBI Reports

Disbursement Payment files setup which includes Bank, Bank branch, Bank account, Payment process profiles, Payment formats, format templates for check,

EFT and control files.

Oracle Apps Technical

Available Trainings

Course Syllabus

Oracle Apps Technical Training