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 SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 9.1 [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***


Symptoms

<Document:661243.1>

IMPACTED RELEASES: 8.4x and beyond


ISSUE VERIFICATION(IV):
=====================
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
Consolidation
Equitization
Allocation
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms