Clarity: Upgrade to 13.3 fails due to unique constraint on the ODF_SSL_GL_ALL_DTL_PCT table

Description:

When attempting to upgrade to Clarity 13.3, the upgrade fails with a unique constraint message due to records created for GL Allocation Detail Percentages

Steps to Reproduce:

1. Have a Clarity implementation with Standard and Credit Rule GL Allocation Detail rows configured
   
   
2. Upgrade to Clarity 13.3

Expected Result: Upgrade is successful.

Actual Result: Upgrade fails with a unique constraint error on the ODF_SSL_GL_ALL_DTL_PCT table

Solution:

This is caused by an issue documented as CLRT-71791.

There may be duplicated data already existing in the table in a version prior to Clarity 13.3.

Therefore, it is recommended that before performing the upgrade action, please apply the attached script file using the following steps.

PRE-UPGRADE STEPS:

1. Extract and copy the script XML file to your Clarity application server in the $CLARITY_HOME directory
   
   
2. Open a command prompt window, navigate to the directory where the file is saved and execute the following command
   
   dbpatch -install -file <filename> -apply
   
   
3. Proceed with the upgrade to Clarity 13.3

Keywords: CLARITYKB, CLRT-71791, clarity13upgrade.