Application Transactions Page PeopleCode Errors On SAD_APL_DAT_STG.LAST_SCH_ATTEND.FieldChange When User Tries Updating Last School Attended (Doc ID 2124185.1)

Last updated on OCTOBER 05, 2016

Applies to:

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

Symptoms

On the Application Transactions page, when a user tries to modify the last school attended field, the following error occurs either after tabbing out of the field or upon save:

ERROR
-----------------------
Field does not exist -DERIVED_CS.LAST_SCHOOL. (2,104) SAD_APL_DAT_STG.LAST_SCH_ATTEND.FieldChange PCPC:57 Statement:2, Field does not exist -DERIVED_ADM.EXT_ORG_ID. (2,104) SAD_APL_DAT_STG.LAST_SCH_ATTEND.FieldChange PCPC:633 Statement:12

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

1. Run file parser to load data to admissions staging.
2. After successful load, navigate to application transactions page by going to Student Admissions > Application Transaction Mgmt > Application Transactions.
3. Click the Search button.
4. Select a record from the search results.
5. Under Application Data section > Last School Attended, modify last school attended field.
6. Click Save.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users cannot update last school attended field in application staging.

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