Purging Inventory Audit table YFS_INVENTORY_AUDIT

Answer

Q) When INVENTORYAUDITPRG is run it clears records out of YFS_INVENTORY_AUDIT but deletes them and is not writing to a History table.Why?

A) INVENTORYAUDITPRG will directly delete all the data from YFS_INVENTORY_AUDIT table. Currently in ver 8.0 there is no YFS_INVENTORY_AUDIT_HISTORY table and INVENTORYAUDHISTPRG.

Q) How to achieve a scenario where INVENTORYAUDITPRG needs to be written to a new table where it can be called on if required. A further purge of this table e.g INVENTORYAUDHISTPRG would be required to clean this new table say after 2 years

A)To achieve the above requirement, create a custom transaction and a custom table.

After the creation of the custom table (INVENTORY_AUDIT_HISTORY) move the data from the YFS_INVENTORY_AUDIT table to custom table (INVENTORY_AUDIT_HISTORY) and then the custom transaction can remove the data from the custom table according to required time frame (2 years).

To create a custom transaction, non task based please refer Customization guide 8.8 Creating Custom Time-Triggered Transactions
To create a custom table refer section 7.2.6 Creating Custom and Hang-off Tables.

Q) Are there any performance related issues with INVENTORYAUDITPURGE

A) We have seen slow performance issue when the INVENTORYAUDITPURGE is running in the multithread mode. If the number of threads is set to 1, then there are no performance related issues with INVENTORYAUDITPURGE.