Oracle Apps technical training

ORACLE APPS TECHNICAL COURSE CONTENT

  • Introduction to ERP
  • Definition of ERP, Overview of popular ERP'S
  • Comparison of Oracle Apps with other ERP'S
  • Types of Roles
  • Types of Projects
  • AIM documentation standards
  • Oracle Application Architecture.
  • Database structure of OA
  • Using TOAD

Application Object Library

  • Creating Users
  • WHO columns
  • Creating Responsibilities
  • 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 sets

  • Overview of value sets
  • Options in value sets
  • Types of value sets
  • Creation of value set
  • Overview of value set tables

Registration of Custom Objects

  • Registration of Application
  • Report development
  • Report registration
  • Parametric report registration
  • Registration of a Table
  • Registration of Sql, Sql Loader, PL/SQL programs

Report Development:

  • Customization of Reports – Adding DFF Info
  • Customization of Reports – Removing Parameters
  • Flexfields Report with Single Structure
  • Report Coding Standards
  • User Exits in Report design
  • Customization of Reports – Adding Parameters
  • Customization of Reports – Adding Logos

Discoverer Administration Edition:

  • Creating a end user layer
  • database user
  • Connecting to discoverer administrator, using the load
  • wizard and the work area
  • Modifying the Business Area
  • Working with Custom Folders
  • Creating Joins
  • Customizing Items
  • Designing a complex Folder

Discoverer User Edition:

  • Creation of Simple Workbook
  • To design parameterized workbook
  • To change Heading items
  • To insert new sheet in the Workbook
  • To add and remove items from Workbook
  • To create duplicate sheet in Workbook
  • To add title to the Worksheet
  • To insert date, time, page numbers and image on
  • Header/Title of Workbook
  • To apply Conditional Formatting

Interfaces

  • Introduction to Interfaces
  • Outbound Interfaces
  • Using UTL_FILE package
  • Inbound Interfaces
  • Using SQL * Loader tool / dynamic table for files read( New concept)
  • SQL * Loader Concepts
  • Data File.
  • Control File.
  • Bad File.
  • Discard File.
  • Log File.
  • Commands in Sql * Loader
  • Registration Of control File in Oracle Apps.

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

  • Overview of flex fields
  • Types of Flex Fields
  • Descriptive Flex Fields
  • 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

Multi Org Concepts

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

PO Overview and tables

  • Overview of purchasing
  • Major setups and transactions
  • Overview of some purchasing tables

INV Overview and Tables

  • Overview of inventory
  • Major setups and transactions
  • Overview of some INV Tables

OM Overview and Tables

  • Overview of order management
  • Major setups and transactions
  • Overview of some Order Management Tables

GL Overview and Tables

  • Overview of GL
  • Major setups and transactions

Overview of some GL tables

AP Overview and tables

  • Overview of payables
  • Major setups and transactions
  • Overview of some payable tables

Alerts

  • Overview on alerts
  • Types of alerts
  • Creation of alerts

Workflows

  • Introduction to workflow
  • Workflow builder
  • Attributes
  • Creating Processes

XML Publisher

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

FAQ’s in Oracle Apps

Job Assistance

Sgraph Infotech
MSBI | DOT NET | AWS | Data Science | Python
Address :
3rd Floor, JP Royale- 90/4, Above ICICI Bank, Outer Ring Road, Opposite Radisson Blu, Marathahalli,
Bengaluru,
Karnataka - 560037
India.
Tel : 9620885025
Email : sgraphinfotech@gmail.com

OUR TRAINING COURSES

Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore

CONTACT FORM

© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap