My Oracle Support Banner

OM Command Center Data Load Program completed with Error ORA-22828 (Doc ID 2939410.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.


OM Command Center Data Load Program completed in Error.
After completion of OM configuration user tried to run program "OM Command Center Data Load Program" with Full load but completed with error.


ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset ont-lines for job 31,751
java.sql.SQLException: ORA-22828: input pattern or replacement parameters exceed 32K size limit
ORA-06512: at "APPS.OE_ECC_UTIL_PVT", line 1788
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Perform necessary OM configuration for ECC
2. Submit OM Command Center Data Load Program
3: Parameter- Full Load


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

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