My Oracle Support Banner

When Manufacturer Name Is More Than 150 Characters Post Mass Additions Errors With ORA-6502 (Doc ID 1498859.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle Assets - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When the size of the Manufacturer Name is over 150, Mass Additions Post errors with:
   
  Error Message
  =============
  ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
  Error: function fa_massadd_pkg.do_mass_addition returned failure

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.