Tuesday 21 June 2011

Accounting setup in Oracle General Ledger - R12

Accounting setup is used to set up the accounting structure which controls transaction processing across Oracle Financial Applications . With Accounting setup manager we can define and maintain the accounting setup for Legal Entities,
              Ledgers,
              Operating Units,
              Subledger Accounting,
              Intercompany and Intracompany Balancing, and
              Reporting Currencies

Responsibility:   General Ledger
Navigation:       Setup : Financials : Accounting Setup Manager → Accounting Setups


Click on Create Accounting setup to setup the Accounting structure.

There are three steps in Accounting setup process.

1. Assign Legal Entities: 

Here we may create or assign existing LE to the accounting structure. We need not assign legal entity if there is no legal entity context.

If legal entities are involved, we need to define separate accounting setup for each legal entity, which require it's own primary ledger. So ledgers have to be defined for each legal entity separately.

The need for other legal entity depends on Chart of Accounts, calendar, Currency, Accounting Method and Ledger processing options. If a legal entity requires any one of the above attributes to be different, a separate primary ledger is required.

Chart of accounts refers to the number of segments that a Chart of accounts structure consistes of.
Calendar refers to the type of accounting calendar that a legal entity uses. Ex: Monthly or Quarterly Calendar.
Currency refers to the primary currency that a legal entity belongs to.
Accounting Method refers to the subledger accounting methods based on the different accounting standards that a legal entity operates.
Ledger Options refers to the options that control how journals and transactiones are processed for a ledger.
Ex: Journal approval, Suspense account, Average balances, Intracompany balancing option, etc.

If we assign Legal entities to the accounting structure, we must assign specific balancing segment values to legal entities to identify and secure transactions by legal entity.


2. Define Accounting Representations: 

Here we need to define Primary and Secondary ledgers to make the Accounting representation.

Primary Ledgers are mandatory. We need to define the primary ledger for each legal entity and accounting setup.

Secondary ledgers are optional.  Secondary ledgers have to be assigned to the accounting setup or primary ledger to maintain multiple accounting representations for the same legal entity. A secondary ledger can differ in one or more of the following attributes from primary ledger.
Chart of Accounts,
Currency,
Calendar,
Accounting Convention

Secondary ledgers can be maintained at different levels such as:
Subledger level
Journal level
Balance level
Adjustments


In this step we can map the ledgers to  chart of accounts and assign currency, calendar, subledger accounting method and reporting currency.

Reporting currencies have to be assigned when you want diferent currency representation to primary or secondary ledgers.  Reporting currencies must share same chart of accounts,calendar,accounting method and ledger processing options as their source ledger. Reporting currencies can be assigned at different levels.
Subledger level
Journal level
Balance level

We can not use subledger level reporting currencies for secondary ledgers.

3. Save Accounting structure: This step is to review and complete the accounting setup.

Friday 17 June 2011

Cash Pooling in Cash Management - R12

Cash Pooling Techniques are used by the Organizations to optimize the funds by consolidating bank balances across multiple bank accounts.

Benefits of Cash Pooling Techniques:

- Minimizes the idle funds by consolidating balances
- Helps to decrease external borrowing costs and increase investment returns
- Allows users to group bank accounts into pooling structures to manage funds effectively

Oracle supports following types of cash pools:

1. Self-Initiated Physical Cash Pools:

When Organizations want to monitor individual bank account balances manually and then physically move cash to or from their accounts based on their preferences, Self-Initiated Physical Cash Pools structure can be used.

We can define the rules in pool definitions, to automatically determine when bank account transfers should be made and for what amounts.

2. Bank-Initiated Physical Cash Pools, or Zero Balance Accounts(ZBA’s):

Bank-Initiated Physical Cash Pools are used When Organizations want to sweep all end-of-day balances automatically to or from the main accounts.

This kind of services will leave zero balances at the end of way. That is the reason, Bank-Initiated Physical Cash Pools are often called as Zero Balance Accounts.

3. Notional Cash Pools:

If Organizations want to track the net balances across all accounts along with individual accounts, then Notional Cash Pools will be used.



In 11i, this functionality was available to Oracle Treasury users, but now it is supported by Oracle Cash Management in R12.


Thursday 16 June 2011

Bank model in Cash Management - R12


In R12, banks are moved into Trading Community Architecture(TCA). Now Cash Management owns the internal bank setup definition.

Benefits of new Bank Account model:
  • There is a central place to define internal bank accounts. So with centralized user interface, users can reduce the number of access points to manage bank accounts

  • With the help of Multi-Org Access Control, we can explicitly grant account access to multiple operating units/functions and users, which improves the visibility and control of bank accounts

  • A single Legal Entity is granted ownership of each internal bank account and One or more Organizations are granted usage rights. So, a single bank statement can be reconciled across multiple Operating Units, which helps to simplify reconciliation process.

  • Reconciliation options can now be defined at the bank account level, which provides more flexibility and control to the reconciliation process.

Bank structure in 11i:





Bank structure in R12:

In R12, Banks are part of TCA and the same bank accounts can be used in Payables, Receivables, Payroll and Treasury.

Impact of Upgrade:

All the internal bank accounts of 11.5.10, will be migrated into Centralized Bank model automatically during the upgrade.

Tables to store the bank information in R12:

The new tables that store bank information are now under Cash Management as follows:

CE_BANK_ACCOUNTS    
                 Contains Legal Entity Level bank account information. Each bank
                                                              account must be affiliated with one bank branch.

CE_BANK_ACCT_USES_ALL           Stores Operating Unit level bank account use information.

CE_PAYMENT_DOCUMENTS  
         Stores payment Documents to be used for Printed type Payments

CE_BANK_BRANCHES_V      
           View: Bank/Branches Info

CE_BANK_ACCT_USES_OU_V 
       View: Internal Bank Account Uses Info

The following tables were obsoleted in R12, in which Bank Data was stored in R11i:

AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNTS_USES_ALL 




In R12, Internal bank accounts can be created in Cash Management (Setup -> Banks). Where can we define Supplier (or External) bank accounts?

Supplier (or External) bank accounts can be created in Payables, by using Supplier Entry forms.  In the Payables Manager responsibility:

1. Navigate to Suppliers -> Entry.
2. Query or create your supplier.
3. Click on Banking Details and then choose Create.

After creating the bank account, we can assign the bank account to the supplier site.

Tuesday 14 June 2011

Major changes in Purchasing/iProcurement - R12


1. Requisition Creation:

• In R12 iProcurement, users can see a new button for Managing Approval Routing lists in create requisition page under Approvals stage. The functionality remains the same as in 11i, but users can add/delete approvers and can make changes in the routing sequence in iProcurement itself.

• New country field is required when entering a “one-time” ship to address on create requisitions page.         
          
• Oracle has introduced a new feature for Internal Requisitions and Internal Sales Orders. If preparer makes changes for approved Internal Requisition it will be reflected in Internal Sales Order and vice versa.

Oracle supports this feature only for few particular fields.

For Internal Requisition Oracle supports changes to the following attributes:
1. Quantity
2. Need By Date

If preparer updates any of these values, the changes will be reflected in Internal Sales Order.

Similarly, for Internal Sales Order Oracle supports changes to the following attributes:
1. Order Quantity
2. Request Date
3. Schedule Date
4. Arrival Date

If user updates any of  these values in Internal Sales Order, the requester of Internal Requisition will get notification and quantity and Need by Date in Internal Requisition changes automatically.

• In addition to this, if user cancels the Internal Requisition line, the corresponding line in Internal Sales Order will also be cancelled and vice versa.

• And finally, the urgent flag on the internal requisition line will flow onto the internal sales order line as the shipment priority, based on a profile option.


Set ups required:


To get the new functionality, processing constraints need to be disabled for internal sales orders in Order Management.
1. For 'Update Ordered Quantity' - Disable the Condition where Validate Template is "Internal Order".
2. For 'Update Requested date'   - Disable the Processing Constraint.


2. iProcurement non-Catalog Request:

• In 11i, for a Non-Catalog Request, when requester describe the purchase, there is a chance that it may not be classified into an existing commodity hierarchy. This increases the misclassification of spend information, contract leakage, lower compliance and internal controls.

• In R12, requester creating Non-Catalog requests will have the option of category being predicted for the purchase being made. After the requester clicks on “Add to Cart” they will be able to view a “suggested best fit” category with a list of categories that could be alternate possibilities.

• With this new feature,  all the unstructured requests will be categorized appropriately to aid the downstream spend analysis.
                                      
• So with the new features organizations can analyze the spending according to the Purchasing Category, which helps to easily identify the categories of items that they purchase.

Set ups required:

This feature takes the category value from Oracle Spend Classification(A new module of the Oracle BI Applications). Oracle Spend Classification is a pre requisite to get use of the new feature. Once we set up Oracle Spend Classification, when user clicks on "Add to Cart" they can see the category list for non-catalog items.

This option is not mandatory.

3. Realms:

In R12 realms are replaced by Content Security Management.

Realms from prior releases are converted to content zones.  The new Content Security model allows administrators a more flexible method to control and adjust iProcurement Content (items) available for requisitioning users. It replaces and enhances functionalities previously provided by Realms, System Profiles, Catalogs, and the Extractor.


4. Communication Process:

Oracle R12 supports FYI notifications. So, FYI notifications can be enabled for the viewers to avoid reports and alerts.

FYI notifications set up has to be done in AME. The Set up process is as follows:

1) The first step is to turn on the FYI Approver capability for the "Purchase Requisition Approval" transaction type. The navigation for this is :

1. Choose "Approvals Management Administrator" responsibility
2. In the upper right Quick Links region choose "Configuration Variables"
3. Enter the Purchase Requisition Approval transaction type and click Go
4. At the "Transaction Type" level set variable "Allow For Your Information Notifications" = Yes
5. Click Apply

2) Now go to the "Approvals Management Business Analyst" responsibility . From here choose the "Purchase Requisition Approval" transaction type and we can modify existing Rules or when we create new Rules,there will be a Category field that is now available, where we can choose "For Your Information".

For any Rule with this choice, the approvers that are returned are FYI and their approval response is not required. They are only notified with FYI notification.

This feature is available only at the Rule level. So to have FYI notifications and regular response required Approval Notifications send to other approvers, multiple AME Rules have to be created.

  

How Data Access Sets & Security Rules work together - R12 General Ledger

Data Access Sets:

Data access sets control, which ledgers can be accessed by different responsibilities. Data access sets can also limit a user from accessing certain balancing segment values or management segment values or grant read–only or read and write access to data in a ledger. 
 
It provides security in 3 levels.
 
1. Full Ledger - Provides access to whole Chart of Accounts. This is required to perform certain operations such as opening and closing periods, creating summary accounts, creating budgets, and performing mass maintenance. Full ledger access provides full read and write access to the ledger and all of its balancing segment values and management segment values.
2. Balancing Segment Value - Provides access to specific balancing segment values
3. Management segment value - Provides access to specific management segment values
 
 
 - Data Access Sets is mandatory in R12. But defining Data Access Sets is optional. That means if users do not define Data Access Sets, system creates it  with full access automatically when a ledger or ledger set is created.
 
 - Users need to define Data Access Sets, it they want security at balancing segment or management segment value level
 
 - We can assign multiple ledgers or ledger sets to a Data access set, which share the Chart of Accounts and Calender/period type combination.
 
 - To prevent potential errors in processing, we need to make sure at least one responsibility has a data access set assigned with full ledger access.
 
Data Access Sets & Security Rules:

Data Access Sets work with Segment Value Security Rules and Cross–Validation Rules. If we have defined Segment Value Security Rules that prevent certain responsibilities from accessing certain segment values, those rules are combined with data access set security.

For example, if user defined Segment Value Security rules to exclude Balancing Segment Value 01 and then defined data access set security that provides read-only access to values 01–03, the user assigned to this responsibility would not be able to read segment value 01 due to the Segment Value Security rule.

Major changes in AP - R12


1. Supplier Creation and Maintenance:

In Oracle R12, Suppliers are now part of TCA(Trading Community Architecture), where suppliers are defined as parties and supplier sites as party sites. Each supplier, supplier sites and contact details can be defined globally in TCA level. It means, any changes to supplier/supplier sites/address reflects across Operating Units with out really updating every OU and all the supplier information can be leveraged by multiple Operating Units. Supplier bank information can also be handled at TCA level.

In Release 12, there is a new user interface for suppliers entry and maintenance. When user opens Supplier entry form, Oracle automatically redirects the page to TCA with a jsp form.

Impact of Upgrade:

1. During the upgrade from 11i to R12, TCA party and party sites records are created and updated in TCA for all the existing suppliers and supplier sites.             
2. TCA data model requires country and address information for suppliers, which will be used by E-Business Tax. If there is no country or address information specified to a supplier site, Oracle automatically infer the data based on most frequently used site from the supplier's historical transactions.
3.Oracle Payables reviews the supplier sites and determines duplicates, based on         supplier,address,city,province, state, country, zip and language and creates only one party site for each distinct supplier site address.
4. In 11i the employees are associated with Payables as internal suppliers to create the payments for their expense reports. During migration of data, for internal suppliers, only party will be created in TCA and employee address will not not be migrated to party site and the data remains in HRMS records for data security.
5. As the supplier objects are moved from AP to TCA, the tables related to supplier, supplier site, and supplier address are obsolete in R12 and views are created with the obsoleted table names to link the information from old tables with information in TCA.

Table Changes:


AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, AP_SUPPLIER_CONTACTS, AP_SUPPLIER_INT_REJECTIONS are the new tables introduced to replace obsoleted tables PO_VENDORS, PO_VENDOR_SITES_ALL, PO_VENDOR_CONTACTS

2. Invoice Entry & Cancellation:


In Oracle R12, there is an additional level of detail called Invoice lines between Invoice Header and invoice distribution to capture the data related to Items, freight, miscellaneous, Tax, Prepayment or withholding tax. An invoice line can have one or more invoice distributions.
                                                                                                                                                               With the introduction of invoice lines, there is lot of significant improvement in the data flow to other modules which are integrated with Payables.
For example: 1. Fixed Assets use the data stored in the Invoice lines fields such as Manufacturer, Model,  Serial Number, Warranty Number, Asset Book and Asset Category to track the assets.
                     2. E-Business tax takes information from the AP invoice lines and creates summary and detail  tax lines in E-Business tax repository.
                     3. Sub ledger Accounting require the invoice distributions should be stored at the maximum level of detail. With additional level in the invoice hierarchy, data flow will be improved to the Sub ledger accounting.

Impact of Upgrade:

During a upgrade one invoice line will be created for every distribution for existing data in 11i.


Cancellation of Invoices:

An invoice line may be discarded on its own or as a part of invoice cancellation. A discarded invoice line will have an amount as 0, marked as discarded and creates a negative respective transaction in the distributions. If a line is discarded as a part of invoice cancellation it will be marked as cancelled.

Recurring Invoice:

In Oracle R12,For Recurring invoices,  invoice definition and line definition are introduced in place of template definition.  In line definition additional information such as Item description, Manufacturer and Model number are included. This will be helpful in smooth data flow to the integrated modules. In addition to Invoice definition and line definition few more tabs are introduced namely Tax, Control and Payment. E-business tax uses the data in Tax ad Payment module uses the data from payment tab on recurring invoices window.

Table Changes:

AP_INVOICE_LINES_ALL              New table introduced to represent the data stored in invoice lines
AP_CHRG_ALLOCATIONS_ALL    Obsolete and now distributions itself represent the allocation of charges


3. Payment Process:

In R12, Oracle Payments is a new module introduced to centralize the payment process into one payment engine, so that multiple applications can leverage the same functionality. In R12 Payables, user can find Payments manager under payment entry, which will re-direct the page to a OAF page. So unlike in 11i, user need to use Payables Payments dashboard to begin the payment process.

Build Payment Batch:


The first step in the payment process is to submit a Payment Process Request(PPR), which replaces Build payment Batch in Release 11i. The Payments Process Request form enable users to set invoice selection criteria. This form consists of various tabs such as Scheduled payment Selection Criteria, Payment Attributes, User Rates, Processing, Validation failure result and additional Information to specify the required criteria for payment processing.

Format Payment Batch:

Payment Process Request will be formatted automatically after submitting the Payment Process Request form. Users can check the status of PPR under Payment Process Request status.

Confirm Payment Batch:

When users click on start action icon, the form takes user to Payment Process Instructions tab, where users can confirm the batch if it is printed correctly, by clicking on 'Record Print Status' button. Here the module name changes from Payables to Payments.


>  There are no different processes  for payment and payment batch in R12. Same screen and process can be used for both .
> If user selects Payee under Scheduled payment Selection Criteria tab in the Payment Process Request  then  single payment will be done for a selected payee. If user leaves it blank, payment will be done to all suppliers.

> All Payment related setups are now moved to Oracle Payments.


4. Create Payment Instructions:

In R12 there are two programs to create payment instructions:

Create Electronic Payment Instructions    for Electronic Payments
Create Printed Payment Instructions        for Check payments

We can run these programs automatically or manually by selecting an option in the Build Payment process.

5. Transmit Payment File to Banks:

As part of R12 , there is a check box in the "Payment System" set up . When enabled the check box " Automatic Transmit of File" - This would transfer the file to bank automatically.

There are few new set ups that needs to be done in the R12.
1. Payment System - External organization ( Internal bank) needs to be set up.
2. Transmission Configuration - This includes the ftp details and how to pull the flat file from a particular location.

6. Banks:

> Bank accounts are moved into TCA architecture which needs to be defined in R12
> Cash Management now owns Banks Set up Definition.
> All the internal bank accounts of 11.5.10, will be migrated into Centralized Bank model automatically during the upgrade.


7. Transfer journal entries to General Ledger:


Users can transfer journal entries to General Ledger in two ways.                                       
1. Run Create Accounting Program with Transfer to GL option as Yes.                          
2. Run Transfer Journal Entries to GL after running Create Accounting Program with Transfer to GL parameter set to NO or after create accounting online in Final mode.

Create Accounting Program:

Payables Accounting Process is obsolete in R12 and is replaced with Create Accounting program. The create accounting program creates sub ledger journal entries by processing eligible accounting events. The Create Accounting program uses application accounting definitions, which are created in Accounting Method Builder(AMB) to create sub ledger journal entries.

The Create Accounting program
1. Creates and validates sub ledger journal entries.
2. Transfers the final journal entries in the current batch run to General Ledger and starts General Ledger Posting Process.
3. Generates Sub ledger Accounting Program Report.

The create Accounting program creates journal entries in three modes.

Draft: Users can create the journal entries in SLA in draft mode and can review and make changes again.

Final: With this option users can create journal entries in SLA which can not be modified again. Here users need to run Transfer Journal Entries to GL to post the subledger journal entries to GL.

Final Post: With this options users can create the journal entries and post to GL with out using Transfer Journal Entries to GL program.

Transfer Journal Entries to GL:


Payables Transfer to General Ledger program is obsolete in R12 and is replaced with Transfer Journal Entries to GL. The Transfer Journal entries to GL program enables users to transfer eligible journal entries to GL, including those from the previous run that have not yet been transferred to GL.

This program is used when the Create Accounting program is run with Transfer to GL parameter set to NO or after create accounting online in Final mode.
                                                                                                                                                                      
8. Invoice Approval Workflow:

Invoice work flow has been enhanced to include line level invoice approval. Based on rules setup for Payables Invoice Approval Transaction Type in AME, the work flow determines if the invoice Header (invoice document) needs approval or invoice lines needs approval or both. If both invoice lines and document need approval, all the lines of the invoice requiring approval must be approved before the invoice document can be approved.                                                                  
                                                                              
The approval  status both at header level as well as line level shows whether the invoice document or invoice lines need approval or not.     

Setup:

> The item class provided in defining rule in AME determines whether this rule effects the invoice document approval or invoice line approval.
> If item class is given as Header, this rule govern the invoice document approval and if given as line item, would govern the invoice line approval. Remaining all setups in AME are same as in 11i.

Changes in Tables: 

In R12, there are 2 history tables for invoice approval.                                                                                               
   1.     AP_APINV_APPROVERS                Stores the line level approval history            
   2.     AP_INV_APRVL_HIST_ALL              Stores both Header and line level history.



Monday 13 June 2011

Collection Element 'REV' has no LOV in R12 Oracle Quality


In Oracle Quality module, the Quality Element 'Revision' on Enter Quality Results window has no list of values after R12 upgrade, where it was available in 11i. The users who want to capture the 'Revision' for an item on quality plans have no option to select the list of values for Revision. 

According to Oracle, this is expected functionality in R12. The Item revision collection element would be enabled and editable only for a Revision controlled Item. 

The behavior in 11.5.10 was a bug because of which even though the revision field was grayed out, the user could still enter Revision values by invoking the LOV. This was fixed in R12.

The following are the three possible options available to resolve the issue:


Srl# Option Remarks
1 Activate “Revision Control Code” for the items in question:
All items for which Revision needs to be captured in the Quality Collection Plan’s results, using an LOV, we need to active the Revision Control code for the items in inventory.
The drawback of this option is that all material transactions would mandate the entry of Revision of the item, which makes it very cumbersome for the Inventory and other modules’ users.
Hence, may not be a viable option
2 Go with the new functionality suggested by Oracle This also may not be a good option if users need to capture the Revision of items on QC plans
3 Creation of a new Quality Collection Element that has the capability of accepting Revision of items;
In this option, the “Revision Control” code for items need not be activated.
This workaround would enable the users to capture Revision of items during the entry of Quality Results.
This option is explained in detail in the subsequent section.
  
Solution for Option 3: Create new collection Element

  1. Create a new collection element with SQL Validation statement to populate the LOV. The following screen shot show the details of the new custom collection element to be created
     Navigation:  Quality Setup Collection Elements



The “select” statement to fetch the item’s revisions within the LOV is as under: 

  
2.   Identify all the QA Plans that use the standard / seeded QA element “Revision” for all the inventory organizations 

3.   Add the new custom QA element to all the QA Plans (stored in the table QA_PLAN_CHARS) identified in step 2. This could be programmatically done using an open API

4.  Using standard APIs, copy the existing data present in the “Revision” column of QA_RESULTS table into the column of newly added “custom revision” of the same table. Once the change is activated, the data captured under the new “custom revision” column would be stored in one of the custom (user-defined) columns titled CHARACTER1 through CHARACTER100. 
 
5.   Finally, once the copying of the Revision data is completed into the QA_RESULTS table (via Oracle APIs), nullify the data in “Revision” column
 
6.   Modification of Reports: All reports (Oracle Reports / SQL / Discoverer based) that were referring to “Revision” column should now be referring to the custom / user-defined columns defined for the new “custom revision” QA collection element.










Period-End Process

Period-End process is performed at the end of each period(depends on the organization). It is very important in any organization because if the period is not closed, the accounting for that period can not be closed, which will affect the financial results reporting of the respective period.
One can not close any module without following the order.The suggested module wise sequence to be followed for Period-End process is as follows.

1. Projects
2. Payables
3. Purchasing
4. Assets 
5. Receivables
6. Inventory
7. General Ledger

Accounting entries in Purchasing, Payables and Receivables

When we enter transactions in Purchasing, the accounting entries will get generated with respect to the following accounts.

1. When Creating a receipt:
Inventory Receiving A/C DR
Accrual Account CR

2. At the time of Receiving transactions:
Asset clearing A/c or Inventory valuation a/c DR
Inventory Receiving A/c CR

3. When a Payables invoice matched with PO:
Accrual A/C DR
Liability A/c

4. when asset addition done:
Asset A/c DR
Asset Clearing A/c CR(Asset item)
           (OR)
expense a/c DR
inventory Valuation A/C(Inventory item)


When we enter transactions in Payables, the accounting entries will get generated with respect to the following accounts.

1. Invoice: When we create accounting for an invoice, the accounting will be generated with respect to the following accounts.

Item Expense A/C      DR
Liability  A/C             CR

2. Payment: There are two stages in which the accounting may generate, based on the accounting option that we setup in Payables.
  
> Direct Pay-No Clearance: In this stage, there will be no clearance process separately and the cash account will get credited directly.

Liability  A/C    DR
Cash  A/C         CR

> Pay and Clear: In this stage, the payment and clearance process will have separate accounting entries.

At the time of Payment:

Liability A/C               DR
Cash Clearing A/C      CR

At the time of Clearance:

Cash Clearing A/C    DR
Cash A/C                  CR

 When we enter transactions in Receivables, the accounting entries will get generated with respect to the following accounts.

1. Accounting for invoice:
Receivables A/C DR
Revenue Account Cr

2. Credit memo:
Revenue Dr
Receivables A/C CR

3. Receipts:
Cash A/C DR
Receivables A/c CR

Thursday 9 June 2011

R12 Upgrade Vs Re-implement:


When a company is planning to adopt R12 from previous versions, the first question arises is whether to Upgrade or Re-implement?

First let us see what is the difference between an upgrade and re-implement.

An R12 upgrade involves running the scripts on a database to transform it into R12 structure. During the upgrade all the data will be moved to the respective  tables in R12.

A re-implementation involves creating a completely new oracle applications installation, doing all the set-ups from scratch and moving the data using data conversions to the new R12 database.

Let us see the advantages and disadvantages of an upgrade and re-implement

Upgrade:

The major advantages of an upgrade process are:

1. The upgrade process has become easy as the technology, tools and the upgrade scripts are significantly improved
2. There will be no effort of data conversions and testing, as the data will be moved during the upgrade process
3. Not many customizations are needed
4. No changes in the functional setups
5. Upgrade is often cheaper as it involves significantly less work for setting up the applications

But an upgrade process requires very significant effort technically and is more challenging. In comparison with re-implementation process an upgrade is risky in technical perspective.


Re-implement:

The main advantage with Re-implementation process is that the technical risk is low when compared with an upgrade.

Disadvantages:

1. Re-implementation process is very extensive as the data conversions and testing is involved.
2. Lot of effort is needed for application configuration.


Organizations generally go for following considerations before going for the re-implementation.

1. There are major changes in the Organization structure or business processes, and the existing application configuration doesn't fit for the business
2. There are lot of customizations that can be avoided with the new features and functionality
3. The original implementation has disturbed and unusable.
4. There is lot of bad data exists.