Batch COMPEFFUPD Fails With Error : "Cannot Update ("EXP_PROF_DETAIL"."COMP_CURRENCY") To NULL@2COST_COMP_UPD"
(Doc ID 2831736.1)
Last updated on JANUARY 04, 2022
Applies to:Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.
Batch COMPEFFUPD fails with below error:
ERROR@1ORA-01407: cannot update ("EXP_PROF_DETAIL"."COMP_CURRENCY") to NULL@2COST_COMP_UPD_SQL.UPDATE_RATES_EFFECTIVE_DATE
Steps To Recreate:
1. From RMS ,navigate to "Country Expense Profiles" and choose an existing profile that already has a rate update record. For example "US" .
2. Add rate update: complete mandatory field and do not complete "Component currency" (this is the field that can be left blank thus causing the BATCH_COMPEFFUPD_JOB error).
3. Click on save.
4. The record will be saved in COST_COMP_UPD_STG table and NEW_COMP_CURRENCY will be NULL and later cause BATCH_COMPEFFUPD_JOB error.
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