Error Loading International PROFILE Due To Postal Code Value Being Too Long

(Doc ID 2330476.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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

Symptoms


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.
ERROR
-----------------------
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



STEPS
-----------------------
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


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