Nullify 3 Custom Fields For Deleted And Merged Records
(Doc ID 2486833.1)
Last updated on NOVEMBER 22, 2019
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Accounts, Contacts, Households
Update 3 custom fields for deleted and merged records
We're using 3 custom fields on accounts to capture hierarchy information for reporting.
"Customer Organization Extension"."Extension Attribute Character 075" = Ultimate account grouping
"Customer Organization Extension"."Extension Attribute Character 102" = Division
"Customer Organization Extension"."Extension Attribute Character 101" = Country Division
Using Prompt search on these fields provides incorrect / outdated values for account groupings which are not based on active account record, but to merged (Party Status = M) or deleted accounts (Party Status = I). This makes it impossible to identify the correct filter value.
We need help to update / clean these values for the three mentioned fields on merged or deleted accounts.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document