1 / 41

Oracle R12 Upgrade

Oracle R12 Upgrade. Go Live Tuesday (Dec. 14). Administrative Information Systems Team Oracle R12 Revision Date: December 6, 2010. Experience Oracle R12. Central Financial Services. Oracle R12 Upgrade. Welcome Presenter: Rob Andrews, CFS. Oracle R12 Upgrade. Go Live Tuesday (Dec. 14).

georgianne
Download Presentation

Oracle R12 Upgrade

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle R12 Upgrade Go Live Tuesday (Dec. 14) Administrative Information Systems Team Oracle R12 Revision Date: December 6, 2010 Experience Oracle R12 Central Financial Services

  2. Oracle R12 Upgrade Welcome Presenter: Rob Andrews, CFS

  3. Oracle R12 Upgrade Go Live Tuesday (Dec. 14) Agenda: • Welcome – Rob Andrews, CFS • Oracle • Across the Board Changes – Rob Andrews, CFS • Oracle • Discoverer data warehouse • General Ledger – Sandy Catalan, CFS • Purchasing Operations – Gina Smith, Purchasing • Open Discussion/Q&A

  4. Oracle R12 Upgrade Across the Board Changes Presenter: Rob Andrews, CFS

  5. Oracle R12 Upgrade Oracle Across the Board Changes - Oracle • Preparing for R12 • Training events • System downtime • New or improved features • Look and feel • Report output: templates & republishing • Visual accessibility options available, contact fse@ohsu.edu • Changes • Navigation page • Questions?

  6. Oracle R12 Upgrade Oracle Training Events • Register in TrainingForce, https://trainingforce.ohsu.edu/registration/

  7. Oracle R12 Upgrade Oracle System Downtime

  8. Oracle R12 Upgrade Oracle • Navigator Appearance on Oracle Applications Home Page • Look and feel • Color change • Worklist

  9. Oracle R12 Upgrade Oracle • Navigator Appearance on Base Apps Form • No change other than color change

  10. Oracle R12 Upgrade Oracle • Report Output: Templates & Republishing • PDF and Excel formats may be available – select Options

  11. Oracle R12 Upgrade Oracle • Locate Template Options • Select Template Name • Verify Format matches the template style selected

  12. Oracle R12 Upgrade Oracle • Modify Report Format Post Completion • Select Tools > Reprint/Republish

  13. Oracle R12 Upgrade Oracle • Verify Template Name Matches Output Format • Select Template Name dropdown list to view available formats • Select the preferred template

  14. Oracle R12 Upgrade Oracle • Print Report • Select Copies > Apply

  15. Oracle R12 Upgrade Discoverer Across the Board Changes - Discoverer • Preparing for R12 • Extract skip • New or improved features • Password change • Changes • Ledger name vs. set of books • Questions?

  16. Oracle R12 Upgrade Discoverer • Extract Skip • Friday (Dec. 10) through Sunday(Dec. 12) • Up-to-date information expected Tuesday (Dec. 14)

  17. Oracle R12 Upgrade Discoverer • Password Change • Access to HRDW only? • You can now reset your own password • Access to other data warehouses (e.g. APDW, GLDW, etc.) ? • You no longer need to log in to Oracle • Link to reset password will be available at Discoverer AIS web page, http://ozone.ohsu.edu/finance/discoverer.cfm

  18. Oracle R12 Upgrade Discoverer • Ledger Name vs. Set of Books • New field, Ledger Name • Existing field, Set of Books remains

  19. Oracle R12 Upgrade Discoverer • Future of Set of Books Field • Short term - Set of Book field and parameter remain • Long-term - replace Set of Books field with Ledger Name • Create new reports using Ledger Name

  20. Oracle R12 Upgrade General Ledger Presenter: Sandy Catalan, CFS

  21. Oracle R12 Upgrade General Ledger • Preparing for R12 • Early close schedule • November reports available Friday (12/10); one day early • New or improved features • Sub-ledger Accounting (SLA) • Definition, Events, Structure and Journal Drilldown • Changes • Reports • Close Other Forms Function • Outstanding issues or limitations • After go-live • Questions?

  22. Oracle R12 Upgrade • General Ledger Early Close

  23. Oracle R12 Upgrade General Ledger Subledger Accounting (SLA) Often referred to as SLA Provides a common repository of all your accounting information Behaves like a detailed version of your general ledger (GL) Allows the GL to be free of extraneous data; stores only what is needed for GL reporting and analysis Go directly to SLA to view detail

  24. Oracle R12 Upgrade General Ledger SLA Architecture Allows businesses to create and modify accounting definitions to meet specific fiscal, regulatory and analytical requirements SLA is driven by events Accounting events represent transactions that have a financial accounting impact

  25. Oracle R12 Upgrade General Ledger E.g. of an Invoice Event

  26. Oracle R12 UpgradeGeneral Ledger Differences between 11i and R12

  27. Oracle R12 UpgradeGeneral Ledger Reconciliation between R11i and R12

  28. Oracle R12 UpgradeGeneral Ledger Reports *At go live Accounts Payable detail will be available; additional subledger detail available post go live. **Report not available in GL Inquiry OHSU AIS responsibilities; report to be utilized if the detailed lines on the Account Analysis – SLA - Secure report do not tie to general ledger balances

  29. Oracle R12 UpgradeGeneral Ledger Reports (cont.) ***Download reports will work for historical data; new downloads/reports in development for post go live data.

  30. Oracle R12 UpgradeGeneral Ledger Drilldown from General Ledger

  31. Oracle R12 Upgrade Oracle Close Other Forms Function Recommend user set the Close Other Forms to unchecked for best General Ledger performance The Close Other Forms can be found on the main navigation form (Tools > Close Other Forms) Value is defined by user

  32. Oracle R12 Upgrade General Ledger Outstanding Issues Bug when user drills down on Cost Management WIP transaction. Error message will disappear if user selects OK. System will enable drilldown to the transaction. Distribution button not available on the Material Transactions form when drilling from a General Ledger Cost Management MTL journal entry.

  33. Oracle R12 Upgrade General Ledger Outstanding Issues (cont.) Export Feature in SLA fails to export the first line of the journal entry If there is only one line of data, system will provide the user with an error message If there are numerous transactions, system will export all data excel except the first line SLA is currently set to display 10,000 journal lines. If default is exceeded, not all transactions will be visible

  34. Oracle R12 Upgrade Purchasing Operations Presenter: Gina Smith, Purchasing

  35. Oracle R12 Upgrade Purchasing Operations • Preparing for R12 • Rejected or returned requisitions • New or improved features • View invoices from PO Summary • Changes • Requisition to Pay Reports do not migrate to R12 • Operating Unit field on Requisition & PO forms • After go-live • Notifications for Rejected/Returned requisitions • The Expenditure Type field nulls out when entering Project related information at the Distribution level on Requisitions • Questions?

  36. Oracle R12 Upgrade Purchasing Operations Rejected or Returned Requisitions • In Process documents will be rejected (requisitions) or returned (purchase orders) on Friday (Dec. 10) • Resubmit for approval post go-live (Dec. 14)

  37. Oracle R12 Upgrade Purchasing Operations View Invoices from PO Summary (Inquire > View Invoices) • You can now drill into more invoice detail

  38. Oracle R12 Upgrade Purchasing Operations Requisition to Pay Reports do not migrate over to R12 • Requisition to Pay Reports by Requisition • Requisition to Pay Reports by Purchase Order • Requisition to Pay Reports by Invoice

  39. Oracle R12 Upgrade Purchasing Operations Operating Unit Field • The Operating Unit field is now the first field on the Requisition/PO Summary forms and on the Requisition/PO forms (something to be aware of when entering Requisition or PO numbers)

  40. Oracle R12 Upgrade Go Live Tuesday (Dec. 14) Open Discussion

  41. Oracle R12 Upgrade Go Live Tuesday (Dec. 14) Administrative Information Systems Team Oracle R12 Thank you for attending the Oracle 12 Experience presentation. Please direct questions to: Financial Support & Education, fse@ohsu.edu Disclaimer: Oracle is the source of screen shots contained in this presentation. Central Financial Services

More Related