My Oracle Support Banner

E1: 15: Lease Management - Real Estate Sample Files for Data Import for Inbound Processing Using Zfile Processing (Doc ID 2451522.1)

Last updated on OCTOBER 24, 2023

Applies to:

JD Edwards EnterpriseOne Real Estate Management - Version 9.1 and later
Information in this document applies to any platform.


Understanding the Real Estate Management Data Import Process

Several programs are available to facilitate the import of real estate management data into the EnterpriseOne system. These programs use the standard EDI process, which involves these steps:

  1.  Create flat files that are formatted using the same layout as their associated Z tables, and populate those flat files with your business data. Be aware that the first column in your flat file must include the Record Type value, and that you must use the delimiter and text qualifiers that are defined in the processing options of the associated version of the Inbound Flat File Conversion program (R47002C) you are using.
  2. Set up real estate transaction types (UDC 00/TT) and identify the name and location of your flat files using the Flat File Cross Reference program (P47002).
  3. Run the specific version of the Inbound Flat File Conversion program (R47002C) to populate the specified Z table with the data from the flat file
  4. Review and update the data in the Z tables.
  5. Upload edited data from the Z tables into the target EnterpriseOne tables using the specific inbound processor program.
Note that you can set up this program to automatically upload the data from the Z table into the EnterpriseOne table if there are no errors during processing. To do this, specify the inbound processor program and version in the processing options. If there are errors when processing the flat file conversion, the system does not run the inbound processor.

See Processing EDI Documents in the JD Edwards EnterpriseOne Applications Data Interface for EDI Implementation Guide for additional information.

Please see Document 1267783.1 - E1: 47: Inbound Flat File Conversion (R47002C) if experiencing any issues in loading the flat file.

JD Edwards EnterpriseOne has provided sample files for processing Z file entries with Lease for the following tables. Please access the zip files below for details:

 Asset Master (F1201Z1), Lease Master (F1501BZ1), Recurring Billing (F1502BZ1), Unit Master (F1507Z1), Manual Billing (F1511BZ1), Bill Codes (F1512Z1), Area Master (F1514Z1) and  Lease Detail (F15017Z1)


Lease Management 9.1 and 9.2


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.