Issues When Posting a Donor Gift Adjustment with a Refund for a Foreign Amount

(Doc ID 1907215.1)

Last updated on MAY 03, 2016

Applies to:

PeopleSoft Enterprise CS Contributor Relations - Version 9 and later
Information in this document applies to any platform.


When posting an adjustment with a refund for a foreign amount, the following issues are encountered:

  1. Currency cd for the base currency is not populating on the refund clearing account rows; 
  2. The foreign amount is keeping the amount of the original gift (GIFT_AMT_ENTRY) instead of the calculated amount for the refund.
  3. The debit/credit signs are reversed on the FOREIGN_AMT field; however, they are correct on the MONETARY_AMT field.

Expect the amounts to be equivalent amounts and the signs should be the same.

The issue can be reproduced at will with the following steps:
1. Post a gift for a foreign amount - queue and post to gl
2. Adjust the gift with a refund to go to the donor - queue and post to gl.
3. look at the AV_ACCTG_LN and see the signs reversed on the monetary amount and foreign amount fields.

The issue has the following business impact:

Due to this issue, users cannot post a refund if the gift is a foreign amount.


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