How to fix the Oracle error LSX-00149: duplicated ID specified in “~S”?

In this post, you’ll learn more about the Oracle ErrorLSX-00149: duplicated ID specified in “~S” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LSX-00149: duplicated ID specified in “~S”

Reason for the Error LSX-00149: duplicated ID specified in “~S”

Cause: An attempt was made to specify two distinct members of {attribute uses}with {attribute declaration}s, both of whose {type definition}s are from ID or are derived from ID.

How to fix the Error LSX-00149: duplicated ID specified in “~S” ?

You can fix this error in Oracle by following the below steps

Action: Declare only one member of the {attribute uses} whose {type definition} is from ID or will be derived from ID.