Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies.The Training in is every thing we explained based on real time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Course Content
Pre-Requisites
- Oracle Database (SQL and PL/SQL)
- Oracle forms 10g and Reports 10g
Introduction to ERP
- ERPs available in market
- Types of Roles
- Types of Projects
- Types Instances
- Types of AIM Documents
- Versions of Oracle ERP
- Oracle Applications File Structure
- Oracle Applications Database
- Multi Org structure
- Types of Modules and Integration
Application Object Library
System Administrator
- User
- Responsibility
- Concurrent program
- Executable
- Request group
- Request set
- Profiles
Application Developer
- Lookups
- Messages
- Application
- Menus
- Flexfield
- Value Sets
Modules Overviews
- Inventory Module(INV) flow with base tables
- Accounts Payable(AP) module flow with base tables
- Accounts Receivable(AR) module flow with base table
- Purchasing(PO) module flow with base tables
- Order Management(OM) module flow with base tables
- General Ledger(GL) module flow with base tables
- Joins between tables over across modules
Functional Cycles - Procure to pay(P2P) Cycle
- Order to Cash(O2C) Cycle
Reports
Oracle Reports
Oracle Reports
- Report development process and registration steps
- Building report manually with parameters
- Using repeating frames, Anchor and USER_EXIT
- Summary columns, Formula columns & place holder column
- Report Triggers, Format Triggers, Bind parameters and Lexical
- parameters
- Customization of standard report
- XML Publisher Reports
Introduction to XML publisher
- XML publisher Report development and registration process
- Create XML publisher report with data templates
- Converting standard RDF report to XML Report
- Discoverer Reports
- Introduction to Discoverer Reports
- Development and Registration process of Discoverer reports
- PL/SQL Reports
Development and Registration process of PL/SQL reports
Interfaces and Conversions
- Introduction to Interfaces
- Outbound Interfaces, using UTL_FILE package
- Inbound Interface process using SQL*Loader
- Different option in SQL *Loader tool, bad file and discard file
- Interface Using interface tables and open interface program approach
- Interface Using standard API Approach
- Overview on conversions
- Differences between Inbound interfaces and Conversions
- Explaining the real-time project code
Oracle Forms
- Introduction to oracle Forms
- Form development process using TEMPLATE.fmb
- Form registration process
- Master details form
- Form personalization
- Customization Using Custom.pll
- Implementing ZOOM functionality
Workflows
- Workflow Introduction
- Workflow development process, running the workflow
- Sending notifications
- Creating lookup type, Creating role
- Explanation of standard workflow
- Real time Workflow development
Other Topics - MOAC usage
- TCA
- SLA
- 11i and R12 differences
For More Details