Oracle EBS database schema has a number of standard columns. Here is a list of most important ones.

Metadata columns

• CREATION_DATE - date and time row was created
• CREATED_BY - login of user that created row
• LAST_UPDATE_DATE - date and time row was last modified
• LAST_UPDATED_BY - login of user last modifying row
• LAST_UPDATE_LOGIN - login of user last modifying row
• OBJECT_VERSION_NUMBER - Object version number
• PROGRAM_ID - Program identifier of last concurrent program to update this record
• PROGRAM_APPLICATION_ID - Application identifier of last concurrent program to update this record
• BATCH_ID - Identifier to identify a set of records processed as a batch

Object IDs

Oracle EBS has following notation of row ids: <object_name>_id

Here are most popular row id columns:

• INVENTORY_ITEM_ID
• BUSINESS_GROUP_ID
• SET_OF_BOOKS_ID
• PROJECT_ID
• TASK_ID
• TRANSACTION_ID
• USER_ID

Customizations

• ATTRIBUTE1-30 - Descriptive flexfield segments

Comments

• COMMENTS - Comments field
• DESCRIPTION - Description field

Organization identifiers

• ORG_ID
• ORGANIZATION_ID

Status and validity

• STATUS_CODE
• ENABLED_FLAG
• DELETED_FLAG
• START_DATE_ACTIVE
• END_DATE_ACTIVE
• START_DATE
• END_DATE

Localization

• LANGUAGE
• CURRENCY_CODE

We found these columns with this query of most popular columns in a database.