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 […]
No Comments »
Filed under: AOL (Application Object Library ), ERP, Interview Questions(& answers)
Posted on June 30th, 2008 by admin
Is Data Warehousing Essential to Business Intelligence?
The role of data warehousing is changing as companies move toward using new business intelligence approaches.
Over the last few issues of this newsletter, I have been writing about the impact of Enterprise 2.0 approaches on business intelligence (BI). I intended this time to write about how business intelligence […]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on June 30th, 2008 by admin
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 […]
No Comments »
Filed under: Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
Interview Questions - Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS
Continued from http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-01
11.What are the Quick-codes in Oracle Receivables? Describe? Freight Carriers, Demand Class, Customer Category, Customer Class
12.How will you send the Information about Invoices? Describe the Frequency?Through Statement Cycles, The Interval between dates like Weekly, Monthly, Quarterly
13.What is used to notify customers […]
1 Comment »
Filed under: ERP, Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
Interview Questions - Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS
1.What are the Key Flex Fields in Oracle Receivables? Sales tax Flexfields
Territory Flexfields
2.What is the Payment Term in AR?
How You are going to Receive the Amount from Customers […]
1 Comment »
Filed under: 11i, ERP, Interfaces, Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
The Most Successful Business Intelligence Tool
When evaluating, selecting and deploying business intelligence tools, one of the most important steps is to understand which segment of user needs you are trying to fulfill and then match the tool to that segment.
Business intelligence (BI) has become a smorgasbord of user interfaces, with certain modules generating more excitement […]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on June 30th, 2008 by admin
The Business Intelligence and Data Warehousing Glossary
I have collected and compiled this from a very nice website.Some of the terms are relating to Microsoft’s tool (Microsoft’s Analysis Services ) but that can be generalised to other non-microsoft tools also.
Link >>
Agent
An application that searches the data and sends an alert when a particular pattern is found.
Aggregations
Information […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), OBIEE, PL/SQL, Reports, SQL
Posted on June 27th, 2008 by admin
I am proud of our GREAT INDIANS…I received this collection from forwarded emails.This is my way of forwarding to the world about our great great Indians.
ARYABHATT
(476 CE) MASTER ASTRONOMER AND MATHEMATICIAN
Born in 476 CE in Kusumpur (Bihar), Aryabhatt’s intellectual brilliance remapped the boundaries of mathematics and astronomy. In 499 CE, at the age of 23, […]
1 Comment »
Filed under: Interesting
Posted on June 27th, 2008 by admin
I was asked by my junior consultant what is Agile Software Development ?
I paused for a while and was wondering myself of what it really meant though I very well know what software development means…..
I found nice defination from Wikipedia as below.
“Agile Software Development is a conceptual framework for software development that promotes development iterations, […]
No Comments »
Filed under: Interview Questions(& answers), Software
Posted on June 26th, 2008 by admin
Life cycle of a DW ( Data Warehouse ) project
After many requests ,I am compiling everything in one page for easy page navigation and easy learning.hope you like it.
1 )Requirement Gathering
Requirements Gathering is started by directly discussing or with JAD sessions (Joint Application Development) with the End users .The help of Business leader or Business […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps, Reports, SQL
Posted on June 23rd, 2008 by admin
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 […]
1 Comment »
Filed under: AOL (Application Object Library ), DBA (DataBase Administrator), ERP, Forms, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL
Posted on June 23rd, 2008 by admin
USER EXITS: USER EXITS are the 3rd party programs (i.e. java,Pro*c, etc.) that we can link with our reports to perform a particular task.
We can link 3rd party programs with our reports with SRW.USER_EXIT ( Name_of_the_User_Exit)’. We can reference the input parameters in user exist with SRW.REFERENCE( input_parameters).
FND SRWINIT: This User Exit is used to […]
No Comments »
Filed under: AOL (Application Object Library ), ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL
Posted on June 20th, 2008 by admin
This short Article shows the basic Installation steps in installing OBIEE on your windows PC.
Pre-requisite
Computer with Windows XP (Home Basic) ,RAM 2GB, HDD approx 80 GB
JDK 1.5 installed and JAVA_HOME created.
Download the OBIEE setup from the www.Oracle.OTN.com. After downloading, I recommend to unplug the internet (turn off wireless internet or unplug the LAN wire )from […]
9 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, OBIEE, Reports
Posted on June 20th, 2008 by admin
create JAVA_HOME quickly with following steps on Windows XP (Home Basic)
The goal is to create a new variable called JAVA_HOME in Windows Operating system,so get access to System Properties window and create new variable called ‘JAVA_HOME’ and insert value where your BIN folder of JDK within your system.
more detailed steps as below.
1)Right Click on “computer”
2)Select […]
1 Comment »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Oracle Apps, Software
Posted on June 18th, 2008 by admin
Benefits of data warehousing
Some of the benefits that a data warehouse provides are as follows:
A data warehouse provides a common data model for all data of interest, regardless of the data’s source. This makes it easier to report and analyze information than it would be if multiple data models from disparate sources were used to […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 18th, 2008 by admin
Repository is a place where data are stored and maintained. A repository can be
a place where data is stored
a place where specifically digital data are stored
a site where eprints are located
a place where multiple databases or files are located for distribution over a network,
a computer location that is directly accessible to the user without […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 18th, 2008 by admin
Metadata (singular: metadatum) (sometimes called Metainformation) is “data about data”, of any sort in any media. An item of metadata may describe an individual datum, or content item, or a collection of data including multiple content items.
Metadata (sometimes written ‘meta data’) are used to facilitate the understanding, characteristics, and management usage of data. The metadata […]
No Comments »
Filed under: DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 17th, 2008 by admin
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 […]
No Comments »
Filed under: DBA (DataBase Administrator), DataWarehousing, Interview Questions(& answers), PL/SQL, SQL
Posted on June 17th, 2008 by admin
How to find a column in database
Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. […]
1 Comment »
Filed under: 11i, Business Intelligence, DataWarehousing, Discoverer, ERP, Oracle Apps, PL/SQL, SQL
Posted on June 16th, 2008 by admin
Incremental Enhancements
After the system is up and running in the Production environment,there are situations where small and minor changes arises.(Incremental Enhancements).The task can be as simple as to do the changes in the production environment,but is highly risky to do on live (production)systems.Do the chnagses on the Developmetn and roll out the changes in the […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)