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

A Note on Oracle Application Journey

Posted on January 31st, 2007 by anand ||Email This Post Email This Post

Today is 31st Jan, 2006, the day when oracle had schedule to release 5 different products across 6 continent, out of which one is Oracle application i.e. R12.Thus,I thought to bring this topic here, to let everyone know how oracle helps in understanding the evolution of ERP Suite in last 20 years. 14000 installations worldwide is a wildcard entry while considering for product evaluation by companies who are looking for some ERP product. I hope everyone is bit excited to know.

Journey from 1978 till 1987

These 9 years oracle has seen lot many achievement like becoming first DBMS based Database Company. They have released 7 different database versions with technology enhancement, and they become Public company as sometime 1986 had IPO in market. The start up has turned in recognized DBMS company, thus it was perfect time for them as well as Industry expert are looking Integration with in area like Finance , Manufacturing etc..Thus ERP evolution takes place.

The application group Formed

Some times in August 1987 Oracle started there Oracle Applications division, a group focusing and building business management software closely integrated with there own database software.

The First “Oracle Application ”Product Launched

Sometime in August 1988 they released there first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reason of having General ledger application_id is 101.Intresting..

i-era/Dot com Time

The year 1997-98, the attention was primininlly focused on Internet, which already takes off in Information Technology sometime back. The concept of thin client was a baby at that time. This year oracle strategy shifts toward the internet and browser based development. The middle of year oracle launched and shipped there 11i product which was armed with 8i database, with lot many new features.


In 2000, Oracle9i Application Server released at Oracle becomes the first database with middle-tier cache. This 9iAS leads to launches of E-Business Suite. The suite combined with all inbuilt products.

sanjit042003 Onward

Since 2003 onward, oracle keep there attention on oracle application product and same time they make ready with departure of old 10.7 products, by simply de-supporting.


These two year have seen acquisition and movement of oracle from DBMS to grid database, thus EBS suite does come out with MobApps, has feature of RFID and other need for manufacturing area. The year 2006 seen a release of yet another .. version.

2007 onward

Oracle is ready with there new version ready to release in market. This times a new member i.e. R12.


Posted in EBS Suite, Misc, News, Release12 | 1 Comment »

12i Documentation

Posted on January 26th, 2007 by anand ||Email This Post Email This Post

Finally the wait is over. Oracle has provided a link for R12 documentation.12irelease.jpg

The download bundle consists of 408.08 MB file. Anyone can download directly from Oracle site.


Amazing this time these documents has colour jpg/gif’s that means readability is greatly enhanced. Isn’t It. Wow!! 12irelease2.jpg

Posted in EBS Suite, Release12 | No Comments »

R12 Release Content Documents

Posted on January 18th, 2007 by anand ||Email This Post Email This Post

A new headline for Release Content Documents would be appearing once you logged in Metalink. The document id 404152 describe with a note and the links for Release Content Documents of various Oracle EBS products. These documents mostly covered brief discussion for new and updated features in R12.Metalink user can access these documents and get the feeling of R12 before actual release which is schedule to be on month end. Take a note, these documents does not describe any existing functionally so, bit disappointed to those who are looking for comparative study.

Posted in EBS Suite, News, Release12 | 4 Comments »

11i EBS and Food Industry

Posted on January 14th, 2007 by anand ||Email This Post Email This Post

Could you imagine what kind of ERP system required to such kind of industry whose line of business is these products line? 

  • Meat and Poultry
  • Dairy
  • Grains
  • Processed Products
  • Fruits and Vegetables
  • Sea Food
  • Grocery
  • Beverages Alcoholic
  • Beverage Beer
  • Beverage Soft Drink
  • Beverage Water
  • Beverage Sports Drinks

I know this is bit tricky to answer. Though I have been never exposed to Food industry yet, but as EBS consultant working for such a long time, can surly consider Oracle Apps 11i as a complete product to cater this segments. The reason for bringing this topic here just because of a simple reason as sometime back I get across one the article written by Thomas R. Cutler, where he put some thoughts on the Potential usage of ERP product with Floor shop automation. What we understood, food and beverage industry require an ERP system that is flexible to respond to today’s demands and tomorrow’s changes, because of there uniqueness, rapid changing nature of there market. Sudden change in strategy, manufacturing process may require special attention for shop managers for such kind of industry, therefore a complete integration with Shop floor with ERP based application is one of key area. 

In his paper he did mention some tight system automation requirement with ERP system. Though he considers Food industry has of idiosyncratic nature of food manufacturing process. Thus the shop floor and some of area involved the process can be tighten which add-on the cost of product. Here are some of the area where he considers needs a nut and bolt requirement:

  • Online tracking of engineering change orders with electronic routings for approvals.
  • System generated BOM’s and routings for configured products.
  • System generated production schedules from MRP module.
  • Automatic yielding for finished goods and BOM components/ingredients.
  • Where used and mass replace capabilities.
  • System generated work orders for make to order environments.
  • Fully attributed inventory from order entry through production and shipping.
  • Online order promising by exploding the multi-level BOM, reviewing BOM stocking levels, and production space.
  • Online messaging for production managers on plant floor exceptions.
  • Integrated dashboards for management’s KPI’s.

Thus it is important to find balance between this industry sector nuance and a Basic ERP system . he too agreed that basic ERP functionality  are often lacking when the focus is too heavily on the bells and whistles. In his paper he strongly agree by Gill idea that he felt , “Many vertical ERP applications in the food sector lack strong financials and must integrate with bolt-on third party systems.” The ERP functionality should also include complete multi-company, multi-currency, and financial reporting capacity.

Here are some of potential area and functionality he mentions for ideal ERP system:

  • Fully EDI enabled which offers automatic order entry, acknowledgements, ASN submittal, invoicing, purchase order transmittal, vendor acknowledgements
  • Automatic check input and matching for bank deposits
  • System generated forecasts based on sales history
  • Online system (MRP/DRP) generated requisitions with purchase order creation and submission
  • Online messaging with exception reporting
  • Fully barcode enabled system
  • Directed put away, pick, and restocking locations in warehouse
  • Various picking methodologies for complete optimization of the warehouse
  • Centralized purchasing and payment for multiple facilities, divisions, or companies
  • Fully integrated e-commerce
  • Integrated to Microsoft Outlook
  • Fully integrated CRM

Apart from this there are some other areas which need a flexible move as required as some of changing business need to satisfy these requirements:

  •     Regulatory Compliance – Reporting to support FDA, Bioterrorism Act, 702 and other legal requirements
  •     Retailer Mandates – RFID, promotions, packaging requirements, private-label brands
  •     Consumer Demands – Higher quality, more convenient products at lower prices Also other area like grower accounting for Contracts, pricing, settlement, payment and grower Management for Harvest management, farming activities, receipts can be add-on requirement in food industry

E-Business Suite for Food & Beverage

EBS suits does have a solid functionality to cater the food industry segment, Whether it is baking mix manufacturer, nut processor or other type of Food and Beverage producer, Oracle E-Business Suite provides specific food and beverage feature and functionality such as:

  •  Process Manufacturing – Enables traceability throughout the entire manufacturing cycle with recipe management, production scheduling, process execution and inventory management.
  •  Trade Management – Organizes and tracks marketing and sales trade promotions, deductions, and budgets.
  • Food Safety and Compliance –Supports full accountability tracking at each step of the process.

    Also, I would like to share some of EBS 11i.10 enhancements like Scarce inventory allocation, lot/serial receiving, better controls for Food and Drug Administration (FDA) 21 CFR Part 11 compliance and an improved channel/partner management dashboard has been targeted for faster communications.

    This is what Oracle EBS suites provides. This is datasheet provided by oracle of this industry segment.

Posted in EBS Suite, Misc | 2 Comments »

Oracle EBS Suite at Mitsubishi Electric Automotive India (MEAI)

Posted on January 13th, 2007 by anand ||Email This Post Email This Post

Japan based Automobile manufacturing subsidray MEAI(Mitsubishi Electric Automotive India) selects Oracle EBS
to facilitate real time accounting and integration with tight integration with the existing production control systems
at MEAI’s parent company in Japan.
Oracle Procurement, Oracle Financials, Oracle Order Management and Logistics the areas which covered within the scope. a news paper reported.

More information can browsed at: Details

Posted in News | No Comments »

Order Management – Split Lines

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

Order Management allow you to split order lines to meet customer needs. Until the product is shipped, the customer can request to change the shipping address or date for part of the order line. To meet such requests, split the order line into multiple shipments. These are referred to as user initiated splits .

When Order Lines are partially processed at:

  • Ship Confirmation – When the shipping department finds that stock on hand is less than the ordered quantity, you can ship the available quantity and Order Management will split the line so that the customer can be billed for what was shipped.
  • Purchase Release Receipt – When a Drop-Ship Line is partially received, Order Management splits the line so that a customer can be invoiced for what was already shipped.

When Return Lines are partially processed at:

  • Return Receipt – When the customer returns partial quantity on a return, the system splits the return line so that customers can be issued credit for what was returned.

Posted in Oracle Order Management | No Comments »

ERP Market Trends

Posted on January 9th, 2007 by anand ||Email This Post Email This Post

Last quater of year 2006 sees boost in economic in North America, Europe and South Asia.The drastic growth of execution of some of the projects in ERP segment is beacuse, as many companies are planning to implement a new or expand an existing ERP solution in the near term. The predication of the ERP market is expected to grow 8 percent until 2008.For midsized corporations, government agencies, and industries such as health care are expected to lead the spending on ERP implementation, a web site reported. The leading ERP system providers are SAP and Oracle/PeopleSoft.

Some of the business drivers and market trend in ERP are :

  • Consolidation of Systems – global instance
  • Standardization of Processes
  • Move to Shared Service Centers -SOA
  • Focus on Security -SSO
  • Corporate Compliance -SOX
  • Cutting edge Technology -XML Pub

Posted in Misc | No Comments »