This topic describes the available OPM Regulatory Management reports. Reports are available through the application's Standard Report Submission window. Refer to the Oracle E-Business Suite User's Guide or the online help topics for detailed information on running reports.
This chapter covers the following topics:
Use the Disclosure Code Details Report to view all the disclosure codes and their associated descriptions set up in OPM Regulatory Management.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Complete the other fields on the Submit Request window.
Click Submit Request.
Use the Field Name Class Codes Report to view the field name class codes that are set up in OPM Regulatory Management.
The report displays the field name class codes in the language range selected along with their associated descriptions.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the From Language in the range that you want to display field name class codes for. Field name class codes display in every language in the range.
Select the To Language in the range that you want to display field name class codes for. Field name class codes display in every language in the range.
Click OK.
Complete the other fields on the Submit Request window.
Click Submit Request.
Use the Field Name Codes Report to view the field name codes that are set up in OPM Regulatory Management.
The report displays either the field name codes or field name class codes for the range and language range selected along with their associated descriptions.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the Report Type as Field Name Class Code or Field Name Code.
Select Print Report For by field name class code or field name code.
Select the From Field Name Class in the range that you want to display field name class codes for if you have selected to print the report by field name class.
Select the To Field Name Class in the range that you want to display field name class codes for if you have selected to print the report by field name class.
Select the From Field Name in the range that you want to display field name codes for if you have selected to print the report by field name.
Select the To Field Name in the range that you want to display field name codes for if you have selected to print the report by field name.
Select the From Language in the range that you want to display field name codes for. Field name codes display in every language in the range.
Select the To Language in the range that you want to display field name codes for. Field name codes display in every language in the range.
Click OK.
Complete the other fields on the Submit Request window.
Click Submit Request.
Use the Properties Report to view the properties that are set up in OPM Regulatory Management.
The report displays the property IDs with their associated type, length and precision, minimum and maximum range, language, and description.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the From Property ID in the range that you want to display properties for.
Select the To Property ID in the range that you want to display properties for.
Select the Property Type. Valid values are Alphanumeric, Date, Flag, Numeric and Phrase
Select the From Language in which you want to display the Properties report.
Select the To Language in which you want to display the Properties report.
Click Submit Request.
Use the Risk Phrases Report to view the risk phrases that are set up in OPM Regulatory Management.
The report displays risk phrase codes with their associated languages and descriptions for the language range selected.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the From Language in the range that you want to display risk phrase information for. Codes display in every language in the range.
Select the To Language in the range that you want to display risk phrase information for. Codes display in every language in the range.
Click OK.
Complete the other fields on the Submit Request window.
Use the Safety Phrases Report to view the safety phrases that are set up in OPM Regulatory Management.
The report displays safety phrase codes with their associated languages and descriptions for the language range selected.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the From Language in the range that you want to display safety phrase information for. Codes display in every language in the range.
Select the To Language in the range that you want to display safety phrase information for. Codes display in every language in the range.
Click OK.
Complete the other fields on the Submit Request window.
OPM Regulatory Management uses XML publisher to print the reports. The XML Publisher report lets you enter the printing parameters for the reports.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Select the Report Request that you want to print. The Template Application of the report displays.
Select the Template of the report.
Select the Template Locale as the language in which you want to print the report.
Select the Output Format for the report.
Click OK.
Use the Document Dispatch History Report to view information about the print selections that have printed successfully. The report displays the date the document was sent, the recipient, item information , CAS number, and document category.
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Enter any of the following criteria to narrow your search:
Organization to search for documents dispatched from a specific organization.
From Item and To Item to specify the range of item numbers for whose dispatch history you want to print the report.
From Recipient and To Recipient to specify the range of the recipients to whom the documents were dispatched.
From Document Category and To Document Category to specify the category range of the dispatched documents. For example, if you specify the range as MSDS for a Regulatory Item to MSDS for a Shipment, then all the dispatched MSDS documents for regulatory item and shipments are listed.
From Date and To Date to specify a date range for which you want a report for.
CAS Number to search for the dispatch history an item using its Chemical Abstract Services number.
Ingredient to search for dispatched documents related to a hazardous ingredient.
Order By to specify the order in which you want the report to be ordered. For example, you can order the reports by date.
Click OK.
Use the Print Regulatory Documents Report to send (e.g., print, e-mail, or fax) applicable copies of the partner-generated documents for distribution.
To submit the Print Regulatory Documents report:
Navigate to the Submit Request window.
Enter the name of the report in the Request Name field.
Enter any of the following fields to narrow the scope of your report.
Organization Code to search for regulatory documents from a specific organization.
From Item is the number of the first item to include on the report.
To Item is the number of the last item to include on the report.
Select the From Language in the range that you want to display regulatory documents for the items.
Select the To Language in the range that you want to display regulatory documents for the items.
Document Category as the category assigned to the document in iSignatures Files Approval.
Recipient Site as the number of the party site listing for the recipient entered in the Human Resources application.
Click Submit Request.
Use the Process Manufacturing Regulatory Management Lookups window to maintain lookups. Each lookup has a code and a meaning. For example, lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No. Refer to the Oracle Process Manufacturing Systems User's Guide for a detailed description of this window.
Use the Session Parameters window to view the current system information. Refer to the Refer to the Oracle Process Manufacturing Systems User's Guide for a detailed description of this window.