EAR9.2: Foreign Currency Direct Journal not Balanced in MONETARY_AMOUNT (Doc ID 2165527.1)

Last updated on OCTOBER 28, 2016

Applies to:

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

Symptoms

On : 9.2 version, Direct Journal

ACTUAL BEHAVIOR
---------------
Depending on the sequence of steps performed, AR direct journal with foreign currency has its monetary amounts not balanced.

EXPECTED BEHAVIOR
-----------------------
Monetary amount should always be balanced.

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

  1. Market Rate between USD and CHF is 0.9690
  2. Create a new regular deposit for business unit CHE01. Bank is CHBK2, account CHCK and currency USD. Payment amount is 6875.02 USD. Make sure to enable ‘Journal Directly’.
  3. Navigate to Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries, for line 1 enter Line Amount -7032.00 USD, Account 401000 and enter Line Descr.
  4. Add a second line (+ button). For line 2 enter Line Amount 156.98 USD, Account 402000 and enter Line Descr.
  5. Save changes.
  6. Click on Complete button and save.
  7. Message: There are no cash lines for this journal. (6040,762) is triggered.
  8. Click OK.
  9. Uncheck Complete button.
  10. Then click on Create button.
  11. The system adds a third line with 100000 account.
  12. Save changes.
  13. Amount in base currency is NOT balanced. To verify run the following SQL: SELECT SUM(MONETARY_AMOUNT) FROM PS_PAY_MISC_DST WHERE DEPOSIT_BU = 'CHE01' AND DEPOSIT_ID = '2';
  14. SUM(MONETARY_AMOUNT) = -0.01
  15. Then check Complete button.
  16. Save changes, deposit is still not balanced.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, in General Ledger journal cannot be posted.

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