Cannot make Primary Partner Field Null Using File Based Import

(Doc ID 2325257.1)

Last updated on NOVEMBER 14, 2017

Applies to:

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

Symptoms

On :  11.12.1.0.0 version, Opportunities
Cannot make Account (Advertiser) and the Primary Partner (Agency) fields null using file based import using #NULL.
Advertiser is the Account and the Agency is actually a primary partners which are populated on opportunity and both of them are Dynamic Choice list so I was associating them using the Party number.But after putting #NULL in the respective fields and in the opportunity Id which was used to associate them with the Opportunity, it doesn't make them blank on UI.

ERROR
-----------------------
You must provide a value for the attribute {ATTRIBUTE_NAME}.The combination of attributes (SALES_ACCOUNT_ID,CUST_PARTY_ID) is not valid. (MOO-450119)
This row cannot be imported because the parent opportunity record has errors. (MOO-450118)"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Sales Cloud
2. Navigator> Setup and Maintenance> Manage File Import Activities
3. Import Opportunity import with #NULL values for Account and Agency and the values are not removed and receive an error message

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot delete the values in the Account (Advertiser) and the Primary Partner (Agency)  fields.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms