Customers Workbench: Query Customers Created by Customer Interface (RACUST) Raises Error - Flexfield Segment Context Value Does Not Exist in the Value Set $FLEX$.DF_CONTEXTS
Last updated on MARCH 27, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
You imported customers using CUSTOMER INTERFACE concurrent standard program. The import is successful but when you query the customer record in the application, it raises the following error message:
ID XXXX for the flexfield segment Context Value does not exist in the value set $FLEX$.DF_CONTEXTS.
(Where XXX above is a flexfield name.)
Review of the RACUST process shows it inserts the same value into 2 tables:
AR_CUSTOMERS.ATTRIBUTE_CATEGORY and HZ_PARTIES.ATTRIBUTE_CATEGORY.
Review of the customer records created manually via the form have HZ_PARTIES.ATTRIBUTE_CATEGORY = null. These customer records can be queried without errors in the form.
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 hundreds of Community platforms