Locations Spatial Index Rebuild Concurrent Program Error - ORA-06502: PL/SQL: Numeric Or Value Error

(Doc ID 1599462.1)

Last updated on OCTOBER 16, 2017

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

In R12.1.3:

Attempting to run the Locations Spatial Index Rebuild concurrent program and receive the following error:

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HZ_ELOCATION_PKG", line 1179
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

When the Profile Option HZ: Detailed Concurrent Program Output = Y, the program run successfully.

When query for the profile option HZ: Detailed Concurrent Program Output, it is noticed that there is no list of values.

Steps to Reproduce:
Responsibility:  Trading Community Manager
Navigation:  Trading Community > Concurrent Requests > Run
Choose the "Locations Spatial Index Rebuild" concurrent program from the list of values
Enter the following parameter:
  Language Setting = American English
  Start Date = As soon as possible
  Recurrence = Never repeat
  Select Recipient = blank
  Select Printer = no print
Click Submit

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