My Oracle Support Banner

What Is The Procedure For Purging Completed OPM Transactions? (Doc ID 359213.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Process Manufacturing Inventory - Version 11.5.8 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
ICPUPND.fmb - Purge Pending
ICPUCMP.fmb - Purge Completed



Goal

(Checked for continuing relevance :- 19-Feb-2013)

Performance issues arise with some forms which have to calculate 'Available to Allocate' quantities, and it is suspect that the sheer quantity of historical transaction data, especially in the IC_TRAN_PND table, is a contributing factor.

What are the steps for purging Completed transactions from the OPM Transactions tables?


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.