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 MARCH 09, 2018
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 11-Mar-2013***
***Checked for relevance on 08-Mar-2018***
IMPACTED RELEASES: 8.4x and beyond
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:
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:|