Course ORCLF-03: Oracle Payables

Purposes of a payable system, innovative uses of Oracle Payables, web-enabled commerce, Electronic Data Interchange (EDI), Evaluated Receipt Settlement (ERS), procurement cards, attachments, an overview of payables in your business, Timing your liability, the payables workflow, the payables cycle, enter invoices, approve invoices, pay approved invoices, General Ledger Transfer, supplier data, the supplier account, accounting methods, accounting entries for payables transactions, prepayments, invoices, credit memos and debit memos, payments, integration with other financials modules, integration with Oracle purchasing, integration with Oracle Self-Service web applications, integration with Oracle Receivables, integration with Oracle Projects, the Oracle Payables data model, technical overview of automatic payment process, technical overview of General Ledger Interface,

Course ORCLF-04: Oracle Receivables

Oracle Receivables and your AR business processes, creating and managing the customer database, customer profiles, the customer account, transactions, invoices, tax considerations, Automatic Account Generation (AutoAccounting and Flexbuilder), printing transactions, debit memos, credit memos, enter receipt actions, applied receipts, on-account or unapplied receipts, unidentified receipts, receipt reversals, application of on-account receipts, automatic receipts, bank file formats, multiple-invoice applications, cross-currency receipts application, application rule sets, QuickCash, AutoCash Rules, Adjustments, writing off small amounts during receipt entry, finance charges, commitments, customer follow-up, customer calls, dunning letters, dunning letter customization, statements, integration with other modules, Order Entry, creating invoices from orders, Projects, Inventory, receivables open interfaces, AutoInvoice, customer interface, AutoLockbox, sales tax rate interface, the Receivables Data Model, technical overview of the application process, on-account receipts and AR-RECEIVALE_APPLICATIONS , technical overview of the GL transfer, the customer account and balance due, reconciliation, the purge feature, receivables conversion issues, choice of mechanism—manual, interface, or mix, customer conversion.

CourseORCL-01: Oracle8 & 8i DBA

Includes both 8 & 8i DBA. ‘i’ in Oracle 8i, Oracle 8i and objectrelational technology, architecture, database objects, SQL and PL/SQL: Language constructs, syntax, and usage; data definition language, data manipulation language, data control language; basic data modeling and database design and basic Oracle Procedure Builder; architecture, startup and shutdown, database creation, managing database internal and external constructs (such as rego logs, rollback segments, and tablespaces) and all other structures. Backup and Recovery: motives, architecture as it relates to backup and recovery, backup methods, failure scenarios, recovery methodologies, archive logging, troubleshooting,; Performance. Tuning: diagnosis of tuning problems, database optimal configuration, shared pool tuning, buffer cache tuning, Oracle block usage, tuning rollback segments and redo mechanisms, monitoring and detection lock contention, tuning sorts, tuning in OLTP, SDD and mixed environments, and load optimization; data warehousing features.

Course ORCL-02: Oracle DBA Certification

This course covers the Oracle DBA Certification track, consisting of the following four Tests: Test 1: Introduction to Oracle: Introduction to Oracle: SQL and PL/SQL (exam no. 1Z0-001); Test 2: Oracle8 Database Administration (exam no. 1Z0-013); Test 3: Oracle8 Backup and Recovery (exam no. 1Z0-015); Test 4: Oracle8 Performance Tuning (exam no. 1Z0-014); Test 5: Oracle8 Network Administration (exam no. 1Z0-016).

 

 

 

Previous Page - Next Page