Oracle Apps Technical Training

Oracle Apps Technical Training

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







Ready to Begin?

Find subjects you're passionate about by browsing our online course categories.Start learning with top courses Built With Industry Experts