Tuxedo tpxmltofml() Does Not Convert Empty XML Tags Tnto FML Fields (Doc ID 1290208.1)

Last updated on MARCH 07, 2011

Applies to:

Oracle Tuxedo - Version: 9.1 and later   [Release: and later ]
Linux x86
IBM AIX on POWER Systems (32-bit)

Symptoms

tpxmltofml function does not convert all empty tags in xml file to FML fields.

This is the input xml:


<FML32>
<OPV_EID>576207140</OPV_EID>
<OPV_EID>576199567</OPV_EID>
<PAT_CITY></PAT_CITY>
<PAT_CITY>DEERFIELD</PAT_CITY>
<OPV_PAT_STATE></OPV_PAT_STATE>
<OPV_PAT_STATE>IL</OPV_PAT_STATE>
<PAT_STREET_ADDR>300 WILMOT</PAT_STREET_ADDR>
<PAT_STREET_ADDR>300 WILMOT RD</PAT_STREET_ADDR>
<PAT_ZIP></PAT_ZIP>
<PAT_ZIP>600154614</PAT_ZIP>
<PAT_BIRTH_DTTM>12/16/1995 00:00:00</PAT_BIRTH_DTTM>
<PAT_BIRTH_DTTM>11/22/1995 00:00:00</PAT_BIRTH_DTTM>
<PAT_EMAIL_ADDRESS>~</PAT_EMAIL_ADDRESS>
<PAT_EMAIL_ADDRESS>~</PAT_EMAIL_ADDRESS>
<PAT_FIRST_NAME>ECOMMERCE</PAT_FIRST_NAME>
<PAT_FIRST_NAME>NOVEMBER</PAT_FIRST_NAME>
<PAT_LAST_NAME>DECPATIENT</PAT_LAST_NAME>
<PAT_LAST_NAME>NEWPATIENTS</PAT_LAST_NAME>
<PAT_MID_INIT></PAT_MID_INIT>
<PAT_MID_INIT></PAT_MID_INIT>
<PAT_SURNAME_SUFFIX></PAT_SURNAME_SUFFIX>
<PAT_SURNAME_SUFFIX></PAT_SURNAME_SUFFIX>
<OPV_CELL_AREA_CD>~</OPV_CELL_AREA_CD>
<OPV_CELL_AREA_CD>847</OPV_CELL_AREA_CD>
@ <OPV_CELL_PHONE>~</OPV_CELL_PHONE>
@ <OPV_CELL_PHONE>9145360</OPV_CELL_PHONE>
</FML32>|


and this is the FML buffer


194: 12/23 10:49:46
----------------------------------------------------------------------------
195: 12/23 10:49:46 Field-NameIndex# FML ID
<Value>
196: 12/23 10:49:46 -----------------------
-------
197: 12/23 10:49:46 OPV_EID 0 167774908
<576207140>
198: 12/23 10:49:46 OPV_EID 1 167774908
<576199567>
199: 12/23 10:49:46 OPV_CELL_AREA_CD0 167774935
<~>
200: 12/23 10:49:46 OPV_CELL_AREA_CD1 167774935
<847>
@ 201: 12/23 10:49:46 OPV_CELL_PHONE0 167774936
<~>
@ 202: 12/23 10:49:46 OPV_CELL_PHONE1 167774936
<9145360>
203: 12/23 10:49:46 OPV_PAT_STATE 0 167775013
<IL>
204: 12/23 10:49:46 PAT_BIRTH_DTTM0 167777730
<12/16/1995 00:00:00>
205: 12/23 10:49:46 PAT_BIRTH_DTTM1 167777730
<11/22/1995 00:00:00>
206: 12/23 10:49:46 PAT_CITY0 167777733
<DEERFIELD>
207: 12/23 10:49:46 PAT_FIRST_NAME0 167777741
<ECOMMERCE>
208: 12/23 10:49:46 PAT_FIRST_NAME1 167777741
<NOVEMBER>
209: 12/23 10:49:46 PAT_LAST_NAME 0 167777749
<DECPATIENT>
210: 12/23 10:49:46 PAT_LAST_NAME 1 167777749
<NEWPATIENTS>
211: 12/23 10:49:46 PAT_STREET_ADDR 0 167777772
<300 WILMOT>
212: 12/23 10:49:46 PAT_STREET_ADDR 1 167777772
<300 WILMOT RD>
213: 12/23 10:49:46 PAT_ZIP 0 167777777
<600154614>
214: 12/23 10:49:46 PAT_EMAIL_ADDRESS 0 167781080
<~>
215: 12/23 10:49:46 PAT_EMAIL_ADDRESS 1 167781080
<~>
216: 12/23 10:49:46 ------------------------------ End of FML Dump
-----------------------------



You can see that the all the empty tags in XML file are not present in FML.

Cause

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