My Oracle Support Banner

'ORA-00904: "SFA_NAC_ASREJ_CD": invalid identifier' Error With Execution of Upd33234548_03_imp.dms When Applying 2023-2024 Aid Year Updates for ISIR (Doc ID 2915499.1)

Last updated on DECEMBER 13, 2022

Applies to:

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

Symptoms

When attempting to apply the 2023-2024 AID YEAR UPDATES FOR ISIR fixes, delivered originally in Patch 33234548 and then in CS 9.2 PUM Image 27, the following error occurs with the execution of the .dms script Upd33234548_03_imp.dms, in the process of applying the change package via Peoplesoft Update Manager (PUM) and Change Assistant. The error displays in the change assistant log file for the step that executes that .dms.

The issue can be reproduced with the following steps:

  1. In PUM, create change package with 2023-2024 AID YEAR UPDATES FOR ISIR fixes. 
  2. Apply the change package using Change Assistant.
  3. Note the step to execute upd33234548_03_imp.dms ends in error.
  4. Review the log file for the details of the error.

Changes

The issue occurs after downloading/deploying the CS 9.2 PUM 27 (or higher) source image containing the 2023-2024 AID YEAR UPDATES FOR ISIR fixes, prior to those fixes being applied to any target environment. Originally, the issue would have occurred after applying PRP 33234548, which first delivered the fixes, to the CS 9.2 PUM 26 source image.

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
References


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