LicenseAssignmentFailureReason Table

LicenseAssignmentFailureReason holds all the reasons why a license assignment for an installation of an application could not be made.

Table 1. Database columns for LicenseAssignmentFailureReason table

Database Column


LicenseAssignment FailureReasonID

Type: integer. Key. Generated ID

A unique identifier for each LicenseAssignmentFailureReason. Possible values and the corresponding default strings are:

  • 1 = There are not enough entitlements available on this license to cover this device
  • 2 = The installation was outside the restricted enterprise group
  • 3 = Custom tags on the device do not match the custom tags set on the license
  • 4 = This license type requires allocation, but no license entitlement was allocated to the device or user
  • 5 = The number of sockets, required to calculate consumption, is missing for this device
  • 6 = The number of sockets for this device is more than the maximum allowed for this license
  • 7 = The number of processors, required for calculating consumption from this license type, is missing for this device
  • 8 = The number of processors for this device is fewer than the minimum allowed for this license
  • 9 = The number of processors for this device is more than the maximum allowed for this license
  • 10 = The number of cores, required for calculating consumption for this license type,is missing for this device
  • 11 = The number of cores (or processors) for this device is more than the maximum allowed for this license
  • 12 = No licensable Oracle database instance is known for this device
  • 13 = No consumption calculated, possibly because processor, core, or thread counts are missing from device inventory
  • 14 = Application is supplementary on this license, and consumption needs either the missing primary product installation, or an allocation
  • 15 = The license was not assessed, because the device has consumed from a higher priority license
  • 16 = Access logs are missing the usage date/period needed for a CAL

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a license assignment failure reason. Foreign key to the ComplianceResourceString table.


Type: text (max 256 characters)

The text to display if the license assignment failure reason resource string has no translation.