Error Posting A Cash Receipt To A Student And Printing An XML Receipt
Last updated on NOVEMBER 28, 2017
Applies to:PeopleSoft Enterprise CS Student Financials - Version 9 and later
Information in this document applies to any platform.
*** Checked For Currency 28-NOV-2017 ***
On CS 9 Bundle 31 an error is received when posting Payments or Charges to a student's account.
Remote program SFPQKDRV failed with return code: 8006 .Reason: Invalid datatype specified. In section: SQLRT: EXECUTE-STMT (2,-1) CSH_OFF_WRK.CALL_QUICK_POST.FieldChange Name:PostReceipt PCPC:6111 Statement:94
Called from:CSH_OFF_WRK.CALL_QUICK_POST.FieldChange Name:Save_Receipt Statement:181
Called from:CSH_OFF_WRK.CALL_QUICK_POST.FieldChange Statement:193
Query SF750R_BI_CSH_OFF_RCPT_ADDR does not exist. (241, 16) PT_CONQRS.CONQRSMGR.OnExecute Name:ValidateIfCurrent PCPC: 79760 Statement:1702
Called from: PT_CONQRS.CONQRSMGR.OnExecute Name:retrieve Statement 1034
Called from: PT_CONQRS.CONQRSMGR.OnExecute Name:Open Statement: 60
Called from: SSF_CASHIERING: PrintReceipt:BIPubReport. OnExecute Name:SetBindData Statement 78
Called from: SSF_CASHIERING: PrintReceipt:BIPubReport. OnExecute Name:ExecXmlQryReport Statement 162
Called from: SSF_CASHIERING.Pr
Please delete the object and recreate it.
The issue can be reproduced at will with the following steps:
- enter a student receipt
- click the Print Receipt button
Applied CS 9 bundle 31.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms