Resource Rate Cannot Be Set to 1 For Currency Type Resource by Cost Import (Doc ID 2976680.1)

Last updated on OCTOBER 03, 2023

Applies to:

Symptoms

Problem Statement
On Cost Import process, when importing resource rate = 1 for currency type resources, the following error occurs on CST_RESOURCE_COSTS_INTERFACE

Error
ERROR_CODE :CST_INVALID_RESOURCE
ERROR_EXPLANATION: The resource id and resource code combination does not exist or the functional currency flag is equal to 1.

Steps to Reproduce

1. Define Resource with type:Currency.
2. Insert a record to the interface table.
   INSERT INTO CST_RESOURCE_COSTS_INTERFACE
   (RESOURCE_ID
   ,ORGANIZATION_ID
   ,RESOURCE_RATE
   ,PROCESS_FLAG
   ,GROUP_ID
   )
   VALUES
   (85544 ---ResourceID
   ,207 ---OrgID
   ,1 ---Resource rate
   ,1 ---'1'
   ,999---GROUP_ID
   );
3. Execute Cost Import Process
4. The request ended with warning status
5. Review error on CST_RESOURCE_COSTS_INTERFACE

Cause

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