Purge Financial Runs

Purge Financial Runs is initiated from the Supplementary Purge using Request Type "PFR".

This function will remove

  • Failed / Completed / Canceled / Completed with Errors / Aborted Request Queue entries, related to Financials, older than the Cut-Off Date
  • Financial runs older than the Cut-Off Date where all related data has already been purged

Identify and delete all the entities that need to be purged, as follows:

  • Identify all entries in FNCL_QUE_T with a status of Failed / Completed / Canceled / Completed with Errors / Aborted, that meet the following conditions:
    • Created date is less than or equal to the user specified Cutoff Date
    • Request type is one of the following: VC, FB, AP, AC, AR, VR, CR, IV, PC
  • Identify all entries in ACRL_RUN_T whose created dates are less than or equal to the user specified Cutoff Date and have no corresponding entries in GL_TRNS_T.
  • Identify all entries in INVC_RUN_T whose created dates are less than or equal to the user specified Cutoff Date and have no corresponding entries in INVC_T.
  • Identify all entries in FBAUTOPYMT_RUN_T whose created dates are less than or equal to the user specified Cutoff Date and have no corresponding entries in FRHT_BILL_T.
  • Identify all entries in TRNS_RUN_T whose created dates are less than or equal to the user specified Cutoff Date and have no corresponding entries in AP_TRNS_T, AR_TRNS_T and GL_TRNS_T.
  • Identify all entries in VCHR_RUN_T whose created dates are less than or equal to the user specified Cutoff Date and have no corresponding entries in VCHR_AP_T and VCHR_AR_T tables. Also, cascade delete any related rows from the Voucher Run Exceptions table (VCHR_RUN_EXCP_T).

See Also