Checking for orphan records in Requisitions

  1. Check for orphan records by completing step 1a or 1b:
    1. Use the report programs only and the Requisitions application, run RQ Orphan Check - Report Only (RQ420).
    2. Use the update programs and the Requisitions application, run RQ Orphan Record Check (RQ430). In the Update Option field, select Report Only.

      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 RQ Orphan Record Check (RQ430) in Update mode.

    If you made repairs manually, then run RQ Orphan Record Check (RQ430) 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 ensure that no errors exist before going on to the next phase.