How to fix the Oracle error LSX-00152: only “minOccurs”, “maxOccurs”, or “id” is allowed?

In this post, you’ll learn more about the Oracle ErrorLSX-00152: only “minOccurs”, “maxOccurs”, or “id” is allowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LSX-00152: only “minOccurs”, “maxOccurs”, or “id” is allowed

Reason for the Error LSX-00152: only “minOccurs”, “maxOccurs”, or “id” is allowed

Cause: If the item’s parent is not and “ref” is present, then “complexType”, “simpleType”, “key”, “keyref”, “unique”, “nillable”, “default”, “fixed”, “form”, “block”, and “type” must be absent.

How to fix the Error LSX-00152: only “minOccurs”, “maxOccurs”, or “id” is allowed ?

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

Action: Remove the prohibited attribute.