Data Cube Using Multiple Files Causes Duplicate Records
Last updated on OCTOBER 16, 2017
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms