OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » diff tables in apps

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

diff tables in apps [message #115098]

Thu, 07 April 2005 08:12

gorge
Messages: 2
Registered: March 2005
Location: usa

Junior Member

please any body give me the details of

different types of tables and what are those meaning
why we use those types

why _vl,_all,_v,_b,_S

Report message to a moderator

Re: diff tables in apps [message #115206 is a reply to message #115098]

Fri, 08 April 2005 02:51

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

Of the tables you mention and some others

_ALL are multi-org tables.
_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.
_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.
_B I am not quite sure about these.

Not all of the "tables" you mention are tables.

_V are views.
_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.

--
Aleksander

Report message to a moderator

Re: diff tables in apps [message #115318 is a reply to message #115206]

Sat, 09 April 2005 10:35

gorge
Messages: 2
Registered: March 2005
Location: usa

Junior Member

Hi adragnes,

Thanks for ur reply.

Report message to a moderator

Re: diff tables in apps [message #115387 is a reply to message #115206]

Mon, 11 April 2005 01:46

vikrams
Messages: 23
Registered: November 2000
Location: Dubai

Junior Member

Hi,
Thanks for the information.

About the _B, these are the BASE tables.
They are very important and the data is stored in the these 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.
If you are aware of the kind of architecture used by Oracle/RDBMS, then you should understand this.

Thanks and regards,
Vikram

Report message to a moderator

Re: diff tables in apps [message #148289 is a reply to message #115387]

Wed, 23 November 2005 07:40

altasen.com
Messages: 38
Registered: November 2005

Member

Hi,

a nice list. Two more are:
_A are Audit Shadow Tables
_AVn and _ACn are Audit Shadow Views (when data was changed, and with what values)

Qui Thai
More info on Tech Apps in the free Knowledge Base on
http://www.altasen.com

Report message to a moderator

Previous Topic:	Different types of table in 11i
Next Topic:	OPM 11.5.10 Setup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 10:08:27 CDT 2024