My Oracle Support Banner

EGL: How Do We Fix Data That Goes To The Third Decimal For USD In The Ledger And Journal Tables? (Doc ID 661243.1)

Last updated on AUGUST 08, 2023

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 9.2 [Release 8.4 to 9]
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201066235 *** ***
***Checked for relevance on 15-Apr-2021***


Customer has a trial balance report that has data showing to 3rd decimal place. Based on research, the data also goes to 3rd decimal place on the LEDGER and JRNL_LN tables.

Data being selected from the LEDGER table for other processing and finding three decimal places for currencies that should only have two decimal positions.

Examples of processes that can be impacted:

Copy journal

We have data out to the 3rd decimal  in the ledger and journal tables when it should not be. 
How can we fix it?

When trying to fix from on-line it will not permit entry to the 3rd decimal for this currency code.




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
 If SQL Updates are required, here is the solution action plan to follow:
 Possible Workaround

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