My Oracle Support Banner

Cost Component Rate Update Expects Currency Code (Doc ID 2717441.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

"Component Currency" field is not mandatory in "Country Expense Profiles" screen, but causes error if it is not filled when running BATCH_COMPEFFUPD_JOB:

" @0PACKAGE_ERROR@1ORA-01407: cannot update ("RMS01"."EXP_PROF_DETAIL"."COMP_CURRENCY") to NULL@2COST_COMP_UPD_SQL.UPDATE_RATES_EFFECTIVE_DATE "


Steps to reproduce:
1. From RMS go to "Country Expense Profiles" and choose an existing profile that already has a rate update record. For example "US" (on GRID 19).
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. 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.

 

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!


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