My Oracle Support Banner

EBS 12.2 ADOP Prepare Phase Fails with Error: [UNEXPECTED]Data dictionary corruption - timestamp mismatch (Doc ID 2981244.1)

Last updated on JANUARY 30, 2024

Applies to:

Oracle Applications DBA - Version 12.2.3 to 12.2.12 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.


When trying to run ADOP prepare phase, the following error occurs.


Below error can be found in the adopshowlog.out.

Verifying data dictionary.
[UNEXPECTED]Data dictionary corrupted:
[UNEXPECTED]Data dictionary corruption - timestamp mismatch
APPS <DEPENDENT CUSTOM OBJECT> V_20230219_1819 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 14-NOV-22 08:59:51 28-JUL-23 20:13:00
APPS <DEPENDENT CUSTOM OBJECT> V_20230328_2121 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 08-MAY-23 17:37:58 28-JUL-23 20:13:00
[UNEXPECTED] Follow the instructions in the "Fix data dictionary corruption"
[UNEXPECTED] section of My Oracle Support Knowledge Document 1531121.1 .


  1. Connect to Application tier as applmgr user and source the environment file.
  2. Run ADOP Prepare phase
    $ adop phase=prepare


 No known changes.


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

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