ProductGrp SubGrp Hierarchy Relationship Import Is Not Working And Throwing An Errors (Doc ID 2220247.1)

Last updated on FEBRUARY 16, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Sales, Sales Catalog

Product Group Sub Group Hierarchy relationship import is not working and throwing an errors.

ERROR
-----------------------
Customer is trying to import Product Group and Sub-group relationships, they are following Doc ID 1500148.1 but are still getting errors

ERROR 1: The same combination of values for the columns (PG_REF_NUMBER, LANGUAGE, SOURCE_LANG_FLAG) already exists in this table. (QSC-375090)A matching record of type Parent Product Group cannot be found using the value of the attribute ProductGroupRelationBulkImport_PgRefNumber that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.A matching record of type Parent Product Group cannot be found using the value of the attribute PG_INTERNAL_NAME that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.You must provide a value for the attribute PROD_GROUP_NAME.The value of the attribute PROD_GROUP_ID is not valid.The value of the attribute PROD_GROUP_ID is not valid.The value of the attribute PROD_GROUP_DETAIL_ID is not valid.The value of the attribute PG_INTERNAL_NAME is not valid.The value of the attribute PG_INTERNAL_NAME is not valid.

ERROR 2: The same combination of values for the columns (PG_REF_NUMBER, LANGUAGE, SOURCE_LANG_FLAG) already exists in this table. (QSC-375090)The same combination of values for the columns (PROD_GROUP_ID, LANGUAGE, SOURCE_LANG_FLAG) already exists in this table. (QSC-375090)

ERROR 3: The same combination of values for the columns (PG_REF_NUMBER, LANGUAGE, SOURCE_LANG_FLAG) already exists in this table. (QSC-375090)A matching record of type Subgroup cannot be found using the value of the attribute ProductGroupRelationBulkImport_PgRelChildRefNumber that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.A matching record of type Subgroup cannot be found using the value of the attribute PG_REL_CHILD_INTERNAL_NAME that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.The value of the attribute REL_CHILD_PROD_GROUP_ID is not valid.A matching record of type Parent Product Group cannot be found using the value of the attribute ProductGroupRelationBulkImport_PgRefNumber that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.A matching record of type Parent Product Group cannot be found using the value of the attribute PG_INTERNAL_NAME that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.You must provide a value for the attribute PROD_GROUP_NAME.The value of the attribute PROD_GROUP_ID is not valid.The value of the attribute PROD_GROUP_ID is not valid.The value of the attribute PROD_GROUP_DETAIL_ID is not valid.The value of the attribute PG_INTERNAL_NAME is not valid.The value of the attribute PG_INTERNAL_NAME is not valid.

ERROR 4: The value of the attribute PG_INTERNAL_NAME is not valid.The value of the attribute PG_INTERNAL_NAME is not valid.The value of the attribute PROD_GROUP_DETAIL_ID is not valid.The value of the attribute PROD_GROUP_ID is not valid.The value of the attribute PROD_GROUP_ID is not valid.You must provide a value for the attribute PROD_GROUP_NAME.A matching record of type Parent Product Group cannot be found using the value of the attribute PG_INTERNAL_NAME that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.A matching record of type Parent Product Group cannot be found using the value of the attribute ProductGroupRelationBulkImport_PgRefNumber that you provided. (MKT-285218) Cause: No record exists with the specified user key value. Action: Verify that the record with the specified user key exists. If it does not exist, then remove the record from the data file, or update the record with a valid user key.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import Product Group and Subgroup relationship
2. Import completes with errors
3. Various Errors in the log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import relationships

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