My Oracle Support Banner

EAP WTHD: Withholding Adjustment Page error, Number Field Format Error. The Field Format is (23.2). The Currency Control Field CURRENCY_CD Restricts It Too. (Doc ID 2918403.1)

Last updated on JANUARY 03, 2023

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When entering Withholding Adjustments, the Amt fields = 0.000. The decimal precision will change from 0.000 to 0.00 when tabbing out of different fields based on the amount of Legacy rows added. However, after adding the third row, the decimal precision remains 0.000 for the Liability Amt and Paid Amount fields. When saving this third row adjustment, an error message is received.

 

ERROR
-----------------------

Number field format error. The field format is (23.2). The currency control field CURRENCY_CD restricts it too.

The value of the currency control field should be the name of a currency entry in the PS_CURRENCY_CD_TBL, which defines a currency symbol, thousands delimiter character, decimal character, integer positions, decimal positions, and scale positions. The value for this field is constrained by the more restrictive of that format and the field's format.



STEPS
-----------------------

1. Suppliers > Supplier Information > Add/Update > Add/Update Supplier > USA1099019 > Location tab > 1099 link > setup for 1099 (Class 01 & 02), 1099M (Class 02 & 06), 1099N (Class 01) - Default Jurisdiction box checked

2. Supplier > 1099/Global Withholding > Maintain > Adjust Withholding > Select USA1099019 001

3. Enter Business Unit, Start and End Dates > click link for ‘Show all columns’ icon

4. Adjustments section > enter BU, Entity, Type, Jurisdiction, Class, Rule, Basis Amt and Description

5. After tabbing out of the Class field, the Amt fields change automatically from 0.000 to 0.00

6. Continue to enter Rule, Basis Amt, and Description > Save

7. Get out of the page > select USA1099019 > go back in > enter Business Unit, Start and End Dates > click Search > prior Legacy row appears > click link for ‘Show all columns’ icon > all Amt fields = 0.000

8. Adjustments section enter BU, Entity, Type, Jurisdiction, Class, Rule

9. Tabbing out of Rule field and all Amt fields again change from 0.000 to 0.00 > continue to enter Basis Amt and Description > Save

10. Click the ‘+’ icon to add a new row

11. All Amt fields = 0.000

12. Adjustments section enter BU, Entity, Type, Jurisdiction, Class, Rule > Basis Amt

13. Liability and Paid Amount fields remain 0.000 > Save

14. Message: Number field format error. The field format is (23.2). The currency field CURRENCY_CD restricts it too.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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