E-IB: Error occurred while building Document: The Document Primitive: XXXX Defined Length Is Smaller Than The Value: YYYY (Doc ID 2203446.1)

Last updated on NOVEMBER 14, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

Applies To: All tools releases below 8.55.12,  on any platform.

Sample Environment:
------------------
Tools 8.55.06
HRMS 9.2 DEV env

Issue:
--------

Document Based Message: Sending in a value of 137749 on a Request message. The field is on the table HRS_APP_ITEMS (PS delivered). When the GetDocument command is issue, it converts the integer 137749 to 137749.000000 which is now too big for the integer field in the Document definition. Document was created using the Create Document from Record. The field is defined as
Element Name: JPM_ITEM_KEY_ID
Type: Integer
Length: 12
*Sub-Type: None
Unbound Maximum: unchecked

Error Codes
---------------------------------------------------
Error occurred while building Document: The Document Primitive: JPM_ITEM_KEY_ID defined length is smaller than the value: 137749.000000. (2,1043) C_WS_APPLICANT.Profile.Rest.SaveProfile.OnExecute Name:OnRequest PCPC:427 Statement:14


Segment of JSON request
"HRS_APP_ITEMS": [
  {
  "HRS_PERSON_ID": 257491,
  "HRS_PROFILE_SEQ": 7,
  "JPM_PROFILE_ID": "00102277",
  "JPM_CAT_TYPE": "DEG",
  "JPM_CAT_ITEM_ID": "BAC",
  "JPM_CAT_ITEM_QUAL2": "1536",
  "EFFDT": "2012-09-07",
  "JPM_ITEM_KEY_ID": 137749,
  "JPM_JP_QUAL_SET2": "MAJOR",
  "COUNTRY": "USA",
  "JPM_DATE_1": "1991-04-01",
  "JPM_DATE_2": "0001-01-01",
  "JPM_YN_1": "Y",
  "JPM_YN_2": "N",
  "JPM_YN_3": "N",
  "JPM_DATE_3": "0001-01-01",
  "STATE": "CA",
  "SCHOOL_CODE": "1234",
  "SCHOOL_DESCR": "Test University of USA",
  "MAJOR_DESCR": "Accountancy",
  "LASTUPDDTTM": "2012-09-07T11:20:34.000000-0600",
  "LASTUPDOPRID": "718999"
  },


Expected Behaviour:
-------------------------
GetDocument should not be converting the integer into a decimal number.

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