This topic shows how to upload external documents such as Material Safety Data Sheets (MSDS) using Files Approval System. Using Oracle E-Records and setting up Oracle Approvals Management (AME) are also explained.
This chapter covers the following topics:
OPM Regulatory Management enables both new and updated documents to be uploaded and routed through an approval process before being published or distributed. The approval process supports the entry and management of 21 CFR Part 11 compliant e-signatures. This signature must contain two distinct components. The Oracle E-Business Suite uses the user ID and password for the approval process.
OPM Regulatory Management stores MSDS and regulatory documents associated to an OPM record in Oracle E-Records which provides full audit trail and CFR compliance tracking. The documents can be sourced internally, or they can be gathered externally from third party Regulatory providers. Attaching or modifying documents is controlled through iSignatures Files Approval.
Optionally, Oracle Workflow enables regulatory documents to be submitted for approval before they are made available for general distribution. Approvers are defined in Oracle Approval Manager.
Oracle E-Records provides an interface that lets you search and display historical versions of a document. Search by document name, category, author, or status. You can also display user-defined values for each document based on the document category. And, you can search by user-defined values.
You can automatically attach approved regulatory documents to a shipment or manually to any other entity. Only the most recent version of each approved document can be attached to a shipment. View historical versions from the Oracle E-Record Evidence store.
Oracle Approvals Management is a self-service web application that lets you define business rules governing the process for approving transactions in other Oracle Applications. The purpose of AME is to define approval rules that determine the approval processes for Oracle Applications. Rules are constructed from conditions and approvals.
See: Oracle Approvals Management User's Guide
Create transaction attributes, conditions, approval groups, and approval rules within AME. The appropriate approvers are determined using the document category in iSignatures Files Approval.
E-records are stored in an evidence store. The evidence store provides a secure storage location and links to transaction windows. You can query the e-records repository using the evidence store. The Evidence Store window is divided into two regions. The top region lets you specify the query criteria and the bottom region shows the results of the query.
Oracle E-Records Implementation Guide
Upload external documents using the iSignatures Files Approval. Each document is assigned a category that contains rules for the approval process. Each category has fifteen descriptive flexfield segments used to store information about the documents in that category. This information is stored in the database with the document, and can be used to search for the document.
Following are the four seeded Regulatory MSDS document categories used to determine the appropriate approvers:
MSDS for a Regulatory Item
MSDS for an Inventory Item
MSDS for Shipment
MSDS for a Recipient
Oracle Approvals Management User's Guide
Oracle E-Records Implementation Guide
The MSDS for Shipping lets you automatically or manually attach documents to shipping transactions.
Documents can be attached either automatically or manually.
Using the Document Management Information in the OPM Regulatory Management responsibility or Files Approval in the iSignature Responsibility, you can upload a document into the FND tables. You must use a seeded or user-defined category for the shipping transactions to automatically print the document. The user defined category user description must contain the word Safety, MSDS, or Hazard.
Refer to the Oracle E-Records Implementation Guide for details on uploading a document.
Documents attached manually to a sales order or shipping transaction using the Attachment option for the user-defined categories can be enabled on any window. The user defined category user description must contain the word Safety, MSDS, or Hazard.
You can manually attached a document to both the sales order line and the shipping transaction.
Set up categories in the FND Categories window in the Applications Developer responsibility.
Set up the Categories Assignments on the FND Categories window to include the Sales Order and Shipping Transaction windows.
Run the concurrent programs Listener for Event Q and Listener for Outcome Q for any automatically uploaded documents.
In order for an uploaded Regulatory document to print with a Shipment, the Regulatory Document Summary API (Concurrent Program) must be added to a Document Set.
In the Shipping Module, the Regulatory Document Summary API is added on the Document Set window for the Usage Ship Confirm. When Ship Confirm is performed, the Regulatory documents is printed.
Navigate to the Order Management Super User, Process Operations (USA) responsibility.
Navigate to Document Sets from Setup Documents. The Document Sets window displays.
Query for the Document Sets with the usage: Ship Confirm. There can be many Document Sets, but you must choose the set that is used to print documents with a shipment. The query returns existing document sets. Now, add in the documents block.
Enter Sequence in the serial order.
Enter the Application Process Regulatory Management.
Enter Report Name Regulatory Document Summary API.
Enter Copies as 1. Number of copies required.
Save the information.
Navigate to the Sales Orders window from the Order Management responsibility.
Create and save a sales order.
Navigate to the Line Items tab.
Click the line you want to attach the document to and click the Attachments icon. The Attachments window displays.
Enter a Sequence number and select the list of values for the Category. The list of values displays the seeded categories or any user-defined categories containing the words MSDS, Hazard, or Safety.
Enter a description and select the DataType of File.
Ensure that the Entity Name is OM Order Line.
Save the attachments. All attached documents are automatically printed with the sales order line.
Navigate to the Shipping Transaction window from the Order Management responsibility.
Select an order and click the Attachments icon. The Attachments window displays.
Enter a Sequence number and select the list of values for the Category. The list of values displays the seeded categories or any user-defined categories containing the words MSDS, Hazard, or Safety.
Enter a description and select the DataType of File.
Ensure that the Entity Name is WSH Delivery Details.
Save the attachments. All attached documents are automatically printed with the shipping transaction.