Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
B
Appendix: Offline File Validator
In order to help with the preparation of the data files, apart from the above detailed templates, an additional java-based utility is available to validate the correctness of your generated files before they are loaded into the Data Conversion Application. The jar can be downloaded onto a local machine and does not require any database to run it.
This application, along with the templates, serve as useful tools to help you in generating the right files even before the Data Conversion Application and Merchandising environments have been provisioned.
Prerequisites
-
The system where this validator is loaded should have JDK (Java Development Kit) installed supporting Java 8.
-
The DataConversionFileValidator.jar should be copied in the local folder of the system.
-
The data should be in .dat file format (values separated by commas) in the format dictated by the templates.
-
The folder that contains the input .dat files should have read and write permission.
Note
This tool will identify errors with respect to data type mismatch, size mismatch and check constraint failures that are within a single file. It will not cover: primary, foreign, or unique key checks, or any other business validation. It will also not validate the file name pattern.
Download the Off-line File Validator
This tool is available on My Oracle Support under document ID 2538102.1. In order to download the tool, you will need a password. This password can be obtained by logging an SR and requesting the information for the relevant version of Merchandising.
Use the Off-line File Validator
To use the Off-line File Validator tool, double click the DataConversionFileValidator.jar to run the application.
June 3, 2026 Appendix B-1 of B-4
hethe off va jar GataConversionFileValidator.jac EFS Cr\Gaera\date_comversion_ dat files\deps.dat Wi = jar DaraConversionPs levalidgcar, iar [TEM MASTER C:\Csers\daty conversion dat files item master dat }ave = Jat PataConversionFiievalidator, jar 1TaM_TiCRET C:Waers’data_converaion dat_files\iten ticket. dat va jar BatatonversicsPilevalidator,jar PACKITEN BREAKOUT C:\sers\data conversion dat files \packites breghoyt day m/e