Generic System Error When Creating WIP Adjustment With Exchange Rates

Products

• Clarity PPM On Premise

Issue/Introduction

When creating a WIP adjustment gives a generic error with no details on how to fix.

This happens when adjusting the transaction and changing the currency to one where there is no bi-directional currencies set up in Foreign Exchange Rates

Steps To Reproduce

1.  Create Exchange Rates

• BRL to USD
• USD to BRL

and

• INR to USD
• USD to INR

Do not create one BRL to INR as we want to adjust from BRL to INR

2. Create  a transaction using BRL currency

2. Post the transaction to WIP.

3. Make an adjustment, such as role and rate and 

4. Change the currency to INR

5. Save

Expected: The adjustment should be accepted.
Actual: The adjustment is not accepted but does not give detail about why it is not accepted.

There is a generic error: System error. Contact System administrator.

Logs (app-ca and bg-ca) do not have any information.

Resolution

1. Check if  involved country/currency rate exchange exists.
The following query can be used:

select * from CMN_EXCHANGE_RATES

If bi-directional rate exchanges do not exist, proceed to create them, e.g.


INR to USD, USD to INR

If you do not want to create the new bi-directional rates 2 WIP adjustments are needed to bridge the gap.

1. WIP adjustment #1

• Change the quantity and the currency from BRL to USD (as there is a bi-directional match for this)
• Click the Calculate New Rates box (required)
• Save and Approve WIP Adjustment

2. WIP Adjustment #2

• Follow the same steps changing the currency from USD to INR
• Click the Calculate New Rates box again (required)
• Save and Approve