Need

When an enricher is set to update a field (let's call it FieldA) based on changes done to another field (FieldB), users may observe that while editing FieldA, it updates FieldB in the form.

But clicking "Finish" does not retain the updated value in FieldB.

The correct value only appears if FieldB is overridden manually, which disrupts automated workflows.


Summarized Solution

This feature has been requested through an enhancement (MDM-11376) to automatically apply enriched values without manual override.

Until the feature is implemented, two workarounds can be considered to ensure smooth, automated updates with minimal manual intervention.

Detailed Solution


Option 1: Use the Override Button

After updating FieldA and seeing the enriched value in FieldB, manually select the override button beside FieldB. While this requires user interaction, it ensures the enriched value is saved.


Option 2: Apply PL/SQL Update in the SF Table

This second option avoids user interaction and enables a fully automated update. Implementing this option requires access to write and execute PL/SQL in the database.


Because you'll need to create a PL/SQL script to insert the enriched value directly into the SF table (which stores flags that indicate which field was overridden):

INSERT INTO SF_XX (B_LOADID, B_CLASSNAME, <GOLDEN_ID_COLUMN>, <COLUMNS_TO_OVERRIDE>)
VALUES (vLoadid, <your_entity_name>, <the golden id to override>, <flag '1' for each column that needs to be overridden>)