My Oracle Support Banner

EGL9.2: Spreadsheet Journal Import (JRNL1_WS) Batch Process (GL_EXCL_BATC) Fails On MS SQL Server & DB2 OS390 With ''CLI0109E String data right truncation" Error (Doc ID 2600033.1)

Last updated on FEBRUARY 01, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Spreadsheet Journal import [JRNL1_WS] - Batch import process doesn't work on MS SQL server and DB2 OS390 platform.

Process abends at step GL_JE_HDR.Prepare.gSIDPAct with "CLI0109E String data right truncation"


Steps to Replicate:

1. Use Spreadsheet Journal import template JRNL1_WS to enter header & line details for journal in a sheet.
2. Click on 'Write to File’ button to create flat file for sheet.
3. Create a run control to import this file & run batch import process GL_EXCL_BATC




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.