My Oracle Support Banner

REIMFIXEDDEALUPLOAD Batch Fails When Consolidation Rate is not Available (Doc ID 2800381.1)

Last updated on AUGUST 22, 2021

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

When CONSOLIDATION_IND = 'N' and there is no data for exchange type 'C' in IM_CURRENCY_RATES table, reimfixeddealupload batch fails with an error 'operational_currency_rate_not_defined'

ERROR
-----------------------
messageKey-Error.operational_currency_rate_not_defined

Steps to Recreate:

  1. Ensure that CONSOLIDATION_IND = N.
  2. Run batch_rfmvcurrconv.ksh to refresh MV_CURRENCY_CONVERSION_RATES view.
  3. Create a non-merch fixed deal for a foreign currency supplier.
  4. Run all relevant batches including vendinvf and notice that STAGE_FIXED_DEAL_HEAD table is populated.
  5. Run reimfixeddealupload batch and notice that upload fails with below error:
    "messageKey-Error.operational_currency_rate_not_defined"

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.