FCCS Data Exchange – How to clear an Attribute value once it has been loaded?

Hello everyone,

I’m working with Oracle FCCS – Data Exchange mappings and I need clarification on how attribute values can be cleared or removed.

Scenario:

• I am mapping an Entity Attribute in FCCS using Data Exchange.
• The attribute has a meaningful value:
  ICP_Entity_Yes
• The attribute is populated based on a source field (UD3):
  • When UD3 = 'Y', the attribute is correctly assigned.

Observed behavior:

• When UD3 is not 'Y', I need the attribute to be cleared.
• Using:
  • CASE ... ELSE NULL → results in an error
  • CASE ... ELSE '' → results in an error (empty string treated as NULL)
  • Mapping to <None>