Skip Non-Null Target Values in Lookup Table Processing

Lookup Table processing includes a toggle to preserve existing non-null values in target columns. When enabled, the Lookup Table return value is applied only where the target is null. When disabled, all qualifying target columns continue to be updated, including columns that already contain values.

Prevents unintended overwriting of previously populated or enriched data and gives users explicit control over update behaviour. The default processing pattern remains available for implementations that require complete refreshes.

Steps to enable and configure

You don't need to do anything to enable this feature.

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html