Transcript Release 11i New Features

Oracle Applications Release 11i
Financials New Features
Karen Brownfield, Solution Beacon
Solution Beacon
Atlanta OAUG
November 20, 2003
www.solutionbeacon.com
1
© 2003 Solution Beacon, LLC. All Rights Reserved.
Introductions / Experiences
 Karen Brownfield
 Working with Oracle Applications over 12 years
 OAUG Director 11 years and Past President
 IOUC Pricing Council
2
© 2003 Solution Beacon, LLC. All Rights Reserved.
Audience Profile
 Current Release
 10.7
 11.0
 11i.x
3
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
4
© 2003 Solution Beacon, LLC. All Rights Reserved.
11i Terminology
 Mini-Pack
 Consolidated patches for a product
 Alphabetically named – PN.H, AP.I
 Patches
 Fix specific bug
5
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
6
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
7
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
8
© 2003 Solution Beacon, LLC. All Rights Reserved.
11i Point Release Features
 11.5.9 CD/User
Guides
 Accessed via
Metalink, EBusiness 11i,
Documentation
 Requires OTN
userid/password
9
© 2003 Solution Beacon, LLC. All Rights Reserved.
11i Point Release Features
 11 and 11.1.1 thru 11.1.8 User Guides
 Accessed via Metalink, E-Business 11i,
10
Documentation
 Requires OTN userid/password
© 2003 Solution Beacon, LLC. All Rights Reserved.
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]
11
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
12
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
13
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
14
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
15
© 2003 Solution Beacon, LLC. All Rights Reserved.
All Products

New Personal Home
Page – 11.5.9
 Notifications
 Favorites cross
Responsibilities
 Responsibility
menu – click
direct to screen
16
© 2003 Solution Beacon, LLC. All Rights Reserved.
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

17
© 2003 Solution Beacon, LLC. All Rights Reserved.
Financials Suite
 Family Pack D is 11.5.9 - released March
2003
 View Accounting
 T-Accounts
 Account Generators are now workflows
 Web ADI
18
© 2003 Solution Beacon, LLC. All Rights Reserved.
Federal Financials
 FACTS I, II Reporting– 11.5.7/11.5.8
19
 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
© 2003 Solution Beacon, LLC. All Rights Reserved.
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)
20
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
21
Security by COA (11.5.9)
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
22
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
23
© 2003 Solution Beacon, LLC. All Rights Reserved.
General Ledger Process Flow
24
© 2003 Solution Beacon, LLC. All Rights Reserved.
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)
25
© 2003 Solution Beacon, LLC. All Rights Reserved.
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)
26
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
27
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
28
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
29
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
30
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
31
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
32
© 2003 Solution Beacon, LLC. All Rights Reserved.
Property Manager
33
 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
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
34
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
35
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
36
© 2003 Solution Beacon, LLC. All Rights Reserved.
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
37
© 2003 Solution Beacon, LLC. All Rights Reserved.
Futures – 11i.9 and beyond
 OFA moves into database with
materialized views
 Better support for Shared Service
Centers
 Enterprise Planning and Budgeting
38
© 2003 Solution Beacon, LLC. All Rights Reserved.
Thank you!
If you have any questions or comments please contact
us:
Karen Brownfield, [email protected]
39
© 2003 Solution Beacon, LLC. All Rights Reserved.