CA PPM 14.2/14.3 upgrade fails with error ORA-01438: value larger than specified precision allowed for this column while inserting value in PFM_INV_CONTRAINTS
Steps to Reproduce:
Applies to all supported PAS environments for specified releases.
Caused by CLRT-79116
This issue is caused by the size of the column. In source table(FIN_FINANCIALS) size of the columns is (32, 6) and in destination table(PFM_INV_CONSTRAINT_SUMS) size of the column(PH_CURVE_SUM) is (16,6).
The Sustaining Engineering team is reviewing this issue.
Note: The following workaround is provided by our Sustaining Engineering team for On Premise Customers. If you implement the changes to the code file may be overwritten with subsequent patches or upgrades. Be sure to review this developer, pre-approved customization to the code. Once the issue is resolved in new version, be sure to check and verify the new files are installed and overwrites the existing code files.
If you are a SaaS Customer, our upgrade team will take care of this issue.
Interim code modification to upgrade successfully
For On Premise implementations, you can follow the steps to update the application code file prior to CA PPM 14.2 or 14.3 and then start the upgrade
In case of upgrade, i.e. coming from 13.x to 14.2 then need to repackage the 14.2 or 14.3 installer
Note: Before re-running the upgrade process, please roll-back to a working CA PPM version
Release: ESPCLA99000-14.3-Clarity-Extended Support Plus