My Oracle Support Banner

Request Transcript Report Error ' ORA-01407: cannot update ("SYSADM"."PS_SSR_TSRSLT_PERS"."DESCR30") to NULL (Doc ID 3075061.1)

Last updated on MARCH 03, 2025

Applies to:

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

Symptoms

When attempting to o generate transcripts through Request Transcript Report, the following error occurs.

Return: 1407 - ORA-01407: cannot update
("SYSADM"."PS_SSR_TSRSLT_PERS"."DESCR30") to NULL
Failed SQL stmt: UPDATE PS_SSR_TSRSLT_PERS SET DESCR30= ( SELECT
B.XLATLONGNAME FROM PS_SSR_TSC_TMP2 Z , PS_HCR_PER_PDE_I A , PSXLATITEM
B WHERE Z.PROCESS_INSTANCE = 0 AND Z.REPORT_REQUEST_NBR =
PS_SSR_TSRSLT_PERS.REPORT_REQUEST_NBR AND Z.REQUEST_SEQ_NBR =
PS_SSR_TSRSLT_PERS.REQUEST_SEQ_NBR AND Z.REPORT_NUMBER =
PS_SSR_TSRSLT_PERS.REPORT_NUMBER AND Z.EMPLID =
PS_SSR_TSRSLT_PERS.EMPLID AND Z.EMPLID = A.EMPLID AND A.EFFDT = ( SELECT
MAX(A1.EFFDT) FROM PS_HCR_PER_PDE_I A1 WHERE A1.EMPLID = A.EMPLID AND
A.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')) AND
B.FIELDNAME = 'SEX' AND B.FIELDVALUE = A.SEX AND B.EFFDT = ( SELECT
MAX(B1.EFFDT) FROM PSXLATITEM B1 WHERE B1.FIELDNAME = B.FIELDNAME AND
B1.FIELDVALUE=B1.FIELDVALUE AND B1.EFFDT <=
TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') AND B1.EFF_STATUS =
'A') AND B.EFF_STATUS = 'A') WHERE REPORT_REQUEST_NBR = '<number will display here>' AND
EXISTS ( SELECT 'X' FROM PS_SSR_TSC_TMP2 Z1 WHERE Z1.PROCESS_INSTANCE = 0
AND Z1.REPORT_REQUEST_NBR = PS_SSR_TSRSLT_PERS.REPORT_REQUEST_NBR
AND Z1.REQUEST_SEQ_NBR = PS_SSR_TSRSLT_PERS.REQUEST_SEQ_NBR AND
Z1.REPORT_NUMBER = PS_SSR_TSRSLT_PERS.REPORT_NUMBER AND Z1.EMPLID =
PS_SSR_TSRSLT_PERS.EMPLID)

The issue does not occur in every case but only a subset. In a recent case, problem students were observed to have future dated row on PS_HCR_PER_PDE_I, and/or a value of 'U' in the sex field in the table on either the current or future row. In this recent case, the effective dates were verified to be the same for all translate values for SEX in PSXLATITEM, however past cases reported the error to occur when the dates were different for one or more values compared to the others.

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

  1. Navigate to Records and Enrollment > Transcripts > Request Transcript Report
  2. Fill out all necessary information and click to produce transcript.
  3. Note error displayed in the page or the log.





Cause

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
Symptoms
Cause
Solution
References


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