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:
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/
Post a Comment