My Oracle Support Banner

Element Calculation Formula Is Thowing Error After Upgrade To Release 13 (update 17D): ORA-20001: The data type of TEXT of parameter .... does not match the NUMBER used in the formula. (Doc ID 2379091.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Global Payroll

Element calculation formula is throwing error after upgrade to Release 13 (update 17D) .
Same formula is worked before upgrade.

The following error occurs:

ERROR
-----------------------
" ORA-20001: The data type of TEXT of parameter Advance_Amount does not match the NUMBER used in the formula. ORA-06512 at "FUSION_HR_UTILITY", line 798 ORA-06512: at "FUSION.FF_EXEC_WRAPPER_PKG", line 81 ORA-06512 at line 2 "

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Element calculation formula checked after after upgrade to Release 13 (update 17D);
2. Error is thrown.

Details:
1. What validation is being done:
calculating advance amount based on other element (House Rent Allowance)
2. What is the formula type:
Presuming based on description Calculation > Element Input Validation
3. Are the formula inputs ADVANCE_AMOUNT, NUMBER_OF_MONTHS required:
Yes it is required

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use element calculation formula after upgrade to Release 13 (update 17D).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.