You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

edited May 7, 2024 2:44PM in Financials – General (READ ONLY) 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!