My Oracle Support Banner

Defect: Error 'ORA-01400: cannot insert NULL into ("UNIFIER"."CONAME_WEBAUDIT_LOG"."SHORTNAME")' When Attempting to Disable a User in Cloud Administration (Doc ID 2432938.1)

Last updated on MARCH 06, 2019

Applies to:

Primavera Unifier Cloud Service - Version 18.7 to 18.7 [Release 18.7]
Information in this document applies to any platform.


When trying to deactivate a user in Cloud Administration, a license is taken out but after clicking the Disable button the license comes back.  The following error also occurs in the log:

ORA-01400: cannot insert NULL into ("UNIFIER"."CONAME_WEBAUDIT_LOG"."SHORTNAME")


This issue can be reproduced at will using the following steps:

  1. Login to Cloud Administration.
  2. Select the desired user.
  3. Click Manager Application Access.
  4. Take out the license and click OK, then Save.
  5. Click the Disable button.
  6. Note that the license is made available again in Application Access.


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.