My Oracle Support Banner

EGL9.2:When Journal Foreign Amount's Currency is Changed from 2 to 0 Decimals (ex: USD to JPY), Foreign Amount is Changed Accordingly But Not When Queried from PS_JRNL_LN Record. (Doc ID 2808062.1)

Last updated on OCTOBER 28, 2021

Applies to:

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


Journal is created for USD lines.  When lines are changed to JPY currency, the page displays the correct Foreign Amount (Debit Amounts and Credit Amounts) with 0 decimal. 
However, checking backend at PS_JRNL_LN.FOREIGN_AMOUNT, JPY currency still has 2 decimals.   This only happens when 'Separate DR/CR Amount Fields’ checkbox is selected in Ledgers for a Unit. 
When unchecked, amounts are updated as expected.

Steps to replicate:

1.  In Ledgers for a Unit, select ‘Separate DR/CR Amount Fields’ checkbox.    
2.  Create a journal in USD and amount with 2 decimal places (ex:  200.56), then save.    
3.  Change the last 2 highlighted rows currency from USD to JPY.  Note that for each change, gets the warning message such as shown.  
     Click OK on both, and hit Save.   
     - Notice that at save, JPY currency changed from 2 to 0 decimal place (ex:  255.95 to 256) for the Debit Amount and Credit Amount fields.    
       However, backend, the Foreign Amount Field values were still showing the 2 decimals for JPY.   

See replication here.




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

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