Pre – Upgrade Functional Steps — First Darft

¦ Oracle General Ledger

  • Run Accounting Setup Manager Diagnosis for MRC

The Accounting Setup Manager replaces many forms and user interfaces in this release. We recommend that you run the Accounting Setup Manager Pre-Update Diagnosis report to identify potential incompatibilities that would prevent you from using some new features. The report identifies Release 11i setup for Multiple Reporting Currencies, General Ledger, Global Accounting Engine, Assets, Payables, and Receivables. In order to run this report successfully, apply patch 5259121 to your Release 11i APPL_TOP. To access the report, run the Accounting Setup Manager Pre-Update Diagnosis report in the Standard Request Submission form from a General Ledger responsibility. Review the report and fix any setup it identifies as problematic. Note that modifying setup configurations is not easily done after the upgrade is complete.

  • Run the Accounting Healthcheck found in Note 416699.1 on My Oracle Support and Misclassified accounts (if available)
  • Resolve any issues that arise
  • Run the Segment Value Inheritance Program when changes are made tothe segment qualifiers for segment values of the chart of accounts.
  • Next, complete all your period close actions/processes. This is the time to validate and account for as much data as possible and make sure that everything is transferred to GL
  • Run the General Ledger Period Closing diagnostics test to verify that a ledger period is ready to close.
  • After successfully closing your period, run your standard reconciliation and account balance reports and resolve any issues that arise
  • run the Accounting Healthcheck again and resolve any remaining data issues
  • Check and Clear GL_interface Tables for duplicate, error and unprocessed events.

¦ Oracle Payables

  • Import all invoices from the Payables open interface.

In this release, global descriptive flex fields (GDFs) are obsolete and are moved into tax and payment columns. Several validations are performed based on the country the invoice is imported from on these GDFs. They are not upgraded in the open interface tables. Import all invoices that have not yet been imported by running the Open Interface Import program on the 11i APPL_TOP. Resolve any rejections and resubmit the program until all invoices are imported.

  • Confirm or cancel all Unconfirmed Payment batches.

With the introduction of Oracle Payments, the new payment batch model is not compatible with 11i payment batches. To ensure that there are no in-process payment batches included in the upgrade processing, either confirm or cancel all payment batches before you begin.

Subledger Accounting (only if you they have subledger acounting).

  • TUMS step key: N/A

During the upgrade, existing accounting data from the subledgers is upgraded into the new Oracle Subledger Accounting data model. By default, the upgrade updates the data for the current fiscal year, as well as the necessary periods of the previous fiscal, to ensure that there are at least six periods included in the upgrade (occurs when the upgrade is performed in the first half of the fiscal year).You may need to run the SLA Pre-Upgrade program if you are using Oracle General Ledger and at least one of the following subledgers: Assets, Cost Management, E-Business Tax, Payables, Receivables, or Projects Accounting. This optional program allows you to change the default number of periods of historic data to be upgraded. You can define a larger range of periods to be upgraded, and you can decide to perform the upgrade for all or most of the data during the downtime phase. This is an important decision because some of the Oracle Subledger Accounting functionality, such as accounting reversals and business flows, rely on the existence of previous accounting
If you do not perform a complete upgrade of the accounting data, Oracle Subledger Accounting allows you to perform an additional upgrade of the data by running the SLA post-upgrade process whenever the missing data is required (see Subledger Accounting, page G-9 in Appendix G, page G-1). This program is executed at the same time as daily operations. As a result, it may have an impact on overall system performance.
If you need to change the default number of periods of historic data to be upgraded, you must apply patch 5233248 to your Release 11i APPL_TOP and submit the SLA Pre-Upgrade program. When submitting this program, you can enter the following parameters
• Migrate all sets of books: Possible values are Yes (SLA Pre-Upgrade program updates the periods in all sets of books) or No (SLA Pre-Upgrade program updates the periods that belong to the selected set of books).
• Set of books: Set of books to be upgraded where you have selected to upgrade one set of books.
• Start Date: Date to be used to determine the first period to be upgraded. Does not have to be the starting date of a period – the initial period is determined as the first period in which this date falls.

  • Run the Payables Accounting Health Check script (My Oracle Support Doc ID 416699.1 to ensure that there are no inconsistencies in your 11i data.
  • Reslove any issues that araise.
  • Next, complete all your period close actions/processes. This is the time to validate and account for as much data as possible and make sure that everything is transferred to GL
  • run the Accounting Healthcheck again and resolve any remaining data issue.
  • please run the needed reports to balance within PayablesTrial Balance, Posted Invoice Register, and Posted Payment Register reports. You’ll also need to run the Account Analysis in General Ledger and reconcile that to Payables.

¦ Oracle Receivables

  • Run Accounting Healthcheck
  • Import/Clear All AR interfaces.
  • Ensure that the Create Accounting program in Receivables has successfully completed.
  • Resolve any issues that arise
  • Review the Un-posted Items reports to confirm that all items are posted to the General Ledger
  • Review the Posting Execution Report to check that journal entries transferred from Receivables are successfully posted to the General Ledger. Receivables automatically prints the Posting Execution Report that displays a summary line for each currency within every category of transaction that you transfer.
  • Next, complete all your period close actions/processes. This is the time to validate and account for as much data as possible and make sure that everything is transferred to GL
  • run the Accounting Healthcheck again and resolve any remaining data issue.
  • The following steps are recommended for reconciliation of Receivables with General Ledger:
  • Run the Receivables Reconciliation Report as the first step in the reconciliation process. It displays summary information consistent with detailed registers and journal reports. It also displays transactional data in an Activity column, and accounting data in a Journal column. If any discrepancies exist, run the following reports for more details:

Transaction Register versus Sales Journal Adjustment Register versus Adjustment Journal Applied Receipts Register versus Journal Unapplied and Unresolved Receipts Register versus Journal Invoice Exception Report Run the Ageing – 7 Buckets – By Account OR the Ageing – 4 Buckets report to view beginning and ending customer balances, and to compare with AR Reconciliation Report balances. Run the Journal Entries Report after completing Create Accounting (Final Accounting) to show the accounting data transferred to Subledger Accounting. This should be matched with the AR Reconciliation Report to ensure that Receivables versus Subledger Accounting reconciliation is done.
Run the AR to GL Reconciliation Report to ensure that there are no differences. Run this report after transactions in Receivables are posted to General Ledger and there are no unposted transactions per the “Unposted Items” report. This report compares the account balances in Receivables to those in General Ledger and highlights the journal sources where discrepancies might exist.

¦ Oracle Cash Management.

reader’s Input required

¦ Oracle Fixed Assets.

  • By default, transactions in the current fiscal year in Assets books will have their accounting lines migrated to the Subledger Accounting model. Accounting for current period depreciation will be upgraded only if depreciation has already run for the period, and the period remains open. After the upgrade, you can run the SLA post-upgrade process to update accounting for past transaction data as needed.
  • Important reports such as the transaction diagnostics report and reconciliation reports should be run before closing the period to ensure that the accounting entries are reviewed and verified.

¦ Oracle Purchasing.

reader’s Input required

¦ Oracle Order Management.

reader’s Input required

¦ Oracle Project Costing and Project Billing.

  • Complete distribution, transfer, and tieback of expense reports (conditional)
  • If you create expense reports using Pre-Approved Expenditure Entry or import unaccounted expense reports from external systems, then run the following concurrent programs for each operating unit that uses Oracle Projects as a source entry point for expense report creation, adjustment, or both:

• PRC: Distribute Expense Report Costs2-18 Oracle E-Business Suite Upgrade Guide

• PRC: Interface Expense Reports to Payables • Expense Report Import (must be run from the Payables responsibility)

• PRC: Tieback Expense Reports from Payables Your Projects application specialist should ensure that all transactions are successfully interfaced and that no exceptions remain.

  • Complete transfer and tieback of cost, cross charge, and revenue (conditional)
  • Run the following concurrent programs for each operating unit implemented in Oracle Projects and Oracle Grants Accounting. Ensure there are no exceptions.

• Journal Import: Complete Journal Import in General Ledger for all project journal sources

• PRC: Tieback Labor Costs from General Ledger.

• PRC: Tieback Usage Costs from General Ledger.

• PRC: Tieback Total Burdened Cost from GL.

• PRC: Tieback Cross Charge Distributions From General Ledger (does not apply to Grants Accounting).

• PRC: Tieback Revenue from General Ledger.

¦ Oracle Property Manager.

reader’s Input required