My Oracle Support Banner

EGL9.2: Unable to Import Delimited File Using DataExport Import Utility (Doc ID 2115677.1)

Last updated on NOVEMBER 23, 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

On : 9.2 version, Direct Journal

When attempting to run Data Export Import Request for an import request the following error occurs.

ERROR
-----------------------
"link\file.csv could not be opened for mode rb as a file of charset UTF8BOM (2,668) FS_MAP_PR.MAIN.GBL.default.1900-01-01.Mapper.OnExecute PCPC:983 Statement:16"

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

  1. Add a new document in PeopleTools > Documents > Document Builder.
  2. Add a new Delimited File Layout in Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > Delimited File Layout.
  3. Map Definition in Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > Map Definition.
  4. Create document relationship in Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > Document Relationship.
  5. Navigate to Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > Data Export Import Request and import csv file.



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.