Question & Answer
Question
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.
Historical Number
FAQ3041
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21518913