Thursday, 19 January 2012

Oracle Apps RICEW Component



RICEW Component
sql & plsql
Module Knowledge(Flow)
RICEW Component


Reports
========
--Oracle RDF reports
--Oracle XML reports
Oracle Discovery Reports
--Oracle PL SQL Reports

Interface
=========
--Flate file -->(sql loader)(Inbound) --> Staging table
--Staging table --> (PL Sql with Validation)--> Interface tables
--Interface tables--> (Standard CP) --> Base Tables

Conversion
==========
--Staging table (For Data Store and error)
--Sql Loader for data load
--utl files  for data load
--write procedure to validate and load data to interface table.
--run standard program to transfer data to base table

Extensions
==========
Oracle New Form Development
--Oracle Form Customization
--Oracle Form Personalization
--Using Custom.pll to meet the requirement.

Work Flow
==========
Creating new workflow.
Customizing existing workflow.

 

Friday, 13 January 2012

End-to-End Implementing


End-to-End Implementing
May mean different things to different people. To me,
It means implementing a given module or modules from the
Analysis phase all the way to post-implementation support.
It means that you work with the client to


Identify their requirements.
  1. Map those requirements to Oracle.
  2. Identify gaps (i.e. areas where Oracle does not fit the requirements, solution by customizations).
  3. Suggest process work-around.
  4. Design customizations if necessary to solve remaining gaps.
  5. Develop the code and test it.
  6. Conduct multiple CRPs (Conference room pilots).
  7. Go live.
  8. Post go-live support.

Thursday, 12 January 2012

Technical Terms in Oracle Apps explained through real time example


Technical Terms in Oracle Apps explained through real time example

The below example explains the important terms and concepts used in the Oracle E-Business Suite.

Say Santosh Kumar is the owner of a wholesale laptop shop. He buys various laptops like Apple, Dell, Lenovo and HP etc from manufacturers directly and sells them to retail shop owners and also to the direct customers.

These manufacturers are referred to as VENDORS/SUPPLIERS in Oracle Applications. Hareesh
keeps track of all his vendors’ information like addresses, bank account and the amount he owes to them for the laptops that he bought etc, in a book named PAYABLES.

Hareesh gets an order from a retail shop owner of Lap Mart, for a shipment of 11 of Apple, 25 of Dell and 32 of Lenovo. In Oracle Apps, size is referred to as UOM (unit of measure), Lap Mart is called CUSTOMER and the order is referred to as SALES ORDER. Hareesh maintains a book called
ORDER MANAGEMENT where he writes down all the details of the SALES ORDERS that he gets from his customers.

Say the laptops have been shipped to the customer Lap Mart. Hareesh now sends him the details like cost of each Laptop, the total amount that the customer has to pay etc on a piece of paper which is called INVOICE / TRANSACTION. Once the INVOICE has been sent over, the customer then validates this against the actual quantity of laptops that he received and will process the payments accordingly. The invoice amount could be paid as a single amount or could be paid in installments. Hareesh’s customer, Lap Mart pays him in installments (partial payments). So Hareesh has to make a note of the details like date received, amount received, amount remaining, amount received for what goods/shipments/invoice etc, when Hareesh receives the payments. This detail is called RECEIPT, which will be compared to the invoice by Hareesh to find how much Lap Mart has paid to him and how much has to be paid yet. This information is maintained in a book named RECEIVABLES to keep track of all the customers, their addresses (to ship the items), what and how much he has shipped to his customers and the amount his customers owe him etc.

Hareesh’s laptop business has begun to improve and has attracted more and more customers. As a result, Hareesh decided to buy a building to stock more laptops. In Apps, this building is known as WAREHOUSE and all the laptops are referred to as INVENTORY. Due to increase in customers, Hareesh needs to hire more people to help him out in his business without any hiccups. These workers are called EMPLOYEES. At the end of every month, Hareesh pays the salary for all his employees through Checks. These checks are nothing but PAYROLL in Apps.

At the end of every month, Hareesh prepares a balance sheet in a book called GENERAL LEDGER to determine how much profit/loss he got and keeps track of the money going out and going in.

As the business grows, it becomes impossible to record everything on a paper. To make everybody’s life easier, we have very good tools in the market, which help the business men to keep track of everything. One such tool is Oracle E-Business Suite.

Oracle Applications is not a single application, but is a collection of integrated applications. Each application is referred to as a module and has it own functionality trying to serve a business purpose.

Few of the modules are Purchasing, Accounts Payables, Accounts Receivables, Inventory, Order Management, Human Resources, General Ledger, Fixed Assets etc.

Here is a high level business use of various modules:

Oracle Purchasing handles all the requisitions and purchase orders to the vendors.
Oracle Accounts 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 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.

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

Tuesday, 10 January 2012

Types of projects in Oracle Applications

Types of projects in Oracle Applications
  • Implementation Project
  • Customization Project
  • Migration / Up-gradation ( 11.5.9 , 11.5.10.2 & R12.1. and R12.++)
  • Supporting / Maintenance
Implementation Project:
Client will be using another software to Maintain the business solution. now the client wants to have Oracle applications Package to capture the data.
That time we will start setups, data conversions, gap analysis, functions document prepare from the scratch - first time.                           

Customization Project:

Client was already using Oracle Applications, now the client would like to have few more modules to cover the business, for that we will customize new modules and integrate with existing modules.

Migration / Up-gradation Project:

Client was already using oracle applications older version now client would like to move new version of Oracle Applications that time we will migrate older version objects in to new version.

Supporting or Maintenance:

Once the implementation, customization and migration are over, then supporting project will be started where we will give supporting for the objects which were already developed, customized and migrated.

Oracle Applications Roles and Responsibilities in brief

Oracle Applications Roles and Responsibilities in brief

Functional:
  • Gather Business Requirement
  • Prepare MD050 Document
  • Prepare BR100 setup Document
  • Functional setup

Technical:

Develop RICE components.
  • R - Reports     -- Reports 6i, 10g
  • I - Interface   -- Programs, SQL, PL/SQL
  • C - Conversion-- Programs, SQL, PL/SQL
  • E - Extension  -- Forms 6i, 10g

Document Preparation:

  • MD050: Functional Design Document
  • MD070: Technical Design Document
  • MD120: Migration Or Installation Document
  • CV040: Conversion Functional Document
  • CV060: Conversion Technical Document
  • TE020: Unit Test Cases Document

Performance Tuning:

  • Prepare sequel queries based on end user requirement.
  • Attend weekly Meeting.

Legacy System:

Any software other than Oracle Apps. ( Ex: AutoCAD, TIBCO, SAP, Mainframes. )
 
 

Thursday, 5 January 2012

Types Of Modules in Oracle Apps


Types Of Modules in Oracle Apps

Types Of Modules in Oracle AppsModule: Module is nothing but one application it contains forms, reports and programs which are related for specific business functionality.

Example: PO - Module - This will be used to capture purchasing information like suppliers. their contact details, supplying material, unit price and discounts and so on.


ERP: Enterprise Resource planning

Financial: 
  • AP -  Account Payable
  • AR -  Account Receivables
  • FA -  Fixed assets
  • CM - Cash Management
  • GL - General Ledger
  • PA - Project Accounting

Manufacturing:
  • PO    -      Purchase Order
  • Inv   -      Inventory
  • WIP  -      Work in Process
  • BOM -      Bill of Material
  • OM   -      Order Management, Production, MRP Schedules and Enquiring

HRMS:
  • People
  • Payroll
  • Benefits
  • OTL  - Oracle Time & Labour

CRM:      Customer Relationship and management
  • Tele Services
  • Service Contract
  • Mobile Process

Wednesday, 4 January 2012

What is General Ledger?


What is General Ledger?

General Ledger is one of the core modules in oracle apps. The Oracle General Ledger is the central repository of accounting information. The main purpose of a general ledger system is to record financial activity of a company and to produce financial and management reports to help people inside and outside the organization make decisions.

Here are the major functions of General Ledger:
  • General Ledger is a central repository of all your financial transactions.
  • All sub-ledger data (AR, AP, INV, WIP, etc.) eventually flows into General Ledger.
  • At the end of each month, quarter, year one has to close your current period and open the next period on your transaction calendar.
  • Financial reporting occurs out of your General Ledger.
  • All financial statements are generated out of General Ledger.
  • Journal Import” is a “one stop” interface for any data that comes into GL from external sources (e.g: Sub Ledgers, external accounting systems, legacy data, etc.)
  • You can recognize revenue in several currencies in a single installation of General Ledger.