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 JUNE 22, 2022
Applies to:
Oracle Fusion Sales Cloud Service - Version 11.1.4.0.0 and laterOracle 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |