Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

_ALL, _TL, _VL, _V,_F,_VL,_A,_AVN and what else..

Posted on May 2nd, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Very common thing, people get confuse why such type of naming convention oracle have used. Here is note for some of them:

  • _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 these are 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

Related Posts

Posted in 11i, EBS Suite, Oracle Application | 6 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
6 Responses
  1. pavan Says:

    excellent effort Anand…thanks alot

  2. Reddy Says:

    wow.. what a post this is. It is such a crucial information which needs to be known.

  3. Dinesh Says:

    _MRC_V
    MRC (Multiple Reporting Currency) is supported by the following Oracle Applications:
    Oracle Assets,Oracle Cash Management, Oracle Cost Management, Oracle General Ledger, Oracle Global Accounting Engine, Oracle Payables, Oracle Receivables, Oracle Purchasing, Oracle Projects
    For the subledgers that support

  4. Anil Reddy Says:

    Good thing to know….

  5. chowdary Says:

    how to get oracle apps technical documents and faqs

  6. Guru Says:

    Thanks Anand, for ur valuable Info.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.