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

Oracle Environmental Accounting and Reporting [ EAR] -Solution for capturing and reporting environmental and emissions data

Posted on February 19th, 2014 by Sanjit Anand ||Email This Post Email This Post

In Release 12.1.3 of the eBusiness Suite, Oracle included an Environmental Accounting and Reporting application.

Environmental Accounting and Reporting (EAR) enables to record and account for activities that have an impact on the environment. It provides the ability to store date effective energy consumption and emissions by location that are later used for environmental reporting.

EAR provides several flexible means to record environmental data through the use of standard transactions , such as invoice processing, inventory issues, batch entry, and manual
data entry.

Supported by a built-in emissions calculation engine that takes the emission factors, the emission sources and the transactional data, it computes the CO2 equivalent and the inventory usage, and stores the data where all the reporting is then done, the Environmental Data Ledger.

It allows the classification of green house gas (GHG) emissions data by Scope 1, 2, or 3 [ see more details at the end] , and also by standard industry codes

The application was originally built by an Australian company NDEVR and subsequently acquired by Oracle . [ Source Oracle Website]

Oracle Environmental Accounting and Reporting is an add-on module to Oracle E-Business Suite and provides multiple modes to capture environmental data, a GHG emissions accounting engine, and pre-built dashboards and reports to:

  • Record, account, track, and report activities that impact the environment.
  • Participate in voluntary GHG monitoring and disclosure programs such as Carbon Disclosure Project.
  • Identify opportunities to improve energy efficiencies and reduce GHG emissions.
  • Recognize and undertake early voluntary actions for reducing greenhouse gas emissions.
  • Fulfill mandatory GHG reporting requirements enforced by global and local legislations.
  • Enhance shareholders confidence as an environmentally conscious organization.

Some of the key features of Oracle EAR that allow you to achieve the above are:

  • Store date effective energy and emission factors for location specific GHG accounting.
  • Maintain an emissions audit data trail in the Environmental Ledger for a time based analysis, reporting, and statutory auditing requirements.
  • Classify GHG emissions data as Scope 1, 2, or 3 and by standard industry codes. Refer to the Setting Up chapter for more information on Scopes.
  • Configure organization hierarchy to meet specific analysis and reporting needs of the enterprise.
  • Record environmental data through several flexible means – through ERP transactions, manual batches or import using WebADI templates.
  • Report emissions data using Oracle Business Intelligence dashboards.
  • Define KPIs for tracking an enterprise’s sustainability performance.

Technology Overview

Oracle Environmental Accounting and Reporting uses the following Oracle technologies:

  • Oracle Business Intelligence Enterprise Edition (OBIEE).
  • Oracle E-Business Suite (EBS) Technology Stack.
    • Following applications of Oracle E-Business Suite to be able to run the EAR application:
      • Oracle System Administration
      • Oracle Inventory
      • Oracle General Ledger
      • Oracle Human Resource Management System
      • Oracle Payables
      • Oracle Assets
      • Oracle Projects
  • Oracle Data Integrator (ODI).

Oracle Environmental Accounting and Reporting

The centre of the diagram [ Fig 1] shows the environmental ledger [ CHG Ledger] – the central storage for EAR, which is supported by a number of configuration screens.
The top section of the diagram shows how environment source data may be collected from:

  • Oracle Payables (e.g. from electricity invoices which show usage statistics)
    • EAR integrates with Oracle Payables to capture data while processing Invoices with or without Purchase Order match, related to the supply and use of products and services that have environmental impact.
  • Oracle Inventory (e.g. if you have an onsite petrol bowser)
    • EAR integrates with Oracle Inventory to record data related to the issue of Items to Assets that result in environmental emissions
  • The Environmental Transaction Batches window (manual data entry specifically related to environmental sources)
  • Or upload data from spread-sheets using Oracle WebADI Templates (e.g. from data extracted fromother systems)
  • EAR leverages Oracle Data Integrator (ODI) to transfer the data from the Environmental Ledger to the Environmental Data Warehouse. The Oracle Business Intelligence application uses the data for environmental reporting through the pre-built dashboards and reports.
  • EAR enables you to record environmental transactions involving the issue of items, to assets defined in the Oracle Assets application.
  • EAR allows you to map Environmental Organizations to projects and tasks defined in Oracle Projects. While processing Invoices that have references to projects and tasks, EAR uses this information to identify organizations to calculate and store environmental data based on the projects and tasks mapped to the organization.

Environmental Reporting Overview

Oracle Environmental Accounting and Reporting provides the following pre-built dashboards to report the source usage, emissions data, carbon disclosure, and KPI measures for organizations:

  • Emissions
  • Energy
  • Metrics
  • Reporting
  • Summaries
  • Test
  • Transaction
  • Usage

Categorization of Emission Types

  1. Scope 1 : Direct GHG Emission from sources owned or controlled by the organization (i.e. gasoline that is put into a fleet of vehicles owned by the organization)
  2. Scope 2 : Energy Indirect GHG Emission from the generation of imported electricity, heat or steam consumed by the organization (i.e. electricity or gas bought by the organization)
  3. Scope 3 : GHG emission that arises from GHG sources that are owned or controlled by other org anizations (i.e. business travel)

Additional Reference

  • Oracle Environmental Accounting and Reporting User’s Guide 12.1 (# E23439-02)
  • MOS 1327248.1 – Oracle Environmental Accounting and Reporting Release Notes 12.1.3

Posted in Functional, General Interest, Oracle Application | No Comments »

Know more on “REIT” [Real estate investment trust ]

Posted on November 9th, 2012 by Sanjit Anand ||Email This Post Email This Post

More and More companies are pursuing conversion to a real estate investment trust (REIT). Those who are exploring the whole new world of REIT can find this post useful to start with. Here to go:


I. What is a REIT?

Is a tax designation for a company that invests in real estate that reduces or eliminates corporate income tax

In return, a REIT must distribute 90 percent of its taxable income to investors. The REIT structure was designed to provide a real estate investment structure similar to the structure that mutual funds provide for investment in stocks.

An entity that qualifies as a REIT under the Code is entitled to preferential tax treatment. It is a “pass-through” entity that can avoid most entity-level federal tax by complying with detailed restrictions on its ownership structure and operations.

REIT shareholders are taxed on dividends received from a REIT.

II. In layman language what is Meaning of REITs

  • This is collective investment device of commercial real estate
  • This is equity-type funding
  • This Owns, and in most cases operates, income-producing property (Equity REITs)
    • Office
    • Apartment
    • Retail (shopping centers)
    • Hotels
    • Warehouses (storage)
  • This is Essentially a tax-tool where equity funding of real estate is allowed on tax transparent basis upto minimum 90% dividend
  • REITs are typically listed and quoted

III. The Four Requirements You Must Know!

  • A REIT must distribute 90% of its annual income as dividends to its shareholders
  • A REIT must have at least 75% of its assets invested in real estate, mortgage loans, other REITs, cash, or government securities
  • A REIT must derive at least 75% of its gross income from rents, interest, and gains from sale
  • A REIT must have at least 100 shareholders and must have less then 50% of the outstanding shares concentrated in the hands of five or fewer shareholders

More details you can see under section “What are the required elements for forming a REIT?”


IV. When and why were REITs created?

REIT is essentially a tax term.

Congress passed the original REIT legislation in 1960 in order to provide a tax-preferred method by which average investors could invest in a professionally managed portfolio of real estate assets.

This Offer expert management and familiar corporate governance structures (BOD)

Many of the limitations imposed upon the operation of REITs and the taxes to which they are potentially subject are perhaps best understood in terms of the original notion that the activities of REITs were to consist predominantly of passive investments in real estate.

V. What types of REITs are there?

There are three types of REITs:

  1. equity REITs, which primarily own, or have an interest in, income-producing real estate;
  2. mortgage REITs, which originate or acquire mortgage loans and other debt obligations that are secured by real property;
  3. and hybrid REITs, which combine the equity REIT and mortgage REIT model and both owns commercial real estate and holds mortgages secured by commercial real estate

VI. What are the required elements for forming a REIT? [Adopted from U.S. SEC website]

In order to qualify for the tax benefits available to a REIT under the Code, the qualifying REIT entity must:

  • Be an entity that would be taxable as a corporation but for its REIT status;
  • Be managed by a board of directors or trustees;
  • Have shares that are fully transferable;
  • Have a minimum of 100 shareholders after its first year as a REIT;
  • Have no more than 50 percent of its shares held by 5 or fewer individuals during the last half of the taxable year;
  • Invest at least 75 percent of its total assets in real estate assets and cash;
  • Derive at least 75 percent of its gross income from real estate-related sources, including rents from real property and interest on mortgages financing real property;
  • Derive at least 95 percent of its gross income from such real estate sources and dividends or interest from any source; and
  • Have no more than 25 percent of its assets consist of non-qualifying securities or stock in taxable REIT subsidiaries

VII. What other countries have REITs?

A number of countries, including Australia, Brazil, Canada, Germany, India, Japan, Pakistan, Singapore and the United Kingdom have REIT-type legislation. The details of the rules may vary from the U.S. rules and from country to country.

VIII. What are the tax advantages of being a REIT?

REITs do not have to pay federal taxes at the corporate level

  • More specifically, REITs are allowed to deduct dividends paid to shareholders from taxable income, and thus have the ability to shield 100% of taxable income through distributions to shareholders
  • REIT shareholders still have to pay taxes on dividends and capital gains
  • Most states honor the REIT status and don’t require REITs to pay state taxes


Posted in General Interest | No Comments »

Are you in the right career path?

Posted on November 1st, 2012 by Sanjit Anand ||Email This Post Email This Post

Most careers are driven by 1 of 3 motivators:

  1. Achievement
  2. Affiliation
  3. and Competence.

Are you in the right career path?

Worth reading great post of how to choose a career

There are three career paths. One will fit you. read at penelopetrunk

so what is your choice then ..winning, relationships, or craftsmanship

Posted in General Interest | No Comments »

Public Speaking Tips : The Presentation Secrets of Steve Jobs

Posted on February 20th, 2011 by Sanjit Anand ||Email This Post Email This Post

If you like to learn some of the techniques and styles that make Steve Jobs such a great presenter, here’s some excellent advice from Businessweek columnist Carmine Gallo, who is also the author of the book – The Presentation Secrets of Steve Jobs. I think it is an awesome video on presentation skills.

Here are some points extracted from the video:

  • Make your theme clear and consistent
  • Create a headline that sets the direction for the meeting
  • Provide the outline
  • Open and close each section with a clear transition
  • Make it easy for your listeners to follow your story
  • Demonstrate enthusiasm e.g. extraordinary, amazing, cool, incredible, unbelievable, awesome
  • Wow your audience by seeling an experience
  • Make numbers and statistics meaningful
  • Analogies help connect the dots for your audience
  • Make it visual
  • Point a simple picture that doesn’t overwhelm
  • Identify your memorable moment and build up to it
  • Rehearse, rehearse, rehearse
  • Last but not the least…
  • Give your audience an added bonus to walk away with

Posted in General Interest | No Comments »

Top 18 EBS UI : Provides all users with a highly productive interface

Posted on August 8th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle’s EBS delivers a user interface that was designed to increase the productivity of all users. Here are the compiled list of some of the features that user experiences such rich UI functionality who moved from SAP to Oracle Apps.

  1. Folders for screen layout in which you can change Prompts, Field Orders, Size etc. Refer this post
  2. Top Ten List : User can use the Top Ten List to add personal favorites and most frequently used forms to quickly navigate to them from the Top Ten List on the right side of the screen.
    • The good is that each list is unique to a user and responsibility.
    • To add a form to the Navigation Top Ten List, select a frequently used form in the navigation list (on the left side of the screen).
    • The form name appears in the Top Ten List preceded by a number.
    • To remove a form from the Top Ten List, select the form in the Top Ten List and click the left arrow buttonTop10
  3. Navigator Window : In Oracle a Navigator window will be displayed after a responsibility is selected.User can use this window to navigate to the form that allows you to perform desired business functions. This is the main window that is always displayed during your session.The navigation list is organized in levels. Items that begin with a plus sign (+) can be expanded to further sub-levels until you find the form of interest (no sign will appear). The expand buttons are located on the Navigator window at the left of the screen
  4. File Export to Excel :The File – Export option allows you to dump the data you see on the form.check this post
  5. Multiple Windows Open at one time : Technically called zoom in Oracle.Since 11i multiple Document Interface, which means that all windows are displayed inside a single window, with a single toolbar and menu attached to that window. So, since the toolbar opens as part of the window, there is no way for the toolbar to get disconnected or “lost”.
  6. Workbenches :These are most liked one by key user. These are only menus which carry the whole bunch of functions/submenus.Most of application product does have workbench. If you are new to Oracle you can understand within AR workbench is divided into 3 main sections:
    • Transaction Workbench – Menu: Transactions
    • Receipts Workbench – Menu: Receipts
    • Collections Workbench – Menu: Collections
  7. Message and Status Line :The Message Line and the Status Line are shown at the bottom of the window, instead of on the toolbar.
  8. Required Fields Highlighted – Fields where input is required have a highlighted background,Fields are color coded to indicate the type of activity allowed:
    • White– Permits data entry
    • Yellow– Requires data entry
    • Grey with Black Text- For display only
    • Blue- Indicates the form is in Query-Enter mode
  9. Autofill and Type Ahead
  10. Field Level Update/Validation : That you can get without ‘save’ or ‘Update’ operations.
  11. Drag and Drop: This is feature, in which you can move a column by drag and drop.
  12. Graphical Elements : User can get some graphical elements like ‘T’ Accounts, Graphs, Diagrams directly from UI.
  13. Attachment
  14. Query in all forms : Oracle best feature for user is they can do query is most of the form.
  15. Right Mouse click :Clicking the right mouse will open up a menu that offers the cut, copy, and paste features, as well as folders and help.
  16. Hot keys :Hot keys can increase user productivity by allowing common operations to be executed from a keyboard shortcut, rather than a menu selection. Hot keys are an effective usability tool, especially for “heads down” mouse-less data entry such as rapid order entry.Experienced Oracle Applications users can access the menu by using a keyboard shortcut or hot key, a specific combination of keystrokes that performs the same function as a corresponding menu item. Oracle Applications assigns many commonly used functions, such as Run Query(Ctrl+F11), Save(Ctrl+S), or Clear Record(F6) to keyboard shortcuts.
  17. DFF : Addding a Descriptive Flexfield and Use It
  18. Using FIND penis: If you want to search for records in your current block or window, the simplest way to proceed is to use Find. This will usually display a Find window, in which you can enter the criteria to match, then click the Find button. If any of the fields in the Find window have lists of values associated with them, you can use these to validate your search criteria. Find windows often provide ranges in addition to individual field values (e.g. date or value ranges). However, your search is limited to the fields that have been included in the Find window.

This quick overview of User interface for EBS is designed to provides all kind of end users with a highly productive interface.

Posted in General Interest | No Comments »

Diagnostics Made Easy : Oracle Diagnostic Tool -II

Posted on December 10th, 2007 by Sanjit Anand ||Email This Post Email This Post

rxRead this

Diagnostics Made Easy : Oracle Diagnostic Tool

In earlier post we have seen how Oracle Diagnotics tool makes life easy for everyone. Lets take some intresting stuff inside the tool.

Applications Collection Tool (ACT)

The Applications Collection Tool (ACT) is a test collecting information about apps technical environment and setup of a given product. This tool is executable via Oracle Diagnostics framework under the tab ‘Advanced’. Oracle Diagnostics framework is launch able via OAM.

Many time you will get this message “No Groups have been registered for the Advance Test”? What is meant?

You get this message because there are no currently available diagnostics tools for that particular product. So you haven’t missed any step… It is correct behavior. Information of all currently available diagnostics tools you can find in the Diagnostic Tests Catalog for E-Business Suite.

Is some things Changed from Security side?

Yes,from Jan-07 Support diagnostics (IZU) patch, diagnostics have now role-based security . It means:

  • Is can be assigned to the current user belongs to one of the valid applications internally defined in the test.
  • The Diagnostic Test available are specific to an EBS module.
  • Each Module’s test are organized into a group of related test called “test Group”
  • These grouping are based on what the test scripts have in common from data security standpoint.
  • By having the tests divided into groups, you are able to easily control access, these test groups have a ‘sensitivity’ assigned as:
    • Low
    • Medium
    • High
  • Role Diagnostic: roles determine the set of operations that can be performed on test groups, based on the sensitivity of the test group. The sensitivity of the test group (high, medium or low) is determined by the developer of the test. The diagnostic roles and tests authorized are as follows.

    • Super User – User such as SYSADMIN and responsibility like CRM HTML Administration ,Has permission to execute tests, perform configuration, view reports and set up security
    • Application Super User Medium/Low Sensitivity ,All applications – Has permission to execute tests, configure results and view reports Authorized applications – Has permission to execute tests, perform configuration, view reports, and set up security
    • End User those with low Sensitivity , most of the applications has permission to execute tests and configure results.
  • A particular user’s access to the diagnostic test is determined by
    • responsibly that he/she is accessing
    • what role are granted to those responsibility
  • If we take a example for BOM module, you will find 5 “test group” , which is listed as:
    • items –Diagnostic test related to Items setup
    • Item Categories—Diagnostic test related to Items Category setup
    • Bills -Diagnostic test related to Bills
    • Routings -Diagnostic test related to Routing
    • ECOs — Diagnostic test related to ECOs
    • Data Collection – Diagnostic test related to data collection


When should go for Batch Processing?

This option is good when diagnostic test taking too long to execute.This option, located on the home page of the diagnostics framework, allows you to select one or more tests within one or more products for execution in batch mode. It means you can do setup for Period end Close setup in GL as well as Auto invoice setup in AR.

So, this is all about for the Oracle tools diagnostic capability. Now time for comment, question, clarification.:)

Posted in 11i, EBS Suite, General Interest | 1 Comment »

Diagnostics Made Easy : Oracle Diagnostic Tool

Posted on December 10th, 2007 by Sanjit Anand ||Email This Post Email This Post


Do you know in Oracle eBusiness Suite Diagnostics is a free tool provided by Oracle to ease the gathering and analyzing of information from your eBusiness Suite specific to a existing issue or setup.

bluOracle Diagnostic Tool Responsibility

The Oracle Diagnostic Tool is provided by Oracle to ease the gathering and analyzing of information from your eBusiness suite when diagnosis an existing data issue, transactional problem or setup error through a complete set up responsibility.

purpOracle Support Diagnostics benefits

Problem Avoidance: Identify and solve potential issues before suffering their symptoms

Formatted Output: Conveniently display the information gathered, the finding of the analysis and appropriate action to take if necessary

Ease to use: This tool is easy to use and is designed for both the functional and technical user. Identify and solve existing issues without external assistance

Self Services Resolution: Resolving Problem without the need to contact oracle support

Reduction in resolution time: minimizing the time spent to resolve an issue by increasing support engineer as well as end user efficiency

No Technical skill required: No special SQL*Plus/operating system access required.

Testing Hub: Because of Central location of all tests, it is the hub for all Diagnostic testing.

yel Important Points

  • The diagnostic tool does not alter the data or setup in your system i.e. no updates, inserts, or deletes happen.
  • Sensitive customer information is not collected or displayed.
  • The diagnostic tool are organized into one of the following groups

Read the rest of this entry »

Posted in 11i, EBS Suite, General Interest | 8 Comments »