ORA-01400: cannot insert NULL into (“HR”.”PAY_ELE_TMPLT_CLASS_USAGES”.”CLASSIFICATION_ID”)

Problem: When running International HRMS Setup from the UK HRMS Super User responsibility, the following error occurs:

Inserting Balance Attribute Definition : ONLINE_SOE_BALANCE_ATTRIBUTE
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-01400: cannot insert NULL into ("HR"."PAY_ELE_TMPLT_CLASS_USAGES"."CLASSIFICATION_ID")

Solution: Ensure that the Human Resources product (PER) is licensed.

Here is the entire log file for the International HRMS Setup:

+---------------------------------------------------------------------------+
Payroll: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
PYINTSTU module: International HRMS Setup
+---------------------------------------------------------------------------+
Current system time is 16-AUG-2011 10:27:43

+---------------------------------------------------------------------------+

**Starts**16-AUG-2011 10:27:43
Inserting Balance Attribute Definition : ONLINE_SOE_BALANCE_ATTRIBUTE
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-01400: cannot insert NULL into ("HR"."PAY_ELE_TMPLT_CLASS_USAGES"."CLASSIFICATION_ID")

+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
1604

Output is not being printed because:
The print option has been disabled for this report.

Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-AUG-2011 10:28:25

+---------------------------------------------------------------------------+

Solution: Check System Administrator > Oracle Application Manager > License Manager

Status            Count
Licensed          1
Not Licensed      195
Shared            0

Note that this is on the VISION instance, which comes bundled with R12. It appears that the products were not licensed.

To license the products, navigate to License Manager > License Products. Choose License E-Business Suite, check the products to license, and then click Next. The products are licensed.

To confirm that the products were licensed, check License Manager once more.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.