Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Integration and Information Flow from OIC to Oracle E Business Suite

Posted on June 25th, 2009 by Sanjit Anand ||Email This Post Email This Post

OIC is fully integrated with following Oracle E Business Suite modules:

Transactions are primarily collected from Oracle Receivables and Oracle Order Management. Oracle Incentive Compensation transactions can originate from a sales order, a customer billing, a customer payment, or other business functions.

  • Oracle Order Management is used to collect booked orders and adjustments to booked orders
  • Oracle Receivables is used to collect invoices, credit/debit memos, Payment postings and take back postings etc
  • Oracle Payables is used to pay people who are not full-time, regular employees.Oracle Payable recognizes resources for payment only if they are activated as suppliers.
  • Oracle Payroll is used by application to pay the employees
  • Oracle Human Resource / Resource Manager is where you must first create employees in order for them to be paid compensation in Oracle Incentive Compensation. After creating employees in Human Resources, you then import these records into Resource Manager to create resources
  • Oracle Territory Manager provides integration with the Territory Assignment Engine for Sales Credit Allocation
  • Oracle Quoting uses Oracle Incentive Compensation to project commissions for resources and for Sales Credit Allocation. Oracle Incentive Compensation receives data through an API and then sends back projected commissions to Oracle Quoting
  • Oracle Workflow is a workflow management system that is used by Oracle Incentive Compensation to integrate business processes. It can be used to notify individuals that action is required, a process is complete, or that a concurrent process has run into a problem. Workflow is already configured for use in Oracle Incentive Compensation and does not require any setups.

Posted in Integration, Oracle ICM | No Comments »

Month End Close with Oracle R12

Posted on June 22nd, 2009 by Sanjit Anand ||Email This Post Email This Post

Fig 1 below outlines the period end dependency for Oracle Payables, Oracle Purchasing, Oracle Inventory, Oracle Receivables, Oracle Assets, Oracle Order Management, Oracle Projects and Oracle General Ledger (Release 12).
Period Closure

Fig 1: Period Close dependecy among the modules

If you are coming from 11i then you might see beacuse of SLA there would be additional steps you need to perform.Fig 2 will be a quick compare of steps between two versions.

Period Closure1

Fig 2: Process and flow changes between two versions

In almost all modules the period end process consist of 5-6 major activity as:

  1. Completing the Transactions
  2. Creating Accounting
  3. Followed by Reconcile Transactions
  4. Post to GL
  5. Reconcile Accounting
  6. Close Period

You can check some of closure process & checklist from previous post :


Posted in Oracle General Ledger, Oracle Payable, Oracle Purchasing, Oracle Receivable, R12, Subledger Accounting | No Comments »

Oracle Incentive Compensation Overview

Posted on June 22nd, 2009 by Sanjit Anand ||Email This Post Email This Post

dgreybarrow What is Oracle Incentive Compensation (OIC)?

Oracle Incentive Compensation is a global compensation management application that allows organizations to align the business objectives with sales force activities. Using Oracle Incentive Compensation organizations can automate the complex task of calculating variable compensation and ensure timely and accurate payments.

Based on the rules of compensation plan that can be configured Oracle Incentive Compensation determines:

  1. What events are eligible for incentive payments?
  2. Who should receive the payments?
  3. How the payments are calculated and paid?

dgreybarrowKey Features of Oracle Incentive Compensation

Oracle Incentive Compensation includes the following features:

Beacuse of better Design, this helps to give

  • 360-Degree Plan View
  • Role-based Plan Assignment
  • Multi-Dimensional Rate Tables, User-friendly Expression Builder
  • Interdependent Plan Elements and Plan Element Checklist
  • Flexible Sales Credit Allocation Rules, Date-effective Territories, and Compensation Group Hierarchy
  • Flexible Transaction Definition, Configurable Data Mapping

From Administration, this helps

  • 360-Degree View of Resources
  • Transaction Research Assistant, Mass Transaction and Credit Adjustment
  • Automatic Payment Worksheets including Draws, Cap Adjustments and Recovery
  • Payment Approval Hierarchy
  • Incremental Calculation and Retro-processing

For Analysis, this helps in

  • Commission Statement, Performance Reports
  • Extensible XML Publisher Reporting Capability
  • Sophisticated Ad-Hoc Analysis
  • Total Compensation View
  • Projected Compensation
  • Complete Audit Trail and Date-Effectiveness

From Technology Aspect, these are:

  • Meta-Data Driven User Interface for Personalization and Extensibility built on Oracle Application Framework (OAF)
  • Have advanced Searches and Configurable Views
  • Have Export to Excel capability
  • Have open Architecture for Integration with External Systems
  • Out-of-the-box Integration with Oracle HR, Order Management, Receivables,Payroll, Payables, Territory Manager, Resource Manager, Quotes
  • Configurable Data Mappings, Pre and Post Collections Actions and Triggers
  • High Performance Multi-Threaded Rules Engine

dgreybarrow Key Benefits

  • Increase Productivity
  • Improved Operational Effectiveness
  • Improved Time to Market
  • Increased agility to respond to strategic and market shifts
  • Improved corporate alignment
  • Improved ability to monitor and measure incentive compensation effectiveness
  • Reduced Administration Costs

Next, we discuss integration and information Flow.:)

Posted in Oracle ICM | No Comments »

Golden rules for a Successful Data Migration

Posted on June 21st, 2009 by Sanjit Anand ||Email This Post Email This Post

Top 10 Key Tips for Successful Data Migration are:

  1. Scope – Clearly define the scope of the project.
  2. Profiling -Actively refine the scope of the project through targeted profiling and auditing.
  3. Volumn – Minimize the amount of data to be migrated.
  4. Documentation – Profile and audit all source data in the scope before writing mapping specifications.
  5. Time, cost – Define a realistic project budget and timeline, based on knowledge of data issues.
  6. Sign-offs -Secure sign-off on each stage from a senior business representative.
  7. Prioritize with a top-down, target-driven approach.
  8. Testing – Aim to volume-test all data in the scope as early as possible at the unit level.
  9. Allow time for volume testing and issue resolution.
  10. Segment the project into manageable, incremental chunks.

Posted in Conversion | No Comments »

Period Close Processing Checklist -> R12 General Ledger

Posted on June 18th, 2009 by Sanjit Anand ||Email This Post Email This Post

GL period closure is needed per ledger.Here is checklist with some handy notes for refrence.

  1. Ensure Next Period is Future Enterable or Open : You need Set the status of the next accounting period to ‘Future Entry’ if it is not already, except at year-end.While doing the year-end, it is recommended that you complete all period end processing, prior to opening the first period of the new financial year.
  2. Import & Post SLA & Feeder Systems
    • Import Journals
      • Journal Import Execution Report
      • Delete Journals in Error
      • Correct via Correct Journal Import Data
      • Re-import
    • Post Journals
  3. Post All Journals (after correcting posting errors)
  4. Run and Review Journals Reports
  5. Run Revaluation :This need to revalue account balances to update functional currency equivalents
  6. Run Translation : This is Optional , need only when you define any new currencies to which accounting balances are to be translated. In that case you
    • .. Maintain period-end exchange rates for all foreign currencies to which you want to translate.
    • .. Maintain average exchange rates for all foreign currencies to which you want to translate.
    • .. Maintain historical rates or amounts for any owner’s equity accounts to be translated.
    • .. Translate account balances to any defined currency
  7. Reconcile Intercompany
  8. Close GL Period
  9. Consolidate Ledgers
  10. Run Final Reports

If you are using intercompany segments, then steps 7 will be additional for you. Therefore

  • While doing Intercompany Reconcilation, you need to compare the balance of intercompany accounts for a pair of trading partners to see if they match
  • Drill down to General Ledger Balances
  • Drill down to journals in GL, SLA and subledger transactions (invoices, etc.)

Hope this helps.

Posted in Oracle General Ledger | No Comments »

Period Close Processing Checklist -> R12 Cash Management

Posted on June 13th, 2009 by Sanjit Anand ||Email This Post Email This Post

This is recap of previous post in brief for Close Checklist – Cash Management

  1. Load & Reconcile Bank Statements
    • Auto-Reconciliation Execution Report
  2. Resolve Exceptions
  3. Create Miscellaneous Transactions
  4. Resolve Unreconciled Lines
    • Bank Statement Detail Report
    • Transactions Available for Reconciliation Report
  5. Reconcile to GL
    • GL Reconciliation Report
    • Account Analysis Report for Cash Account

Posted in Cash Management | No Comments »

Period Close Processing Checklist -> R12 Receivables

Posted on June 13th, 2009 by Sanjit Anand ||Email This Post Email This Post

This is recap of previous post in brief for Close Checklist – Receivables

  1. Complete Transactions
  2. Review Unapplied Receipts
  3. Reconcile Receipts to Bank Statement
  4. Change Period Status to Close Pending
  5. Create Accounting
  6. Review Unposted Items Report
  7. Reconcile Transaction Activity
    • Transaction Register
    • Sales Journals
    • Receipt Register
    • Receipt Journals Report
    • Journal Entries Report
  8. Reconcile Outstanding Customer Balances
    • Aging Report (run for last period)
    • Transaction Register
    • Adjustments Register
    • Invoice Exceptions
    • Applied Receipts Register
    • Unapplied Receipts Register
    • Aging Report (run for this period)
  9. Post (GL) Receivables Transactions
  10. Print Invoices
  11. Print Statements
  12. Print Dunning
  13. Reconcile Receivables Activity to GL
    • AR Reconciliation Report
    • AR-GL Reconciliation Report
    • Third Party Balances Report
    • Account Analysis Report
  14. Close Receivables Period
    • Subledger Close Exceptions Report
    • Change Period Status to Closed
    • Open Next Period
  15. Do your Tax Reporting

Posted in Oracle Receivable | No Comments »

Period Close Processing Checklist -> R12 Payables

Posted on June 7th, 2009 by Sanjit Anand ||Email This Post Email This Post

These are Closure Checklist for Payables Period end.

  1. Complete Transactions : that means Completing all transactions for Oracle Payables:
      • .. Complete Invoicing and Credits
      • .. Complete Prepayments
      • .. Complete Expense Reports
      • .. Complete Invoice Import
    • you can use Invoices On Hold Report
  2. Approve Invoices :The Payables Approval process is run to try to approve all unapproved invoices in the system, so that they can be paid by Oracle Payments and posted to the General Ledger
  3. Complete Payments
  4. Reconcile Payments/Bank Statements
  5. Resolve Potential Accounting Issues
    • Create Accounting
    • Journal Entries Report
    • Unaccounted Transactions Report
  6. Post (GL) Payables Transactions
  7. Review Accounting
    1. Payables Accounting Process Report
    2. Posted Invoices Register
    3. Posted Payments Register
  8. Unaccounted Transactions Sweep
  9. Close Payables Period
    • Subledger Period Close Exceptions Report
  10. Accrue Un-invoiced Receipts
  11. Reconcile Payables Activity to GL
    1. AP Trial Balance Report (Account definition, Data Mgr Program)
    2. Third Party Balances Report
    3. Account Analysis Report
  12. Mass Addition Transfer to Assets

While doing the reconcilation , you might have these issue

  • Transactions do not appear in Open Account Balances Listing report
  • Accounting does not appear in Account Analysis report
  • Cancelled invoices/payments result in errors in accounting and reports
  • Create accounting program errors
  • Transfer to GL program errors

These are known issues and you check with corresponding metalink note.

Make sure you should follow the best Practice

  • It always encouraged to include all LIABILITY accounts in Open Account Balances Report Definition.
  • Explore the Control Account feature with Third Party Balances report.
  • You should avoid reversing batches (or modifying Journals) in GL, if transferred by SLA.
  • Always use Period Close Exception report prior to closing Periods in GL and reconciling to Account Analysis & Trial Balance reports.
  • You can use only SLA or GL (not both) to create manual journal entries for subledger transaction corrections.

Posted in Oracle Payable | No Comments »