An Oracle Approach to

Environmental, Health,
and Safety Enablement

An Oracle White Paper

 An Oracle Approach to
Environmental, Health,
and Safety Enablement

INTRODUCTION
Companies aspire to be responsible members of their community by creating a safe environment for their employees
and minimizing their impact on the air, water, and land. In conjunction with those efforts, Manufacturing companies
also comply with a series of regulatory requirements aimed at addressing environmental, health, and safety (EHS)
issues.

EHS risk management is focused on the people, materials, and assets that are used to manufacture product and deliver
services. Processes that manage these resources must be established, monitored, and optimized to minimize the impact
on the environment and the health and safety of employees and the community.

To support the full range of their EHS responsibilities, each company must establish an infrastructure for capturing,
analyzing, and acting on data generated by their operations. Oversight bodies at the Federal, State, and local level
require reports using specific formats tied to applicable regulations. The approach at each Company will vary based
on the manufacturing processes and regulatory requirements that are unique to their organization. Each company will
also have a different initial level of maturity, perhaps driving them to start with manual processes and then to move
toward higher levels of sophistication over time.

The goal at Oracle is to provide a set of capabilities that can be leveraged to capture, store, and act on data generated by
the core business processes. The captured data can be used by the EHS team at each Company to develop process-
and regulation-specific plans and reports. Instead of providing a separate application that lays on top of the core
business processes and requires duplication of effort to populate and operate, Oracle embeds EHS operating, tracking,
and monitoring processes in the manufacturing processes that potentially affect the environment or the health and
safety of the employee or general population.

This White Paper provides an overview of the approach Oracle recommends for establishing the EHS infrastructure.
The model will entail the use of Oracle applications, process-specific Bills of Material and Routings, custom reports,
and third party software.

Oracle Solutions – Environmental, Health, and Safety Enablement Page 2

 ORACLE SOLUTIONS FOR EHS COMPLIANCE
As Oracle Applications are configured to support the business processes at each Company, they can also be configured
to monitor and capture the attributes of materials used in the manufacturing processes, transactions that use those
materials, and incidents that arise during operations. If incidents arise or audits identify risks, then responses and
corrective actions can be identified and monitored as well.

Oracle does not purport to be an expert on EHS laws and regulations and does not make an effort to maintain specific
processes or reports aligned to those legal requirements. Oracle’s reporting capabilities can be leveraged to generate
customized reports that display the unique information required by Federal, State, or Local regulators. As with other
business processes, the transactional flow and data elements can generally be configured to meet the specific regulatory
reporting requirements.

Figure 2 shows the general EHS functional requirements and aligns them with the Oracle module that can be used to
comply. This White Paper provides additional guidance on the approach that can be used to build the appropriate
infrastructure based on the unique requirements at each company location.

EHS Requirements Recommended Solution

Laws and Regulations Partner

Waste
Permits and Licenses Emissions eAM / Quality / Inventory / WIP
Exposures

Chemicals / MSDS Product Stewardship Workflow/Inventory Agile

Audit Management Quality

Industrial Hygiene Quality

Behavior Based Quality

Job Hazards and Risks eAM/Quality

Document Management Webcentre

Training Management Learning Management

Incidents/Accidents/Violations Case Management

Reporting Oracle Reporting Solutions

EHS Requirement Oracle Proposed Solution Partner

Figure 1 - EHS Requirements & Oracle Solutions

Screen Shots are included in the Appendix showing the method used within these modules to capture relevant EHS
data. In the sections that follow, links are provided to the specific screen shots referenced in the text.

Oracle Solutions – Environmental, Health, and Safety Enablement Page 3

 ENVIRONMENTAL, HEALTH, AND SAFETY (EHS)
The EHS model at a given company is driven by its unique business model, policies, strategy, and applicable laws and
regulations. The specific requirements will differ across companies based on the unique manufacturing processes
employed to create product, and because regulations are promulgated at the Federal, State, and Local level, the process
and reporting requirements will vary by site across an organization. Although there will be commonalities across
industries, companies, and sites for basic processes like Incident Reporting and Corrective Action management, the
EHS model will inherently be different for every location. Oracle’s objective is to provide the basic building blocks
for enabling processes and capturing data while allowing the User to build the model that is most appropriate given
their particular circumstances.

The graphic below provides the basic framework for the EHS model. Each company will need to evaluate its business
model, objectives, strategy, and policy to determine the breadth and depth of its approach. The applicable Federal,
State, and Local laws and regulations determine the nature of data collection and external reporting that is required.

Federal / State / Local Business Objectives Strategy Policies

Model
Laws / Court Decisions /
Regulations / Regulatory

Data Collection / Internal & External Reporting

Decisions Document

Inputs Conversion Outputs Train

People Material / Product Services
Services Processes Activities Audit
Property / Plant /Equipment Systems Waste
/ Facilities Health Assessment
Hygiene Assessment
Inspection & Testing
Job Safety Analysis
Expose
etc
Hazards Incidents

Identify
Risks Investigation

Findings
Create

Controls Recommendations

Actions

Figure 2 - EHS Model

Oracle Solutions – Environmental, Health, and Safety Enablement Page 4

 IPO (Inputs / Process / Output) Analysis
EHS issues are driven by the inputs, processes, and outputs required to execute the business model, achieve the
business objectives, and implement the business strategies and policies. Regulations developed at the Federal, State,
and Local level define what materials must be tracked and which processes must be monitored based on the nature of
the business and the regulatory jurisdictions. Every site will have to ascertain the regulatory impact at that location.

Each aspect of operations introduces hazards that must be exposed, risks that must be identified, and controls that must
be created. Each input, process, and output requires documentation, associated training, and auditing of results to
ensure compliance.

Incidents that arise from process failures must be captured, investigated, and addressed. A closed-loop corrective
action process will help improve the model over time. Across the ecosystem, data must be collected and reports
generated to satisfy the appropriate oversight organizations.

Attributes Transactions Audits Incidents

Characteristic of the Activity that changes a Planned activity to verify Unplanned Activity that
Resource Characteristic of the process effectiveness affects a Resource in a
Resource negative way

People Example: People Example: People Example: People Example:

Age Training Certification Audit Injury
Certifications Certification Skill Audit Exposure
Skills Promotion Hazard Audit Illness
Restrictions Hire Exposure Audit Lost Work Day
Material Example: Material Example: Material Example: Material Example:
Description Purchase Storage Audit Spill
Unit of Measure Receipt Cycle Count Audit Release
MSDS data Issue Hazard Audit Emission
Location Manufacturing
Yield Scrap

Figure 3: EHS Components

For each Input, Process, and Output, there are Attributes that define it and its characteristics. These attributes help
answer the Who, What, Where, and How questions about the People, Materials, Tools, Equipment, and Activities that
are used in the business. They can describe who has the appropriate certifications, what safety precautions are
appropriate for inventory items, or what operating tolerances a piece of equipment offers.

There are Transactions that reflect actions taken that affect the attributes of the resource, changing its state, location,
or condition. When People are trained, when material is moved or processed, or when equipment is maintained,
transactions are generated that change the status of the attributes. These transactions generate a history that reflects
activities and processes as they are executed.

Once the EHS models are established, Audits verify that the attributes are accurately reflected and that transactions
have been accurately recorded. In addition to validating that captured information is accurate, audits can be used to
determine if there are unidentified risks or hazards in a work area or associated with a process. An effective audit
program attempts to ensure that the EHS model is working as planned.

If process controls have not been effective, then Incidents occur, and they must be recorded, reported, and addressed.
Incidents reflect a breakdown in the controls put in place to avoid an EHS failure. If a material is spilled, an employee
is injured, or a safety violation occurs, then an extraordinary event has taken place and action must be taken. A
mechanism must be in place to capture the incident and administer the process to address the failure. The process
should be closed-loop so that corrective actions are put in place to prevent recurrences.

Oracle Solutions – Environmental, Health, and Safety Enablement Page 5

 Examples of each component are reflected in the graphic above. Details of how Oracle applications can capture and
enable these are provided in the sections below. Generally, Attributes and Transactions are captured in the Oracle
module that is appropriate for the type of resource (People / Material / Equipment) while Audits and Incidents are
captured in a universal process that is common across the organization.

ATTRIBUTES
The Attributes of each specific Input, Process, and Output are captured in the relevant business system. Material and
Product attributes can be captured in the Item Master and Bill of Material. Personnel attributes can be captured in the
Employee Record. Asset attributes can be captured in the Enterprise Asset Management (EAM) records. Flex fields
can be created for required attributes that are not standard entries.

Process attributes are captured in the Bill of Material and Routings for manufacturing processes, in the EAM system for
assets requiring calibration, preventive maintenance, and repair, and in the HR system for personnel related processes.

Examples of attributes that are particularly relevant for the EHS model include the following:

 Hazardous Material characteristics, including MSDS data can be entered in the Item Master (See Screen Shots 9 –
14)

 Hazardous Material planned usage and creation can be captured in the Bill of Material (as an input to and output
from production).

 The Inventory and Warehouse functions can be used to identify the quantities and locations of hazardous
materials. This information can include the Unit of Measure and storage method.

 Process characteristics can be captured in the Bill of Material (process inputs, formulas, planned waste) and the
Routing (assembly instructions, equipment usage, scrap operations, personnel requirements, and certifications).

 The training, certification, and skills for Employees can be captured in their Employee records. When processes
require specific qualifications, the use of the proper resources can be validated by checking the Employee
certification. (See Screen Shots 18-20)

 When equipment, plant, or property are used in the manufacturing process, the description, location, bill of
material, and maintenance plan can be captured in the Enterprise Asset Management application. Cumulative
generation of waste can be captured against an asset.

Oracle Solutions – Environmental, Health, and Safety Enablement Page 6

 TRANSACTIONS
As Resources are employed in the business, transactions capture the associated activity. In most cases, those
transactions record the impact on the resource and drive a change in the attributes. Examples that are relevant to the
EHS model include:

 Purchase, receipt, movement, issuance, and conversion of material (including generation of waste or creation of
emissions) can be captured in the Purchasing, Inventory, and Work in Process modules.

 Maintenance, calibration, and utilization of equipment, plant, and property can be captured in the Enterprise Asset
Management application.

 Hiring, training, certification, and assignment of employees can be tracked in the HR application.

 Work by employees against a specific operation or in a particular work area can be captured in the time recording
system.

In addition to the standard transactions enabled by the material, asset, and HR systems, the Oracle Quality module
supports Collection Plans. (See Screen Shots 15-17). A Collection Plan initiates a process flow that intervenes in
standard business processes and requires additional actions or data entry. The graphic below provides an indication of
the type of activities and plans that can be enabled by a Quality Collection plan. Once the data is stored, then the
module enables analytics, charting, and reporting.

Supplier Production Finished Field

Receipts Goods Failures

Quality Collection Plans

Incoming Shop Floor Final Incident and
Inspections Inspections Inspections Failure Details
& Testing

Electronic Document Quality Data Corrective Actions

Multimedia Repository
Instructions Notifications

Quality Analysis Tools

Online
Charts Reports Inquiries

Figure 4: Quality Collection Plans

Oracle Solutions – Environmental, Health, and Safety Enablement Page 7

 AUDITS
As deemed appropriate, the organization will need to validate that resource attributes are accurately reflected, that
transactions are appropriately captured, and that processes are properly executed. The audit process has basic
components that can be managed in the Oracle Quality module. Unique characteristics of the audit, including the audit
plan and audit schedule must be developed externally, but the basic process execution steps can be captured and
monitored within the application.

Send Pre- Log Required

Audit Audit
Initiation questionnaire Corrective
to Auditee Actions
Lead Auditor
prepares plan Follow-up No
Yes CAR
Determine & schedules required?
Lead Auditor Receive and
evaluate pre- Negative
audit response Findings?
Yes

Lead Auditor No
No distributes Audit
Acceptable? the audit plan Any
Execution: Yes pending Follow-up
Collect data & audit actions
evidence areas?
Yes
No
Determine No
Audit Areas & Acceptable?
Auditors No Prepare Audit
Is the data Reports with
suf f icient? Findings Audit
Yes Close-out
Prepare Audit Yes
Questions & Audit is
Procedures scheduled Evaluate Prepare Audit
f or execution evidence Reports with
gathered Findings

Figure 5: Audit Process Flows

The Oracle Quality module enables the process steps required for audit initiation and audit execution as shown in the
graphic above. Screen Shots 1 – 6 in the Appendix show the Oracle capability for enabling EHS Audits.

Oracle Solutions – Environmental, Health, and Safety Enablement Page 8

 INCIDENTS
When events occur that fall outside the planned processes and cause injuries, releases, or other adverse impacts, they
are captured as Incidents. Incidents require investigation, findings, recommendations, and action as appropriate. The
Oracle Case Management Module provides the mechanism for managing the Incident process.

As required, the module can be configured to capture the information that is appropriate for the organization. The
configuration will vary based on sites, locations, organization structure, naming conventions, or business processes. In
each case, the incident report captures the basic Who, What, When, Where information associated with the incident.
Drop-down menus can be added to characterize events in a consistent manner for reporting purposes.

Screenshots 21 – 26 show how Oracle functionality can support Incident capture.

Notification
Sent to
Corporate

Incident Incident
Occurred Reported
Notification
Sent to
Business Unit

Worker’s Investigation Case Monitored

Compensation Conducted and Tracked
Report Completed and Concluded

Notification Corrective
Sent to Workers Actions Identified / Case
Comp TPA Ownership Assigned Closed

Notification Corrective
Sent to Action Actions
Item Owner Closed

Figure 6 - Incident Reporting

Oracle Solutions – Environmental, Health, and Safety Enablement Page 9

 CORRECTIVE ACTION
When action is taken to address an incident, audit finding, or process failure, a Corrective Action Request (CAR) is
used to generated and monitored. The CAR assigns ownership and validates that issues are resolved on a timely
basis, either internally or at a Supplier. The basic CAR process steps enabled by Oracle Quality are shown below.

Submit Owner Owner /

Corrective assigns CAR Supplier No Assignee
Action to responsible Problem? determines
Request person Root Cause
Yes
Owner /
Assign Notif y Assignee
Containment Supplier &
Owner Required? determines
Request CAR Action

Owner f ollow
Owner Determine Review Implement up on
Reviews Containment Resolution by Action Pending
Request Actions Supplier Actions

Discuss Owner f ollow

Analysis to Follow up on remedial Yes up on
Yes determine CAR Pending
Accept actions w/ Actions? Pending
Request? source of implementation Supplier Actions
Problem
No No

No Customer Yes Close CAR

Request Success? Originated
Rejected CAR?

Yes No

Figure 7: Correction Action Request Process Flows

REGULATORY REPORTING
The extent of regulatory reporting at a company is based on the nature of a company’s business model, the processes it
uses, and the applicability of regulatory reporting requirements as defined by Federal, State, and local oversight
organizations. Although certain Federal reports are standard, the manner in which data is captured and the underlying
meaning of that data can vary by Company and site.

Oracle does not monitor the underlying regulations and reporting requirements to identify changes in coverage, format,
or intent. It is the responsibility of the EHS professionals at the manufacturing company to understand the
applicability of the regulatory environment and its impact on each site. The number of potential reports and variations
due to regulatory jurisdictions and ongoing updates precludes Oracle’s ability to stay current on the requirements at
each Customer location. As a result, Oracle does not attempt to develop standard reports nor suggest the appropriate
business processes to follow.

Oracle supports regulatory reporting through the use of BI Publisher to create custom reporting formats. The
underlying data is available based on attributes, transactions, and data collection described above; the required report
formats are maintained by the manufacturer. By providing the building blocks for data collection and reporting, we
enable our Customers to build the appropriate EHS model for their business processes, regulatory environment, and
level of maturity. Several standard OSHA Forms are represented in the Appendix. Forms that may be required
include:

OSHA Forms 300 / 300A / 301

EPA Forms R / R (Schedule 1) / A

MSDS Forms (see MSDS format and content per ANSI Z400.1)

Oracle Solutions – Environmental, Health, and Safety Enablement Page 10

 DOCUMENT MANAGEMENT
The EHS model requires the creation and management of reports, work instructions, drawings, and records. The
document management functionality in Oracle WebCenter Content supports the ability to capture, secure, share and
distribute digital and paper-based documents and reports. Oracle WebCenter Content provides organizations with a
unified repository to house unstructured content, and deliver it to business users in the proper format, and within
context of applications to fit the way they work. Documents can be linked within Oracle EBS to define the attributes
of a resource, support a manufacturing process, or document an incident or action.

Store
Capture Version

Index
Create
Document
Lifecycle Manage
Management

Retain/ Cleanse
Destroy

Search Distribute
Publish

Figure 8 - Document Lifecycle Management

Oracle Solutions – Environmental, Health, and Safety Enablement Page 11

 SUMMARY
Oracle provides building blocks for Environmental, Health, and Safety (EHS) compliance; Customer or third party
experts provide the specific process and regulatory expertise required to create the EHS model and develop reports.

Oracle applications provide:

 the framework for capturing attribute and transactional data associated with core manufacturing, asset management,
and human resource processes.

 the process structure for administering the audit and incident capture processes, and

 the mechanism for developing custom reports required by regulatory agencies.

The User is responsible for:

 identifying the Federal, State, and local regulations that are applicable to the business and all of its sites

 identifying the inputs, processes, and outputs that are relevant for the business model

 defining the EHS hazards, risks, and controls that result from operations

 configuring Bills of Material, Routings, and Item Masters to reflect company-specific processes, resources, and assets

 defining reports and report formats driven by the laws and regulations affecting each site

Oracle Solutions – Environmental, Health, and Safety Enablement Page 12

Environmental, Health, & Safety – An Oracle Approach to Enablement
November 2012

Author: Ralph Carpenter

Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.

Worldwide Inquiries:
Phone: +1.650.506.7000
Fax: +1.650.506.7200
oracle.com

Copyright © 2012, Oracle. All rights reserved.

This document is provided for information purposes only and the
contents hereof are subject to change without notice.

This document is not warranted to be error-free, nor subject to any

other warranties or conditions, whether expressed orally or implied
in law, including implied warranties and conditions of merchantability
or fitness for a particular purpose. We specifically disclaim any
liability with respect to this document and no contractual obligations
are formed either directly or indirectly by this document. This document
may not be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without our prior written permission.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

Other names may be trademarks of their respective owners.
MSDS Format and Content: American National Standard, Z400.1
The American National Standards Institute (ANSI) developed a standard (Z400.1) to assist with the format
and preparation of Material Safety Data Sheets (MSDS). The MSDS is required by the Occupational
Safety and Health Administration (OSHA) Hazard Communication Standard [29 Code of Federal
Regulations (CFR) 1910.1200].

The purpose of this standard is to provide information in a consistent manner and to make it easier to find
information regardless of the supplier of the MSDS. The following list indicates the 16 sections of the
MSDS standardized format.

Section 1: Product and Company Identification

This section names the material and links the MSDS to the label and shipping documents. It also, identifies
the name of the manufacturer, importer or other responsible party along with a mailing address and phone
number for obtaining additional information.
Section 2: Hazard Identification
This section describes the material's appearance and most significant immediate concerns. Hazard
identification is divided into the following four subsections: emergency overview, OSHA regulatory
status, potential health effects; and potential environmental effects.
The physical state of the material along with the health, physical and environmental hazards that require
immediate attention in emergencies are listed in the emergency overview. The OSHA regulatory status
subsection indicates if the material is hazardous or non-hazardous with respect to the Hazard
Communication Standard. Potential adverse health effects and symptoms associated with exposure to the
material are given in the potential health effects subsection. The potential environmental effects subsection
provides information on the potential effects associated with release of the material into the environment.
Section 3: Composition / Information on Ingredients
This section identifies the components, by-products and impurities that contribute to the material's hazards.
The chemical name, common name, or synonym, along with the corresponding Chemical Abstracts Service
(CAS) Registry Number and percentages or ranges of percentages, are included.
Section 4: First Aid Measures
This section is divided into the following two subsections: first aid procedures and notes to physicians. The
first aid procedures should be brief with easy-to-understand emergency and first aid instructions for each
potential route of exposure. They are intended for use by any untrained individual. The notes to physicians
convey additional information on antidotes, specific treatments and diagnostic procedures intended for use
by healthcare professionals.
Section 5: Fire Fighting Measures
This section describes specific hazards arising from a fire and explosive properties of the material, along
with appropriate extinguishing media for the fire, special protective equipment and fire fighting
precautions.
Section 6: Accidental Release Measures
This section contains information for responding to spills, leaks or releases in order to prevent or minimize
the adverse health effects on persons, property and the environment. Also included may be information on
personal protective equipment, containment equipment, clean-up equipment, clean-up techniques,
environmental precautions and specific reporting requirements.
Section 7: Handling and Storage
This section provides guidance on safe handling and storage practices. Emphasis is on proper unique
properties of the materials.
Section 8: Exposure Control / Personal Protection
This section is divided into three subsections. Established exposure guidelines for the material and/or its
components are identified in subsection 1. The established exposure guidelines include, but are not limited
to, OSHA's Permissible Exposure Limits (PELs) and American Conference of Governmental Industrial
Hygienists (ACGIHs) Threshold Limit Values (TLVs) and Biological Exposure Indices (BEIs).
Subsection 2 gives consideration for personal protective equipment guidance eye/face protection, skin
protection, respiratory protection and general hygiene.
Engineering controls that may be appropriate to help minimize the hazards are discussed in Subsection 3.
Section 9: Physical and Chemical Properties
This section identifies the physical and chemical properties of the material. If applicable and relevant, the
following characteristics must be detailed: appearance, odor, odor threshold, physical state, pH,
melting/freezing point, initial boiling point and boiling range, flash point, evaporation rate, flammability
(solid, gas), upper/lower flammability or explosive limits, vapor pressure, vapor density, specific gravity or
relative density, solubility, partial coefficient: n-octanol/water, auto-ignition temperature and
decomposition temperature. If a characteristic is included, but not applicable or relevant, indicate so.
Section 10: Stability and Reactivity
This section describes the potential hazards associated with the stability and reactivity of the material under
specified conditions. Chemical stability, conditions to avoid, incompatible materials, hazardous
decomposition products and the possibility of hazardous reactions should be addressed.
Section 11: Toxicological Information
This section provides toxicological information that can be used to assess human health hazards or potential
health effects of the material and / or its components. Acute dose effects, repeated dose effects, irritation,
corrosivity, skin and respiratory sensitization, carcinogenicity, neurological effects, genetic effects,
reproductive effects, developmental effects and target organ effects data may be listed.
Section 12: Ecological Information
Information to assist in the evaluation of the environmental impact of the material and / or its components
if released to the environment is provided in this section. Ecotoxicity, persistence / degradability,
bioaccumulation / accumulation, mobility in environmental media and other adverse effects may be
addressed.
Section 13: Disposal Considerations
This section provides information that may be useful in the proper disposal, recycling or reclamation of the
material and / or its container.
Section 14: Transport Information
Basic classification information and special precautionary information to help a knowledgeable user
prepare a material for shipment is given in this section. This section is not intended to contain every
regulatory detail involving the transportation of a material.
Section 15: Regulatory Information
This section provides information on the regulatory status that is useful for compliance with health, safety
and environmental regulations. Content and organization of this section depends on where the material is
manufactured or used. It is not intended to be a comprehensive list of all of the regulations that may apply.
US Federal regulations / agencies shown may include the following: Clean Air Act (CAA), Clean Water
Act (CWA), Comprehensive Environmental Response, Compensation and Liability Act (CERCLA), Drug
Enforcement Administration (DEA), Food and Drug Administration (FDA), OSHA, Safe Drinking Water
Act (SDWA), Superfund Amendments and Reauthorization Act (SARA) Title III, Toxic Substances
Control Act (TSCA) and United States Department of Agriculture (USDA).
Section 16: Other Information
This section includes any additional information that may be useful. It may include label text, hazard
ratings, preparation and revision information or key/legend that explains the abbreviations used in the
MSDS.

American National Standards Institute, Inc.

25 West 43rd Street
New York, NY 10036
Telephone: 212-642-4900
Web Address: www.ansi.org
OSHA Form 300
OSHA Form 300A
OSHA Form 301
SCREEN SHOTS

Screen Shot 1 - Audit Master Plan ........................................................................................................................................ 22

Screen Shot 2 - Audit Questions ........................................................................................................................................... 22
Screen Shot 3 - Audit Questions ........................................................................................................................................... 23
Screen Shot 4 - Audit Responses........................................................................................................................................... 23
Screen Shot 5 - Audit Results - Pareto Chart......................................................................................................................... 24
Screen Shot 6 - Audit Results - Percent Passed .................................................................................................................... 24
Screen Shot 7 - Incident Report ............................................................................................................................................ 25
Screen Shot 8 - Incident Report - Party Attributes ............................................................................................................... 25
Screen Shot 9 - Item Master - Attach MSDS ......................................................................................................................... 26
Screen Shot 10 - Item Master - Attach MSDS ....................................................................................................................... 26
Screen Shot 11 - Item Master - ROHS Data........................................................................................................................... 27
Screen Shot 12 – Sub-Inventories ......................................................................................................................................... 27
Screen Shot 13 - Material Status Definition.......................................................................................................................... 28
Screen Shot 14 - Lot Control ................................................................................................................................................. 28
Screen Shot 15 - Quality Collection Plan ............................................................................................................................... 29
Screen Shot 16 - Collection Plans .......................................................................................................................................... 29
Screen Shot 17 - Collection Plan Notification ....................................................................................................................... 30
Screen Shot 18 - EHS Training / Certification ........................................................................................................................ 30
Screen Shot 19 - EHS Course Schedule ................................................................................................................................. 31
Screen Shot 20 - EHS Training History .................................................................................................................................. 31
Screen Shot 21 - Incident Dashboard.................................................................................................................................... 32
Screen Shot 22 - Open Incidents ........................................................................................................................................... 32
Screen Shot 23 - Incident Attachments and Notes ............................................................................................................... 33
Screen Shot 24- Incident Details ........................................................................................................................................... 33
Screen Shot 25 - Incident Agent Dashboard ......................................................................................................................... 34
Screen Shot 26 - Incident Follow-up Actions ........................................................................................................................ 34
Screen Shot 27 - EHS Permits ................................................................................................................................................ 35
Screen Shot 28 - EHS Permit Update .................................................................................................................................... 35
Screen Shot 29 - EHS Permit attachment.............................................................................................................................. 36
Screen Shot 30 - EHS Permit attachment success ................................................................................................................ 36
Screen Shot 31 - EHS Permit - Print ...................................................................................................................................... 37
Screen Shot 32 - EHS Permit - Templates ............................................................................................................................. 37
Screen Shot 33 - EHS Permit Example................................................................................................................................... 38
Screen Shot 34 - Define Waste as Inventory Item ................................................................................................................ 39
Screen Shot 35 - Assign Lot Control / Expiration to Item ..................................................................................................... 39
Screen Shot 36 - Assign Locator restriction to control storage ............................................................................................ 40
Screen Shot 37 - Identify relationships to limit co-location.................................................................................................. 40
Screen Shot 38 - Define Material Attributes ......................................................................................................................... 41
Screen Shot 39 - Control Material Transactions ................................................................................................................... 41
Screen Shot 40 - Define subinventories ................................................................................................................................ 42
Screen Shot 41 - Define subinventory locations ................................................................................................................... 42
Screen Shot 42 - Define location capacity limits ................................................................................................................... 43
Screen Shot 43 - Define coordinates for storage locations .................................................................................................. 43
Screen Shot 44 - Match materials with locations ................................................................................................................. 44
Screen Shot 45 - Query lot and status .................................................................................................................................. 44
Screen Shot 46 - Collection Plan - Identify emissions to monitor......................................................................................... 45
Screen Shot 47 - Collection Plan - Define Actions ................................................................................................................. 45
Screen Shot 48 - Collection Plan - Define collection ............................................................................................................. 46
Screen Shot 49 - Define Parent / Child relationship ............................................................................................................. 46
Screen Shot 50 - Define Parent / Child Data relationship ..................................................................................................... 47
Screen Shot 51 - Define Sampling Plan ................................................................................................................................. 48
Screen Shot 52 - Define Sampling Plan conditions ............................................................................................................... 48
Screen Shot 53 - Define actions based on results ................................................................................................................. 49
Screen Shot 54 - Define Rules / Display ................................................................................................................................ 49
Screen Shot 55 - Generate notification................................................................................................................................. 50
Screen Shot 56 - Link Data to notification ............................................................................................................................ 50
Screen Shot 57 – Select Validation List for Entries ............................................................................................................... 51
Screen Shot 58 - Display Validation List for Entries .............................................................................................................. 51
Screen Shot 59 - Show Instruction for data elements (Lower left hand corner) .................................................................. 52
Screen Shot 60 - Specification values are shown for input ................................................................................................... 52
Screen Shot 61 - Action is taken based on input value ......................................................................................................... 53
Screen Shot 62 - Message displayed based on input............................................................................................................ 53
Screen Shot 63 - Multiple entries can be accumulated and analyzed .................................................................................. 54
Screen Shot 64 - Data can be entered via Web (internally or externally) ............................................................................ 54
Screen Shot 65 - Message when entry out of tolerance....................................................................................................... 55
ORACLE SCREEN SHOTS

Screen Shot 1 - Audit Master Plan

Screen Shot 2 - Audit Questions

Screen Shot 3 - Audit Questions
.

Screen Shot 4 - Audit Responses

Screen Shot 5 - Audit Results - Pareto Chart
.

Screen Shot 6 - Audit Results - Percent Passed

.
Screen Shot 7 - Incident Report

Screen Shot 8 - Incident Report - Party Attributes

Screen Shot 9 - Item Master - Attach MSDS

Screen Shot 10 - Item Master - Attach MSDS

Screen Shot 11 - Item Master - ROHS Data

Screen Shot 12 – Sub-Inventories

Screen Shot 13 - Material Status Definition

Screen Shot 14 - Lot Control

Screen Shot 15 - Quality Collection Plan

Screen Shot 16 - Collection Plans

Screen Shot 17 - Collection Plan Notification

Screen Shot 18 - EHS Training / Certification

Screen Shot 19 - EHS Course Schedule

Screen Shot 20 - EHS Training History

Screen Shot 21 - Incident Dashboard

Cases and tasks waiting to

be worked on

Launch
pad of
common
activities

Screen Shot 22 - Open Incidents

Screen Shot 23 - Incident Attachments and Notes

Screen Shot 24- Incident Details

Screen Shot 25 - Incident Agent Dashboard

Screen Shot 26 - Incident Follow-up Actions

Screen Shot 27 - EHS Permits

Screen Shot 28 - EHS Permit Update

Screen Shot 29 - EHS Permit attachment

Screen Shot 30 - EHS Permit attachment success

Screen Shot 31 - EHS Permit - Print

Screen Shot 32 - EHS Permit - Templates

Screen Shot 33 - EHS Permit Example
Screen Shot 34 - Define Waste as Inventory Item

Screen Shot 35 - Assign Lot Control / Expiration to Item

Screen Shot 36 - Assign Locator restriction to control storage

Screen Shot 37 - Identify relationships to limit co-location

Screen Shot 38 - Define Material Attributes

Screen Shot 39 - Control Material Transactions

Screen Shot 40 - Define subinventories

Screen Shot 41 - Define subinventory locations

Screen Shot 42 - Define location capacity limits

Screen Shot 43 - Define coordinates for storage locations

Screen Shot 44 - Match materials with locations

Screen Shot 45 - Query lot and status

Screen Shot 46 - Collection Plan - Identify emissions to monitor

Screen Shot 47 - Collection Plan - Define Actions

Screen Shot 48 - Collection Plan - Define collection

Screen Shot 49 - Define Parent / Child relationship

Screen Shot 50 - Define Parent / Child Data relationship
Screen Shot 51 - Define Sampling Plan

Screen Shot 52 - Define Sampling Plan conditions

Screen Shot 53 - Define actions based on results

Screen Shot 54 - Define Rules / Display

Screen Shot 55 - Generate notification

Screen Shot 56 - Link Data to notification

Screen Shot 57 – Select Validation List for Entries

Screen Shot 58 - Display Validation List for Entries

Screen Shot 59 - Show Instruction for data elements (Lower left hand corner)

Screen Shot 60 - Specification values are shown for input

Screen Shot 61 - Action is taken based on input value

Screen Shot 62 - Message displayed based on input

Screen Shot 63 - Multiple entries can be accumulated and analyzed

Screen Shot 64 - Data can be entered via Web (internally or externally)

Screen Shot 65 - Message when entry out of tolerance
Contents
Introduction ............................................................................................................................................................................ 2
Oracle Solutions for EHS Compliance ..................................................................................................................................... 3
Environmental, health, and safety (EHS) ................................................................................................................................ 4
IPO (Inputs / Process / Output) Analysis ..................................................................................................................... 5
ATTRIBUTES ....................................................................................................................................................................... 6
TRANSACTIONS ................................................................................................................................................................. 7
AUDITS .................................................................................................................................................................................. 8
INCIDENTS ........................................................................................................................................................................... 9
CORRECTIVE ACTION .................................................................................................................................................... 10
REGULATORY REPORTING .......................................................................................................................................... 10
DOCUMENT MANAGEMENT ......................................................................................................................................... 11
SUMMARY .......................................................................................................................................................................... 12
MSDS Format and Content: American National Standard, Z400.1 ................................................................. 14
OSHA Form 300 ................................................................................................................................................................ 17
OSHA Form 300A ............................................................................................................................................................. 18
OSHA Form 301 ................................................................................................................................................................ 19
ORACLE SCREEN SHOTS ............................................................................................................................................. 22

FIGURES:

Figure 1 - EHS Requirements & Oracle Solutions.................................................................................................................... 3

Figure 2 - EHS Model ............................................................................................................................................................... 4
Figure 3: EHS Components...................................................................................................................................................... 5
Figure 4: Quality Collection Plans ........................................................................................................................................ 7
Figure 5: Audit Process Flows .............................................................................................................................................. 8
Figure 6 - Incident Reporting .................................................................................................................................................. 9
Figure 7: Correction Action Request Process Flows.............................................................................................................. 10
Figure 8 - Document Lifecycle Management ........................................................................................................................ 11