R13 Unable To Import Opportunity Data

(Doc ID 2375235.1)

Last updated on APRIL 09, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.17.11.0 to 11.13.18.02.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Unable to perform opportunity file import . There are few errors are coming while trying for file import .


ERROR
-------
File Record Number Import Job Id System TaskId Error Type Error Message Comments
1 300000005833588 300000005833592 ERROR El atributo de parte OWNER_RESOURCE_ID no es válido. (MOO-450108) Details: Los valores válidos corresponden a los registros de parte activa existentes de tipo PERSON. CK_PARTY_ID_OPTY_OWNER
1 300000005833588 300000005833592 ERROR "El valor de Sales Method no es válido. Debe proporcionar un valor que esté configurado en el tipo de consulta SET_ID para la unidad de negocio de la oportunidad. (MOO-450232)" CK_FK_OPTY_SALES_METHOD_ID
1 300000005833588 300000005833592 ERROR La combinación de los atributos CURR_STG_ID,SALES_METHOD_ID no es válida. (MOO-450119) CK_PAIR_SALES_ID_STG_ID
1 300000005833588 300000005833592 ERROR El perfil para el objeto OWNER debe existir en la tabla JTF_RS_RESOURCE_PROFILES. (MOO-450121) CK_PARTY_ID_OPTY_OWNER_JTF_PROFILES
1 300000005833588 300000005833592 ERROR Debe proporcionar un valor para el atributo OPTY_CREATED_BY. CK_NOT_NULL_OPTY_CREATED_BY
1 300000005833588 300000005833592 ERROR Debe proporcionar un valor para el atributo OWNER_RESOURCE_ID. CK_NOT_NULL_OWNER_RESOURCE_ID
1 300000005833588 300000005833592 ERROR Debe proporcionar un valor para el atributo OPTY_LAST_UPDATED_BY. CK_NOT_NULL_OPTY_LAST_UPDATED_BY

The attribute of part OWNER_RESOURCE_ID is not valid. (MOO-450108) Details: Valid values correspond to the existing active part records of type PERSON.

"The Sales Method value is not valid, you must provide a value that is configured in the SET_ID query type for the opportunity business unit. (MOO-450232)" CK_FK_OPTY_SALES_METHOD_ID
The Sales Method value is not valid. You must provide a value that is configured in the SET_ID query type for the business unit of the opportunity. (MOO-450232) "CK_FK_OPTY_SALES_METHOD_ID

The combination of the CURR_STG_ID, SALES_METHOD_ID attributes is not valid. (MOO-450119) CK_PAIR_SALES_ID_STG_ID

The profile for the OWNER object must exist in the JTF_RS_RESOURCE_PROFILES table. (MOO-450121) CK_PARTY_ID_OPTY_OWNER_JTF_PROFILES

You must provide a value for the OPTY_CREATED_BY attribute. CK_NOT_NULL_OPTY_CREATED_BY

You must provide a value for the OWNER_RESOURCE_ID attribute. CK_NOT_NULL_OWNER_RESOURCE_ID

You must provide a value for the OPTY_LAST_UPDATED_BY attribute. CK_NOT_NULL_OPTY_LAST_UPDATED_BY

Changes

 

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