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

Posted by Vasudev Seeram on August 22, 2011 Leave a comment (0) Go to comments

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.