"MDXT_3547A$ , MDXT_35481$" Tables Are Missing On The Target Database After Migration

(Doc ID 2292241.1)

Last updated on AUGUST 09, 2017

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

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