Gift Adjustment Sessions Do Not All Feed to AV_ACCTG_LN (Doc ID 2912157.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

 An adjustment to a gift was posted but we don't see an adjustment created in PS_AV_ADJ_GIFT_DTL feeding over to PS_AV_ACCTN_LN

If a gift has been changed or corrected we would expect the correcting entry to be recorded in the ledger.

The issue can be reproduced at will with the following steps:
1 Contributor Relations> Session Management > Maintain Gift Sessions and open a new session , session type AG
2. Enter the tender, total and count for the adjusting session.
3. Select a posted gift /emplid number to adjust and create the correction to an amount. Likewise select another gift and change the campaign it is recorded against.
4. Balance the session at Contributor Relations> Session Management > Maintain Gift Sessions by pressing the BALANCE button on the session
5. Queue the session at Contributor Relations> Session Management > Queue session for posting
6. Post the session Contributor Relations> Session Management > Process sessions > GL Interface.
7. Note that the change to an amount creates new journal entries but the change to the campaign does not feed anything to the general ledger by reviewing the PS_AV_ACCTN_LN for the donor.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.