AIM (Application Implementation Method )

kamlesh8888
Categories: ERP, Project Management
Tags:

AIM (Application Implementation Method )

Posted on June 30th, 2008 by admin

AIM (Application Implementation Method )
Every Oracle apps consultant will be and should be aware of the documents related to his/her work profile depending if they are Functional or Technical consultant.
Business Process Architecture (BP)
BP.010 Define Business and Process Strategy
BP.020 Catalog and Analyze Potential Changes
BP.030 Determine Data Gathering Requirements
BP.040 Develop Current Process Model
BP.050 Review Leading Practices
BP.060 Develop […]

http://www.infopurple.com/aim-application-implementation-method

Database Normalization and Table structures

kamlesh8888
Categories: ERP

Database Normalization and Table structures

Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database.
There are 3 or 4 major steps involved known as
1NF (First Normal Form),
2NF (Second Normal Form),
3NF (Third Normal Form) and
BCNF (Boyce-Codd Normal Form).
There are others but they are […]

http://www.infopurple.com/database-normalization-and-table-structures

Interview Questions – Oracle AR (Functional) -Accounts Receivables 03

kamlesh8888

Interview Questions – Oracle AR (Functional) -Accounts Receivables 03

Interview Questions – Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS

some of the questions and answers listed here might repeat .from
http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-02
http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-01
1. How do you create a Chargeback Invoice ?
A. Using Receipts window
2. How do you adjust the amount of advance already received against an Invoice ?A. Create an Invoice for Deposit and receive an […]

http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-03

Create a Simple Flex Field Report

kamlesh8888
Categories: ERP

STEPS REQUIRED TO CREATE A SIMPLE FLEX FIELD REPORT (continued to FLEX Field Reports )
1. Open the Report in Report Builder.
2. Create User defined parameters as per our requirement.

3. Call FND SRWINIT User Exit in Before Report Trigger.
BEGIN
SRW.USER_EXIT (’FND SRWINIT’);
RETURN (TRUE);
END;
4. Call FND SRWEXIT User Exit in After Report trigger.
BEGIN
SRW.USER_EXIT (’FND SRWEXIT’);
RETURN (TRUE);
END;
5. Call FND […]

create-flex-field-report

ERP books for beginners

admin
Categories: EPB

When I started my career with Oracle Apps, I wished so hard if there were any books that would get me jump started. But times have changed now, for new comers to Oracle Apps there is ample of information available all around the web. This is an advantage and might also lead to some confusion as to where to begin.

Recently, Roel of http://www.altasen.com/ send me these awesome beginner books. I quickly glanced through it and knew at the first sight that these are truly useful resources for any beginner in Oracle Apps. So I asked one of my colleagues Kamlesh, who just started his career in Oracle Apps.

Flexfields for Oracle EBS
——————————

—————–


This book, I wished I had it in my early days and it would not had taken
that much of time to understand the topics of Flexfields and good screen shots to
understand the topics.

The topics of KFF and DFF are very well explained enough to be an expert.

BI Publisher for Oracle EBS
——————————

At the very first this books will tempt you to open through all the pages because of its cool green shiny
cover with nice animated nerdy charater.

This book is a real good start for myself. Havent touched those big
fat books for I was scared to invest considerable amount of time to commit for knowing BI publisher.

This book gives a very ground up start . With the simple and easy languange with lots of
screen shots to catch up the text description.

The book starts with the history of versions and the advantage of
learning BI publisher is that BI publisher developer can develop reports not just for Oracle but
also for Seibel,JD edwards and People soft.

The book gives step by step guided practice lessons. In short I would recommend this will be a great selection to start with

———————

Apart from the above two books, there are others in the series like System Administration and Workflow. I am looking forward to more topics being covered in similar style.

What is Oracle Apps (ERP)?

admin
Categories: ERP

(Also known as e-business suite)

Lets take an example. Suppose you are running a small grocery shop named “Janata 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.
Ocassionally 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 lets name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, 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.
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 10,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely no way! 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 Apps is not one huge software, instead it is a collection of software known as modules 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 webstore etc whereas 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 explaination, 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 transfered 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 is it 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 (ofcourse), Oracle Bills of Material, Order Management and so on..

There is more to ERP than this layman explanation of a complex beast that does not justify a single bit but I wished I had this knowledge when I was thrown into Oracle Applications right after I graduated from college. Back then the only piece of software I had known to write was implementing binary trees, infix, prefix, postfix notations in pascal and TSRs (Terminate and Stay resident) using assembly.

Did you like this article? If yes, would you please do me a favor by trying my company’s Dashboard Tool ? It has pre-built sample dashboards which you can demonstrate to your manager or use it to increase your BI and Apps skills. InfoCaptor is the most easy to use dashboard application which I personally put lot of thought in the design. I no longer work for anybody (yes I quit Oracle Corp!) and now just concentrating on growing this baby. I do independent consulting on the side to keep the engine running :-)

You folks have poured in so much love and wishes into this site and this article and I wish the same for my new product. Thank you for listening.