Error ORA-01400 while Applying Latest AD&TXK Patches

(Doc ID 2343015.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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


When attempting to apply the latest AD&TXK patches, the following error occurs.

adop phase=apply patches=25820806,26720905 merge=yes hotpatch=yes 

AutoPatch error:
Error while inserting row in AD_TIMESTAMPS

AutoPatch error:
ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TIMESTAMPS"."ATTRIBUTE")

AutoPatch error:
aijhip(): Error calling aijmgrInsertHangingRowInAdTmStmp()

 After the adop command failed , it was attempted to apply the  two patches separately ,but it failed with another error message as below.

adop phase=apply patches=25820806  hotpatch=yes abandon=yes

Checking for existing adop sessions.
[UNEXPECTED]Unable to find appltop_id for host asiaesplatform in database
[UNEXPECTED]Unrecoverable error occurred. Exiting current adop session.





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