EAR9.0+: Maintenance Worksheet Is Generating Incorrect Foreign Currency, Foreign Amount and Rate for Offset Accounting Entry When Offsetting Foreign Currency Debit to Credit. (Doc ID 1912438.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9 version, Maintenance Worksheet

ACTUAL BEHAVIOR
---------------
Maintenance worksheet is generating incorrect accounting entries when offsetting foreign currency debit to credit.
PS_PENDING_DST is having incorrect FOREIGN_CURRENCY where SYSTEM_DEFINED = 'Y'.
This is only happening when using Item References.

EXPECTED BEHAVIOR
-----------------------
Accounting entries should be correct when offsetting foreign currency debit to credit.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create and post a foreign currency debit with 1 User line and 3 AR lines and a credit with 1 User line and 1 AR line.
  2. Change market rates.
  3. Create a maintenance worksheet, make sure to define Item References and offset debit to credit.
  4. Run ARUPDATE.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, system is creating incorrect accounting entries.

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