Error "Unhandled exception in ACORDEXML.get_xml SQLCODE = -6502: ORA-06502: PL/SQL: numeric or value error" When Returning Packages Through Profile Search In Oracle Financials to IPM Integration (Doc ID 466985.1)

Last updated on MAY 28, 2015

Applies to:

Oracle Imaging and Process Management - Version 7.6.2.0.0 to 10.1.3.3.2 [Release Stellent to 10gR3]
Information in this document applies to any platform.

Symptoms

When executing a Profile search from the Oracle Financials to IPM integration,  a blank results set will be received. The problem will cause the error:

"Unhandled exception in ACORDEXML.get_xml SQLCODE = -6502: ORA-06502: PL/SQL: numeric or value error"

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