My Oracle Support Banner

LSX-00204 error on 12c (Doc ID 2370598.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


Script works fine on 11g and fails with LSX-00204 error on 12c.


User can get the authorization details by passing input as [authorization number] (or) [start date, end date, provider]. Response will be sent in xml format from PL/SQL.

Issue in technical:

As per xsd, there is a ¿choice¿ element defined for the parent tag <auth_status_criteria>. This tag should be having any one of the choice[eitherauthorization number or (start date and end date)] to be successful through the xml schema validation. In 12C during the xml conversion using xmltype function, it is including both the option available in choice element which causes failure as per the xsd configuration, because it should have only any one of the choice values but not both. But in 11G it works fine as xml is created successfully with only one choice option.

If User wants to get authorization details by passing authorization number in the ¿choice¿ input. Using the input, plsql program navigate through the tables and retrieving all the authorization details and finally converting the those details into xml format with the help of registered xsd and using xmltype function as below.

XMLTypeResponse := xmltype(xmlData => NavimedixResponse,
schema => 'v' || version || '.' ||
element => cns_Top_XML_Response_Element);

During the conversion, it should give only the requested choice from the user which is authorization number, but unexpectedly in 12C region we are getting all both the options from the choice tag.
Expected as below on 11g:


What originally happened in 12C:

Due to this it is getting failed while validating against the xsd (XMLTypeResponse.schemaValidate()) as only one choice option is expected causing that error on 12c.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.