Search This Blog

Sunday, March 16, 2008

Different Types of Table in Oracle Apps

In oracle applications there are tables that ends with similar suffixes. Here I am trying to list the meaning of those, please provide your suggestion and help me if I have missed anything.

_B The Main base tables
_ALLContains multi org data. There will be similar table without _ALL. Before querying this data the environment variable needs to be set. Dbms_application_info.set_client_info('org_id'), or apps_initialize can be used to set the environment variable.common column.
_VView created on base table. Mostly forms are created based on this views
_TL Tables that support multi language.
_VL View created on multi language tables. The view generally uses the base table and _tl table
_F This indicates that these are the date tracking tables. These tables are generally seen for HRMS and contain 2 common columns effective_start_date and effective_end_date
_S sequence related tables
_DFV /_KFV The DFF/KFF table created on the base table. This is the best way to get the concatenated value of DFF/KFF.
Also using this table the values can be queried based on the DFF/KFF name and not attributes column.

2 Comments:

Rama Krishna Mateti said...

Suresh,

Great Work!Keep it up....
and please have a glance on the following things.

1)Suffix should be used instead of prefix since suffix is to be placed at the end of the word while prefix is present at the beginning.
2)_KFV is the view which contains all the information about Key Flex Fields while _DFV is the view which contains the information about DFF.

Thanks,
Rama Krishna Mateti

Suresh Vaishya said...

Thanks Rama for your review and comment. Appreciate that.

Copyright (c) All rights reserved. Presented by Suresh Vaishya