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 NOVEMBER 13, 2023

Applies to:

Symptoms

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:

1. 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.
2. 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.
3. Check process monitor for status and check message log if process goes to Error or No success status.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.