Message 14816,302-'SQL error after posting the Item-Select failed for Installation table' Occurs In Posting After Applying Fix for Bug 34645758 SFP: ADD LOGIC TO ENSURE POSTING CREATES A 1:1 RELATIONSHIP BETWEEN SFP <PAYMENTID> AND SF PAYMENT_ID
(Doc ID 2912418.1)
Last updated on MARCH 10, 2023
Applies to:PeopleSoft Enterprise CS Student Financials - Version 9.2 and later
Information in this document applies to any platform.
Non SFP (Student Financial Planning) customers experience a new warning message when running Posting processes for a student after applying the fix for Bug 34645758 SFP: ADD LOGIC TO ENSURE POSTING CREATES A 1:1 RELATIONSHIP BETWEEN SFP <PAYMENTID> AND SF PAYMENT_ID_NBR.
Posting processes include Charge Reversal, Payment Reversal, Student Post, Write Off processing, and Tuition Calculation.
For all posting processes, the transaction completes successfully. Prior to applying the fix, the warning message did not occur.
Performing a Charge Reversal displays the following pop up message. Charge Reversal is the only process experiencing this pop up message.
The issue can be reproduced at will with the following steps:
- Navigate to Student Financials, Charges and Payments, Reversals, Reverse Charge;
- Enter the Emplid;
- Click on the Account Details hyperlink for the term/account type the charge to be reversed is in;
- Click the Reverse button;
- The pop up message box displays 'Data was posted but a warning was detected from the Posting Program Call. (14816.800)'.
The fix for Bug 34645758 - SFP: ADD LOGIC TO ENSURE POSTING CREATES A 1:1 RELATIONSHIP BETWEEN SFP AND SF PAYMENT_ID_NBR has been applied to the environment.
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