EGL: Journal Generator Leaves The Rate Type Blank RATE_DIV As 1 And RATE_MULT As 0 When Using Multiple Currencies In The Subsystem

(Doc ID 1989560.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

CUSTOMER ENVIRONMENT
========================
Application Release 9.2
Image 8
Tools 8.53

Database Production


ISSUE/ERROR
==============
Data has come over from AP to GL.jrnl_ln showing rate_div as 1 and rate_mult as 0 but the foreign amount and monetary amounts are correct.

Steps
=====
1. Have multicurrency transactions in VCHR_ACCTG_LN
2. Have journal generator template for the transactions set to summarize by all chartfields
3. Journal generate transactions
4. Query JRNL_LN for amounts and rate fields and you see rate_div as 1 and rate_mult as 0


BUSINESS IMPACT
=================
Rates are Confusing..but amounts are correct

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