My Oracle Support Banner

11i: IEXLSGEN Search Customer Is Failing With ORA-06512: at "APPS.AS_UTILITY_PVT" When Trying To Update Saved Results (Doc ID 1303029.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Advanced Collections - Version: and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
IEXLSGEN- Search Customer


In IEXLSGEN- Search Customer if a saved search is updated with steps:
Responsibility Collections Agent

1. open Search form (IEXLSGEN)
2. execute a search
3. save the results of the search
4. switch to the 'Saved Results' tab
5. click on the saved results you just created
6. select 'Inactive' on the bottom of the form to make the saved results inactive
7. press 'Update'

It fails with

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.AS_UTILITY_PVT", line 388

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06502.

If you try the same in Telesales in Universal Search, it is working fine.


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.