EGL9.2: While Loading a CSV File, Journal Import (GL_JRNL_IMP) Process Abended at Step GL_JRNL_IMP.PROCESS.Import with "String data, right truncation (SQLSTATE 22001) 0 (2,298)" Error
(Doc ID 2674995.1)
Last updated on JUNE 07, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Microsoft SQLServer - Version 2005 to 2017
Information in this document applies to any platform.
While loading a CSV file having any numeric fields with too many decimal places, Journal Import process (GL_JRNL_IMP) process fails at step GL_JRNL_IMP.PROCESS.Import with the following error:
Note: This was not an issue unless site upgraded to PT 8.57 or higher. The field values used to be truncated in earlier PT release.
Steps to replicate:
- Prepare a CSV file with any numeric fields with too many decimal places. e.g. RATE_MULT entered in a line as 0.052509012 and expect the system to truncate it to 0.05250901.
- Import journal data by navigating in PIA to General Ledger > Journals > Import Journals > External Flat Files. Create a Run control and add the file prepared in step 1.
- Check process monitor for status and check message log if process goes to Error or No success status.
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