enroll today free demo for online oracle apps technical training by oracle apps experts, learn oracle apps technical course within reasonable cost live tutorial classes videos certification materail dumps and documentation in Hyderabad USA Canada Dubai Germany France Brazil South Africa London England Australia Spain Italy UK Singapore Malaysia Qatar

Oracle Apps Technical Training Course Content

• Logon and logout of Oracle Applications
• Entering data in ERP forms
• Searching for available data in forms
• Accessing Online Help

Report Development/Customization and Registration

• a. Developing a new Report without parameter
  • 1. How to develop a report using Reports 6i/10g
  • 2. Deploying the new report into the server
  • 3. Registering the new report as new Executable in ERP
    • i.Execution methods availability
  • 4. Registering the executable as a new concurrent program
  • 5. Attaching the concurrent program to the new request group
  • 6. Attaching the request group to the new responsibility
• b. Developing a new Report with parameters
  • 1. How to develop a report using Reports 6i/10g
  • 2. Deploying the new report into the server
  • 3. Registering the new report as new Executable in ERP
  • 4. Registering the executable as a new concurrent program
    • i.Defining the new Value sets
      • a. Independent Value set
      • b. Dependent Value set
      • c. Table Value set
      • d. None Value set
    • ii. Default types available
    • iii. Using the Existing value sets
  • 5. Use of Token field
  • 6. Attaching the concurrent program to the existing request group
  • 7. Attaching the request group to the existing responsibility
• c. Customizing the Existing Standard Report
  • 1. Finding and downloading the standard report from the server
  • 2. Check the feasibility of customizing the standard report based on the requirement
  • 3. Procedure to customize the standards report as per the oracle guidelines
    • i. Rename the Existing .RDF with new .RDF
    • ii. Customize the RDF as per requirement
    • iii.Deploying the new RDF into the server
    • iv. Creating the new Executable for the new report
    • v. Creating the new concurrent program for the new executable
    • vi.Attaching the new program to the associated request group of responsibility.

Form Development/Customization in Oracle apps

• a.Development and deployment of New form in oracle apps
  • 1. Setting up the form builder environment
  • 2. Template. FMB usage
  • 3. Developing the New Form
  • 4. How to Compile the new form
  • 5. Registering the form in oracle applications
  • 6. Creating the new function and attaching the new form to the function
  • 7. Attaching the form to the Submenu/Menu
• b. Customization and Deployment of Standard form in oracle apps
  • 1. How to customize the standard forms
  • 2. How to compile the form
  • 3. Registering the form in oracle applications
  • 4. Creating the new function and attaching the new form to the function
  • 5. Attaching the form to the Submenu/Menu
  • 6. Risks in customizing the standard forms
• c. Developing the Query Find form in oracle applications
  • 1. Steps in developing the Query Find Form
  • 2. How to compile the new form
  • 3. Registering the form in oracle applications
  • 4. Creating the new function and attaching the new form to the function
  • 5. Adding Calendars to Date Fields
  • 6. Using Message Dictionary
  • 7. Controlling Window Behavior
  • 8. Difference between forms and form functions
• d. Personalization of Existing form in Oracle apps
  • 1. What is personalization?
  • 2. What can be achieved by using Personalization?
  • 3. Restrictions and options in Personalization
• e. Usage of Custom.pll for customizing the Standard form
  • 1. What is the use of Custom.PLL?
  • 2. Restrictions in using the custom.PLL

Interface/Conversion Development

A. Types of interfaces in oracle apps

• a. Inbound Interface
  • 1. What is inbound Interface
  • 2. Hot to develop inbound interface
  • 3. Different ways of developing inbound interface
  • 4. Inbound Interface flow
  • 5. Use of SQL*Loader in inbound interface
  • 6. Error Messages handling in inbound interfaces
• b. Outbound Interface
  • 1. What is outbound Interface?
  • 2. How to Develop Outbound Interface
  • 3. Different ways of developing Outbound interface
  • 4. Use of UTL_FILE Package while developing the outbound interface

Workflow Fundamentals

• Overview of Work-flow
• Oracle Work-flow Home Pages
• Work-list WebPages
• Work-flow Monitor WebPages

Development of XML Publisher Report from RDF

• What is XML Publisher Report
• Benefits in Developing the XML Publisher Reports
• Steps to follow in Developing the XML Publisher Report
• Designing the report layout in RTF
• Define the Data definition
• Defining the Template

Development of PL/SQL Report

• How To Develop a PL/SQL report
• Advantages of Developing the PL/SQL report
• Coding standards to follow while developing the PL/SQL report
• Usage of ERRBUF and RETCODE parameters
• Usage of FND_FILE.PUT_LINE in PL/SQL
• Eroding out the concurrent program based on Conditions
• Hot to call a concurrent program from Backend

Overview of the System administrator responsibility

• Creation of Application Users
• Creation of Responsibilities
• Creation of Request Groups
• Assigning the Responsibilities to the Users
• System Profiles and their usage within oracle apps
• Personal Profiles and their usage

Overview of the Application Developer Responsibility

• Types and use of Flexfield
• Use of Key Flexfield
• Use of Descriptive Flexfield
• How to identify the descriptive Flexfield in the forms
• How to Enable the Descriptive Flexfield of a particular form
• Lookup table and their usage
• Registering the tables in oracle applications
• Oracle apps table registration API
• Building Message dictionary
• Difference between request group and request set
• Creating Custom Menus

What is New in R12 when compare to 11i

• Major Features of R12
• MOAC architecture
• Multi org changes in R12
• Use of SLA in R12
• Some major table changes in R12
• API Changes of R12

Migration of Objects from one instance to Other

• Migrating the objects by using scripts
• Migrating the objects by using the FNDLOAD
• Migrating the objects by using screenshots

Procure to Pay Process

• a. Purchase order Module(PO)
  • 1. Requisition and Types
  • 2. RFQ and Types
  • 3. Creation Of Supplier and Site
  • 4. Types of Purchase Orders
  • 5. Different type of Purchase order Matching
  • 6. Approvals the Purchase Orders
  • 7. Creation of Receipts
  • 8. Return to Vendor Process
• b. Account Payables Module (AP)
  • 1. Creation of Invoice
  • 2. Setting up Payment Terms
  • 3. Different Type of Invoices
  • 4. Validating the Invoice
  • 5. Accounting the Invoice
    • i. Draft
    • ii. Final
    • iii. Final Post
  • 6. Approvals of Invoice
  • 7. Making payment for the Invoice
  • 8. Batch payment of the Invoices
• c. Cash Management Module (CM)
  • 1. Setting up the Banks, Bank Branch and Bank Account
  • 2. Clearing the Payment
  • 3. Reconciling the Payment
  • 4. Uploading the Bank statement to CM which we receive from the banks
• d. General Ledger Module (GL)
  • 1. Defining the Calendar
  • 2. Defining the Currency
  • 3. Defining the Chart of accounts
  • 4. Setting up Accounting Flexfield
  • 5. Creating Journal batches
  • 6. Fixing the Posting issues of the Journals
  • 7. Creating the Budgets