My Oracle Support Banner

"MDXT_3547A$ , MDXT_35481$" Tables Are Missing On The Target Database After Migration (Doc ID 2292241.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP9 version, Install / Upgrade Issues

HR.HR_LOCATIONS_SPT is INVALID and HR.PER_ADDRESSES_SPT are not standard Oracle Spatial indexes but specific to EBS App.
To recreate these indexes some EBS specific script should be applied as follows

$IRC_TOP/patch/115/sql
@irctxloc HR APPLSYS APPS CTXSYS
@irctxadr HR APPLSYS APPS CTXSYS

*****************
Even the customer applied these EBS specific steps the indexes are still INPROGRS status.

ERROR
-----------------------


OWNER INDEX_NAME INDEX_TYPE STATUS
------------ ------------------------- --------------------------- --------
DOMIDX_STATU DOMIDX
------------ ------
HR HR_LOCATIONS_SPT DOMAIN INPROGRS
VALID VALID

HR PER_ADDRESSES_SPT DOMAIN INPROGRS
VALID VALID

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!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.