LSX-00204 error on 12c
Last updated on MARCH 07, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms