Error ORA-01400 while Applying Latest AD&TXK Patches
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
Error while inserting row in AD_TIMESTAMPS
ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TIMESTAMPS"."ATTRIBUTE")
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
[UNEXPECTED]Unable to find appltop_id for host asiaesplatform in database
[UNEXPECTED]Invalid APPL_TOP ID: "".
[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
Million Knowledge Articles and hundreds of Community platforms