My Oracle Support Banner

EAP: Voucher Build Recycle Error " Decimal Precision for Payments Record Amount Fields Does Not Match Currency Setting" When Processing Foreign Currency Transactions With Decimal Amounts. (Doc ID 2985406.1)

Last updated on NOVEMBER 16, 2023

Applies to:

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

Symptoms

An accounts payable business unit has a base currency as JPY( the currency setting has 0 decimal values), for this business unit the invoice information is stagged into voucher staging tables.

These invoices include the transactions that have a transaction amount in USD and with 2 decimals also the transaction in JPY currency.

When these invoices are processed through voucher together with other accounts payable business unit as given below example, one of these vouchers are placed in recycle status with the following error:


ERROR Message
(7220, 32) - Decimal precision for payments record amount fields does not match currency setting.
 

For example the following data is in the staging tables, the supplier is same for all these transactions:

Data 1 : BU: JPN01 (Base Currency JPY) ,Transaction Currency: USD , Gross Amount : Decimal number.
Data 2 : BU: JPN01 (Base Currency JPY) ,Transaction Currency: USD , Gross Amount : Whole number.
Data 3 : BU: US001 (Base currency  USD) ,Transaction Currency: JPY [Bank and currency defined under Supplier Payment setup is Japan Bank and JPY currency] , Gross Amount : Whole number.

NOTE: The above User Details / Company Names / Addresses / Emails / Telephone Numbers / Etc. are fictitious (based upon made-up data used in the Oracle DEMO Environments), any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


Steps to replicate
1. Load invoice information into voucher staging tables.

2. Run voucher build process( for all applicable business units).
     Menu > Accounts Payable > Batch processes > Vouchers > Voucher Build.

3. Review the errors on the vouchers created.
      Menu > accounts Payable > Vouchers > Add/Update > Regular Entry( Search for the vouchers ) > Go to Error summary tab.

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.