Checking for orphan records in Order Entry

  1. Check for orphan records by completing step 1a or 1b:
    1. Use the report programs only and the Order Entry application, run OE Orphan Check - Report Only (OE420).
    2. Use the update programs and the Order Entry application, run OE Orphan Check - Report and Update (OE430). In the Update Option 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 OE Orphan Check - Report and Update (OE430) in Update mode.

    If you made repairs manually, then run OE Orphan Record Check (OE430) 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.