SFA_COD_OUT fails with ORA-00904: "SFA_CR_PROGCREDLVL": invalid identifier (Doc ID 2246234.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

After applying Patch 24290724: 2017 - 2018 AID YEAR UPDATES FOR DIRECT LENDING COD AND PELL COD, the SFA_COD_OUT step of the PELLOUT PS Job is failing with...

Return: 904 - ORA-00904: "SFA_CR_PROGCREDLVL": invalid identifier
Statement: select
sfa_cr_document_id,sfa_cr_rpt_schl_id,sfa_cr_att_schl_id,emplid,sfa_cr_award_name,sfa_cr_award_year,sfa_cr_award_nbr,sfa_cr_disb_nbr,sfa_cr_disb_amt,sfa_cr_disb_dt,sfa_cr_dsb_release,sfa_cr_dsb_seq_nbr,sfa_cr_note_msg,sfa_cr_first_disb,sfa_cr_dsb_net_amt,sfa_cr_dsb_fee_amt,sfa_cr_dsb_reb_amt,sfa_cr_dsb_confirm,sfa_cr_pmt_per_dt,sfa_cr_response_cd,sfa_cr_prv_seq_nbr,sfa_cr_disb_amt_n,sfa_cr_enr_schlcd,sfa_cr_enrlmntstat,sfa_cr_prog_cip_cd,sfa_cr_pgmlenyears,sfa_cr_pgmlenmnths,sfa_cr_pgmlenweeks,sfa_cr_wkpgmacadyr,sfa_cr_specialpgms,SFA_CR_PROGCREDLVL
FROM PS_SFA_COD_DISB WHERE
SFA_CR_DOCUMENT_ID = :1 AND SFA_CR_RPT_SCHL_ID = :2 AND SFA_CR_ATT_SCHL_ID = :3 AND EMPLID = :4
AND SFA_CR_AWARD_NAME = :5 AND SFA_CR_AWARD_YEAR = :6 AND SFA_CR_AWARD_NBR = :7
Original Statement: %Selectall(:1) Where SFA_CR_DOCUMENT_ID = :2
AND SFA_CR_RPT_SCHL_ID = :3 AND
SFA_CR_ATT_SCHL_ID = :4 AND EMPLID = :5 AND SFA_CR_AWARD_NAME = :6 AND SFA_CR_AWARD_YEAR
= :7 AND SFA_CR_AWARD_NBR = :8

Steps:

1. Financial Aid > File Management > COD Full Participant > Generate Pell Data



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