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.
e Loads the data from your files into the staging tables in the conversion schema a ¢ Basic validation of data types and lengths e Validates the data in the staging tables based on the data in a single table + ~alidation e Validation of check constraints and mandatory fields ¢ Validates the data based on business logic, crossing entities where needed Cedenon ¢ Validation of primary and foreign keys
Data Conversion
Q Search for a task —
Data Conversion Folder
vx = Import from File
vy Data Validation yy Business Validation
alll vy Mass Upload vx View| Upload Data vy System Administration go} vy Entity Sequence List vy Uploaded Files
138 3408,Test KI Dept,1000,702,1,0,220,10,11.1111,,R,C,1,1,Y, 139 3409,Building Materials,1000,700,1,0,304,20,25,,C,C,1,1,Y, 140 3410, Paint*,1000,701,1,0,304,35,53.8462,,C,C,1,1,Y, 141 3411,Lighting,1000,700,1,0,304,35,53.8462,,C,C,1,1,Y, 142 3412,Kitchen Hm Imprvmnt,1000,701,1,0,304,15,17.6471,,C,C,1,1,Y, 143 3413,Bathroom,1000,702,1,0,304,15,17.6471,,C,C,1,1,Y, 144 3414,Tools, 635,700,1,0,305,55,122.2222,,C,C,1,1,Y, 145 3415, Plumbing, 635,702,1,0,305,45,81.8182,,C,C,1,1,Y, 146 3416,Heating/Cooling,1000,700,1,0,305,65,185.7143,,C,C,1,1,B, 147 3417,Hardware Services,1000,701,1,0,305,10,11.1111,,C,C,1,1,Y, 148 3418,Dogs,1000,702,1,0,306,25,33.3333,,0,0,1,1,K, 149 3419,Cats,1000,840,1,0,306,25,306,25, 33.3333,,C,C,1,1,Y, 150 3420,Birds,1000,840,1,0,306,25,33.3333,,C,C,1,1,Y, 151 3421,Books Reference*,1000,701,1,0,308,45,81.8182,,C,C,1,1,Y, 152 3422,Video/DVD,1000,700,1,0,308,20,25,,C,C,1,1,Y, 153 3423,Plush, 1000, 702,1,0,fwqeqwe} 702,1,0,fwqeqwe} 55,122.2222,,C,C,1,1,Y, 154 3424,Dolls,1000,855,1,0,309,55,122.2222,,C,C,1,1,Y, 155 3425,Frames,1000,860,1,0,310,70,233.3333,,C,C,1,1,Y, 156 3426,Lenses,1000,860,1,0,310,60,150,,C,C,1,1,Y, 157 3427,Personal Care*,1000,701,1,0,311,30,42.8571,,C,C,10,10,Y, 158 3428,Health Products,1000,702,1,0,311,35,53.8462,,C,C,1,1,Y, 159 3410, Paint*,1000,701,1,0,304,35,53.8462,,C,C,1,1,Y, 160
-
Size mismatches in any of the columns
-
Duplicate records within the same file based on the primary key of the table
If there a large number of errors, you can export the errors to a spreadsheet by selecting the Export to Excel button on the toolbar.
All files that were successfully process will be moved to a process folder and can proceed to the next step. You can also choose to proceed to the next step for the successfully loaded data before correcting the import errors. If you choose to proceed, then the records that had failed can be loaded separately in a new file after making corrections.
Correct Import Errors
To help with correcting errors, you can use the Download Failed Data option in the screen. This will download the file (maximum size 2MB) to your local machine with only the erroneous records. You can then manually correct them and reload them to trigger a fresh file upload against that data.
After analyzing the errors displayed, you can make corrections in the original file and re-load all data or you may need to correct the legacy data or transformation code and regenerate your files. Regardless of the method, you will need to transfer the corrected file through Merchandising File Transfer Service and repeat the load process. A new process ID is generated against this second load.
To load a different file for the same or a different entity, click the refresh icon ( ) at the bottom right of the screen, to reset the search section.
To close the screen, click the Done button at the bottom of the screen.
Data Validation
The next step in the process will take the data that was successfully loaded data from the imported files and validate it for data correctness. The validations covered in this step are:
-
Mandatory fields/not null checks
-
Check constraints on columns
-
Complex check constraints on the table rows
-
To access this function, click on the Data Validation link from the task list, to open the screen. Then, from the Process drop down, select the process against which the file was loaded. The drop-down allows you to search based on the process description that was provided during file import.
4 Validation Errors
|Actions »
Vieww
[S|
GP|if Detach|Download|Failed Data||
|---|---|---|---|---|
|TableName|Row|Sequence|Column Name|Error Message|
|DEPS|105||DEPT_NAME|Failed constraint check: DEPT_NAME IS NOT NULL|
|DEPS|104||DEPT_NAME|Failed constraint check: DEPT_NAME IS NOT NULL|
|DEPS|104||DEPT|Failed constraint check: DEPT IS NOT NULL|
|DEPS|148||OTB_CALC_TYPE|Failed constraint check: OTB_CALC_TYPE IN (‘C’, ‘R’)|
|DEPS
4|148||MARKUP_CALC_TYPE|Failed constraint check: MARKUP_CALC_TYPE IN(‘R’, ‘C’)
la|