In this post, you’ll learn more about the Oracle ErrorLSX-00172: “~S” is not a valid restriction of “~S” with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
LSX-00172: “~S” is not a valid restriction of “~S”
Reason for the Error LSX-00172: “~S” is not a valid restriction of “~S”
Cause: The schema component constraint, Derivation Valid (Restriction, Complex) or Particle Valid (Restriction), was violated.
How to fix the Error LSX-00172: “~S” is not a valid restriction of “~S” ?
You can fix this error in Oracle by following the below steps
Action: Modify the base type (particle) or the restricted type (particle) definition.