Import and Export File Format

When you import and export data forOracle E-Business Suite General Ledger dimensions, you must use a comma-delimited (.csv) file.

Considerations

  • The import file's data is imported in row order. Rows for parent nodes must precede rows for child nodes. If a child node's row precedes its parent node's row, an error occurs when the file is imported.
  • The import ignores duplicate rows.
  • Strings that contain the delimiter, quote, or line terminator (CR/LF) character for the file or that start with characters from ASCII 35 and below (such as Tab, ! or #) will be surrounded by quotes. (For example, "# Children", "Accumulated Depreciation, Equipment".)

The following table describes the comma-delimited file's format in relation to E-Business Suite General Ledger staging tables.

Staging Table Column File Header File Content

VALUE_SET_CODE

VALUE_SET_CODE

Constant - Set to the Segment Value Set Code

VALUE

VALUE

Core.Name

STATUS

N/A

N/A

Not included in export file

START_DATE_ACTIVE

START_DATE_ACTIVE

EBSGL.Start Date

END_DATE_ACTIVE

END_DATE_ACTIVE

EBSGL.End Date

SUMMARY_FLAG

SUMMARY_FLAG

EBSGL.Summary

SORT_ORDER

SORT_ORDER

CoreStats.Level

ENABLED_FLAG

ENABLED_FLAG

EBSGL.Enabled

ACCOUNT_TYPE

ACCOUNT_TYPE

EBSGL.Account Type

ALLOW_POSTING

ALLOW_POSTING_FLAG

EBSGL.Allow Posting

ALLOW_BUDGETING

ALLOW_BUDGETING_FLAG

EBSGL.Allow Budgeting

THIRD_PARTY_CTRL_ACCT

THIRD_PARTY_CTRL_ACCOUNT

EBSGL.Third Party Control Account

RECONCILE

RECONCILE_FLAG

EBSGL.Reconcile

FINANCIAL_CATEGORY

FINANCIAL_CATEGORY

EBSGL.Roll Up Group

DESC_AR

DESC_US

Either the property for the Description like EBSGL.Description US or a Constant Value of Blank

If used as an active language then a property will be used to hold the value otherwise it is just a blank column.

DESC_CS

DESC_AR

 

DESC_D

DESC_CS

 

DESC_DK

DESC_D

 

DESC_E

DESC_DK

 

DESC_EL

DESC_E

 

DESC_ESA

DESC_EL

 

DESC_F

DESC_ESA

 

DESC_FRC

DESC_F

 

DESC_HR

DESC_FRC

 

DESC_HU

DESC_HR

 

DESC_I

DESC_HU

 

DESC_IS

DESC_I

 

DESC_IW

DESC_IS

 

DESC_JA

DESC_IW

 

DESC_KO

DESC_JA

 

DESC_NL

DESC_KO

 

DESC_LT

DESC_NL

 

DESC_PL

DESC_LT

 

DESC_PT

DESC_PL

 

DESC_PTB

DESC_PT

 

DESC_N

DESC_PTB

 

DESC_RO

DESC_N

 

DESC_RU

DESC_RO

 

DESC_S

DESC_RU

 

DESC_SF

DESC_S

 

DESC_SK

DESC_SF

 

DESC_SL

DESC_SK

 

DESC_TH

DESC_SL

 

DESC_TR

DESC_TH

 

DESC_US

DESC_TR

 

DESC_ZHS

DESC_ZHS

 

DESC_ZHT

DESC_ZHT