My Oracle Support Banner

Flat File Journal Import GL_JRNL_IMP Errors on Variable Length Data, Fixed Length Ok, After Upgrade To Tools 8.58.03 (Doc ID 2725521.1)

Last updated on NOVEMBER 02, 2020

Applies to:

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

Symptoms

After upgrade to Tools 8.58.03, when flat file journal lines do not all have the same length of data, journal data does not import, process goes to Warning, and log file gets "Journal Line errors" message along with list of all journal headers with error.

12.17.45 Processing file flat_file_journal_lines_not_fixed_length.txt ...
12.17.46 Validating imported data.
Journal Line errors (Journal ID, Date, Journal Line) :
  (LL020042F, 2020-09-22, 8) - Invalid Rate Type value 000.
  (LL020043F, 2020-09-22, 6) - Invalid Rate Type value 000.
  (LL020046F, 2020-09-22, 9) - Invalid Rate Type value 000.
  (LL020048F, 2020-09-22, 2) - Invalid Rate Type value 000.
  (LL020050F, 2020-09-22, 12) - Invalid Rate Type value 000.
 
12.17.51 Process failed - all work rolled back.  See log file for error
details.


If journal lines all have the same length, then journal data gets successfully imported, process runs to Success, and log file lists all journal headers that got imported.

Flat File Journal Import (GL_JRNL_IMP)
 
         2020-09-22
----------------------------------------
15.09.26 Processing file flat_file_journal_lines_fixed_length.txt ...
15.09.27 Validating imported data.
15.09.32 Moving data into target table.
15.09.33 Process completed successfully with 10 journals imported.
15.09.33 Imported these journals: System ID (Unit, Journal ID, Date)
Reference, Description
         US007, LL020030F, 2020-09-22
         US007, LL020029F, 2020-09-22
         US006, LL020028F, 2020-09-22
         US006, LL020027F, 2020-09-22
         US005, LL020026F, 2020-09-22
         US005, LL020025F, 2020-09-22
         US004, LL020024F, 2020-09-22
         US003, LL020023F, 2020-09-22
         US001, LL020022F, 2020-09-22
         US003, LL020021F, 2020-09-22

Replication Steps:
On environment on Tools 8.58.03:
1.Run flat file journal import GL_JRNL_IMP process using flat file with journal lines that do not all have the same length of data, get errors
2.Run flat file journal import GL_JRNL_IMP process using flat file with journal lines that all have the same length of data, goes to success

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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