External Awards (EA) Load Error: ORA-1407: Cannot Update ("SYSADM."PS_SFA_EA_LOAD_DTL"."ITEM_TYPE") to NULL
(Doc ID 2656871.1)
Last updated on OCTOBER 12, 2020
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.
When attempting to load external awards, batch or on-line, the following error occurs with the Application Engine SFA_EA_LOAD: ORA-1407: cannot update ("SYSADM."PS_SFA_EA_LOAD_DTL"."ITEM_TYPE") to NULL.
The application engine is invoked as part of the cobol FAPPKEAL. The COBOL log may show the additional error message ORA-00942: table or view does not exist.
In at least one case, this problem occurred after loading records into staging from a file where the wrong EA code or other information was populated on the file.
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