Coalesce records on a normal value
Coalescence enables an administrator to redirect references to multiple records containing variants of the same field value to point to a single record, based on a normal value.
Before you begin
Role required: admin
About this task
An example of this is the Company table that might have multiple variants of a
company name, such as Hewlett-Packard, Hewlett-Packard, Inc., Hewlett-Packard
Incorporated, HP, and so on. Potentially, thousands of records might reference each
of these duplicate company records. Using the variants of the Hewlett-Packard name
as aliases, coalescence unifies all these references into a single record that
normalizes the Name field in the Company record to a normal
value such as HP.
Note:
Coalescing normal values
changes the record values permanently. If a rollback is performed, records will
be returned to the table, but the normalized values will not be rolled back to
the original variants.
When the references are fixed, all table fields directly corresponding to sys_dictionary get fixed. The secondary references are not fixed. If you have filter conditions that has the old, pre coelesced company names, they aren't fixed either.