FreeLists / oracle-l / Re: Oracle 11i Data Model

["John Kanagaraj" <john.kanagaraj@xxxxxxxxx>]

Almost every "Apps" DBA has had this issue at one point or another. Remember
that Oracle "Financials" (which evolved into E-Biz Suite) started way back
in the good ole days of Oracle V6 when referential integrity was not
supported (i.e. it was called "declarative" in that you can declare it, but
the RDBMS would ignore it). I believe some of the later modules (HR comes to
mind) do have that, but the older modules do not.

Anyway - Rel 12 is already out and "Fusion Confusion" is apparently around
the corner. Would be interesting to see if Fusion does have this
information.... (Don't think Rel 12 does).

Regards
-- 
John Kanagaraj <><
DB Soft Inc
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

On 8/1/07, Suresh Chaganti <chaganti.suresh@xxxxxxxxx> wrote:
>
> After attending Siebel training some time back, this question came up.
>
> In siebel, they have tools in which all the realtions between tables
> including referential integrity is documented and queried. I understand this
> is pretty much same is peoplesoft as well.
>
>
>
> Oracle 11i model doesn have PK/FK defined for majority of the tables. For
> example, PO_header_id in po_vendors_all is NOT a primary key, but a check
> constraint with not null condition. Also there is no PK/FK between
> po_headers_all and po_lines_all, as defined at the DB level.
>
> For Oracle, I know there are TRMs and I use them a lot. But to my
> knowledge, there is no "data dictionary" about application tables that would
> help use derive realtions by querying with in the application.
>
> Is there an approach / method to derive relationships instead of looking
> at ERDs in TRMs? I guess I am asking is there something equivalent to what
> Siebel/peoplesoft provide in this area
>
> Thanks in advance
>
>
>