My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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