1. Interoperability Guide
  2. Importing Flat Files Using a Business Function

Importing Flat Files Using a Business Function

If you are on a Windows platform, you can use the business function named Import Flat File To JDE File (B4700240). Because of changes to server operating systems and the various ways that operating systems store files, JD Edwards EnterpriseOne supports the business function only when run from a Windows platform. If you use the Import Flat File To JDE File (B4700240) business function, note these constraints:

  • Transaction Type and Flat File Name fields must contain data.

  • Only one character is allowed in the Record Type field.

  • The maximum length per line is 4095 characters.

  • The maximum record types are 40.

  • Every line must have a record.

  • The text qualifier cannot be the same as the column delimiter.

To ensure that flat file data is properly formatted before it is inserted into interface tables, the business function uses the F98713 table to obtain primary index key information. Normally, the F98713 table is located under the Default Business Data table mapping in the Object Configuration Manager. So that the business function can find the F98713 table, you must take one of these actions:

  • Map the F98713 table in the system data source.

  • Ensure the F98713 table exists in the business data source.