My Oracle Support Banner

BCC Excel Import Ignores Cell References and not Importing Respective Data (Doc ID 2672827.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle Commerce Merchandising - Version 11.3.2 and later
Information in this document applies to any platform.

Symptoms

When importing excel data in CA using the BCC, if a line of import data contains a reference to another cell - irrespective of whether the referenced cell is on a different worksheet or on the same worksheet - the excel import ignores the data.
 
In the attached spreadsheet, an attempt is made to import the data in an excel spreadsheet that contains a new product, with a existing childSKU attached.

The childSKU field is a reference to a different cell. The product is imported, but the childskus field is imported empty in ATG 11.3.2.  In addition, no error is given.
 
The screenshots of the results in ATG 11.3.2 and the excel spreadsheet are attached.

Changes

 

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
Changes
Cause
Solution
References


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