Standard columns in Oracle E-Business Suite database

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.

0
There are no comments. Click here to write the first comment.