Tuesday, March 22, 2011

Important Links To Learn Oracle Apps

To learn Oracle apps there are many online resources and blogs but few are oftenly used links...These are the important links
1) Oracle Apps Release 12 Documentation Library
2) Oracle E-TRM(Technical Reference Manual) contains all the tables,packages,procedures details in this link
3) Oracle E-Delivery https://edelivery.oracle.com/  
Solution Beacon(Access VIS 12 Instance) http://www.solutionbeacon.com/ 
4) This blog is very helpful to learn the oracle apps from basicshttp://oracle.anilpassi.com/  and 
5)Oracle Forums http://forums.oracle.com/forums/main.jspa?categoryID=84 

How to Install Oracle apps

Many of you might have doubt how to learn this oracle apps..How to install this software?..how to configure and where to install it?

This post answer all  the above questions..Oracle apps or Oracle E-Business Suite(EBS) software release 11i/12 (R12) — a bundling of several  Applications  — in February 2007.
Refer this two links to install Oracle Apps software in you own PC
 Install Oracle Apps in your own system
but you should have some background knowledge in UNIX and the system hardware requirement should be high configuration.
To learn Oracle apps without installing it in your system you can use the Online Oracle apps software(Internet Connection is Mandatory)..Its working under cloud computing technology providing Software as a service(SaaS).Solution Beacon is a oracle registered website for learning oracle apps..While registering it will ask for CSI(Customer Support Identification) number if you have just enter that CSI number else refer to this link don't have CSI no.Solution beacon provides access to Vis12 instance

You can learn E-business suite using this public e-business suite instance

Monday, March 21, 2011

Roles In Oracle Apps

In oracle apps there are 3 roles
1) Functional Consultant
2) Technical Consultant
3) DBA(Database Administrator)

In oracle apps these are the basic modules
AP -> Account Payables  
AR -> Account Receivables 
GL -> General Ledger
FA -> Fixed Assets 
CM -> Cash Management 
INV -> Inventory
PO  -> Purchasing Order
OM  -> Order Management
BOM -> Bill Of Material
WIP -> Work In Progress
HRMS -> Human Resource Management and  PAYROLL

If you understand the full functional flow of any one particular module say AP then you are functional consultant in AP module.Functional people know how to navigate the front end and how to create an entry in front end.They collect requirements from direct client and the collected requirements passed to Technical Consultant in the written format called MD050 document.Tools used by functional consultant are browser( to view the front end).

All the data entered by functional consultant stored in the database tables.So,the job of techncial consultant is to navigate through the tables affected for that particular entry.Technical consultant design the reports,interfaces,form customizations components.After completing their task technical consultant people create a document to end user called MD070 document.This contains the coding part and the steps how to run the program.Tools used by technical consultant are Toad(to communicate with database),Browser(To see the front end),Transfer Client like (Filezilla),Putty,Oracle Reports Developer,Form Developer, SQL Devloper.

After knowing what is functional consultant and technical consultant everyone's mind trigger to this question called which one is best either functional or technical...In my point of view both are important

DBA(Database administrator's) maintain the oracle apps server and he maintain the security type of issues.

Refer this link in which consultant you want to be a?
Refer this link to know the pre-requistes to be a technical consultant?

Thursday, March 10, 2011

What is Oracle apps?????

Before i start with what is oracle apps i will tell you what is ERP?
erp system ERP System
ERP(Enterprise Resource Planning) is more of a methodology than a piece of software, incorporates several software applications, brought together under a single, integrated interface.To say it as shortly it's Integration of all the modules.In olden days for each module(Manufacturing,Financials, CRM, SCM, HRMS) they maintained individual software but as the business and technology grows there will be a circumstance need to communicate  between the modules which not possible using olden technology since each module is a different softwares.But now the oracle corp created a software by integrating all the modules together is called Oracle E-Business Suite otherwise called as Oracle apps.The main competitor of oracle E-Business suite is SAP ( System Applications Products). There are few more ERP systems like Infor,Epicor, Microsoft Dynamics.

Organization of the application modules in Oracle E-Business Suite