GL_INTERFACE Table Basics

 

GL_INTERFACE table is the main interface table to import journals into GL. This is one of the best automatic way to import the entries into Oracle GL. 

 

 

What values can be entered into the optional columns (i.e Reference Fields) in the GL_INTERFACE table?

You can enter values for many optional columns in the GL_INTERFACE table.  Enter values in these columns for maximum control over the way Journal Import groups the journal entry lines it creates into journal entries.

 

If you have enabled average balance processing, Journal Import will group transactions by Accounting Date.  Transactions are grouped before they are validated and, if the Effective Date Rule is Roll Date, rolled to the nearest valid business day within the period.

 

If you do not enter a value in an optional column and a default value exists for that particular column, Journal Import automatically enters the default value.

 

Enter values in the following optional columns of the GL_INTERFACE table:

 

REFERENCE1 (Batch Name):  Enter a batch name for your import batch. Journal Import

creates a default batch name using the following format. Take the first 85 characters of:

(Source) (Balance type- A, B, or E) (Group ID) then add a space followed by the

concurrent request ID. If the above results in multiple batches in same Journal Import

run with the same name, then additional characters are chopped off, and a 2, 3, 4, and

so on, is added for the second, third, fourth, batches with the same name.

The batch name must be unique for each combination of charts of accounts, accounting

calendar, and period type.

 

REFERENCE2 (Batch Description): Enter a description for your batch.

If you do not enter a batch description, Journal Import automatically gives your batch a description

using the format: Journal Import (Source) (Request Id).

 

REFERENCE4 (Journal entry name):  Enter a journal entry name for your journal entry.

Journal Import creates a default journal entry name using the following format:

(Category Name) (Currency) (Encumbrance Type ID, if applicable) (Currency

Conversion Rate, if applicable) (Currency Conversion Date, if applicable) (Originating

Balancing Segment Value), chopped to the first 100 characters. If the above results in

multiple journals in the same batch with the same name, then additional characters are

chopped off, and a 2, 3, 4, and so on, is added for the second, third, fourth, journals with

the same name.

 

REFERENCE5 (Journal entry description): Enter a description for your journal entry.

If you do not enter a journal entry description, Journal Import automatically gives your

journal entry a description using the format: Journal Import - Concurrent Request ID.

 

REFERENCE6 (Journal entry reference): Enter a reference name or number for your journal entry.

If you do not enter a journal entry reference, Journal Import automatically creates a journal entry reference called

Journal Import Created.

 

REFERENCE7 (Journal entry reversal flag): Enter Yes to mark your journal entry for

reversal. If you do not enter Yes, Journal Import automatically defaults to No.

 

REFERENCE8 (Journal entry reversal period): Enter the name of the period to which

you want to reverse your journal entry. If you enter Yes in the REFERENCE7 column,

you must enter a value in this column.

If you have enabled average balance processing, enter the effective date for the reversal.

General Ledger will determine the appropriate reversal period based on the date you supply.

You can specify adjustment and non-adjustment reversal periods.

Note: The effective date only applies to Actual balances, not Budget or Encumbrance balances.

Note: If you enter Yes in the REFERENCE7 column, you must enter a value in this column.

 

REFERENCE9 (Journal reversal method): Enter Yes to use the change sign method, No

to use the switch debit/credit method.

 

REFERENCE10 (Journal entry line description): Enter a description for your journal entry line.

If you do not enter a journal entry line description, Journal Import uses the subledger document sequence value.

If there is no document sequence value, Journal Import creates a journal entry description called Journal Import Created.

 

REFERENCE21 through REFERENCE30: Enter a reference name or number to further

identify your import journal entry lines. Columns REFERENCE21 through REFERENCE30 map

into columns REFERENCE_1 through REFERENCE_10, respectively, of the GL_JE_LINES table.

 

Once in the GL_JE_LINES table, your General Ledger application prints the value

stored in REFERENCE_1 in standard reports run with Line detail, and prints the value

stored in REFERENCE_4 in standard reports run with Source detail. The other reference

columns are for descriptive or tracking purposes only. The values in these columns are

not used in your General Ledger application.

 

GROUP_ID: Enter a unique group number to distinguish import data within a source.

You can run Journal Import in parallel for the same source if you specify a unique

group number for each request.

 

STAT_AMOUNT: Enter the statistical amount associated with your journal entry line data.

You define statistical units of measure in the Statistical Units of Measure form of your General Ledger application.

You must use this column when you want to see statistical and monetary amounts in the same journal entry line.

 

USSGL_TRANSACTION_CODE: Enter a valid USSGL transaction code for your journal entry line.

Journal Import validates and imports the USSGL transaction codes when you have the profile option

Enable Transaction Code set to Yes, and you have defined your USSGL transaction codes using the

Public Sector Transaction Codes window.

Note: This column is ignored for commercial installations of General Ledger.

 

ATTRIBUTE1 throughATTRIBUTE 10: Enter values for your descriptive flexfield

"Journals - Journal Entry Line". The values you enter depend on how you defined your

descriptive flexfield in the Descriptive Flexfield Segments form.

 

ATTRIBUTE11 throughATTRIBUTE 20: Enter values for your descriptive flexfield

"Journals - Captured Information". The values you enter depend on how you defined

your descriptive flexfield in the Descriptive Flexfield Segments form. The context for

Journals - Captured Information is the natural account value of the account used on each line.

 

CONTEXT: Enter the context field value for the descriptive flexfield "Journals - Journal Entry Line"

that identifies the structure of your descriptive flexfield. If you enter a value, you can also enter some

combination of values in the columns ATTRIBUTE1 through ATTRIBUTE10.

 

CONTEXT2: Enter Yes to identify your Value Added Tax Descriptive Flexfield structure.

You must use this column if you import data for the Value Added Tax Descriptive Flexfield.

Enter No to indicate that your journal entry line is not a tax item.

If you enter No, the four Value Added Tax Descriptive Flexfield related columns must be null.

 

CONTEXT3: Enter the context field value (natural account) for the descriptive flexfield

"Journals - Captured Information" that identifies the structure of your descriptive flexfield.

Enter a value only if you are importing the descriptive flexfield "Journals - Captured Information" without validation.

If you enter a value, you can also enter some combination of values in the columns ATTRIBUTE11 through ATTRIBUTE20.

 

INVOICE_DATE: Enter the date on which you paid or collected tax on your tax journal entry line.

Enter the date in the format DD-MON-YY or the default date format for your language.

Your invoice date should correspond to the date when tax amounts were paid or received for this invoice.

You must use this column if you import data for the Value Added Tax Descriptive Flexfield.

 

INVOICE_AMOUNT: Enter an invoice amount. Enter the net invoice amount that relates

to your tax journal entry line amount. You must use this column if you import data for the

Value Added Tax Descriptive Flexfield.

 

TAX_CODE: Enter a valid tax code that identifies the type of tax paid for this invoice.

You define a list of valid tax codes for this field when you define your descriptive flexfield values.

You must use this column if you import data for the Value Added Tax Descriptive Flexfield.

 

REFERENCE_DATE: Enter a date to capture additional date information about your journal.

The Reference Date column satisfies Libro Giornale requirements in Italy, but can be used to capture

any other date information you want to store at the journal header level. This column is not used to group journal lines.

If multiple rows in the GL_INTERFACE table use different reference dates, they can be grouped into the same journal

entry which will choose a reference date from one of the rows to use as a reference date for the journal entry.

 

JGZZ_RECON_REF: Enter a reconciliation reference to identify a group of journal lines that need to net to zero.

 

AVERAGE_JOURNAL_FLAG: Set to Y (Yes) when importing average balance journals

into an average balances consolidation ledger. The flag indicates whether this journal

affects the average balances and not the standard balances.

 

ORIGINATING_BAL_SEG_VAL: Enter a clearing balancing segment value.

You can use this column if you are entering an intercompany transaction and want to override

the default clearing balancing segment.

 

INVOICE_IDENTIFIER: Enter an invoice identifier. Enter reference information about

the source document or invoice upon which you paid or collected tax. You must use

this column if you import data for the Value Added Tax Descriptive Flexfield.

 

LEDGER_ID: Enter the appropriate ledger ID for your transaction. Use this column if you need

to import data from applications on Release 11i or earlier that use the set of books ID.