Purge Load Denormalized Tables

Purge Load Denormalized Tables is initiated from the Supplementary Purge using Request Type "PLD".

This function will remove entries in MBOL_DENORM and LOAD_TENDER_DENORM tables.

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

  • Identify all entries in MBOL_DENORM table with a Planned Ship Date less than or equal to the user specified Cut-Off Date
  • Identify all entries in LOAD_TENDER_DENORM table with a Tendered on Date less than or equal to the user specified Cut-Off Date

See Also