Home » Applications » Oracle Fusion Apps & E-Business Suite » primary keys for OM tables
primary keys for OM tables [message #643244] Thu, 01 October 2015 10:54 Go to next message
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
Re: primary keys for OM tables [message #643246 is a reply to message #643244] Thu, 01 October 2015 12:22 Go to previous messageGo to next message
BlackSwan
Messages: 26733
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
Re: primary keys for OM tables [message #643247 is a reply to message #643246] Thu, 01 October 2015 12:28 Go to previous messageGo to next message
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.

Re: primary keys for OM tables [message #643248 is a reply to message #643247] Thu, 01 October 2015 12:33 Go to previous messageGo to next message
BlackSwan
Messages: 26733
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.


Re: primary keys for OM tables [message #643261 is a reply to message #643244] Fri, 02 October 2015 01:03 Go to previous message
John Watson
Messages: 8344
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.
Previous Topic: Inventory Accounting Periods
Next Topic: Need to disable PO Line Quantity
Goto Forum:
  


Current Time: Sun Sep 20 05:41:44 CDT 2020