Ministry Home Page top_bar Government of British Columbia
Information Management Branch Ministry of Sustainable Resource Management
Organization Services Standards and Architecture Projects

spacer
spacer

SDLC STANDARDS

ORACLE REPORTS

Version 1.2                 March 10, 2006

This page contains the published standards for the Ministry's approach to Oracle Reports

Table of Contents

VERSION CONTROL

1.      INTRODUCTION
1.1    Purpose
1.2    Audience
1.3    Assumptions
1.4    Other Standards
 
2.      Client-Side Report
 
3.      Reports-Server

4.      Web-Based Reports (This section is under review.)

FIGURES

Figure 1Sample

VERSION CONTROL

This section of the document records the various versions or releases of this document

Table 1: Version Control

Version Details/Description Distribution Date Author Organization
1.0
Whole document
??
22 Mar 2002
??
??
1.1
Updates based on Final Report
??
9 Jul 2004
Chris Burd
Catchword Info Design
1.2
Update report templates to reflect new Ministry names.
Section 1
10-Mar-06
Jordan Armstrong
OA Solutions

[TOC]

1.      INTRODUCTION

Oracle Reports is the reporting standard for Ministry applications. All new reports should be developed for the Oracle Web Reports environment.

Developers must use the Standardized Reports Templates to ensure a common look-and-feel for reports. Separate templates for MAL and MOE are available for download at:

Ministry of Agriculture and Lands Templates - 10g
Ministry of Environment Templates - 10g

[TOC]

1.1      Purpose

The purpose of this document is to provide contractors and Ministry staff with an overview to the Oracle Reports approach used by the Ministry.

1.2      Audience

This document is intended for the use of all Application Administrators, Project Managers, Project Leaders, Business Analysts, Database Designers and Developers involved in planning and delivering applications for the Ministry.

All contractors engaged to perform all or some of the Oracle Reports functions are instructed to follow and conform to the standards outlined in this document. This fact must be specified in the RFP and the contract.

 1.3      Assumptions

It is assumed that users of this document are familiar with the basic functions and applications of Oracle Reports.

1.4      Other Standards

Reports delivery standards can be found at: http://srmgww.bcgov/landinfobc/imb/bas/app_arch/standards/reports_server_delivery_standards.html.

Other related standards can be found on the IMB All Standards page.

 

[TOC]

 2.      Client-Side Reports

Client-side reporting is used for legacy reports only. Oracle will end support for client-side reports in 2004.

3.      Reports-Server Reports

Reports-server reporting are used for some long-running and/or 'batch' mode reporting (legacy reports only).
 

Reports-Server reports run on one or more Ministry Reports Servers and use the Developer6i toolset.

4.      Web-Based Reports

Oracle Web Reports is the standard for all new reports development.

[TOC]


footer Site Map Search Links Feedback Copyright footer