Prerequisites : Preliminary Knowledge on Oracle SQL, PL/SQL and Oracle Development Tools (Forms and Reports)
Course Content:
Utilities:
SQL
PL/SQL
Forms
Reports
UNIX
Sql*Loader
Discoverer
XML Publisher
Workflow Builder
AOL (Application Object Library) and System Administration:
Application Architecture
File System
Schema Admin
Menu
Responsibility
User Creation
Concurrent Program
Request Group
Data Group
Concurrent Process and Registration Process (Form Report, PLSQL, Shell Script)
Register table in application
Printer
Messages
Alerts
Profile Options
Flexfields - Key and Descriptive
Interfaces Methodology - Receipt Import, Autoinvoice, Vendor Import Overview.
Reports Designing
Receivables:
Overview
AR System Setups
Profile Options
Receivable Quick Codes (Lookups)
Customer Setup and Customer Profile Classes
Transaction Setups
Transactions (Invoice, Debit Memo, Credit Memo)
Autoinvoice
Adjustments, Foreign Currency Invoices
Receipts Setups
Receipt Import
Auto Lockbox
Receipts and Reversals
Charge Backs, Write Offs, Misc Receipts.
Invoicing and Accounting Rules
Tax Codes, Tax Exemptions and Tax Exceptions
View Accounting, AR Transfer to GL
Payables:
Overview
Creation and approval of invoice
Supplier Management
Payable Interface
Bank Setup
EFT
2-Way, 3-Way, 4-Way matching
Payment Process
Payables Transfer to GL
Vendor Interface
Purchasing:
Overview
Requisition Process
Finding Items
Workflow Approval Process
Approval Hierarchies
Purchase Orders
Create and Process
Setups
Auto Create Purchase Order
PDOI
AP-PO Match
Receiving
Account Generator
Vendors
Order Management:
Sales Order Process Flow
SOWB and Customizations
Overview of Returns
Overview of Pricing
Order Import
Booking Validations
Copy, Cancel
Holds Management
Profile Options
Payment terms
Tax
Transaction Types
Document Sequences
Order Sources
Items
Pricing
Customers
Transaction Types
Shipping Parameters
OM Technical Details
OM Standard Header Workflows
OM Standard Line Workflows
General Ledger:
Overview
Set of Books
Chart of Accounts
Accounting Calendar
Creating Journal Entries
GL Import
Recurring Journals, Foreign Journals
Mass Allocation
FSG (Financial Statement Generator)
Intercompany
Inventory:
Overview
Inventory Structure
Organization, Org Parameters
Sub Inventories
Item Setup
Item Definition & Attributes
Locators
Inventory Transactions
Inventory On Hand Fundamentals
Physical & Cycle Counts
