Tag Archives: oracle 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
  • [/su_spoiler]
    Report Development/Customization and Registration in oracle apps
    • 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 in Oracle apps
    • 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
    Top ↑