My Oracle Support Banner

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 FEBRUARY 05, 2019

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

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
Changes
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.