Checking for orphan records in Warehouse

  1. Check for orphan records by completing step 1a or 1b:
    1. Use the report programs only and the Warehouse application, run WH Orphan Check - Report Only (WH420).
    2. Use the update programs and the Warehouse application, run WH Orphan Check - Report and Update (WH430). In the Update field, select No Update (Just Report).

      Details on the CSV files created are found elsewhere in this user guide. See CSV files that update programs create.

  2. Review the results to determine the correct method of making repairs. You can make repairs manually or if you have the update programs, then rerun WH Orphan Check - Report and Update (WH430) in Update mode.

    If you made repairs manually, then run WH Orphan Check - Report and Update (WH430) in Report mode again to ensure that the errors are corrected. Then, run the program in Update mode.

  3. After repairs are made, repeat step 1 to ensure that no errors exist before going on to the next phase.