Infolinks

Saturday, 21 July 2012

Naming convention of oracle apps DB objects

Naming convention of oracle apps DB objects


Following is the naming convention that oracle apps uses on its Database objects:

Object name ending with
Description of the Object
_B
The Main base tables
_ALL
Contains multi-org data
_V
View created on base table
_TL
Table that supports multi language
_VL
View created on multi language tables
_F
Data tracking tables. Used in HRMS
_S
Sequence related table
_DFV / _KFV
The DFF/KFF table created on the base table

No comments:

Post a Comment