Error In Opportunity Batch Upload (Doc ID 1911419.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Fusion Opportunity Management Cloud Service - Version 11.1.7.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Error in Opportunity Batch Upload

When creating a file based opportunity batch upload, the party number of the resource (the opportunity Owner with a report using BI, it has worked with customers and consumers batch creation with owner), but the upload process ends with errors related to the Resource (The user has been correctly identified as resource before )and a Field called CHANNEL_TYPE_CD, that isn't even used in the import

Error Message
The value of the attribute CHANNEL_TYPE_CD is not valid. You must provide a value that exists in the lookup type ZPM_SALES_CHANNEL. (MOO-450107) - ATTRIBUTE_NAME: CHANNEL_TYPE_CD
The OWNER must exist either in MOO_OPTY_RESOURCE or in MOO_IMP_OPTY_RESOURCE in the same batch. (MOO-450114) - INTERFACE_TABLE: MOO_IMP_OPTY_RESOURCE - OBJECT: OWNER
This row cannot be imported because the parent opportunity record has errors. (MOO-450118)
The party attribute RESOURCE_ID is not valid. (MOO-450111) Details: Valid values correspond to existing active party records of type RESOURCE with PARTNER_CONTACT usage. - USAGE: PARTNER_CONTACT - ATTRIBUTE_NAME: RESOURCE_ID
The party attribute RESOURCE_ID is not valid. (MOO-450111) Details: Valid values correspond to existing active party records of type RESOURCE with RESOURCE usage. - USAGE: RESOURCE - ATTRIBUTE_NAME: RESOURCE_ID
 

Solution

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