Purge Financial Runs is initiated from the Supplementary Purge using Request Type "PFR".
This function will remove
Completed / cancelled 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 Completed or Cancelled, 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).