Errors During Opportunity Revenue Import (Doc ID 2073355.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Opportunities

When attempting to import Opportunity Revenue
the following error occurs.

ERROR
-----------------------

1) 3E+14 3E+14 ERROR The object OWNER must exist either in the table MOO_OPTY_RESOURCES or in the table CHD - MN Oppty - no custom import.csv in the same batch.
1 3E+14 3E+14 ERROR This row cannot be imported because the parent opportunity record has errors.
1 3E+14 3E+14 ERROR This row cannot be imported because the parent opportunity record has errors.
1 3E+14 3E+14 ERROR The value of the attribute OpportunityRevenue_UomCode is not valid.
1 3E+14 3E+14 ERROR You must provide a value for the attribute REVN_CATEGORY_CODE .
1 3E+14 3E+14 ERROR The value of the attribute OpportunityRevenue_RevnAmtCurcyCode is not valid.
1 3E+14 3E+14 ERROR The specified PR_CON_PARTY_ID and PR_CON_RELATIONSHIP_ID must match the primary contact on the opportunity.
1 3E+14 3E+14 ERROR You must provide a value for the attribute PRODUCT_GROUP_ID .
1 3E+14 3E+14 ERROR The object PRIMARY_CONTACT must exist either in the table MOO_OPTY_CON or in the table CHD - MN Oppty - no custom import.csv in the same batch.
1 3E+14 3E+14 ERROR You must provide a value for the attribute PARENT_REVN_ID .


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import Accounts
2. Import Contacts
3. Import Opportunities with Contacts as customers and adding Revenue items.

The above errors are displayed

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, you are unable to complete the import for Opportunity Revenue.

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