Impdp Fails With ORA-39126 ORA-31604 Iinvalid Transform NAME Parameter "MODIFY" For Object Type PROCACT_INSTANCE in function ADD_TRANSFORM (Doc ID 1596495.1)

SYMPTOMS
DataPump shows following errors :

Starting "<LOGIN_SCHEMA>"."SYS_IMPORT_FULL_14":  <LOGIN>/******** parfile=<PARFILE_NAME>.par logfile=<LOG_NAME>.log dumpfile=<DUMPFILE_NAME>.dmp parallel=1
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS []
ORA-31604: invalid transform NAME parameter "MODIFY" for object type PROCACT_INSTANCE in function ADD_TRANSFORM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8996
 

CHANGES
 

CAUSE
The cause of this problem has been identified in
Bug 16551094 - DATAPUMP IMPORT REMAP_TABLE FAILS WITH ORA-39126, ORA-31604

The bug is fixed in 12c.


SOLUTION
Download and apply the patch 16551094 if available for your version and platform.

Or

You can workaround the issue by specifying exclude=PROCACT_INSTANCE.
To implement the fix, please execute the following step:


Use an additional parameter that is exclude=PROCACT_INSTANCE during impdp

- OR -

Redo the export with exclude=PROCACT_INSTANCE and perform import using new dumpfiles.

The use of the exclude=PROCACT_SYSTEM will exclude the resource manager objects such as resource plans and groups.
That means that if you had resource plans and groups, you will need to recreate them after the import.