Error: 'The combination of attributes (INVENTORY_ITEM_ID INVENTORY_ORG_ID PROD_GROUP_ID UOM_CODE) is not valid. (MOO-450119)'

(Doc ID 1555070.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Sales - Version 11.1.4.0.0 and later
Oracle Fusion Sales Catalog Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On 11.1.7.0 : Opportunity Revenue, File Import

When attempting to import Opportunities the following error occurs.

ERROR
-----------------------
File Record Number Import Job Id System TaskId Error Message
1 300000001768597 300000001768682 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
1 300000001768597 300000001768682 The opportunity is not valid. The referenced opportunity must exist either in MOO_OPTY or in MOO_IMP_OPTY in the same import batch. (MOO-450106) - COLUMN_NAME: OPTY_ID
1 300000001768597 300000001768682 The combination of attributes (INVENTORY_ITEM_ID INVENTORY_ORG_ID PROD_GROUP_ID UOM_CODE) is not valid. (MOO-450119) - ATTRIBUTE_LIST: (INVENTORY_ITEM_ID INVENTORY_ORG_ID PROD_GROUP_ID UOM_CODE)
1 300000001768597 300000001768682 The opportunity is not valid. The referenced opportunity must exist either in MOO_OPTY or in MOO_IMP_OPTY in the same import batch. (MOO-450106)
1 300000001768597 300000001768682 FND-MKT_IMP_LOAD_ERROR (FND--1) Details: FND-MKT_IMP_LOAD_ERROR Cause: The message FND-MKT_IMP_LOAD_ERROR can not be accessed. Action: Report this problem to an administrator. - ERRORMSG: The input value is longer than the mapped field permits. Input length: 4; Field Precision: 3. at ColumnNumber :72 - ATTRIBUTENAME: UomCode


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Importing Opportunity with Revenue Items


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import Opportunities with Revenue Items

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