Opportunity File Import Errors

(Doc ID 1986371.1)

Last updated on AUGUST 09, 2016

Applies to:

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


Opportunity file import failed with the multiple errors. The import was done using opportunity template from Import_Templates_R9_29Jan15.xlsx (<Note 1564536.1>)



MOO-450114 and MOO-450111
File Record Number,Import Job Id,System TaskId,Error Type,Error Message,Comments
1,300000017669452,300000017669456,ERROR,"The object OWNER must exist either in the table MOO_OPTY_RESOURCES or in the table Test Opportunity R9 Map - Opty.csv in the same batch. (MOO-450114)",
1,300000017669452,300000017669456,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.",

Also the import had error for column OpportunityRevenue_ForecastOverrideCode = CRITERIA = ForecastOverrideCode


The issue can be reproduced at will with the following steps:
File import Activities > Create new > Object = Opportunity


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