EAR 9.2 ARX33001.MAIN.Step02 Error Selected Column Size Exceeds 255 Characters Microsoft SQLServer

(Doc ID 1987404.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
-------------------------
9.2 Image 8

Statement of Issue
-----------------------------------
EAR 9.2 ARX33001.MAIN.Step02 Error Selected Column Size Exceeds 255 Characters Microsoft SQLServer

What is Working
------------------------------
Issue happens on Microsoft SQLServer
Customer also claimes they did not encounter this issue back in Image 5

Error Message
-----------
Selected column size exceeds 255 characters.
Query Engine returns error. (228,118) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:GenerateXmlFile FromQuery PCPC:107968 Statement:2127 Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport Statement:1374 Called from:ARX33001.MAIN.GBL.default.1900-01-01.Step02.OnExecute Statement:25

Process 25019 ABENDED at Step ARX33001.MAIN.Step02 (PeopleCode) -- RC = 24

25019 ARX33001 MAIN Step02 PeopleCode 24

Selected column size exceeds 255 characters.

Steps to Replicate
----------------------------
1. Post items for a customer
2. Run and print dunning process

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