INVTMLPR Transaction Purge Failed -- Value Too Large ORA-12899

(Doc ID 1940072.1)

Last updated on NOVEMBER 27, 2017

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

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