OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » primary keys for OM tables

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

primary keys for OM tables [message #643244]

Thu, 01 October 2015 10:54

oracle2k15
Messages: 3
Registered: September 2015
Location: Atlanta

Junior Member

Hi,
The below query returns only check type constraints.
How do we get the primary keys?
SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME='OE_ORDER_HEADERS_ALL'
Can you please advise?
Thanks,
Jaya

Report message to a moderator

Re: primary keys for OM tables [message #643246 is a reply to message #643244]

Thu, 01 October 2015 12:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The below query returns only check type constraints.
above is completely & utterly INCORRECT

when all else fails, Read The Fine Manual

https://docs.oracle.com/database/121/REFRN/GUID-9C96DA92-CFE0-4A3F-9061-C5ED17B43EFE.htm#REFRN20047

Report message to a moderator

Re: primary keys for OM tables [message #643247 is a reply to message #643246]

Thu, 01 October 2015 12:28

oracle2k15
Messages: 3
Registered: September 2015
Location: Atlanta

Junior Member

Thanks BlackSwan.
I know this query returns all type of constraints on the table. That was not my question.

I was reading in one of the links that we can make indexes invisible to user. Since i did not see any PK for oe_order_headers, i was wondering if there is a similar property for hiding PKs.. But i just figured out, there is no such property.
Oracle prefers to create unique keys instead of PKs.

Report message to a moderator

Re: primary keys for OM tables [message #643248 is a reply to message #643247]

Thu, 01 October 2015 12:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

oracle2k15 wrote on Thu, 01 October 2015 10:28

Thanks BlackSwan.
I know this query returns all type of constraints on the table. That was not my question.

I was reading in one of the links that we can make indexes invisible to user. Since i did not see any PK for oe_order_headers, i was wondering if there is a similar property for hiding PKs.. But i just figured out, there is no such property.
Oracle prefers to create unique keys instead of PKs.

You can use non-unique INDEX (not "key") to work with Primary Key constraint.

Report message to a moderator

Re: primary keys for OM tables [message #643261 is a reply to message #643244]

Fri, 02 October 2015 01:03

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

oracle2k15 wrote on Thu, 01 October 2015 16:54

Hi,
The below query returns only check type constraints.
How do we get the primary keys?
SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME='OE_ORDER_HEADERS_ALL'
Can you please advise?
Thanks,
Jaya

I usually to to the Electronic Technical Reference Manual for this sort of thing, on etrm.oracle.com
Attached - all the keys on that table.

Attachment: FND Design Data.html
(Size: 30.05KB, Downloaded 2988 times)

Report message to a moderator

Previous Topic:	Inventory Accounting Periods
Next Topic:	Need to disable PO Line Quantity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 01:16:15 CST 2024