My Oracle Support Banner

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 11.13.18.10.0 and later
Information in this document applies to any platform.

Goal

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

Solution

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
Goal
Solution


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