Staging Voucher EDI Files Using the Data Export Import Utility

This topic describes the transformation of EDI files containing voucher data for import into Payables staging tables using the Data Export Import Utility.

The Data Export and Import Utility provides a mechanism to import EDI voucher data into the staging tables, bypassing steps that are needed using EDI Manager. PeopleSoft Payables provides a sample setup to import EDI voucher data using the Data Export Utility. Businesses should test their own DEIU setup before implementation.

The EDI voucher data transformation is based on People Tools Document Technology and the Data Export and Import Utility (DEIU) tool, which allows users to configure transformation through an online mapping component. Users should be familiar with PeopleSoft documents, as well as Data Export Import Utility map definitions and document relationships before customizing EDI data import setup using DEIU.

PeopleSoft delivers the following sample DEIU program for transforming EDI voucher data and importing the data into the Payables voucher staging tables.

Payables Process

Delivered DEIU Transformation Program

Load Voucher Build Source Transactions

EDI_810_VOUCHER_IMPORT_RUN

Once data is loaded into the staging tables, run the Voucher Build process.

For more information about the Data Export Import Utility, see Understanding the Data Export Import Utility.

PeopleSoft provides a setup with sample field mapping for staging EDI voucher data using the Data Export Import Utility. To set up the import process:

  1. Review PeopleSoft Documents for both source and target documents.

  2. Verify DEIU map definitions for EDI file transformation.

The EDI file voucher import process is supported for flat EDI files.

For more information about setting up DEIU, see Mapping File Layouts and Document Relationships and Defining the Data Source and Target.

Reviewing the PeopleSoft Documents

Use the Document Builder - Document page (IB_LOGICALSCHEMA) to view and edit a document in the Document Builder.

Before using the Data Export Import Utility for EDI voucher file import, review the PeopleSoft Documents delivered for use with EDI files.

PeopleSoft provides the following sample documents and layouts to support the Load Voucher Build Source Transactions process:

  • Source Document

    • Source Type: File Layout (FIXED)

    • Source Name: AP_VOUCHER_IMPORT

  • Target Document

    • Target Type: PS Document

    • Target Name: VCHR_IMP_STG

Verifying the Map Definition

Use the Map Definition component (FS_MAPPER_DEF_WIZ) to set up the transformation from data source to target output.

The EDI voucher file transformation occurs through the online mapping definition. DEIU provides a horizontal navigation, or train stops, to define a map that links the data source and target output format along with any data filter criteria.

PeopleSoft delivers the following sample map definition for EDI files: EDI_810_VOUCHER_IMPORT. Businesses should create, test, and put their own map definitions into production.

The Edit Transform Property secondary page is used to define the parameters for the selected transformation rule. PeopleSoft provides system-delivered transformation rules with the map definitions for EDI files.

Note: The Data Export Import Utility is a generic transformation tool that is used across PeopleSoft Financials. Not all transform types supported by Data Export Import Utility are applicable to EDI file import.

Use the Data Export Import Request page (FS_MAP_REQUEST) to initiate DEIU processing based on the map definition and options to further filter the data set, if applicable.

To import EDI voucher data into the staging tables using DEIU:

  1. Navigate to the Data Export Import Request page (Set Up Financials/Supply Chain, Common Definitions, Data Export Import Utility, Data Export Import Request).

  2. Enter the run control ID to transform and load flat EDI files to support the Load Voucher Build Source Transactions process, in this example EDI_810_VOUCHER_IMPORT_RUN.

  3. Verify the data in the staging table before running Voucher Build to load the data in the Payables voucher tables.