My Oracle Support Banner

Cancelling and or Modifying Collection Agreement Causing Data Corruption (Doc ID 2635502.1)

Last updated on FEBRUARY 05, 2020

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9.2 and later
Information in this document applies to any platform.


On a Campus solutions 9.2 database we see a Payment that was subsequently reversed appearing as a debit in PS_ITEM_SF (payments should always display in the ITEM_SF table as credits) and an unapplied item balance (meaning there is still some amount of the payment that is waiting to apply to charges)
The total of the payment is $0 so $0 should appear appear as the ITEM_AMT and the ITEM_BALANCE in PS_ITEM_SF

A 2nd item number for the same payment_id_nbr with has an item_amt of $0 remains applied to student charges in ITEM_XREF and ITEM_SF as well 

The payment is $0 in the payment table
$0 should appear as the ITEM_AMT and ITEM_BALANCE in ITEM_SF
All rows in ITEM_LINE_SF for each item number of the payment should total $0
The payment should be applied to charges in ITEM_XREF and ITEM_SF
The exact issue cannot be reproduced but it appears to have been caused when adding/removing charges from a collection agreement



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

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