My Oracle Support Banner

UCAS Import Failing After Application Of PUM25 And PRPs: ORA-01400: Cannot Insert NULL Error (Doc ID 2884223.1)

Last updated on FEBRUARY 28, 2023

Applies to:

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


When attempting to test a UCAS Import after PUM 25 and some PRPs, the SAD_UC_IMPAP process is failing, with the following errors in the log file: ORA-01400: cannot insert NULL into ("SYSADM"."PS_SAD_UC_I_IVSTH"."SAD_UC_NATIONALID")

NOTE: Before you import the data, set up the search/match parameters on the Search/Match Processing pages.

  1. Home > Student Admissions > UCAS Processing > Import Applicants > Import Applicant Data
  2. Select/add run control ID on search page
  3. Enter Institution value
  4. Enable checkboxes parameters as desired
  5. Select Run pushbutton
  6. Process errors.




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

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