390 likes | 568 Views
Oracle Applications Release 11i Financials New Features. Karen Brownfield, Solution Beacon. Solution Beacon Atlanta OAUG November 20, 2003 www.solutionbeacon.com. Introductions / Experiences. Karen Brownfield Working with Oracle Applications over 12 years
E N D
Oracle Applications Release 11iFinancials New Features Karen Brownfield, Solution Beacon Solution Beacon Atlanta OAUG November 20, 2003 www.solutionbeacon.com
Introductions / Experiences • Karen Brownfield • Working with Oracle Applications over 12 years • OAUG Director 11 years and Past President • IOUC Pricing Council
Audience Profile • Current Release • 10.7 • 11.0 • 11i.x
11i Terminology • 11i is 11.5 • Point Release • Applies to all products in all suites • Also called Maintenance Packs • Updates the “point” number, 11i.9 or 11.5.9 • Family Pack • Applies to all products in one suite • Alphabetically named – Family Pack C
11i Terminology • Mini-Pack • Consolidated patches for a product • Alphabetically named – PN.H, AP.I • Patches • Fix specific bug
11i Overall Themes – General • Supporting Global Operations • Move to a Single Database – Leverage Multi-Org • Extending Functionality via the Web • Suppliers • Customers • Employees • Intelligence/Discoverer • Workflow is Everywhere
11i Point Release Features • Matrices • List features added since 11i.1, which patch/ mini-pack, family pack, point release first contains the feature • No description • To find, from Metalink, • choose E-Business 11i Tab on left • Release Content Documents, ‘About’ Documents, and Feature Summary Matrices • Features Summary Matrices
11i Point Release Features • Release Content Documents (RCD) • Similar to PUN (Product Update Notes) • Paragraph on each new feature added • Available for 11.5.5 forward • Same Access as Matrices • ‘About’ Documents • Same Access as Matrices
11i Point Release Features • 11.5.9 CD/User Guides • Accessed via Metalink, E-Business 11i, Documentation • Requires OTN userid/password
11i Point Release Features • 11 and 11.1.1 thru 11.1.8 User Guides • Accessed via Metalink, E-Business 11i, Documentation • Requires OTN userid/password
11i Point Release Features • eTRM’s • Metalink, e-Business 11i, e-TRM’s • Available for 11.5.4 through 11.5.9 • Can still download “static” TRM’s • TRM’s available on doc CD thru 11.5.4 • New Features available within core Application modules [via blue ? – search on new features]
E-Business Suite Professional 2003 • Financials • General Ledger, Global Consolidation, • Payables, Receivables, Fixed Assets, • Cash Management, Property Manager, • Report Manager, CPG Trade Acctng • Public Sector Financials, Budgeting • US Federal Financials • Report Manager
All Products • Logins Expire (11.5.7) • No floating toolbar • Documents window (also in 11.0.x) • Process tab • “Find” window (also in 11.0.x) • Ability to set own (through Preferences responsibility) • Language • Date format • Notification preference
All Products • Ability to follow progress of workflows where you are the owner or instigator • Colored fields to aide data entry • Yellow – required • Gray with black text – can’t change • Gray with gray text – display only • White with green text – drilldown exists • Blue – in query mode • Variable Format reports
All Products • Concurrent Processing • Copy button • Report Sets within report sets • Can update parameter date to be current date • Function Security • Segment Value Security • Reporting by Set-of-Books, Legal Entity, or Operating Unit (org) • Enhancing ability to do Shared Service Centers
All Products • New Personal Home Page – 11.5.9 • Notifications • Favorites cross Responsibilities • Responsibility menu – click direct to screen
Report Manager • Compatible with 10.7 and 11.0.x • Web access to reports (FSG, Standard, Variable format, BIS) • Security access to whole/part of report using FSG content sets • Security access by folder
Financials Suite • Family Pack D is 11.5.9 - released March 2003 • View Accounting • T-Accounts • Account Generators are now workflows • Web ADI
Federal Financials • FACTS I, II Reporting– 11.5.7/11.5.8 • New Attributes • Compliance with 2002 FY reporting • Intra-government funds transfer via IPAC (replaces OPAC) • Automated Prior-Year Adjustments – automated method of recording upward and downward adjustments to prior year obligations • Phase I – PO – 11.5.7
Federal Financials • Appropriation and Funds Distribution Forms to be changed in 11.5.8 • Capture Transaction dates • Budget Execution Notification Workflow • Record/Create Re-Programming transactions single form • Drill down to Budget Execution, PYA, Treasury Execution – Family Pack D • Payables-Receivables Netting (from Payables, cross-reference in Fed Admin)
General Ledger • Intercompany – New Segment, New Rules • Journal Approval Workflow • Step-down Allocations (Workflow) • Automatic Journal Reversals • Journal Scheduling • Mass Maintenance • Incremental Summary Account Maintenance • Calendar Auditing • ADI – Account Hierarchy Editor • Security by COA (11.5.9)
General Ledger • Drilldown (goes beyond Payables, Receivables) into Assets, Purchasing, Projects, Inventory, WIP • FSG • Removal of pagewidth limitation • Report title in Report Definition, not RowSet • Security by Parent • Publishing and viewing in ADI secured by user who generated it (11.5.7, MP D) • New amt type, YTD-Actual (FY End), 11.5.9
General Ledger • MRC • Global Intercompany System (GIS) –replaces Centra • Function Security added for reject transaction (11.5.9) • Global Consolidation System (GCS) • Inactive Accounts Listing • Enhanced Chart of Accounts Listing • Expanded Segment Security
Fixed Assets • Multi-org / Security by Book • Rerunnable Depreciation / Depreciation Rollback • Units of Production Depreciation • Short tax year support • Reclass by category – optionally retain old life/method • Bonus Depreciation (11.5.7)
Fixed Assets • Schedule/track maintenance for assets • Track insurance for assets • Manual Override for Depreciation – 11.5.8 • Mass Transfer by Category (11.5.9)
Cash Management • Cash Forecasting includes • Integration with Oracle Sales, Treasury, Projects, Payables, Receivables • Include Expense Reports not yet invoices • Bank Recon integrated with Oracle Payroll • Integration with Treasury – 11.5.8 • Intra-day reporting – 11.5.8, 11.5.9
Payables • Invoice Matching to Receipts • Match debit/credit memo to PO/receipt • Price Corrections during Matching different • Charge Allocations Window • Exclude Tax from Discount Calculation • Record Refunds • MRC and MLS • Period Close Exception Report
Payables • Validate, not approve, invoices (11.5.7) • Invoice approval workflow (11.5.8 or AP.I/J) • Requires Oracle Approvals Manager • AP.J adds Requester to screens • Create Accounting at time of transaction (11.5.9) • Transferring to GL Detail/Summary is different • Account for Payment based on pay date or cleared date
Payables • Procurement Card • Alternative name for Supplier (can query by) • Import using open interface (mandatory with AP.I) • iSupplier Portal invoice entry/inquiry • Contacts now secured by operating unit • Employee supplier update program (synchronize with Oracle HR) • IBAN – International Bank Acct Number
Receivables • Auto-Accounting from bill-to site • Review/correct errors window for autoinvoice • Credit card payments (requires Oracle Payment Server) • Refunds 11.5.7 • Consolidated Billing • Net AP/AR (via Report in commercial version) • Customer Type
Receivables • Alternative name for Customers • New Customer Merge Options • Check box to copy addresses • Credit Memo Workflow – 11.5.5 • Purchase Card – 11.5.8 • Prepayments – 11.5.8 • Party-Pay Relationships – 11.5.9 • TCA data security rules – 11.5.9
Property Manager • Track all aspects of leases • Multiple payments/billings • Multiple leases per location • Integration with Projects (via AP/AR) • Track Milestones (currently by report) • Variable Rent – 11.5.8 • Indexed Rent • Month-to-month lease – 11.5.9 • Drill-down to AP/AR – 11.5.9
Financial Suite Add-Ons • Receivables • Credit Management – 11.5.9 • Advanced Collections – 11.5.7 • iReceivables-customers view own accounts • Customers On-Line – 11.5.7 • Bill Presentment – 11.5.9 • Trade/Deductions Mgmnt – 11.5.6 • Enterprise Asset Management – 11.5.8 preventative maintenance of assets • Daily Business Intelligence 11.5.8
Financial Suite Add-Ons • iExpenses • Disconnected expense report creation using Excel – upload later to Oracle • Credit Card Integration • Receipt Management • By type, amount • Short pay if missing • Refunds • Justifications, purpose • Oracle Approvals Management integration – 11.5.8
Financial Suite Add-Ons • Treasury • Deal Administration, Settlement, Reconciliation, Accounting • Consolidate and Fund cash requirements of subsidiaries • Risk Management – works with Treasury to calculate prices and sensitivities of Financial instruments • Lease Management
Financial Suite Add-Ons • Grants Accounting/Proposal • Award Distribution – 11.5.5 • Transaction control in PA – 11.5.7 • Flexible Budget Rates – 11.5.7 • Indirect Cost Sched Override – 11.5.8 • Tab-based security – 11.5.8 • Support for External Person Type – 11.5.8
Futures – 11i.9 and beyond • OFA moves into database with materialized views • Better support for Shared Service Centers • Enterprise Planning and Budgeting
Thank you! • If you have any questions or comments please contact us: • Karen Brownfield, kbrownfield@solutionbeacon.com