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 22, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.