My Oracle Support Banner

Payment Accounting Creates Multiple Lines For Exchange Gain (Doc ID 1470642.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

On : Release 12 version, Accounting Issues in AP

ACTUAL BEHAVIOR
---------------

Foreign currency payment accounting is creating multiple gain/loss lines using the same account.

Created AP payment to settle 1 Invoice.
Exepected the system to create 1 Exchange Gain for $1.7
instead system created 7 lines for Exchange Gain . The total is correct $1.7
When transfer to GL, we also get 7 lines.

Subledger option Payable is set 'No Summarization'
The SLA journal line Type is set to 'Summary'

EXPECTED BEHAVIOR
-----------------------
Expect to see 1 line for Gain to be created and not 7 lines

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create foreign currency invoice with multiple distributions
2. Pay the invoice using different exchange rate
3. Account the payment

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are misled and not getting grouped balance for gain/loss.

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
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.