Friday, January 18, 2008

_ALL, _TL, _VL, _V,_F,_VL,_A,_AVN objects

we all find different objects with
lots of suffixes...her i am putting the meaning of some those
suffixes..i read this thing in one of the blogs i find it
good...so i am posting it as it will useful to understand these
things..

  • _ALL :
    Table holds all
    the information about different operating units. Multi-Org
    environment. You can also set the client_info to specific
    operating unit to see the data specific to that operating
    unit only.

  • _TL are
    tables corresponding to another table with the same name
    minus the _TL. These tables provide multiple language
    support. For each item in the table without _TL there can be
    many rows in the _TL table, but all with different values in
    the LANGUAGE column.

  • _B theseare the BASE tables. They are very important and the data is stored in the table with all
    validations.

    It is
    supposed that these table will always contain the perfect
    format data.


    If anything happens to the BASE table data, then it is a
    data corruption issue.

  • _F
    these are date tracked tables, which occur in HR and
    Payroll. For these there are two date columns
    EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together
    with the PK identifies a row uniquely. The date intervals
    cannot overlap. Many think they are Secured data. Guess
    someone from Oracle confirms.


  • _V tables
    are the views created on base tables

  • _VL are
    views for multi language tables which combines the row of
    the base table with the corresponding row of the _TL table
    where the LANGUAGE = USERENV(’LANG’).

  • _S are
    sequences, used for finding new values for the primary key
    of a table.

  • _A
    are Audit Shadow Tables

  • _AVN and
    _ACN are Audit
    Shadow Views (when data was changed, and with what values

1 comment:

Unknown said...

I am Sridevi Koduru, Oracle Apps Techno Functional Faculty with 6 Years Training Experience on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K including 3+ Years of Real Time Experience. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact Me for Offline and Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at sridevioracleapps@gmail.com | +91-9581017828 | http://www.oracleappstechnical.com

My Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/