Symptom
You cannot import Exchange Rate due to the following errors:
"An error occurred during file export:
Error ID: AP_UI_OIN 043
Error text: Not enough rows in table for CurrencyCode code list. Add more rows.
Please report an incident if the error persists."
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Common Tasks view.
- Go to the Edit Exchange Rates subview.
- Click the Import button and select From Microsoft Excel.
The following errors are displayed:
"An error occurred during file export:
Error ID: AP_UI_OIN 043
Error text: Not enough rows in table for CurrencyCode code list. Add more rows.
Please report an incident if the error persists."
Cause
You are using an older version of the New Exchange Rates Microsoft Excel template.
Resolution
- Go to the Application and User Management work center.
- Go to the Business Flexibility view.
- Go to the Microsoft Office® Template Maintenance subview.
- Search and select the Template Name New Exchange Rates.
- Click Versions.
- Select the latest version and click Revert To.
You can import the Excel template from the General Ledger work center after the above mentioned changes.
See Also
Error ID: AP_UI_OIN 043, Error text: Not enough rows in table for CurrencyCode code list. Add more rows., Exchange rate, Microsoft excel template
Keywords
KBA , SRD-FIN-GL , General Ledger , Problem