EBS on Oracle Cloud Infrastructure (MOSC)

MOSC Banner

Why are Primary-key and Unique-key constraints disabled in Fusion Saas

Hi Experts,

While investigating an issue I surprisingly found that most of the primary keys and unique key constraints are disabled in Fusion SaaS.

For example, If I run the below query, I can see that these constraints are in disabled status for all AP Tables in Fusion.

Is there any reason behind this?

SELECT constraint_name, table_name, status, validated
FROM all_constraints
where 1=1
and upper(table_name) like 'AP%'
and owner = 'FUSION'
and constraint_type in ('U','P')

Thank you in advance for any information.

Best regards,

Prakash

Tagged:

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