This chapter contains the following topics:
This section provides an overview of Object Configuration Management reports and discusses how to use a batch application to set processing options for running the reports.
Batch Versions provide batch processes that produce reports that helps you track your object mappings.
Some of these reports are called when you select that report from the Oracle JD Edwards EnterpriseOne menu while other reports are called from a batch application. Although the result is the same, you set processing options and data selection differently for a batch process than for a report called from a batch application.
Any data selection for a report must be entered for the specific report and not from the batch application. When you finish entering processing options and data selection, if any, you can run the report from the batch application.
Job Master Deletion By Days Old
Object Configuration Mapping Comparison
Object Configuration Global Update
Object Configuration Delete
Object Configuration Copy
OCM Category Update/Delete report
This section lists the prerequisites and discusses how to set up and run the Job Master Deletion by Days Old report.
This batch application lets you produce a report listing obsolete print jobs submitted to servers. You have the option of generating the report only, or generating the report and then deleting obsolete records from the Job Control Status Master table (F986110).
This batch application is launched by a report driver. Enter any data selection from the batch application, but enter processing options from the report driver (R9861101), not from the actual application (R9861102).
Set up processing options for the report from Batch Versions, not from the actual report.
Access the Work With Batch Versions - Available Versions form.
Figure 11-1 Work With Batch Versions - Available Versions form
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
A description of the version that appears next to the version number. The version title is different from the report title.
This field should describe the use of a version. For example, an application for generating pick slips might have a version called Pick Slips - Accounting and another version called Pick Slips - Inventory Management.
Identifies the use ID of the user who last modified the application or version.
Indicates the last time an application or version was modified by the specified user.
This field allows you to restrict user access for a report version. Values are:
0 - No security. Anyone can design, change processing values, change detail values, check in, check out, install, transfer, copy, delete, or run the version. This is the default when adding a new version.
1 - Medium security. Only the "Last Modified By" user can design, change processing values, change detail values, check in, check out, install, transfer, copy, delete, or run the version. This is how JDE Demo versions are delivered.
2 - Medium to full security. Only the "Last Modified By" user can design, change processing values, change detail values, check in, check out, transfer, delete, or run the version. Anyone can install or copy the version.
3 - Only the "Last Modified By" user can design, change processing values, change detail values, check in, check out, install, transfer, copy, delete, or run the version.
4 - Medium security-extended. Only the "Last Modified By" user can design, change processing values (including runtime processing options and data selection), change detail values, check in, check out, transfer, delete, or run the version. Anyone can install or copy the version.
A user defined name or remark.
A category code associated with the Versions List table for JD Edwards EnterpriseOne (F983051).
Use these processing options to set up the defaults and versions for the report.
Use this processing option to set up the data source, number of days to query for, and the report type.
Specify the name that identifies the data source.
Specify the number of days in future to query for responses due.
Select an option that specifies the type of processing for an event.
1 = Proof Mode
2 = Final Mode
Specify the records to delete.
1 = Delete both UBE and Report Definition records
2 = Delete UBE records only
3 = Delete Report Definition records only
Use this processing option to specify a specific version.
Select a user defined specification that determines how application and reports run. You use versions to group and save user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
XJDE0001 = Jobs With All Status
XJDE0002 = Jobs With Done Status
XJDE0003 = Jobs With Error Status
XJDE0004 = Jobs With Wait Status
Access the Data Selection form.
Enter condition by selecting from the options provided in each cell of the template.
Where
Select the primary data source from the list.
is equal to
is equal to or empty
is greater than
is greater than or equal to
is less than
is less than or equal to
is not equal to
Select the secondary data source from the list.
This section lists the prerequisites and discusses how to set up and run Interactive and Batch Applications.
These batch applications have processing options that are entered from Batch Applications (R98611A) using the same processing option form:
Object Configuration Mapping Comparison (R986101)
Object Configuration Global Update (R986110)
Object Configuration Delete (R986120)
Object Configuration Copy (R986121)
Set up processing options for the report from Batch Versions, not from the actual report.
These processing options enable you set other parameters used by the specific batch application.
Use these processing options to specify which report and version to run.
Specify the name of the report that you want to run. Values are:
R986101 = OCM Mapping Comparison
R986110 = OCM Global Update
R986120= Object Configuration Delete
R986121 = Object Configuration Copy
Specify the version of the report that you want to run.
You must enter report processing options before running the report.
If data selection is necessary, it must be done on the version of the report that you specified on the Driver tab.
Use these processing options to specify parameters when running the R986101 report.
Specify the names of the data sources that you want to compare. If necessary, you can use the Visual Assist feature to locate valid data sources. Click the Visual Assist button to display the Data Source Search and Select form.
Specify the names of the data sources that you want to compare. If necessary, you can use the Visual Assist feature to locate valid data sources. Click the Visual Assist button to display the Data Source Search and Select form.
Specify the comparison method used. Values are:
1 Compare one direction only. Print only the records found in the first data source, but not in the second data source.
Blank: Compare both directions. Print records found in the first data source but not in the second data source, and also the records in the second data source that don't exist in the first data source.
Specify whether to print only the report exceptions, or every record from the data selection, noting the differences between the data sources. Values are:
1 Print exceptions only
Blank: Print all records
Use these processing options to specify parameters when running the R986110 report.
Specify the mode in which the report processes data. Valid options are:
1 Proof Mode. This mode produces a report that enables you to view the records you want to delete, but no records are deleted.
Blank: Final Mode. This mode produces a report of records you want to delete, and then deletes the records.
Specify the name of the data source for the Object Manager Configuration table. Any updates that occur as a result of running this report will be made to the Object Manager Configuration table found in the specified data source.
Specify whether to create new OCM records or change existing ones. Values are:
1 Create new OCM records from existing ones. The records created will look similar to those selected, except that the new OCM values entered in the processing options will be substituted where appropriate.
Blank: Change selected records with new OCM values. Use data selection to specify which records will be changed with the new OCM values entered into the processing options.
Use this processing option to enter new OCM values. If you are creating new OCM records from existing ones, any values you enter for this processing option will replace the existing ones. Values are:
Environment Name
Object Name
Primary Data Source
User
Object Type
Data Source Mode
Secondary Data Source
Allow QBE
Use these processing options to specify parameters when running the R986120 report.
Specify the mode in which the report processes data. Valid options are:
1 Proof Mode. This mode produces a report that enables you to view the records you want to delete, but no records are deleted.
Blank: Final Mode. This mode produces a report of records you want to delete, and then deletes the records.
Specify the name of the data source for the Object Manager Configuration table. Any updates that occur as a result of running this report will be made to the Object Manager Configuration table found in the specified data source.
Specify whether to run the Object Configuration Copy report (R986121) along with the Object Configuration Delete report. Values are:
1 Run the Object Copy (R986121). Creates a copy before deleting records. When you run the Object Copy, remember to enter the processing options under the R986121 tab, and to set up any data selection. Data Selection should be defined on the same version of R986121 that you specified for R986121 (Object Configuration Delete).
Blank: Do not run Object Copy. Deletes the records without first creating a copy.
Use these processing options to specify parameters when running the R986121 report.
Specify the mode in which the report processes data. Valid options are:
1 Proof Mode. This mode produces a report that enables you to view the records you want to delete, but no records are deleted.
Blank: Final Mode. This mode produces a report of records you want to delete, and then deletes the records.
Specify the name of the data source with the Object Configuration Manager table from which you want to copy records.
Specify the name of the data source with the Object Configuration Manager table to which you want to copy.
Access the Data Selection form.
Enter condition by selecting from the options provided in each cell of the template.
Where
Select the primary data source from the list.
is equal to
is equal to or empty
is greater than
is greater than or equal to
is less than
is less than or equal to
is not equal to
Select the secondary data source from the list.
This section lists prerequisites and discusses how to set up and run the Object Configuration Mapping Comparison Report.
Run the Object Configuration Comparison report to compare Object Configuration Master tables (F986101) from two different data sources and display the differences between them. For example, you might compare the F986101 table in the system data source to the F986101 table for a given server map data source.
Set up processing options for the report from the report driver, not from the actual report.
Access the Work With Batch Versions - Available Versions form.
This section lists prerequisites and discusses how to set up and run the Object Configuration Global Update Report.
This process performs global updates and global copies of object mappings in the same Object Configuration Master table (F986101). You can use this batch application rather than the interactive application (P986110). This application is useful in updating and copying multiple records.
Set up processing options for the report from the report driver, not from the actual report.
Access the Work With Batch Versions - Available Versions form and run the Object Configuration Update Report (R986110).
This section lists prerequisites and discusses how to set up and run the Object Configuration Delete Report.
Set up processing options for the report from the report driver, not from the actual report.
Access the Work With Batch Versions - Available Versions form and run the Object Configuration Delete Report (R986120).
This section lists the prerequisites and discusses how to set up and run the Object Configuration Copy Report.
This process copies Object Configuration Manager records from one data source to another and automatically deletes any duplicate records. For example, if you create a new environment by copying an existing one, Object Configuration Manager records are created for the new environment in the system data source.
You use the Object Configuration Copy batch process to copy those records to the appropriate server map data source. After copying the records, use the Object Configuration Global Update program (R986110) to change, at the minimum, any mappings for LOCAL to the appropriate server location.
Set up processing options for the report from the report driver, not from the actual report.
Access the Work With Batch Versions - Available Versions form and run the Object Configuration Copy Report (R986121).
This section provides an overview of the OCM Category Update/Delete Report and discusses how to set up and run the OCM Category Update/Delete report.
This batch application (R986101B) lets you add, update, or delete member objects of a specified category from the Object Configuration Master table (F986101).
Set up processing options for the report from the report driver, not from the actual report.
Access the Work With Batch Versions - Available Versions form and run the Add/Update/Delete Report (R986101B).
Processing options for the OCM Category Add/Update/Delete report include:
These processing options let you add or delete OCM mappings for all members in the same category rather than adding or deleting them individually.
Enter 1 to run the report in Proof mode. The report will print and the Object Configuration Manager table will not be updated. Enter 2 to run the program in Final mode. The report will print and the Object Configuration Manager table will be updated.
Enter 1 to add OCM mappings for objects in the category or 2 to delete mappings.
Enter 1 to delete OCM mappings for objects that already have mappings for the environment and user. Enter 2 or leave this field blank to deactivate but not delete mappings for conflicting OCM records.
These processing options enable you to specify whether to add or delete mappings, as well as the appropriate path code, environment, and data source to use.
When you enter a path code, mappings are added or deleted for all environments with the path code you enter. You do not need to enter a path code if you entered an environment name in the Environments processing option. If this field is blank, OCM mappings will be added or deleted regardless of the path code.
If this field is blank, OCM mappings are added or deleted regardless of the environment. If you entered a path code in the Path Code processing option, that path code is used. If both the Environments and Path Code processing option fields are blank, OCM mappings will be added or deleted for all environments in the Environment Detail table (F00941).
If you are deleting OCM mappings and this field is blank, all OCM records will be deleted regardless of the user class or role. If you are adding OCM mappings, you must enter a value in this field.
If you are deleting OCM mappings and this field is blank, all OCM records will be deleted regardless of the data source. If you are adding OCM mappings, you must enter a value in this field.