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

Last updated on MARCH 08, 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
***Checked for relevance on 24-Jul-2014 ***


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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms