Posted on July 11th, 2008 by admin
Data Conversion for Oracle Applications
This topic is shared to provide an overview of Data Conversion for Oracle ERP.
Approach used for Data Conversion
1. Conversion Data Mapping ( map to specify the data of legacy system –> data of oracle ERP system )The data mapping process provides detailed lists of the data sets and data elements that […]
2 Comments »
Filed under: ERP, Interview Questions(& answers), Oracle Apps
Posted on July 7th, 2008 by admin
I hope this will help the BI practiser to evaluate the tools used at different process and the available tools.
Types of business intelligence toolsThe general categories of business intelligence tools are:
1.Spreadsheets[1]
Lotus 1-2-3
Microsoft Excel
Apple Numbers
OpenOffice.org
more
2.Reporting and querying software - are tools that extract, sort, summarize, and present selected data […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Interesting, Interview Questions(& answers), Software
Posted on July 3rd, 2008 by admin
ERP tables - WF (Work Flow)
brief ( and important ) details of WorkFlow tables.
lets first learn some definations.
A process activity is a modelled workflow process, which can be included as an activity in
other processes to represent a sub–process.
A notification activity sends a message to a performer.
A functions activity performs an automated function that is […]
No Comments »
Filed under: 11i, ERP, Glossary, Interview Questions(& answers), Oracle Apps
Posted on July 2nd, 2008 by admin
Why Build a Data Warehouse?
For decades, companies have been spending millions of $$$’s on systems to streamline and automate the execution of the business plan. Over time, these systems have become more and more integrated within a companies operations and between business partners. However, due to the granularity of the data stored in […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Interview Questions(& answers)
Posted on July 1st, 2008 by admin
Oracle Applications Glossary
This is something which will help the newbee for their familiarity of Oracle apps terms.Also can be found on Oracle download site.
This combined glossary defines terms we use in the Assets, Cash Management, General Ledger, Payables, Projects, and Receivables User’s Guides and in various country-specific and region-specific manuals.
4-4-5 calendar
A depreciation calendar with 12 […]
No Comments »
Filed under: Interview Questions(& answers), Oracle Apps Glossary
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
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 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 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 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 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)
Posted on June 16th, 2008 by admin
Development life cycle of a DW ( Data Warehouse ) project.
The DW project follows following different stages.
1. Requirement Gathering
2. Physical Environment Setup
3. Data Modeling
4. ETL
5. OLAP Cube Design
6. Front End Development (Reports )
7. Performance Tuning
8. Quality Assurance
9. Rollout To Production
10. Production Maintenance
11. Incremental Enhancements
google.load(”visualization”, […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DBA (DataBase Administrator), DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Production Maintenance
After the DW project goes live activities like taking backup on regular time period and mangaging crisis becomes very important and needs to be planned well in advance.
The other task is to monitor the Users and to know how much they utilize the DW; so future enhancements can be planned.
Next >> Incremental Enhancements
[…]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Rollout To Production
After the QA team completes the testing ,they will give thumbs up(signoff document) to go to Production servers. It will take less then a week to go to live once everything is tested and approved.
Deliverables
· Delivery of the data warehousing system to the end users.
Next >> Production Maintenance
[…]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Front End Development of Reports
In this phase of DW project if the reports are not bringing any value to the end user or executive, then the efforts to build the OLAP cube is wasted. so its very important to think about the end reports and timely delivery of reports to the end user. It is […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), Oracle Apps, Reports