Ora-13236, Ora-29400, Ora-7445 Kghufree When Inserting Into HR_LOCATIONS_ALL

(Doc ID 1317811.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jul-2013***

Symptoms

Executing a PL/SQL procedure fails with the following errors:

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-13236: internal error in R-tree processing: [reading node
(mdrbin_mem_ins_rt)]
ORA-29400: data cartridge error
Error - OCI_NODATA
ORA-06512: at "MDSYS.SDO_IDX", line 149
ORA-06512: at line 1

and the following error is reported in the alert log:

ORA-07445: exception encountered: core dump [kghufree()+819] [SIGSEGV] [ADDR:0x8] [PC:0x7E83CC3] [Address not mapped to object] []


From the Oracle Applications side, the following errors are encountered for the same procedure:

1.  US Super HRMS Manager > Work Structures > Location

2.  Enter Name and address details and save

3.  Record saves, but then an error appears at the bottom of the page:

   "FRM-99999: Error 408 occurred.  See the release notes file (relnotes) for information about this error.

4.  When navigating away from the page or attempting to enter another location, you are prompted to save again
  Clicking save then throws the following error:

   "APP-PER-52537: Invalid Ship_to_Site_flag: If the ID of the Ship_to_Location is the same as the ID of the current Location, this flag must be set to 'Y'.  Otherwise it must be set to 'N'."

5.  The Shipping Details tab is fine and mirrors all other locations currently set.
.

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