Thursday, August 14, 2008

List of Oracle AIM Documents

Technorati Tags:
1. 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 High-Level Process Vision
BP.070 Develop High-Level Process Design
BP.080 Develop Future Process Model
BP.090 Document Business Procedure
2. Business Requirements Definition (RD)
RD.010 Identify Current Financial and Operating Structure
RD.020 Conduct Current Business Baseline
RD.030 Establish Process and Mapping Summary
RD.040 Gather Business Volumes and Metrics
RD.050 Gather Business Requirements
RD.060 Determine Audit and Control Requirements
RD.070 Identify Business Availability Requirements
RD.080 Identify Reporting and Information Access Requirements
3. Business Requirements Mapping
BR.010 Analyze High-Level Gaps
BR.020 Prepare mapping environment
BR.030 Map Business requirements
BR.040 Map Business Data
BR.050 Conduct Integration Fit Analysis
BR.060 Create Information Model
BR.070 Create Reporting Fit Analysis
BR.080 Test Business Solutions
BR.090 Confirm Integrated Business Solutions
BR.100 Define Applications Setup
BR.110 Define security Profiles

4. Application and Technical Architecture (TA)
TA.010 Define Architecture Requirements and Strategy
TA.020 Identify Current Technical Architecture
TA.030 Develop Preliminary Conceptual Architecture
TA.040 Define Application Architecture
TA.050 Define System Availability Strategy
TA.060 Define Reporting and Information Access Strategy
TA.070 Revise Conceptual Architecture
TA.080 Define Application Security Architecture
TA.090 Define Application and Database Server Architecture
TA.100 Define and Propose Architecture Subsystems
TA.110 Define System Capacity Plan
TA.120 Define Platform and Network Architecture
TA.130 Define Application Deployment Plan
TA.140 Assess Performance Risks
TA.150 Define System Management Procedures

5. Module Design and Build (MD)
MD.010 Define Application Extension Strategy
MD.020 Define and estimate application extensions
MD.030 Define design standards
MD.040 Define Build Standards
MD.050 Create Application extensions functional design
MD.060 Design Database extensions
MD.070 Create Application extensions technical design
MD.080 Review functional and Technical designs
MD.090 Prepare Development environment
MD.100 Create Database extensions
MD.110 Create Application extension modules
MD.120 Create Installation routines

6. Data Conversion (CV)
CV.010 Define data conversion requirements and strategy
CV.020 Define Conversion standards
CV.030 Prepare conversion environment
CV.040 Perform conversion data mapping
CV.050 Define manual conversion procedures
CV.060 Design conversion programs
CV.070 Prepare conversion test plans
CV.080 Develop conversion programs
CV.090 Perform conversion unit tests
CV.100 Perform conversion business objects
CV.110 Perform conversion validation tests
CV.120 Install conversion programs
CV.130 Convert and verify data

7. Documentation (DO)
DO.010 Define documentation requirements and strategy
DO.020 Define Documentation standards and procedures
DO.030 Prepare glossary
DO.040 Prepare documentation environment
DO.050 Produce documentation prototypes and templates
DO.060 Publish user reference manual
DO.070 Publish user guide
DO.080 Publish technical reference manual
DO.090 Publish system management guide

8. Business System Testing (TE)
TE.010 Define testing requirements and strategy
TE.020 Develop unit test script
TE.030 Develop link test script
TE.040 Develop system test script
TE.050 Develop systems integration test script
TE.060 Prepare testing environments
TE.070 Perform unit test
TE.080 Perform link test
TE.090 perform installation test
TE.100 Prepare key users for testing
TE.110 Perform system test
TE.120 Perform systems integration test
TE.130 Perform Acceptance test

9. PERFORMACE TESTING(PT)
PT.010 - Define Performance Testing Strategy
PT.020 - Identify Performance Test Scenarios
PT.030 - Identify Performance Test Transaction
PT.040 - Create Performance Test Scripts
PT.050 - Design Performance Test Transaction Programs
PT.060 - Design Performance Test Data
PT.070 - Design Test Database Load Programs
PT.080 - Create Performance Test TransactionPrograms
PT.090 - Create Test Database Load Programs
PT.100 - Construct Performance Test Database
PT.110 - Prepare Performance Test Environment
PT.120 - Execute Performance Test

10. Adoption and Learning (AP)
AP.010 - Define Executive Project Strategy
AP.020 - Conduct Initial Project Team Orientation
AP.030 - Develop Project Team Learning Plan
AP.040 - Prepare Project Team Learning Environment
AP.050 - Conduct Project Team Learning Events
AP.060 - Develop Business Unit Managers’Readiness Plan
AP.070 - Develop Project Readiness Roadmap
AP.080 - Develop and Execute CommunicationCampaign
AP.090 - Develop Managers’ Readiness Plan
AP.100 - Identify Business Process Impact onOrganization
AP.110 - Align Human Performance SupportSystems
AP.120 - Align Information Technology Groups
AP.130 - Conduct User Learning Needs Analysis
AP.140 - Develop User Learning Plan
AP.150 - Develop User Learningware
AP.160 - Prepare User Learning Environment
AP.170 - Conduct User Learning Events
AP.180 - Conduct Effectiveness Assessment

11. Production Migration (PM)
PM.010 - Define Transition Strategy
PM.020 - Design Production Support Infrastructure
PM.030 - Develop Transition and Contingency Plan
PM.040 - Prepare Production Environment
PM.050 - Set Up Applications
PM.060 - Implement Production Support Infrastructure
PM.070 - Verify Production Readiness
PM.080 - Begin Production
PM.090 - Measure System Performance
PM.100 - Maintain System
PM.110 - Refine Production System
PM.120 - Decommission Former Systems
PM.130 - Propose Future Business Direction
PM.140 - Propose Future Technical Direction

Monday, June 23, 2008

Creating Custom Reports using DBI Designer

Using the Daily Business Intelligence Designer responsibility we can create custom DBI reports or dashboards based on Oracle EBS views or tables. To create a new report, select the Report designer Menu item. Enter the Report attributes like name and Application. Select the functional area as Customer Defined.

image

Select the required view or table as the data source. The lookup will find the object if apps user has privileges on the object.

image

Once the table or view is selected, the designer shows all the fields available. We can select any fields required for the report and associate it with a seeded dimension or set the column as a measure. If a dimension object is selected then we can associate it with a corresponding seeded dimension object mapping. Enter the display label needed for this column on the report. Click finish.

image

Once the tabular report with columns is selected, it will show up as shown below. The top section saying Oracle Report1 is the report name and can be customized with the report title. The section below that is usually used for selecting parameters. The section below that is used for adding in a graph for the report. Click on Save or Finish and the report witl show up as an item in the Customer Defined functional area.

image

We can then enable this menu item to any responsibility, so users can access this report from the corresponding responsibility.

Thursday, May 22, 2008

Oracle Daily Business Intelligence

Overview of Daily Business Intelligence

Daily Business Intelligence is an integrated out-of-the-box reporting and analysis
application that enables senior managers and executives to see relevant, accurate, and
timely information using self-service dashboards. The data is refreshed in these dashboards based on incremental nightly loads from Oracle E-Business suite applications.




Intelligence Areas


The following intelligence areas leverage the Daily Business Intelligence reporting and analysis framework:

• Customer Support
• Depot Repair
• Field Service
• Financials
• Human Resources
• Interaction Center
iStore
• Maintenance
• Marketing
• Product Lifecycle Management
• Projects
• Procurement
• Quoting
• Sales
• Service Contracts
• Supply Chain

Perform the common Daily Business Intelligence setup steps before you set up the
dashboards provided by each intelligence area. Current DBI is supported on both 11i and R12 release versions of Oracle Applications.

Architecture Overview



Pre-Packaged DBI Content


Oracle BI Strategy



Daily Business Intelligence provides the ability to drill down directly to the transaction detail from the dashboards

Thursday, May 1, 2008

Discoverer Vs DBI


Advantages of DBI


• Easy and simple reporting
• Over 40 Overview pages and 900 pre-canned reports available
• Complete cross-module visibility from Oracle single sign-on.
• Drill features Integrated with the ERP modules into Order Management, Procurement, Purchasing etc.
• Easy to maintain and refresh objects
• All reports Web enabled and user friendly.
• No Additional software or end-user training is needed to use it. (Html reports)
• Very efficient and reports render in a very short time. (no performance issues!)
• Use Apps security model and integrated with Apps.
• Users can customize pages and reports based on other existing DBI content.


Advantages of BIS
Discoverer

• Ad-Hoc Query capability, to create custom workbooks based on needs.
• More than a 1000 folder items and 200 reports.
• Folders based on the Transactional tables available, so data is current.

Tuesday, April 22, 2008

Discoverer Architecture and Creating Workbooks


Discoverer Architecture Components


• Uses an “End User Layer” (EUL)
• Groups information into “Business Areas” (like Schemas or Modules)
• Each Business Area contains “Folders” (like Tables or Views)
• Each Folder contains “Items” (Columns or fields)
• Items are used to create “Workbooks” (reports)





Business Areas Overview

– A business area is a set of folders containing related information.
– Similar to a Database Schema or Business Application Module
– Multiple business areas may share the same data.
– The exact combination of tables and views for each department is usually unique.




Workbooks Overview

• The following types of Workbooks can be created
– Table
– Page-Detail Table
– Crosstab
– Page-Detail Crosstab
• Each workbook can contain multiple Worksheets, similar to Excel



Creating a Workbook

• Steps to create a new workbook

1. Set up default formats for all new Worksheets (optional)
2. Choose a layout for displaying your information
3. Choose an area from which to gather your information
4. Choose the pieces of information you want to view
5. Choose the layout of your information

• Choose a Layout for displaying your information
– Choose File New.
– The Workbook Wizard is displayed
– Choose the desired layout
– Select Next to display Workbook Wizard: Step 2
– Click Next. The Workbook Wizard: Step 3 opens.
– Modify the layout of your information
– Click Finish.




Choose an Area which contains your information






• Click Finish to display the sheet
• Select all the result columns
• Click Format Column Autosize to set the column width or adjust them manually by dragging the column borders
• You can rename any sheet by double clicking its tab

• Workbooks can be saved in either of two ways:
– To the Local or Network drive as a *.DIS file. Only the Configuration data is stored on the drive – the Report data resides in the database
– To the Discoverer Database. The Configuration data is stored in the database along with the Report data