Oracle Apps Technical financial Online Training Course Details
Course Duration
45 Days
Mon-Fri
8 am to 10 am (IST)
Mode of Training
Online
Oracle Apps Technical financial Course Content
- • Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
- • Functional Consultant and Roles
• Technical Consultant and Roles
• Techno-Functional Consultant and Roles
• Oracle Application DBA and Roles
- • System Administration and Application Object Library (AOL)
• Defining an Applications User and Assigning the Responsibilities.
• Understanding AOL and its Components
• WHO columns
• Creating Responsibilities
• Request group creation
• Menu Creation
- • Defining concurrent program
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets
- • Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL
- • Introduction to Interfaces
• Difference Between Interfaces and Conversions
• Outbound Interfaces
• Inbound Interfaces
• SQL * Loader Concepts o Data File.
• Control File, Bad File, Discard File, Log File.
• Working with staging table script
• Developing validations package
• Standards to be followed in conversions
• Using oracle API’s in Interfaces and Conversions
• Interface Tables and Error Tables
- • Overview of flex fields
• Types of Flex Fields
• Descriptive Flex Fields
• Key Flex Fields
• Step in creation of DFF
• Flex fields tables and relations
- • Overview of profile options
• Different levels in Setting profiles
• Steps in setting a profile option
• Some important profile options
- • Overview of value sets
• Options in value sets
• Types of value sets
• Creation of value set
• Overview of value set tables
• Usage of $FLEX and $PROFILE
- • What is Multi Org and why we need.
• Multi Org Tables.
• Multi Org Views.
- • Account Receivables
• Account Paybles
• Advance Collection
• General Ledger
• Fixed Assets
• Cash Management
- • Developing a Report from scratch as per Client Requirement.
• Developing a Report based on MD 50 Document.
• Customization of Oracle Standard Reports.
• Reports Registration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps
- • New Form Development Process
• Form Registration in Oracle Applications.
• Calling one Form to another Form by using Button
• Master-Detailed Forms
• Form Personalization in Oracle Applications
• Form Personalization v/s Form Customization
Account Receivables
• Introduction
• Overview Of The Customer
• Transactions
• Invoicing
• Receipts Processing
• Customer Follow-Up
• Posting
• Reconcilliation
• Statement Cycles
• Auto Invoicing
• Closing Periods
• Introduction
• Enter Invoices
• Inquiry On Invoices
• Apply And Release Holds
• Approve Invoices
• Adjust Or Cancel Invoices
• Payment Banks And Payment Processing
• Supplier Data
• General Ledger Transfer
• Payables Period Close
• Introduction
• Accounting Calendars
• Account Flexfield Design
• General Ledger Inquiries
• Journals
• Journal Reconciliation
• Month And Year End Process
• Overview
• Overview Of Reporting Tools
• Standard General Ledger Reports
• The Financial Statement Generator
• Introduction
• Collection Methods
• Dunning based Collections
• Define Employees
• Define Collectors
• Assign Collectors
• Dunning Plan and Set the Collections level
• Create Templates for Dunning
• Review Scoring Engine
• Strategy Overview
• Scoring Engines
• Introduction
• Bank Reconciliation
• Bank Statement Interface
• Enter And Update Manual Bank Statements
• Cash Forecasting
• Inquiries And Reports
• Introduction
• Asset Controls Set Up
• Asset Books
• Asset Categories
• Manual Asset Additions
• Mass Asset Additions
• Asset Adjustments
• Depreciation
• Asset Accounting