To check for orphan records in Order Entry

  1. Check for orphan records. Complete either step 1a or b.
    1. Use the report programs only and the Order Entry application, run OE Orphan Check - Report Only (OE420).

      - or -

    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. CSV files created by update programs

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

    If you made repairs manually, run OE Orphan Record Check (OE430) in Report mode again to be sure that the errors are corrected. Then, run the program in Update mode.

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