Complete a validation check using a custom program

Prerequisites: Create a validation check batch and Create a validation check.

1. Continuing in the Add Validation Check window, select Create VC using a Custom Program.

2. Click the Select a Program icon.

   1. Use the Query By Example fields above the columns to search for the package.

   2. Select the package.

   3. Click OK.

3. In the Select Source Tables tab, move the tables that contain data you want to display, or that your program operates on, to the SelectedTables box.

4. Discrepant Table and Column: In the upper portion of the window, designate one data item as the one against which discrepancies are created. If the validation check logic processes two or more data items, select one of them.

   Tip:

   You must specify Selected Columns before you can specify the primary table or column.

   1. In the Discrepant Table field, select the table that contains the discrepant data.

   2. In the Discrepant Column field, select the column that contains the discrepant data. (When you view a VC listing, the discrepant column appears with an asterisk next to the column name so you can easily identify it.)

5. If you want to add one or more secondary columns to verify its data against the validation check, select the validation check with the custom program from the Validation Checks for Batch table (if available). (Check the Custom Program? column to identify validation checks with custom programs.) Then click the Add Validation Check icon. Select Create VC using a Custom Program and click the Select a Program icon. Select the program previously created in Oracle LSH with the secondary column you want to use (if available). Click OK to return to the Add Validation Check dialog box. You see the name of the program you selected and the name of the secondary columns (one or more) in the Secondary Column(s) field. (You only see the Secondary Column(s) field if the program has them.) Select the table from the Available Table list in the Select Sources Table tab. You see the program name, version, latest status, path, and one or more secondary column names (if available).

   Note:

   When you create a custom program for a validation check in Oracle LSH, you can add secondary columns by adding $DMWVCSECONDARYVAR$ to the end of any text you add in the Description field of the target table column. This identifies it as a secondary column. (You can also just have $DMWVCSECONDARYVAR$ in the Description field.) Do this for every column you want to use as a secondary column. However, you cannot use the discrepant column as a secondary column. For more details on secondary columns, see Secondary columns. For more details on creating a custom program in Oracle LSH, see the Oracle Life Sciences Data Hub Application Developer's Guide.

6. Click OK.

Next: Install a validation check batch.

Oracle Life Sciences Data Hub