My Oracle Support Banner

Unable To Create Record Group For CFA (Doc ID 3074123.1)

Last updated on MARCH 21, 2025

Applies to:

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

Goal

Unable to create record group with payment terms ids from the TERMS table for CFA

When uploading a record group via CFA foundation spreadsheet, an error is returned saying an invalid RMS table was provided. The intention was to create a record group with payment terms ids from the TERMS table. Is this not valid?

Steps To Recreate:

1. Download the cfa foundation spreadsheet
2. Create a new record group with the following details
-Record Group Name: DM_PAY_TERMS
-Query Type: Simple
-Table Name: TERMS
-Value Column: TERMS
-Description Column: TERMS_CODE
-Where Column1: ENABLED_FLAG
-Operator1: =
-Condition1: Y
3. Upload the spreadsheet
4. Review the status and confirm the error message: "Invalid RMS table. Table name: %s1."
 

Solution

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
Goal
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.