Wednesday, July 3, 2013

Issues When Upgrading Oracle Apps from 11i to R12

If you are starting or thinking of starting your Oracle R12 upgrade, you are probably wondering what type of issues other companies had with their upgrade.  It’s been about six months since I was the project manager on a 11i to R12 (12,1.1) upgrade.  Here’s a list of the modules that were upgraded:
  • General Ledger
  • Payables
  • Fixed Assets
  • Receivables
  • i-Receivables
  • Projects
  • Purchasing
  • Inventory
  • E-Business Tax
  • HR (shared install)
This upgrade seemed to focus around new functionality in Payables (or the Payments module), the integration of E-Business Tax, and addition of Subledger Accounting processes.  From our 3 test cycles, we found 182 issues.
Resolution TypeTotal
3rd Party Configuration7
Customization25
DBA Action11
Module Configuration22
Oracle Sys Admin Config.30
Patch28
SQL Script4
Training55
Grand Total182
As you can see, most of the issues were training related (30%).  If you look by module, Payables almost had half of the issues followed by Receivables.  This makes sense because in R12 payments and receipts are now processed differently.
Resolution TypeAPARFAGLINViRECPAPOSYSTAXTotal
3rd Party Configuration211217
Custom Code12318125
DBA Action22411111
Module Configuration752121422
Sys Admin Config.145211121330
Patch106321212128
SQL Script2114
Training305542121555
Total7927151141269910182

No comments:

Post a Comment