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

The Beginner’s Guide to OGA (Oracle Grants Accounting)

Posted on March 17th, 2010 by Sanjit Anand ||Email This Post Email This Post

OGA (Oracle Grants Accounting) provides your organization with the ability to completely track grants and funded projects from inception to final reporting.

Oracle Grants Accounting provides a fully integrated system that supports multi-funded projects and the required compliance terms and conditions by award. Oracle Grants Accounting supports validation of allowable costs as well as flexible budgetary controls to ensure fiscal responsibility. Reporting is comprehensive, supporting internal and external reports and queries needed to effectively manage funded projects.

Take a note, Oracle Grants Accounting is part of the Oracle E-Business Suite, an integrated set of applications that are engineered to work together, see the section for dependency.

To effectively manage funded projects, Oracle Grants Accounting includes award templates that provide an easy method of recording the appropriate level of data and assists in maintaining consistency and standardization of award details.

Detailed award information includes award attributes like the award number, award name, funding source, installment funding, multiple references, budgetary controls, terms and conditions, and key personnel. Oracle Grants Accounting also stores information such as the sponsor contacts, reporting requirements, and compliance parameters.

dgreybarrow Oracle Grants Accounting – General Structure

OGA operates based on a structure consisting of Awards, Projects and Tasks. Depending on the type of sponsored project, the OGA award will be set up with a particular Award, Project and Task structure.

  • Award – Grant, cooperative agreement, or contract received by an organization, which is used to fund one or more projects.
  • Project – Primary unit of work that can be broken down into one or more tasks.
  • Task – Ability to show further detailed breakdown of project work.

dgreybarrow Oracle Grants Accounting – Functionality

OGA was developed for the needs of grant accounting and specifically to assist in maintaining compliance with sponsor regulations – especially federal grant regulations. To that end, OGA has the following functionality:

  • Budgetary Control – Ability to set spending limits within the award – can be set at the award,expenditure category, expenditure type or task level.
  • Encumbrance Accounting (“Commitments”) – Reservation of funds against Budget prior to actual payment.
  • Funds Checking – Compares expenditure amount, including indirect costs, to Budget Available Balance (Budget – Actuals – Commitments)
  • Costing – Compares Expenditure Item Date to Task Start & End Date, Project Start & Completion Date and Award Start & End Date.
  • Transaction Controls – Ability to include or exclude particular expenditure types from being able to be charged on a project.
  • Allowed Cost Schedules – A list of expenditure types that can be used on a sponsored project.
  • Burdening – The process of assessing indirect costs to expenditure transactions.

dgreybarrow Where this application needed

Project-centric organization, Eductional Institute, Reasech Orginastion , State and Local Governments

dgreybarrow A note to implementer

Implementer might be finding two similar application in EBS.Oracle Projects and grant accounting , in other word they can understand the Grants Accounting module is a “wrapper” around Oracle Projects Costing and Billing modules, and can co-exist within the application suite. One can have Oracle Projects and Grants Accounting operating in the same environment with many of the same users. These are the some of the fundamental difference between two application.

Oracle Grant Accounting


dgreybarrow Integration with Other Application

  • Oracle General Ledger
  • Oracle Payables
  • Oracle Purchasing
  • Oracle Iprocurement
  • Oracle Receivables
  • Oracle Assets (is required if capital projects are used and assets are to be capitalized)
  • Oracle Workflow
  • Oracle Projects
  • iExpense
  • Labor Distribution

Hope this post you will find useful.

Posted in Oracle Application | No Comments »

Oracle Sourcing -Differences between Oracle 11i and R12

Posted on March 7th, 2010 by Sanjit Anand ||Email This Post Email This Post

  • Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyer s Work Center. Based on the latest web-based user interface models the Work Center is a central Launch Pad from which buyers can efficiently perform their daily tasks:
    1. View and Act upon Requisition Demand
    2. Create and Manage Orders and Agreements
    3. Run Negotiation Events including Auctions and RFxs (requires Oracle Sourcing)
    4. Manage Supplier Information
  • In Release 11i generation of purchasing documents in Adobe PDF format required organizations to create layout templates in the form of XSL-FO style sheets. With Release 12.0 organizations can also use RTF or PDF layout templates which require little training to configure and maintain.
  • Oracle Purchasing supports various types of file attachments (MS Word Excel PDF etc.) that can be appended to purchasing documents in addition to long and short text attachments. In previous releases only text attachments were communicated to suppliers. With Release 12.0 buyers can communicate all necessary attachments to suppliers including file attachments via email.
  • Release 12.0 allows finer control of how blanket agreements are enabled for automatic document sourcing. Buyers can now choose to enable them only in specific inventory organizations. Thus buyers can negotiate a blanket agreement to fulfill requisition demand for a subset of inventory organizations and enable the agreement for autosourcing only in those inventory organizations.

Posted in Oracle Purchasing | No Comments »

Oracle Sourcing

Posted on March 6th, 2010 by Sanjit Anand ||Email This Post Email This Post

Oracle Sourcing is the yet another enterprise application that improves the effectiveness and efficiency of strategic sourcing. This application is a key component of Oracle Advanced Procurement, which dramatically cuts all supply management costs. Oracle sourcing enables buyers to source more of the organizations spend at lower total cost. Oracle Sourcing application creates immediate savings through rapid deployment, and ensures long-term savings with consistent execution and compliance.

With Oracle Sourcing you can:

  • Manage more sourcing events in less time and bring them to conclusion faster, so you can exploit additional savings opportunities
  • Make more best-value award decisions based on total cost, not just on unit price
  • Create immediate savings and faster ROI with rapid deployment; then gain additional savings with consistent execution through the Oracle Advanced Procurement suite

There are three typical business flows that utilize Oracle Sourcing.

  1. Create New Documents Using Demand Workbench
  2. Create New Documents from Existing Blanket PO Agreements
  3. Create Documents Directly in Oracle Sourcing

Details are herewith:

1.Sourcing buyers can use the Demand Workbench feature of Oracle Purchasing to select approved requisition lines and aggregate demand into a draft auction or a Sourcing RFQ. Buyers can use the Demand Workbench without leaving Oracle Sourcing. The backing requisition line information is retained throughout the life cycle of the sourcing document.

Oracle Sourcing

2. Oracle purchasing buyers can select a blanket purchase agreement (BPA) and use it as the basis of a new auction or Sourcing RFQ. The details of the BPA (including header, attachments, price breaks) are copied to the draft negotiation, and the sourcing lines refer to the originating BPA lines.

Oracle sourcing2

3. Oracle Sourcing buyers can define sourcing documents directly in Oracle Sourcing. Inventory items can be selected and goods and services can be entered directly. A large number of items can be quickly entered by using the spreadsheet upload feature.

oracle sourcing3

Therefore, buyers have visibility to information throughout the complete procurement process. Oracle purchasing users can view the awards that initiated the standard purchase order or blanket purchase agreement.

Hope this helps.

Posted in Oracle Purchasing | No Comments »