Import Opportunities With Owner Into Sales Cloud 9 Via File Import

(Doc ID 1968805.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Fusion Common CRM - Version 11.1.9.2.0 and later
Oracle Fusion Opportunity Management Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Trying to import opportunities in Release 9 and getting the below error:

File Record Number Import Job Id System TaskId Error Type Error Message Comments
2 300000010992805 300000011079836 ERROR The profile for the object OWNER must exist in the table JTF_RS_RESOURCE_PROFILES. (MOO-450121)
2 300000010992805 300000011079836 ERROR This row cannot be imported because the parent opportunity record has errors. (MOO-450118)
2 300000010992805 300000011079836 ERROR The party attribute OWNER_RESOURCE_ID is not valid. (MOO-450111) Details: Valid values correspond to existing active party records of type PERSON with RESOURCE usage.
2 300000010992805 300000011079836 ERROR The party attribute OWNER_RESOURCE_ID is not valid. (MOO-450108) Details: Valid values correspond to existing active party records of type PERSON.
2 300000010992805 300000011079836 ERROR You must provide a value for the attribute OWNER_RESOURCE_ID.
2 300000010992805 300000011079836 ERROR The object OWNER must exist either in the table MOO_OPTY_RESOURCES or in the table opportunity_import.csv in the same batch. (MOO-450114)
2 300000010992805 300000011079836 ERROR The object OWNER must exist either in the table MOO_OPTY_RESOURCE or in the table opportunity_import.csv in the same batch. (MOO-450114)

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