Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Purging successfully loaded inventory transactions from tables.

edited Oct 8, 2024 7:45AM in Inventory Management 1 comment

Summary:

While loading Inventory Transactions( InvTransactionsInterface & CstTransCostInterface) via FBDI and using Load Interface File for Import and Manage Inventory Transactions processes. Some transactions got loaded in the first run. Others failed due to an invalid subinventory configs which was later fixed. We ran the purge program - Purge Inventory Transactions Interface Process. This did not delete the successfully loaded transactions from the table but only the failed transactions. When we re loaded and re-processed the same files. The transactions that were initially loaded got doubled and the new ones got loaded as well. Is there a way to remove the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!