Error Posting A Cash Receipt To A Student And Printing An XML Receipt (Doc ID 1612980.1)

Last updated on JUNE 28, 2016

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9 and later
Information in this document applies to any platform.
*** Checked For Currency 28-JUN-2016 ***

Symptoms

On CS 9 Bundle 31 an error is received when posting Payments or Charges to a student's account.

ERROR
-----------------------
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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. enter a student receipt
  2. click the Print Receipt button

 

Changes

 Applied CS 9 bundle 31.

Cause

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