FAQ - Base Currency Conversion

Purpose of Document

The base currency conversion consists of programs that convert the base currency of a company to a different base currency. Specifically, these programs:

Ensure data integrity within a table, when necessary.
Based on user preference, create an audit trail that indicates the original amounts and converted amounts for each converted table.

Base Currency Conversion performs,

The programs for the base currency conversion convert monetary amounts and currency codes. As a result, the conversion affects all JD Edwards EnterpriseOne data tables that contain currency codes, monetary amounts, or both.
Depending on the table being converted, the programs for the base currency conversion multiply or divide the domestic or foreign amount by the exchange rate in the Currency Exchange Rates table (F0015) to calculate the new base currency amount.
The programs for the base currency conversion handle rounding the same way as the application programs. For example, if you use soft rounding for transactions in accounts receivable, the accounts receivable conversion programs use soft rounding. If an application program is not set up for rounding, the conversion programs round down amounts less than 0.5 and round up amounts greater than or equal to 0.5.
The results of all conversion programs are final. You cannot run them in proof mode. As with all conversions, you cannot add, change, or delete data while the conversion programs are processing.

Important:

The base currency conversion, specifically the programs for the Euro Conversion Planner/Workbench (P9840E) and the Table Conversion Scheduler (P98430), must be run in a Windows environment (i.e., FAT client, WebDev client. cf., Web Client which is a thin client). All other tasks, including preconversion and postconversion tasks, can be performed in either a Windows or a Web environment. Formerly, the base currency was called as Euro conversion.

This document provides answers to some frequently asked questions on base currency conversion.

Frequently Asked Questions

Question 1 - Where is the Implementation Guide repository?

Answer 1: For detail,

9.2 Base Currency Conversion guide: https://docs.oracle.com/cd/E64610_01/EOABE/toc.htm
9.1 Base Currency Conversion guide: https://docs.oracle.com/cd/E16582_01/doc.91/e15087/toc.htm
9.0 Base Currency Conversion guide: https://docs.oracle.com/cd/E15156_01/e1apps90pbr0/eng/psbooks/1abe/book.htm

For instance,

Go to <Document 1597048.1> Oracle Documentation Links
Quick Link > Applications > (Hyperlink) JD Edwards
Select "JD Edwards EnterpriseOne"

Home / Applications / Oracle JD Edwards EnterpriseOne Applications Documentation, Release 9.2 / Cross-Product
JD Edwards EnterpriseOne Applications Base Currency Conversion Implementation Guide

Product specific knowledge contents are found at,

<Document 625820.1> - E1: 09: FAQ - Frequently Asked Questions Regarding Base Currency Conversion Within JD Edwards EnterpriseOne General Accounting
<Document 872884.1> - E1: 03B: FAQ - Frequently Asked Questions on Accounts Receivable Integrity Reports (R03B707, R03B701, R890911BI, R8903B14I)
<Document 2356698.1> - E1: 09: What is the Process to Change the Domestic Currency of an Existing Company?

Question 2: EnterpriseOne Applications Base Currency Conversion Implementation Guide does not specify any conversion UBE for the tables F41061 (Supplier Price/Catalog File) and F4072 (Price Adjustment Detail). Is there any UBE which enable user to convert currency from EUR to DEM (Deutsche Mark)?

Answer 2: There is no conversion UBE for table F41061 and F4072. The reason is that the currency code in these tables are not base currency (which is related with transaction company). In other words, the currency code defined these two tables are transaction currency not base currency. In case you need to pull price information based on DEM (Deutsche Mark) you need add additional entry for that currency.

For example, if you add a new purchase order for company where (base currency changed from EUR to DEM) and you purchase it from domestic currency,it will look for purchase price information based on DEM (currently you may not have this then). If it is not able to find any matching record from F41061 then it will get item cost from F4105 (Itme Cost). So it is important to add additional entry based on transaction currency. If needed you may need to create batch application which can add additional entries for table F41061 and F4072.

So FROM side (or source) table which is master/setup for a certain transaction do not have conversion routine whereas TO side (or target) side transaction contains base currency because this currency is for how we realize asset and/or profit/loss for a certain transaction.

Technically, UPDATE is none other than INSERT and DELETE whereas the tables (F41061/F4072) require ADD on top of existing records. Hence it is natural that we do not have any conversion UBEs (e.g., R8941061E and so on).

Question 3: Is there any standard application enables user to populate these tables F41061 for procurement and F4072 for sales/procurement?

Answer 3: No. Currently there is no UBE which enables you to populate data into F41061 and F4072.

See below for detail,

<Document 659847.1> - E1: 47: EDI Quick Reference Guide
<Document 1275030.1> - E1: INTEROP: Interoperability Quick Reference Guide (Interoperability Interface Tables) in EnterpriseOne

Question 4: We created two plans for different companies during Euro Conversion run ( P9840E) but noticed a changed for status after 1st run and it prevents us from converting 2nd company. What is possible cause of this issue?

Answer 4: As indicated in the Implementation Guide, it is important to delete Conversion Log if you have more than 2 plans.

Clients who set up multiple plans must run the euro conversion one plan at a time and upon successful completion, delete the conversion log before running the next plan. (Currently the terms base currency conversion is being used).

For example, this error routine is written at business function CheckforDuplicateMergeCnv (B9800941) by issuing query as below:
sql> SELECT * FROM SY920.F984052 WHERE ( SHCNVSTS = '2' AND SHCNVTYP = '3' AND SHPGM = 'R890911E' AND SHDATP = 'Business Data - PROD ' AND SHTRLS = 'B9' )

Check data from F984052 and make it sure that table F984052 do not contain duplicated information in it. Usually the status will be appeared as "Duplicate Conversion or Merge" with status code '70' from F984052 (Table Conversion - History Log).

Question 5: What is simplified routine to process Base Currency Conversion?

Answer 5: Refer to Completing Conversion Tasks in the User Guide
Simplified routine can be,

Form Name	Form ID	Navigation	Usage	Others
Work with Conversion Plans	W0087B	Setup and Conversion (G97UE9A), Conversion Constants	Review a list of conversion plans.	Web Only
Conversion Plan Revisions	W0087C	Click Add on the Work with Conversion Plans form	Set up constants for a conversion plan	Web Only
Work with Audit Definitions	W0085EA	Setup and Conversion (G97UE9A), Audit Record Maintenance	Work with audit records for a plan	Web Only
Audit Definition Revisions	W0085EB	Select a plan on the Work with Audit Definitions form and click Select	Revise audit record values for a conversion plan	Web Only
Work with Currency Conversion Plans	W9840EC	In the Windows environment, Advanced Operations (GH9611), Euro Conversion Planner/Workbench	Work with conversion plans	Windows Client Only
Maintain Currency Conversion Plans	W9840EA	Click Add on the Work with Currency Conversion Plans form	Set up conversion plans	Windows Client Only
Euro Conversion Planner	W9840T	On the Work with Currency Conversion Plans form, select a plan, and then select Conversion Planner from the Row menu	Review conversion programs in a plan	Windows Client Only

The Euro Conversion Planner/Workbench program interfaces with the existing Installation Planner (P9840) and Control Table Workbench (P98413) programs and provides access to these forms:

Euro Conversion Planner (P9840), which contains the conversion programs for a plan.
Euro Conversion Workbench (P9840E), which you use to run the conversion programs.

Note that,

Application P0087 (Conversion Constants), P0085E (Euro Conversion Audit Records) can be running through HTML client.
Application P9840 (Installation Planner) and P9840E (Currency Conversion Planner/Workbench) are to be accessed only through WebDev/WebAdmin client.

Question 6: In WebDev client, (row exit) "Convert Selected" from P9840E - [Euro Conversion Workbench] it does not perform any. What is possible cause?

Answer 6: This conversion must be running on the Deployment Server.

Question 7: What UBEs are called when clicking "Convert All"?

Answer 7: For EURO Conversion (or Base Currency Conversion) launch R98405 (Table Conversion/Merge Driver)|XJDE0001.

Question 8: Is base currency conversion the best practice when we need to have a new base currency code?

Answer 8: Yes. For detail, refer to <Document 2356698.1> - E1: 09: What is the Process to Change the Domestic Currency of an Existing Company?

Question 9: Is it possible to run conversion batch independently and standalone?

Answer 9: This can be used when a certain conversion UBE performs slow so you want to split it into many or conversion application does not return expected result.

Possible business scenario: R894201E fails to update F4211.UPRC how to debug this?

Log on to WebDev client
Look for conversion UBE through Plan (P9840E) which shows R894201E|XJDE0001 (F4201 - Sales Order Header Base Currency Conversion)
Look for the object returned in step 2 and move it to available OMW Project
(Optional) Check out
Go to Report Design Aid and Highlight main section (where business view is associated. For this example, "Header - Sales Order Header - DRIVER" section)
Go to Event rule and focus on "Initialized Section" event
Look for RI (Report Interconnection, which is Data Structure for the conversion UBE you are to run) RI RI szPlanName (For this example, R894201E assigns VA rpt_szPlanName_ENVN = RI szPlanName
Disable it and override VA rpt_szPlanName_ENVN (for example, VA rpt_szPlanName_ENVN = "C500" if you have defined plan name as C500 through P0087). This value is to be used to get company and conversion information from F0087
Save it then submit version specification
Either submit it to server (so follow same UBE logging/tracing) or run it locally after modifying JDE.INI as below,

[DEBUG]
Output=FILE

[UBE]
UBEDebugLevel=6
UBESaveLogFile=1

11. Get callobject kernel log (JDEDEBUG_*.log) from the directory you have defined in [DEBUG] section DebugFile=c:\logs\jdedebug.log and get UBE log from PrintQueue directory where you run R894201E

Note:

This override can be used when a certain conversion application performs slow to split a single run into many run
You need to know basic flow of base currency conversion routine to implement this

Question 10 - How to debug specific conversion batch?

(to be updated) 1. Create a user 'LOCAL', 2. Map the user 'LOCAL' to run UBE locally through OCM, 3. Modify JDE.INI, 4. Analyze jdedebug.log and ube log

Question 11 - What is simple step to test it out?

(to be updated) 1. (Menu GH9611) and select Euro Conversion Planner/Workbench (P9840E), 2. Add a plan, 3. Delete unnecessary conversion batches (this file can be created anytime by clicking Load), 4. Go to P98413 and look for plan created then (form exit) Convert Selected or Covert All

Question 12 - What are the table related with conversion routine?

Tables below controls the conversion routine,

• F0087 – Conversion Constants File for Euro
• F0085 – Audit Record Y/N File – Euro
• F0086 – Conversion Audit File for Euro Conversion

• F0009 – General Constant
• F00941 – Environment Detail
• F9840 – Installation Plant Master
• F9840T – Installation Plan Master Tab File
• F98403 - Environment Plan Detail Table
• F98405 – Table Conversion Scheduler
• F984052 – Table Conversion – History Log
• F9843 – Table Conversion – JDE Scheduler
• F9843T – TC Schedule – Tag File
• F9860 – Object Librarian Master Table
• F986101 – Object Configuration Master

Question 13 - Simplified routine for debugging?

Conversion iterates below,

P98413|W98413D (Table Conversion Workbench)
|--- LaunchConversionOrMerge (B984052, Launch Conversion Or Merge)
|--- R98405 (Table Conversion/Merge Driver)
|--- LaunchConversionOrMerge (B984052, Launch Conversion Or Merge)
|--- R894111E (Convert F4111 to the Euro)
|--- LaunchConversionOrMerge (B984052, Launch Conversion Or Merge)
|--- R98405 (Table Conversion/Merge Driver)
|--- LaunchConversionOrMerge (B984052, Launch Conversion Or Merge)
|--- R894105E (Convert F4105 to the Euro)
…

(this document is to be updated shortly).