My Oracle Support Banner

Data Cube Using Multiple Files Causes Duplicate Records (Doc ID 2017800.1)

Last updated on MAY 31, 2019

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2013 Spring to 2015 R1 Update 4 [Release 2013 to 2015]
Information in this document applies to any platform.

Symptoms

When setting a Mapping File for a Data Cube to use multiple quote level or line level files per Commerce process, the data files can not be loaded into a database. See an example Mapping File below.

  

When using multiple files as the example above, the output will have duplicate columns in the data files. This will cause force the data output file to have an extra, duplicate column while the column headers will not show the extra column.


Depending on the database being used, the errors will be different. The errors will likely be related to column information mismatch. Most likely a column that contains the wrong data type.

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


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