My Oracle Support Banner

Nullify 3 Custom Fields For Deleted And Merged Records (Doc ID 2486833.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.