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

Last updated on SEPTEMBER 14, 2016

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
-----------------------
"\\alvdbssql003\Interfaces\DEIU_Testing\DEIU_JRNL_LN_02.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.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import any csv file.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms