Mass Additions Post Errors With ORA-06502 PL/SQL Numeric or Value Error: Associative Array Shape Is Not Consistent With Session Parameters

(Doc ID 1435199.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Assets - Version 12.0.6 and later
Information in this document applies to any platform.
FAMAPT


Symptoms

Post Mass Addition Errors:
The SQL statement being executed at the time of the error was:  and was executed from the file .
FND_CONCURRENT.AF_COMMIT
APP-OFA-47715: Error: function faafcommit returned failure (called from FAXEMT)
APP-FND-01564: ORACLE error 6502 in faafcommit
Cause: faafcommit failed due to ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters
ORA-06512: at "APPS.FND_GLOBAL", line 266
ORA-06512: at "APPS.FND_GLOBAL", line 278
ORA-06512: at "APPS.FND_GLOBAL", line 287
ORA-06512: at "APPS..
The SQL statement being executed at the time of the error was:  and was executed from the file .
FND_CONCURRENT.AF_ROLLBACK
APP-OFA-47715: Error: function faafrollback returned failure (called from FAXEMT)
APP-FND-01564: ORACLE error 6502 in faxemt
Cause: faxemt failed due to ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters
ORA-06512: at "APPS.FND_GLOBAL", line 266
ORA-06512: at "APPS.FND_GLOBAL", line 278
ORA-06512: at "APPS.FND_GLOBAL", line 287
ORA-06512: at "APPS..
The SQL statement being executed at the time of the error was:  and was executed from the file .
APP-OFA-47328: Error: Unable to execute SQL statement
Cause:        You have a database problem. 
Action:        Contact your system administrator.
APP-OFA-47715: Error: function faxemt returned failure (called from FAMAPT)

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