Oracle Apps Technical

oracle apps technical training

Course Syllabus

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.