Table of Contents:


    Follow us

    Standard columns in Oracle E-Business Suite database

    Michal Wrobel - Dataedo Team Michal Wrobel 2018-10-04 2019-01-30

    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.

    Share this article

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