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***
Symptoms
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:
Reports
Consolidations
Equitizations
Allocations
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.
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 |
| If SQL Updates are required, here is the solution action plan to follow: |
| Possible Workaround |
| References |