My Oracle Support Banner

Data Conversion Error While Doing Application Upgrade From CS 9.0 To CS 9.2 PI8 (Doc ID 2485413.1)

Last updated on APRIL 22, 2019

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, Campus Community Install/Upgrade

Data Conversion went to error while doing application upgrade from CS 9.0 to CS 9.2 PI8


ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 1219 Return: 1722 - ORA-01722: invalid number

Failed SQL stmt: SELECT E.SFA_CR_PMT_PER_DT , E.SFA_CR_ENRLMNTSTAT , E.SFA_CR_PROG_CIP_CD FROM PS_LOAN_DISBMNT A , PS_LOAN_ORIG_DTL B , PS_LOAN_DISB_ACTN C , PS_SFA_COD_AWARD D , PS_SFA_COD_DISB E , PS_SFA_COD_DOCUMNT F WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR=B.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.LOAN_TYPE = B.LOAN_TYPE AND A.LN_APPL_SEQ = B.LN_APPL_SEQ AND A.ITEM_TYPE = B.ITEM_TYPE AND A.LN_EXT_ACT_ID = ' ' AND A.EMPLID = C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.ACAD_CAREER = C.ACAD_CAREER AND A.LOAN_TYPE = C.LOAN_TYPE AND A.LN_APPL_SEQ = C.LN_APPL_SEQ AND A.ITEM_TYPE = C.ITEM_TYPE AND A.DISBURSEMENT_ID = C.DISBURSEMENT_ID AND C.LN_ACTION_CD IN ('N') AND C.LN_ACTION_STATUS IN('P') AND D.EMPLID = B.EMPLID AND D.SFA_CR_AWARD_YEAR = B.AID_YEAR AND D.SFA_CR_AWARD_ID = B.LN_APPL_ID AND D.SFA_CR_DOCUMENT_ID = E.SFA_CR_DOCUMENT_ID AND D.SFA_CR_RPT_SCHL_ID = E.SFA_CR_RPT_SCHL_ID AND D.SFA_CR_ATT_SCHL_ID = E.SFA_CR_ATT_SCHL_ID AND D.EMPLID = E.EMPLID AND D.SFA_CR_AWARD_NAME = E.SFA_CR_AWARD_NAME AND D.SFA_CR_AWARD_YEAR = E.SFA_CR_AWARD_YEAR AND D.SFA_CR_AWARD_NBR = E.SFA_CR_AWARD_NBR AND E.SFA_CR_DSB_RELEASE = 'false' AND E.SFA_CR_DISB_NBR = TO_NUMBER(A.LN_EXT_ANT_ID) AND TO_NUMBER(E.SFA_CR_DSB_SEQ_NBR) = C.DL_DISB_SEQ AND E.SFA_CR_DOCUMENT_ID = ( SELECT MAX (E1.SFA_CR_DOCUMENT_ID) FROM PS_SFA_COD_DISB E1 WHERE E1.SFA_CR_RPT_SCHL_ID = E.SFA_CR_RPT_SCHL_ID AND E1.SFA_CR_ATT_SCHL_ID = E.SFA_CR_ATT_SCHL_ID AND E1.EMPLID = E.EMPLID AND E1.SFA_CR_AWARD_NAME = E.SFA_CR_AWARD_NAME AND E1.SFA_CR_AWARD_YEAR = E.SFA_CR_AWARD_YEAR AND E1.SFA_CR_AWARD_NBR = E.SFA_CR_AWARD_NBR AND E1.SFA_CR_DISB_NBR = E.SFA_CR_DISB_NBR AND E1.SFA_CR_DSB_RELEASE = 'false' AND E1.SFA_CR_PMT_PER_DT > ' ' AND E1.SFA_CR_ENRLMNTSTAT > ' ' AND E1.SFA_CR_PROG_CIP_CD > ' ' ) AND D.SFA_CR_DOCUMENT_ID = F.SFA_CR_DOCUMENT_ID AND F.SFA_CR_DOC_TYPE IN (' ', 'RS') AND A.EMPLID =:1 AND A.INSTITUTION = :2 AND A.AID_YEAR = :3 AND A.ACAD_CAREER = :4 AND A.LOAN_TYPE = :5 AND A.LN_APPL_SEQ = :6 AND A.ITEM_TYPE = :7 AND A.DISBURSEMENT_ID = :8

Process 2323854 ABENDED at Step UPG_FA90.CSFAL04A.Step01 (Do Select) -- RC = 1722 (108,524)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Application upgrade from 9.0 to 9.2 using upgrade image 2.
2. Data Conversion step: Run AE_PTIADATACONV

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot move towards next steps as a part of upgrade.

Changes

 

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
Changes
Cause
Solution


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