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: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
IEXLSGEN- Search Customer

Symptoms

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.

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