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 ***
(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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms