My Oracle Support Banner

Error On Opportunity StatusCode Field When Importing Opportunity : OPTY_STATUS for the opportunity's business unit. (MOO-450232) (Doc ID 1964752.1)

Last updated on JUNE 19, 2017

Applies to:

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


On : version, File Import/Export

When I try to import a simple opportunity, I get an error on the field StatusCode of the opportunity.
The error says:
File Record Number,Import Job Id,System TaskId,Error Type,Error Message,Comments
1,300000005203419,300000005440782,ERROR,"The value of Oppty_StatusCode is not valid. You must provide a value that is set up in the lookup type OPTY_STATUS for the opportunity's business unit. (MOO-450232)",
1,300000005203419,300000005440782,ERROR,"This row cannot be imported because the parent opportunity record has errors. (MOO-450118)",
 Cause: The message, MOO-MOO_IMP_OPTY_FAIL
, can not be accessed. Action: Report this problem to an administrator.",

Navigator > Setup and Maintenance > Manage File Import Activities
> Create a batch with type = Opportunity
> Fill wizard > Submit and get error


Business Case
Cannot import Opportunities


To view full details, 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 a vibrant support community of peers and Oracle experts.