Winsomesoft

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