After R12 Platform Migration Using Transportable Table Spaces, Adadmin Recreate Grants And Synonyms Fails With 'adptaskGetTaskStatusID: Error while selecting from table AD_TASK_STATUS' And 'ORA-00942: table or view does not exist' (Doc ID 2223505.1)

Last updated on JANUARY 24, 2017

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications DBA, Issues with the Functionality of AD Utilities

 

 

Recreate grants and synonyms via adadmin is failing after a platform migration.

After a migration between different hardware platforms adadmin fails on grants with the following:

 

AD Administration error:
adptaskGetTaskStatusID: Error while selecting from table AD_TASK_STATUS

 

AD Administration error:
ORA-00942: table or view does not exist

The tablespace migration was performed using steps from the following documents:
<Note 1945814.1> - Using Transportable Tablespaces to Migrate Oracle EBS Release 12.0 or 12.1 Using Oracle Database 12.1.0 (Doc ID 1945814.1)
<Note 438086.1> - Application Tier Platform Migration with Oracle E-Business Suite Release 12 (Doc ID 438086.1)

Changes

 A migration between hardware platforms was performed.

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