Understanding the External Exchange Rate Processor Program

After you upload exchange rates from an external source into the F0015Z1 and, if necessary, revise the rates, run the External Exchange Rate Processor program (R0015Z1). This program processes information from the F0015Z1 workfile and stores it in the F0015 table.

Specifically, the External Exchange Rate Processor program:

• Selects only unprocessed exchange rate records, which contain 0 (zero) in the ZEEDSP field.

• Validates the currency codes, exchange rates, and effective date against the F0015 table.

  If an exchange rate for a currency relationship and effective date exists, the program does not overwrite the existing record. Instead, it sends an error message, Duplicate Keys Not Allowed, to the work center and prints a message on the report that the record failed.

• Validates exchange rates against the F0015 table and, if applicable, ensures that the rates follow the no inverse and triangulation calculation methods.

  You must set up no inverse and triangulation for a currency relationship in the F0015 table before you can upload exchange rates and use this program.

• Generates a report that displays the number of records that were selected and failed and the total number of records added to the F0015 table.

• Writes errors to the work center and displays the user ID, batch number, and transaction number.

• Updates successfully processed records with 1 (processed) in the ZEEDSP field in the F0015Z1 workfile.

• Purges records from the F0015Z1 workfile, if specified in the processing option.

If you have to revise exchange rates successfully processed, you must use the Currency Exchange Rates program (P0015A).