PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PeopleSoft record key field vs Oracle record primary key

edited Apr 23, 2014 12:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Hi,

In otherwords, how PeopleSoft record key field information stored at the Oracle database level..?  I want to query oracle metadata table ALL_CONSTRAINTS to verify or validate if a particular PeopleSoft record has any key fields. Assuming in Oracle database level it will be stored as Primary key. My understanding is that, at Oracle database level, primary key field will have constraint_type as "P", but it appears that all PeopleSoft record fields are stored as "C" check constraint on a table. Coud someone explain this or any other alternateway to identify the key fields..?  I know we may be able to

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center