My Oracle Support Banner

Error Loading International PROFILE Due To Postal Code Value Being Too Long (Doc ID 2330476.1)

Last updated on APRIL 02, 2019

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


When loading an international applicant in a PROFILE XML, the file has a value in the <PostalCode> tag line '23529 Code 1000'.  The following error occurs.
Assignment of "23529 Code 1000" to SFA_PF_COMM_ST.POSTAL failed. (2,119) SFA_PF_XML_LOAD.INTFC.LoadToStage.OnExecute Name:PopulateComonStageRec PCPC:172644 Statement:1990

The issue can be reproduced at will with the following steps:
1. Load a profile where the postal code exceeds 12 characters
2. Review result of load


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.