Skip to main content

Table Suffixes of EBS

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 tables 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
Labels:

Comments

  1. AnonymousJanuary 27, 2009 at 2:15 PM

    Excellent document , keep this continue

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Payroll R12 - Payroll Processing 1

Hi , This is the last part of Payroll Tutorial, In this video , we will see how payroll process for an individual person through Quick Pay and how Payroll process for all Employees through Payroll Run Process and Prepayments process for payment distribution. In the next tutorial we will see more processes in detail for complete payroll processing.
43 comments
Read more

Oracle Payroll R12 - Salary Basis

Hi All, This is the 3rd part of Oracle Payroll Tutorial , Salary Basis is the main Salary Component of Salary Structure. The Other Salary Components are driven by this components. So Ideally there should be one or two Salary Components.You can not attach multiple salary basis to single assignment of the employee. Kindly send your feed back.
20 comments
Read more

Oracle Payroll Costing Concept

To understand Payroll Costing concept, I would first discuss the Costing Allocation Key Flex field, during the business group definition it is being created and map with Cost Allocation KFF with following segments normally • Company • Cost Centre • Natural Account During the configuration of Cost Allocation KFF the most important concept is to set the Flex Field Qualifiers at each segment level, we have the five levels available for each segment i.e. • Payroll • Balancing • Organization • Element Link • Assignment • Element Entry For the Company segment following setting can be applied Payroll Checked Balancing Checked This setting will explain that the Company Account will be input at Payroll level (debit information) and balancing information will goes into credit information and on every segment level it is mandatory to define Balancing. For the Cost Centre segment, I can set the following setting Payroll Checked Organization checked Balancing checked This setting will explain t...
80 comments
Read more