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 APRIL 16, 2021
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