none
TS837_2000A_Loop is an invalid child element? RRS feed

  • Question

  • Has anyone seen this error before?

     

    C:\Users\Pauli\AppData\Local\Temp\2\_MapData\HIPAA837_5010\Map1_output.xml: error btm1046: Output validation error: The element 'X12_00501_837_P' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006' has invalid child element 'TS837_2000A_Loop' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'. List of possible elements expected: 'ST' as well as 'BHT_BeginningofHierarchicalTransaction' in namespace 'http://schemas.microsoft.com/BizTalk/EDI/X12/2006'.

    T

    Tuesday, April 5, 2011 10:10 PM

Answers

  • Getting the SQL schema exactly as same as X12 837 Schema is quite difficult unless your tables are in sync with the X12 structure. You have to make use of BizTalk Map to achieve the mapping

    With just the header and detail table as you mentioned, for mapping the 2300 loop you can use the index functoid in Map to get the first record and mapp it 2300.

    For 2400 loop you using looping functoid to loop through all the records and map it.


    Sathish - http://blog.tsathish.com - Please Indicate "Mark as Answer" if this Post has Answered the Question
    Thursday, April 7, 2011 6:53 PM

All replies

  • Hi,

    These are the mandatory elements which are not getting mapped. Please map them and this will fix the problem.

     


    Best Regards, Vishnu
    Wednesday, April 6, 2011 4:19 AM
  • Hi Piancu,

    Did you check you input test file that contains ST01_TransactionSetIdentifierCode as 837 and ST03_ImplementationGuideVersionName has 005010X222 similar for 'BHT_BeginningofHierarchicalTransaction' Loop check the values in schema throughly.

    Thanks,

    Rajesh

    Wednesday, April 6, 2011 5:52 AM
  • Hi, 

    Error message specifies you are not populating ST and BHT segments properly and you are populating the required segements/elements in the 2000A loop

     


    Sathish - http://blog.tsathish.com - Please Indicate "Mark as Answer" if this Post has Answered the Question
    Wednesday, April 6, 2011 5:48 PM
  • Thanks, Yes, I have to populate those as well as others that cause errors when I test my map.

    On a different tangent, let's say you have two tables (a header and detail table) which store 5010 837P information.  The tables can be joined on an id so that you can link the claim header to the claim lines. I need to generate a schema for this source SQL data which will allow me to map the columns to the 5010 XML Schema. Any tips would be appreciated about how this schema should be generated and how it should look like.

    Paul

    Wednesday, April 6, 2011 7:05 PM
  • If you are using SQL Adapter then you can try as below to generate the Schema

    select

       hdr.*,dtl.*

    from

     header hdr inner join detail dtl

    on hdr.id = dtl.id FOR XML AUTO



    Sathish - http://blog.tsathish.com - Please Indicate "Mark as Answer" if this Post has Answered the Question
    Thursday, April 7, 2011 2:40 AM
  • Thank you, I had already done this. I didn't phrase my question correctly.

    My question is how to map the header data and claim line data to the 2300 and 2400 loops.

    The id from header will be repeated for each claim line. If I link the hdr id through a looping functoid to the TS837_2300_Loop, won't this generate duplicate 2300 loops?

    For the 2400 loop, how should I link this to the detail data?  Do I connect both the id from hdr and id from detail to a looping functoid and then to the 2400 loop?

     

    Thursday, April 7, 2011 5:26 PM
  • Getting the SQL schema exactly as same as X12 837 Schema is quite difficult unless your tables are in sync with the X12 structure. You have to make use of BizTalk Map to achieve the mapping

    With just the header and detail table as you mentioned, for mapping the 2300 loop you can use the index functoid in Map to get the first record and mapp it 2300.

    For 2400 loop you using looping functoid to loop through all the records and map it.


    Sathish - http://blog.tsathish.com - Please Indicate "Mark as Answer" if this Post has Answered the Question
    Thursday, April 7, 2011 6:53 PM