My Oracle Support Banner

EGL 8.9+:Journal Edit Does Not Validate If Monetary Amount = Foreign Amount for Base Currency Transactions When Journals Are Imported / Journal Generated From 3rd Party Tables. (Doc ID 763005.1)

Last updated on MARCH 25, 2024

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.
*** checked for relevance 9th September 2010 ***
*** checked for relevance 25-03-2024 ***


Consider the following example :

Journal generate or Import a Journal with the following scenario

line 1: Foreign Amount and Monetary Amount of (5,10).
line 2: Foreign Amount and Monetary Amount (-8,-10)

base currency = foreign currency

When such a journal is batch edited, the journal goes to valid. The journal is marked valid even though it has lines with monetary amount not the same as foreign amount and this journal then gets posted successfully .

Posting the above journal creates the following entry in ledger ,

PTrA, PBA, PTA (5,5,5)
PTrA, PBA, PTA (-8,-8,-8)

PTrA: Posted Transaction Amount
PBA: Posted Base Amount
PTA: Posted Total Amount

When Trail Balance (GLS7012) is run it will show an out of balance state.


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.