You are html tracking Visitor

Saturday, August 9, 2008

Oracle Application Story

Oracle Application Story:-

-----------------------------

This article is design to explain what's all about the Oracle Applications

Suppose you are running a small grocery shop named “XYZ Grocery”, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop. Occasionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now let’s name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor or Supplier (Vendors are define in the Purchasing Module), the people who come to your shop to buy things are known as customers (Customer are define in the Receivable Module), the stock in your shop is known as inventory.

So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as Employees. Employees are define in the HRMS Module.

So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 1, 00,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Now, it is impossible to manage all that information using pen and paper. And if you try to do that, then your business will come to a sudden stop sign.

To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Application is not one huge software, instead it is a collection of software known as modules (GL, PO, AP, AR or FA etc) that are integrated and talk to each other. Now what is meant by integrated? First let us identify the modules by entities. For e.g. Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors.

Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or web store etc where as Receivables help you collect the money for the orders that are delivered to the customers.

Now who maintains the paychecks, benefits of the 1000 employees? Right! It is managed by Oracle Human Resources. So you get the idea by now that for each logical function there is a separate module that helps to execute and maintain that function.
So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.

Just to simplify the explanation, when you pay your employees that payment is reported back to General Ledgers as cost i.e. money going out, when you purchase inventory items the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items in your inventory it is transferred to GL as money coming in, when your customer sends payment it is transferred to GL as money coming in, so all the different transaction modules report to GL (General Ledger) as either “money going in” or “money going out”, the net result will tell you if you are making a profit or loss.

All the equipment, shops, warehouses, computers can be termed as Assets and they are managed by Oracle Fixed Assets. Initially Oracle Applications started as bunch of modules and as time passed by they added new modules for different and new functions growing out of the need for today’s internet world.

So if you come across a module that you are trying to learn and work on, first try to understand what business need it is trying to fulfill and then try to understand what the immediate modules that it interacts with. For e.g. lets say you come across Oracle Cost Management module, you will learn that it helps to maintain the costs of items in your inventory and the immediate modules that it interacts with are Oracle Inventory (of course), Oracle Bills of Material, Order Management and so on..

I have listed few modules description:-

Oracle Purchasing handles all the requisitions and purchase orders to the vendors.

Oracle Payables handles all the payments to the vendors.

Oracle Inventory deals with the items you maintain in stock, warehouse etc.

Order Management helps you collect all the information that your customers order.

Oracle Receivables help you collect the money for the orders that are delivered to the customers.

Oracle Human Resources helps maintain the Employee information, helps run paychecks etc.

Oracle General Ledger receives information from all the different transaction modules or sub ledgers and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc. For Example: when you pay your employees in your organization then that payment is reported back to General Ledgers as cost i.e. money going out, when you purchase inventory items and the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items into your inventory, it is transferred to GL as money coming in, when your customer sends payment, it is transferred to GL as money coming in. so all the different transaction modules report to GL (General Ledger) as either “money going in” or “money going out”, the net result will tell you if you are making a profit or loss.

Oracle Fixed Assets All the equipment, shops, warehouses, computers can be termed as ASSETS and they are managed by Oracle Fixed Assets Module.

There are lot of modules keep adding everyday in Oracle Application. Oracle application is
acquiring other EPR software and Integrating all the software in one software. They want to name it as Oracle Fusion. But, this is not ending. This is starting point to new World of ERP.

17 comments:

Ramya Arani said...

Good...I Appreciate It:)
Keep Posting Phani.

phani said...

Sure, thank you for the compliment.

Unknown said...

Hey Phani.Its a good effort to make people understand for what these modules in oracle appliation.I really appreciate.Though I have expertise on other application a clear understanding on another application functionality will help me to switch to oracle easily.

Regards,
gururaj

phani said...

Hi Gururaj,
Functionality wise, you will find lot of things similar across all the ERP's.

If you are focus towards the Functional side, then gain some Industry knowledge and try to check the Implement and User guides of the Modules you want to Expertise in the Oracle Applications.

http://alloracletech.blogspot.com/2008/07/user-guides.html

You can download any version User Guides of many Modules directly from the link given above.

I have tried document the latest version Oracle Application new features. You can do through them in the following link.

http://alloracletech.blogspot.com/2008/08/release-12-new-features.html

I hope all these things would help you.

Anonymous said...

Hey Phani,

Excellent. I didn't read an article about 'What's all Oracle Application' simpler than this. Very nice. Keep it up

shoukath

asu khan said...

Hi Phani i work for an bank which uses an appl for corporate client its in oracle10g i work for project department where are task is to see proper flow of project includes(testing+supporting) where can i look forward too in my career can u plz tell me

phani said...

Hi Asu,
If you are working at the Technical side then I believe you are already excel in the PL/SQL language. Oracle has introduce many new tools like BPEL, SOA, OAframe work etc. You can learn more about these tools. OAframe work would replace form builder completely in the coming up versions, If you are expert in this tools, then you are always in business.

Regards,
Phani

Unknown said...

What is the significance of suffix:
_F, _B, _TL, _V, _ALL, _VL with the table names?

Unknown said...

What is the significance of suffix:
_F, _B, _TL, _V, _ALL, _VL with the table names?

phani said...

Hi depesh,
In Oracle Application, every Extension of the Table got it's own important.

_ALL : Table holds all the information about different operating units. When ever you see the table _ALL, you will always find the column org_id. org_id column would store the value of Operating Unit.

For more information related to the Multi Org, I suggest you to go through the following URL:

http://alloracletech.blogspot.com/2008/06/multi-orgorganization-functional-and.html

_TL are the translation tables. These tables provide multiple language support. You will always find the LANGUAGE column in these tables.

Example:- Say, if you are implementing the Oracle Apps Inventory module for Europe Nation, then you have to support many language. The Items you define should have define in many language. You will define Item once, but say German people understand only Germany. So you define Item and in the description you give the Item description in Germany. For same item, for France, you define description of item in French.

MTL_SYSTEM_ITEMS_B is the table which stores the information definition of the Item.

MTL_SYSTEM_ITEMS_TL stores in the information about the Language.

If your project has implemented multiple language then you can filter based on language column from translation table.

_B these are the BASE tables.

Example, as I have mentioned MTL_SYSTEM

_F these are date tracked tables, which occur in HR and Payroll. For these tables you will always find two columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.

_VL are views for multi language tables

--Phani

Unknown said...

Thanks a lot Phani for the information

phani said...

You welcome dude.

--Phani

Unknown said...

very good article that explains the basic terms and the mandotory need to know business flow functionality as simple & as good as possible. Tnq...keep up ur work buddy

Vinoth Kumar Madanagopal said...

Very good article which explains clearly about the basic modules of oracle apps...Thank you
You are good functional guy

Geetu said...

Very good article...

karthik said...

hi phani
thanks for the article...it is very helpful...
could you please give me a suggestion...?
I am right now working in oracle forms 6i and 10g I am planning my career in oracle apps in near future so could you please say what are the pre-requisites we should have ..?
thanks in advance

Unknown said...
This comment has been removed by a blog administrator.