---

Quick Links

News | The Premier Online | Ministries & Organizations | Job Opportunities | Main Index

---

Contents

• B.C. Home
• Ministry of Environment
• Ministry of Agriculture and Lands
• CSD
  • IMB
    • Services
      • Database Services
      • Management Services
      • Application Services
      • Information Management Services
      • Technology Services
      • Web Services
        • File Transfer Service (SOFT)
      • Data Services
    • Organization
      • Business Plan
      • Corporate Information Architecture
      • Web Services
      • GIS and Access Support Services
      • Application Development Services
    • Standards
      • Alphabetical List of All Standards
      • Application & Architecture
      • Project Management
      • Standards for Standards
      • System Development Life Cycle (SDLC)
      • Technology
      • Web
    • Projects
      • Corporate Information Architecture
      • Web Services
      • Data Management Services
      • GIS and Access Support Services
      • Application Development Services
      • Land and Resource Data Warehouse
  • Reports and Publications
  • Branch Contacts

B.C. Home » Environment » CSD

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 1: Sample

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://csdgww.bcgov/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]