My Oracle Support Banner

INVTMLPR Transaction Purge Failed -- Value Too Large ORA-12899 (Doc ID 1940072.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

INVTMLPR Transaction Purge Failed

I'm trying to run material transaction purge for data in 2011. All periods are closed for the target inventory organization. When running transaction purge, program INVTMLPR, the program returns

Purge Transaction failed. Please see the log file for more details and contact your System Administrator.

ERROR
-----------------------
Purge Transaction failed. Please see the log file for more details and contact your System Administrator.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run transaction purge INVTMLPR, see failure.

Cause

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
Symptoms
Cause
Solution


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