Oracle Apps Technical Development

Oracle Apps Technical Development

Continuous calculations enable to distribute payroll processing throughout a payroll period. we can run payroll process like payroll run, pre payments and costing for static employee data.

Continuous calculations works by using triggers. Define triggers and events which inform the system when data has changed. When employee receives a sal increment the corresponding event is triggered. The identifies these triggers and marks the corresponding payroll processes to be repeated. A change an emp data is trigger for the continuous calculations process these three types. Affect costing, Affect prepayments, Affect all three continuous calculation processes like payroll run, prepayments and costing

Continuous calculation recalculates all assignments that have run,prepayments and costing with status other then complete.


Introduction to ERP
    •	1.Definition of ERP, Overview of popular ERP'S
    •	2.Comparison of Oracle Apps with other ERP'S
    •	3.Types of Roles
    •	4.Types of Projects
    •	5.AIM documentation standards
    •	6.Oracle Application Architecture.
    •	7.Database structure of OA
    •	8.Using TOAD

Application Object Library
    •	1.Creating Users
    •	2.WHO columns
    •	3.Creating Responsibilities
    •	4.Menu construction
    •	5.Request group construction

Application development
    •	1.Defining concurrent program
    •	2.Concurrent programs with parameters
    •	3.Working with multiple concurrent programs
    •	4.Scheduling the Concurrent Program
    •	5.Concurrent Program incompatibilities
    •	6.Creating Request Set
    •	7.Procedure registration
    •	8.Value sets

Reports registration
    •	1.Report development
    •	2.Report registration
    •	3.Parametric report registration
    •	4.Reports with repeating frames

Module Overviews
    •	1.Inventory Module flow with base tables
    •	2.Accounts Payable module flow with base tables
    •	3.Accounts Receivable module flow with base tables
    •	4.Order Management module flow with base tables

Form registration
    •	1.Template.fmb
    •	2.Appstand.fmb
    •	3.Form development using templates
    •	4.Form customization concepts
    •	5.Form Registration Process
    •	6.Custom.Pll
    •	7.Using function Zoom_available( )
    •	8.Using procedure Event( )

Interfaces
    •	1.Introduction to Interfaces
    •	2.Outbound Interfaces
    •	3.- Using UTL_FILE package
    •	4.Inbound Interfaces
    •	5.- Using SQL * Loader tool

Conversions
    •	1.Overview on conversions
    •	2.Difference between Interfaces and conversions
    •	3.Working with staging table script
    •	4.Developing validations package
    •	5.Standards to be followed in conversions

Flex Fields
	•	1.Types of Flex Fields 
        o	1.Descriptive Flex Fields
        o	2.Key Flex Fields

Workflows
    •	1.Introduction to workflow
    •	2.Workflow builder
    •	3.Attributes
    •	4.Creating Processes
    •	5.Sending notifications using workflows

XML Publisher
    •	1.Introduction to XML Publisher
    •	2.Generating XML file using reports
    •	3.Creating Templates
    •	4.Creating Data Definitions

Discoverer
    •	1.Introduction to Discoverer tool
    •	2.Discoverer Administrator 
        o	1.Creating EUL
        o	2.Creating Business Areas
	•	3.Discoverer Desktop 
        o	1.Creating work books