System error creating projects from template in MUX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Users receive a System Error in MUX when creating a project from template if the Project Template modal contains the Billing Currency field, this is secured and the user logged in does not have Edit Access to the field

STEPS TO REPRODUCE:

1. MUX > Administration > Attributes > filter by the Billing Currency Code field (pac_mnt_projects table)
2. Enable security and provide View Access to all users
3. MUX > Administration > Blueprints > Edit a project object related blueprint
4. On the Create from Template tab add the Billing Currency Code field
5. Assign a project template to the blueprint above
6. Project Grid > Click on New from Template > select the template we linked to the custom blueprint
7. Notice the Billing Currency Code field is on the modal and is read-only
8. Populate the required data and click on Create

Expected Results: The project is created successfully
Actual Results: You receive a System Error, but the project is created successfully.

Environment

Clarity 16.4.0

Cause

The Billing Currency field attribute is secured and the user who is creating the project does not have Edit Access to the same

This is caused by DE181700

Resolution

This is fixed in Clarity 16.4.2

Check the Attribute Field level security.

• Go to MUX Administration > Attributes > Locate the Billing Currency attribute
• If the field needs to be secured, ensure the users who create projects from template have Edit Access over the same
• Alternatively, do not mark the field as secured

Or remove the field from the Create from Template modal

 

Additional Information

The app-ca.log file shows the following errors.

In Oracle:

ERROR 2026-01-15 23:05:33,417 [http-nio-1640-exec-147] niku.xql2 (clarity:myuser:mysession:PPM_REST_API) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 1407
Error message: ORA-01407: cannot update ("MYCLARITY"."PAC_MNT_PROJECTS"."BILLING_CURRENCY_CODE") to NULL

In PG:

ERROR 2026-01-15 23:10:52,100 [http-nio-8080-exec-617] niku.xql2 (clarity:myuser:mysession:PPM_REST_API) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: null value in column "billing_currency_code" of relation "pac_mnt_projects" violates not-null constraint