Date and Number Validations for General Ledger Descriptive Flexfields

You can define date and number validations when setting up your Oracle General Ledger descriptive flexfields. These validations ensure the information captured using these additional fields is more accurate and consistent.

Here are the General Ledger flexfields that support both the date and number data types.

Flexfield Code	Name	Description
GL_ACCESS_SETS	Access Sets	Fields for access set details on the data access sets page.
GL_CAPTURED_INFO	Journals Captured Information	Fields for captured information details on the journal entry page.
GL_CODE_COMBINATIONS	General Ledger Accounts	Fields for account combination details on the account combinations page.
GL_DAILY_RATES	Daily Rates	Fields for daily rate details in the currency rates manager.
GL_JE_BATCHES	Journal Batches	Fields for journal batch details on the journal entry page.
GL_JE_CATEGORIES	Journal Categories	Fields for category details on the Journal Categories page.
GL_JE_HEADERS	Journals	Fields for journal details on the journal entry page.
GL_JE_LINES	Journal Lines	Fields for journal line details on the journal entry page.
GL_JE_SOURCES	Journal Sources	Fields for source details on the journal sources page.
GL_LEDGERS	Ledgers	Fields for ledger details on the ledgers page.
GL_PERIOD_STATUSES	Open and Close Periods	Fields for period status details on the period statuses page.
GL_PERIODS	Accounting Calendar Periods	Fields for accounting period details on the accounting calendars page.
GL_TRANSACTION_DATES	Transaction Dates	Fields for calendar date details on the transaction calendars page.

You can define validations on up to five date and five number columns.

The column names for the Date data type are ATTRIBUTE_DATE1 through ATTRIBUTE_DATE5 and the column names for the Number data type are ATTRIBUTE_NUMBER1 through ATTRIBUTE_NUMBER5. For the Journals Captured Information descriptive flexfield, the date columns are ATTRIBUTE_DATE6 through ATTRIBUTE_DATE10 and the number columns are ATTRIBUTE_NUMBER6 through ATTRIBUTE_NUMBER10.

Here are the file-based data import templates and desktop-integrated Excel workbooks that can use both the date and number fields as additional validations.

Name	Type	Related Descriptive Flexfields
Create Journal	ADF Desktop Integration	Journals Captured Information, Journal Lines
Import Account Combinations	File-Based Data Import	General Ledger Accounts
Import and Calculate Daily Rates	File-Based Data Import	Daily Rates
Journal Import	File-Based Data Import	Journals Captured Information, Journal Lines