Converting Base Currency Data

This chapter provides an overview of Currency Conversion Utility Application Engine process (EO_CURRENCY) run controls and discusses:

Restarting and rerunning Currency Conversion Utility process run controls.
Running the Currency Conversion Utility process.

Note. Because the Currency Conversion Utility conversion processes are very complex and deal with the conversion of extremely important financial data throughout your system, PeopleSoft strongly recommends that you contact PeopleSoft Global Services (PGS) for assistance in using the Currency Conversion Utility.

Overview of Currency Conversion Utility Process Run Controls

The Currency Conversion Utility process run controls are similar to standard PeopleTools Process Scheduler run controls. However, there are some additional safeguards built into the Currency Conversion Utility process run controls to ensure that converted data does not get corrupted if an error occurs in the middle of conversion.

When you run a process group, the entire Currency Conversion Utility process runs for each conversion rule in that process group. The sections and steps that are actually executed at run time depends on how the rule is defined and which data is selected for conversion. The Currency Conversion Utility does not actually update the conversion record with converted data until all the required Currency Conversion Utility engine steps are completed successfully for that record's conversion rule.

The Currency Conversion Utility process tracks the successful completion of exception processes using a status setting on the utility's primary State record. When an exception process completes successfully, the Currency Conversion Utility process updates the RUN_CNTL_EO_CC3 run control tracking record and continues on to the next conversion step. If at any point during this process an error occurs, the Currency Conversion Utility process abends, no data on the conversion record is updated, and the process rolls back to the last successfully completed conversion process for the process group. The Currency Conversion Utility process does this so that data in the conversion record does not become partially converted. To prevent partial updates to a record if an error occurs in the middle of conversion, the following restrictions apply to Currency Conversion Utility process run controls:

You can use a Currency Conversion Utility process run control only once for a specific set of conversion criteria for a process group.
You cannot change or delete a Currency Conversion Utility process run control once it has begun processing.
You must create a new run control for each new set of conversion criteria for a process group.

Once a run control starts processing, the Currency Conversion Utility process locks it from further changes by setting a flag on the process run control tracking table and modifying the run control pages so that the fields are no longer selectable. The Currency Conversion Utility process does this because the data in the detail audit tables for the conversion records are tied to the run control.

Restarting and Rerunning Currency Conversion Utility Run Controls

The Currency Conversion Utility process provides a restart process that enables you to continue running a process group run control that is not successfully completed. Because the process handles its own restart capability, the normal PeopleSoft Application Engine restart function is not available. Determining whether to restart or rerun a process group run control depends on several factors, including:

Is the Run Status field value set to Completed or In Process?
Are you doing a pre-conversion analysis or running the actual conversion?
What type of error did you encounter?
Do you want to use the same run control criteria you used the last time you ran the same run control?

Restarting a Process Group Run Control

In general, you can restart a Currency Conversion Utility run control if an error occurs before a process group run control is completed and you want the utility to continue conversion processing without rerunning the entire process group from the beginning.

Before you decide whether to rerun or restart a process group, you need to correct the error that caused the Currency Conversion Utility to abend. Once you have corrected the error, carefully consider any post-conversion data integrity issues before you decide whether to restart a process group.

To restart a run control, open the run control ID for the process group you want to restart and click the Run button. You cannot modify any of the conversion criteria on the existing In Process run control page. If you need to change conversion criteria, you must rerun the process group with a new run control. You can restart a run control as long as it is not yet completed, or in other words, it still has a run control status of In Process.

When you restart an In Process run control, the Currency Conversion Utility does not re-execute all of the conversion steps in the process group. Instead, the Currency Conversion Utility skips any completed conversion steps for that run control process instance and restarts conversion processing at the last successfully completed conversion task.

The Currency Conversion Utility's restart process is designed for pre-conversion analysis and testing because it speeds conversion processing. This may be particularly helpful when you troubleshoot process groups with large amounts of data that take a long time to run. Restarting the process group run control from where it abended instead of rerunning it from the beginning can help you quickly analyze which Currency Conversion Utility processes complete successfully and which processes may need further modifying before the actual conversion.

However, PeopleSoft strongly recommends that you do not use the Currency Conversion Utility restart during the actual conversion. If you encounter an error during the actual conversion and restart the same process group run control without restoring the data and running the process group again from the beginning, there is no guarantee that all your data will be converted correctly, even if you have fixed the error and the process group appears to complete successfully. In some cases, an exception process may need to re-execute during a Currency Conversion Utility restart even if it has already successfully completed. For example, the exception process may check or set a status flag in a different table required for conversion to continue, or set a required value. There is a check box on the Exception Process page to identify any exception process that should always re-execute even during a restart.

Rerunning a Process Group Run Control

When you rerun a process group, the Currency Conversion Utility re-executes the entire process group from beginning to end. You must create a new run control ID when you rerun a process group. You must rerun a process group if you are running the same process group using different conversion criteria. For example, if you decide to convert two business units separately and you run a process group once for the first business unit, you must create a new run control to rerun the same process group for the second business unit. In both cases, all of the conversion tasks within that process group execute both times that you run the process group. You must also rerun a process group if you are running the same conversion criteria for the same process group and the run control is already completed. For example, if you modify a rule or exception process for a process group and want to use the same conversion criteria as a previously completed run control, you must create a new run control ID and rerun the process group.

If you rerun a process group using the same conversion criteria, you should always restore the original pre-conversion data in the conversion records first. If you don't, you run the risk of incorrectly processing already converted data. This is particularly important for effective-dated tables where new rows are inserted during conversion. We recommend that you rerun all the process groups as one of the final pre-conversion testing and analysis steps prior to the actual conversion. Rerunning process groups from beginning to end against a copy of the production database prior to the actual conversion helps ensure that all conversion rules and exception processes complete successfully and that all the data converts correctly.

If the Currency Conversion Utility does encounter an error during the actual conversion, we strongly recommend that you do not restart the process group run control. Instead, you should correct the error, restore the original data, and rerun the process group using a new run control ID. Otherwise, you run the risk of incorrectly converting data.

Using the Currency Conversion Utility Process

To run the Currency Conversion Utility process on a process group, specify the process group conversion criteria on the process run control pages. Based on these conversion criteria, the Currency Conversion Utility process executes the appropriate process group conversion rules and calls any associated exception processes to select and convert data. The Currency Conversion Utility process runs for one process group at a time.

In this section, we discuss:

Specifying currency criteria run control parameters.
Specifying selection component run control parameters.
Running the Currency Conversion Utility process.

Pages Used To Use the Currency Conversion Utility Process

Page Name	Object Name	Navigation	Usage
Currency Criteria	RUN_CNTL_CC_EO	Set Up Enterprise Components, System Administration, Utilities, Convert Currency, Currency Conversion Processes, Process Currency Convrsn Util	Provide specific rate information for the From Currency or Currencies and the To Currency that the Currency Conversion Utility uses during the conversion process.
Selection Components	RUN_CNTL_CC1_EO	Set Up Enterprise Components, System Administration, Utilities, Convert Currency, Currency Conversion Processes, Process Currency Convrsn Util, Selection Components	Specify conversion parameters for additional process group selection components (if any).

Specifying Currency Criteria Run Control Parameters

Access the Currency Criteria page.

To run a process group, you first specify the currency criteria that the Currency Conversion Utility process should use for conversion. You must specify at least one From Currency (the original base currency), along with information on the To Currency (the new base currency).

Process Group ID	Select the appropriate process group.
To Currency	Specify the currency to which you're converting.
Rate Type	Specify the Rate Type you want to use as the conversion basis.
As Of Date	Specify the date. The default is the current date. If you want to convert data as of a specific date, specify that date as the As Of Date. The Currency Conversion Utility selects conversion records beginning with the record that is effective on that date. See Determining Your As of Date and Its Impact on Effective-Dated Tables.
Audit Processing	Specify the value based on how you want the Currency Conversion Utility to generate detail audits for all the conversion fields on the conversion rules in the process group. If you want to run detail audits for certain rules, clear this check box and select the Detail Audit check box on the Conversion Rules page. As Defined. Generates audit details for those rules that have the Audit Detail check box selected on the Conversion Rules page. Audit Proc (audit processing). Generates audit details for those rules that have the Audit Detail check box selected on the Conversion Rules page. Bypass All. Does not generate audit details for any of the conversion rules in the process group.
From Currency	Specify the currency from which you're converting. Insert a new row for each additional From Currency value.
Exchange Rate	Displays the selected currency's conversion rate, based on the To Currency, From Currency, Rate Type, and Rate Effective Date. The Currency Conversion Utility can convert multiple From Currencies for the same process group, as long as all of the following are true: You are converting all the From Currencies to the same To Currency. You have not selected the Convert from Single Currency check box on the process group setup page. The process group does not have an exception process associated with it that limits the process group to only one From Currency.
Run Status	Changes to reflect the status of the run control for the conversion. You can use the PeopleTools Process Monitor to view the status of conversion run controls. The Currency Conversion Utility sets the Run Status field value based on the following statuses of conversion processing. Not Run. A run control that has been defined, but not yet run. In Process. The run control has started, but is not yet completed. Ran with Errors. The run control is completed, but controlled errors were encountered during conversion. Completed. The run control ran to completion with no errors. Note. You cannot modify, alter, or delete a Currency Conversion Utility run control once it is in process; that is, once it no longer has a status of Not Run. This ensures that the Currency Conversion Utility correctly identifies where to restart converting data if a process group does not complete all its conversion processes successfully and has to be restarted.

Specifying Selection Component Run Control Parameters

Access the Selection Components page.

If there are any additional selection components for the process group, you use the Selection Components page to specify which value or range of values to use for these fields at run time.

Because each process group can have a different set of selection components, the Selection Components page changes dynamically to reflect the selection components defined for the process group. Fields on this page can include characters or dates, depending on the selection component type. Character entry fields are free-format. Case-sensitive information must be entered correctly.

For each additional selection component defined for the process group, choose the operator that should be used to select values during conversion:

All.

Includes all values for that selection component.
Equal.

Specifies a single value for the selection component. When you select this operator, this page displays an additional data entry field where you can specify the value for the selection component.
Between.

Specifies a range of values for the selection component. When you select this operator, this page displays two additional data entry fields where you enter the From value and Through value of the selection component. The From value must be less than the Through value. The range is inclusive of the From and Through values.

Running the Currency Conversion Utility Process

Once you have defined the process group currency criteria and any selection component values, run the Currency Conversion Utility process on the process group by clicking the Run button. You can view the status of the run control using the Process Monitor. The following page control elements appear on the Process Monitor page:

Report Manager	Click to access the Report List page, where you can view report content, check the status of a report, and see content detail messages (which show you a description of the report and the distribution list).
Process Monitor	Click to access the Process List page, where you can view the status of submitted process requests.
Run	Click to access the PeopleSoft Process Scheduler request page, where you can specify where a process or job runs and the process output format.

Once the process group is completed successfully, you can query the tables or run your regular reports to verify that the data has converted successfully.