My Oracle Support Banner

EGL8.8SP1+: Import Ledger From Flat File Fails With Invalid Record Type Value When Trying to Load a CSV File (Doc ID 1279968.1)

Last updated on JULY 02, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 SP1 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.
***Checked for relevance on 04-Mar-2013***


On : 8.8 SP1 and higher version, Flat File Ledger Import

When attempting to run Import Ledger from Flat File using CSV format the following error occurs.

Invalid Record Type value XXX.

When using Fixed format the process is running to success.

The issue can be reproduced at will with the following steps:

  1. In Application Designer open File Layout GL_LED_IMPORT. Go to the File Layout Definition Properties and change File Layout Format from Fixed to CSV. Checkbox Excel Format, Qualifier Optional and Convert Tabs to Spaces are all enabled.
  2. Navigate to General Ledger > Ledgers > Import Ledger from Flat File. Attach CSV file to run control page and run GL_LED_IMP process.

The issue has the following business impact:
Due to this issue, users cannot use CSV format when importing ledger data.


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.