Mapping XML to EDI - Error (7: Missing or invalid transaction set control number)

I need some help please, new to BizTalk 2013...

Using the original XML created by BizTalk from Passing in a 837 file and having it convert to XML. I keep getting this error when passing the file back in from SQL.

If I change the sendport to Passthru I can see the XML file is being created just fine.   But once I change to EDISend I start getting an error.   Mapping from a created XML schema to the standard x12_837_P schema.

Error: 1 (Miscellaneous error)

7: Missing or invalid transaction set control number

Error: 2 (Miscellaneous error)

3: Transaction Set Control Number Mismatch

Error: 3 (Miscellaneous error)

4: Number of included segments do not match

Error: 4 (Field level error)

SegmentID: ST

Position in TS: 1

Data Element ID: ST01_TransactionSetIdentifierCode

Position in Segment: 1

Data Value:

1: Mandatory data element missing

Error: 5 (Field level error)

SegmentID: ST

Position in TS: 1

Data Element ID: ST02_TransactionSetControlNumber

Position in Segment: 2

Data Value:

1: Mandatory data element missing

Error: 6 (Field level error)

SegmentID: ST

Position in TS: 1

Data Element ID: ST03_ImplementationGuideVersionName

Position in Segment: 3

Data Value:

1: Mandatory data element missing

Error: 7 (Field level error)

SegmentID: BHT

Position in TS: 2

Data Element ID: BHT01_HierarchicalStructureCode

Position in Segment: 1

Data Value:

1: Mandatory data element missing

Error: 8 (Field level error)

SegmentID: BHT

Position in TS: 2

Data Element ID: BHT02_TransactionSetPurposeCode

Position in Segment: 2

Data Value:

1: Mandatory data element missing

Error: 9 (Field level error)

SegmentID: BHT

Position in TS: 2

Data Element ID: BHT03_OriginatorApplicationTransactionIdentifier

Position in Segment: 3

Data Value:

1: Mandatory data element missing

Error: 10 (Field level error)

SegmentID: BHT

Position in TS: 2

Data Element ID: BHT04_TransactionSetCreationDate

Position in Segment: 4

Data Value:

1: Mandatory data element missing

ECT...

Start of XML..

<ns0:X12_00501_837_P xmlns:ns0="http://Company.BizTalk.SQLSource">

  <ST>

    <ST01_TransactionSetIdentifierCode>837</ST01_TransactionSetIdentifierCode>

    <ST02_TransactionSetControlNumber>2227576</ST02_TransactionSetControlNumber>

    <ST03_ImplementationGuideVersionName>005010X222A1</ST03_ImplementationGuideVersionName>

  </ST>

  <ns0:BHT_BeginningofHierarchicalTransaction>

    <BHT01_HierarchicalStructureCode>0019</BHT01_HierarchicalStructureCode>

    <BHT02_TransactionSetPurposeCode>00</BHT02_TransactionSetPurposeCode>

    <BHT03_OriginatorApplicationTransactionIdentifier>2227576</BHT03_OriginatorApplicationTransactionIdentifier>

    <BHT04_TransactionSetCreationDate>20150722</BHT04_TransactionSetCreationDate>

    <BHT05_TransactionSetCreationTime>2305</BHT05_TransactionSetCreationTime>

    <BHT06_ClaimorEncounterIdentifier>CH</BHT06_ClaimorEncounterIdentifier>

  </ns0:BHT_BeginningofHierarchicalTransaction>

  <ns0:NM1_SubLoop>

    <ns0:TS837_1000A_Loop>

      <ns0:NM1_SubmitterName>

        <NM101_EntityIdentifierCode>41</NM101_EntityIdentifierCode>

        <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>

July 30th, 2015 2:42pm

Hi,

This Error/Warning/Information event indicates that the receive or send pipeline could not process the interchange because the value of the transaction set control number (in the ST02 field) was missing or had an invalid value. The transaction set control number must be an alphanumeric value.

To resolve this error, do one of the following:
1. Make sure that each transaction set has a transaction set control number.
2. Make sure that each transaction set control number is an alphanumeric value.

Thanks,

Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 4:36pm

Thanks,

But as you can see the ST02 value is set in my XML

<ns0:X12_00501_837_P xmlns:ns0="http://Company.BizTalk.SQLSource">

 < ST>

    <ST01_TransactionSetIdentifierCode>837</ST01_TransactionSetIdentifierCode>

    <ST02_TransactionSetControlNumber>2227576</ST02_TransactionSetControlNumber>

    <ST03_ImplementationGuideVersionName>005010X222A1</ST03_ImplementationGuideVersionName>

< /ST>

So I am still at a loss.

July 30th, 2015 5:09pm

Hi,

According to list of error, 

1. Missing or invalid transaction set control number
2. Transaction Set Control Number Mismatch
3. Number of included segments do not match
4. Mandatory data element missing

Transaction set control number is missing or invalid or mismatch, and some mandatory data elements are also missing, could you please check or share you input file?

Thanks

Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 5:49pm

Sure...  Here is the XML Import....

This was generated by the 837P EDI to 837P XML....

 

<ns0:X12_00501_837_P xmlns:ns0="http://Company.BizTalk.SQLSource">
  <ST>
    <ST01_TransactionSetIdentifierCode>837</ST01_TransactionSetIdentifierCode>
    <ST02_TransactionSetControlNumber>2036763</ST02_TransactionSetControlNumber>
    <ST03_ImplementationGuideVersionName>005010X222A1</ST03_ImplementationGuideVersionName>
  </ST>
  <ns0:BHT_BeginningofHierarchicalTransaction>
    <BHT01_HierarchicalStructureCode>0019</BHT01_HierarchicalStructureCode>
    <BHT02_TransactionSetPurposeCode>00</BHT02_TransactionSetPurposeCode>
    <BHT03_OriginatorApplicationTransactionIdentifier>2036763</BHT03_OriginatorApplicationTransactionIdentifier>
    <BHT04_TransactionSetCreationDate>20141212</BHT04_TransactionSetCreationDate>
    <BHT05_TransactionSetCreationTime>2303</BHT05_TransactionSetCreationTime>
    <BHT06_ClaimorEncounterIdentifier>CH</BHT06_ClaimorEncounterIdentifier>
  </ns0:BHT_BeginningofHierarchicalTransaction>
  <ns0:NM1_SubLoop>
    <ns0:TS837_1000A_Loop>
      <ns0:NM1_SubmitterName>
        <NM101_EntityIdentifierCode>41</NM101_EntityIdentifierCode>
        <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
        <NM103_SubmitterLastorOrganizationName>TEST NETWORK</NM103_SubmitterLastorOrganizationName>
        <NM108_IdentificationCodeQualifier>46</NM108_IdentificationCodeQualifier>
        <NM109_SubmitterIdentifier>481009999</NM109_SubmitterIdentifier>
      </ns0:NM1_SubmitterName>
      <ns0:PER_SubmitterEDIContactInformation>
        <PER01_ContactFunctionCode>IC</PER01_ContactFunctionCode>
        <PER02_SubmitterContactName>JOE</PER02_SubmitterContactName>
        <PER03_CommunicationNumberQualifier>EM</PER03_CommunicationNumberQualifier>
        <PER04_CommunicationNumber>JOE@JOE.NET</PER04_CommunicationNumber>
      </ns0:PER_SubmitterEDIContactInformation>
    </ns0:TS837_1000A_Loop>
    <ns0:TS837_1000B_Loop>
      <ns0:NM1_ReceiverName>
        <NM101_EntityIdentifierCode>40</NM101_EntityIdentifierCode>
        <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
        <NM103_ReceiverName>HST</NM103_ReceiverName>
        <NM108_IdentificationCodeQualifier>46</NM108_IdentificationCodeQualifier>
        <NM109_ReceiverPrimaryIdentifier>000000000</NM109_ReceiverPrimaryIdentifier>
      </ns0:NM1_ReceiverName>
    </ns0:TS837_1000B_Loop>
  </ns0:NM1_SubLoop>
  <ns0:TS837_2000A_Loop xmlns:ns0="http://Company.BizTalk.SQLSource">
    <ns0:HL_BillingProviderHierarchicalLevel>
      <HL01_HierarchicalIDNumber>1</HL01_HierarchicalIDNumber>
      <HL03_HierarchicalLevelCode>20</HL03_HierarchicalLevelCode>
      <HL04_HierarchicalChildCode>1</HL04_HierarchicalChildCode>
    </ns0:HL_BillingProviderHierarchicalLevel>
    <ns0:NM1_SubLoop_2>
      <ns0:TS837_2010AA_Loop>
        <ns0:NM1_BillingProviderName>
          <NM101_EntityIdentifierCode>85</NM101_EntityIdentifierCode>
          <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
          <NM103_BillingProviderLastorOrganizationalName>ORG NAME</NM103_BillingProviderLastorOrganizationalName>
          <NM108_IdentificationCodeQualifier>XX</NM108_IdentificationCodeQualifier>
          <NM109_BillingProviderIdentifier>1999999999</NM109_BillingProviderIdentifier>
        </ns0:NM1_BillingProviderName>
        <ns0:N3_BillingProviderAddress>
          <N301_BillingProviderAddressLine>PO BOX 999</N301_BillingProviderAddressLine>
        </ns0:N3_BillingProviderAddress>
        <ns0:N4_BillingProviderCity_State_ZIPCode>
          <N401_BillingProviderCityName>WEST PLAINS</N401_BillingProviderCityName>
          <N402_BillingProviderStateorProvinceCode>MO</N402_BillingProviderStateorProvinceCode>
          <N403_BillingProviderPostalZoneorZIPCode>657759998</N403_BillingProviderPostalZoneorZIPCode>
        </ns0:N4_BillingProviderCity_State_ZIPCode>
        <ns0:REF_SubLoop>
          <ns0:REF_BillingProviderTaxIdentification>
            <REF01_ReferenceIdentificationQualifier>EI</REF01_ReferenceIdentificationQualifier>
            <REF02_BillingProviderTaxIdentificationNumber>999999999</REF02_BillingProviderTaxIdentificationNumber>
          </ns0:REF_BillingProviderTaxIdentification>
        </ns0:REF_SubLoop>
      </ns0:TS837_2010AA_Loop>
    </ns0:NM1_SubLoop_2>
    <ns0:TS837_2000B_Loop xmlns:ns0="http://Company.BizTalk.SQLSource">
      <ns0:HL_SubscriberHierarchicalLevel>
        <HL01_HierarchicalIDNumber>2</HL01_HierarchicalIDNumber>
        <HL02_HierarchicalParentIDNumber>1</HL02_HierarchicalParentIDNumber>
        <HL03_HierarchicalLevelCode>22</HL03_HierarchicalLevelCode>
        <HL04_HierarchicalChildCode>0</HL04_HierarchicalChildCode>
      </ns0:HL_SubscriberHierarchicalLevel>
      <ns0:SBR_SubscriberInformation>
        <SBR01_PayerResponsibilitySequenceNumberCode>P</SBR01_PayerResponsibilitySequenceNumberCode>
        <SBR02_IndividualRelationshipCode>18</SBR02_IndividualRelationshipCode>
        <SBR04_SubscriberGroupName>PITTSBURG</SBR04_SubscriberGroupName>
        <SBR09_ClaimFilingIndicatorCode>12</SBR09_ClaimFilingIndicatorCode>
      </ns0:SBR_SubscriberInformation>
      <ns0:NM1_SubLoop_3>
        <ns0:TS837_2010BA_Loop>
          <ns0:NM1_SubscriberName>
            <NM101_EntityIdentifierCode>IL</NM101_EntityIdentifierCode>
            <NM102_EntityTypeQualifier>1</NM102_EntityTypeQualifier>
            <NM103_SubscriberLastName>MOUSE</NM103_SubscriberLastName>
            <NM104_SubscriberFirstName>MICKEY</NM104_SubscriberFirstName>
            <NM105_SubscriberMiddleNameorInitial>M</NM105_SubscriberMiddleNameorInitial>
            <NM108_IdentificationCodeQualifier>MI</NM108_IdentificationCodeQualifier>
            <NM109_SubscriberPrimaryIdentifier>123456789</NM109_SubscriberPrimaryIdentifier>
          </ns0:NM1_SubscriberName>
          <ns0:N3_SubscriberAddress>
            <N301_SubscriberAddressLine>555 22ND RD</N301_SubscriberAddressLine>
          </ns0:N3_SubscriberAddress>
          <ns0:N4_SubscriberCity_State_ZIPCode>
            <N401_SubscriberCityName>WICHITA</N401_SubscriberCityName>
            <N402_SubscriberStateCode>KS</N402_SubscriberStateCode>
            <N403_SubscriberPostalZoneorZIPCode>67211</N403_SubscriberPostalZoneorZIPCode>
          </ns0:N4_SubscriberCity_State_ZIPCode>
          <ns0:DMG_SubscriberDemographicInformation>
            <DMG01_DateTimePeriodFormatQualifier>D8</DMG01_DateTimePeriodFormatQualifier>
            <DMG02_SubscriberBirthDate>19800523</DMG02_SubscriberBirthDate>
            <DMG03_SubscriberGenderCode>M</DMG03_SubscriberGenderCode>
          </ns0:DMG_SubscriberDemographicInformation>
        </ns0:TS837_2010BA_Loop>
        <ns0:TS837_2010BB_Loop>
          <ns0:NM1_PayerName>
            <NM101_EntityIdentifierCode>PR</NM101_EntityIdentifierCode>
            <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
            <NM103_PayerName>KANSAS CITY</NM103_PayerName>
            <NM108_IdentificationCodeQualifier>PI</NM108_IdentificationCodeQualifier>
            <NM109_PayerIdentifier>KANSAS</NM109_PayerIdentifier>
          </ns0:NM1_PayerName>
          <ns0:N3_PayerAddress>
            <N301_PayerAddressLine>P.O. BOX 99999</N301_PayerAddressLine>
          </ns0:N3_PayerAddress>
          <ns0:N4_PayerCity_State_ZIPCode>
            <N401_PayerCityName>OVERLAND PARK</N401_PayerCityName>
            <N402_PayerStateorProvinceCode>KS</N402_PayerStateorProvinceCode>
            <N403_PayerPostalZoneorZIPCode>66225</N403_PayerPostalZoneorZIPCode>
          </ns0:N4_PayerCity_State_ZIPCode>
        </ns0:TS837_2010BB_Loop>
      </ns0:NM1_SubLoop_3>
      <ns0:TS837_2300_Loop xmlns:ns0="http://Company.BizTalk.SQLSource">
        <ns0:CLM_ClaimInformation>
          <CLM01_PatientControlNumber>3251460999AA</CLM01_PatientControlNumber>
          <CLM02_TotalClaimChargeAmount>24127.77</CLM02_TotalClaimChargeAmount>
          <ns0:C023_HealthCareServiceLocationInformation>
            <C02301_PlaceofServiceCode>42</C02301_PlaceofServiceCode>
            <C02302_FacilityCodeQualifier>B</C02302_FacilityCodeQualifier>
            <C02303_ClaimFrequencyCode>1</C02303_ClaimFrequencyCode>
          </ns0:C023_HealthCareServiceLocationInformation>
          <CLM06_ProviderorSupplierSignatureIndicator>N</CLM06_ProviderorSupplierSignatureIndicator>
          <CLM07_AssignmentorPlanParticipationCode>C</CLM07_AssignmentorPlanParticipationCode>
          <CLM08_BenefitsAssignmentCertificationIndicator>Y</CLM08_BenefitsAssignmentCertificationIndicator>
          <CLM09_ReleaseofInformationCode>Y</CLM09_ReleaseofInformationCode>
        </ns0:CLM_ClaimInformation>
        <ns0:DTP_SubLoop>
          <ns0:DTP_Date_OnsetofCurrentIllnessorSymptom>
            <DTP01_DateTimeQualifier>431</DTP01_DateTimeQualifier>
            <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
            <DTP03_OnsetofCurrentIllnessorInjuryDate>20141205</DTP03_OnsetofCurrentIllnessorInjuryDate>
          </ns0:DTP_Date_OnsetofCurrentIllnessorSymptom>
          <ns0:DTP_Date_RepricerReceivedDate>
            <DTP01_DateTimeQualifier>050</DTP01_DateTimeQualifier>
            <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
            <DTP03_RepricerReceivedDate>20141211</DTP03_RepricerReceivedDate>
          </ns0:DTP_Date_RepricerReceivedDate>
        </ns0:DTP_SubLoop>
        <ns0:REF_SubLoop_5>
          <ns0:REF_ClaimIdentifierForTransmissionIntermediaries>
            <REF01_ReferenceIdentificationQualifier>D9</REF01_ReferenceIdentificationQualifier>
            <REF02_ValueAddedNetworkTraceNumber>2036763</REF02_ValueAddedNetworkTraceNumber>
          </ns0:REF_ClaimIdentifierForTransmissionIntermediaries>
        </ns0:REF_SubLoop_5>
        <ns0:CR1_AmbulanceTransportInformation>
          <CR104_AmbulanceTransportReasonCode>A</CR104_AmbulanceTransportReasonCode>
          <CR105_UnitorBasisforMeasurementCode>DH</CR105_UnitorBasisforMeasurementCode>
          <CR106_TransportDistance>1</CR106_TransportDistance>
        </ns0:CR1_AmbulanceTransportInformation>
        <ns0:CRC_SubLoop>
          <ns0:CRC_AmbulanceCertification_Loop>
            <ns0:CRC_AmbulanceCertification>
              <CRC01_CodeCategory>07</CRC01_CodeCategory>
              <CRC02_CertificationConditionIndicator>N</CRC02_CertificationConditionIndicator>
              <CRC03_ConditionCode>09</CRC03_ConditionCode>
            </ns0:CRC_AmbulanceCertification>
          </ns0:CRC_AmbulanceCertification_Loop>
        </ns0:CRC_SubLoop>
        <ns0:HI_SubLoop>
          <ns0:HI_HealthCareDiagnosisCode>
            <ns0:C022_HealthCareCodeInformation>
              <C02201_DiagnosisTypeCode>BK</C02201_DiagnosisTypeCode>
              <C02202_DiagnosisCode>5400</C02202_DiagnosisCode>
            </ns0:C022_HealthCareCodeInformation>
            <ns0:C022_HealthCareCodeInformation_2>
              <C02201_DiagnosisTypeCode>BF</C02201_DiagnosisTypeCode>
              <C02202_DiagnosisCode>78907</C02202_DiagnosisCode>
            </ns0:C022_HealthCareCodeInformation_2>
          </ns0:HI_HealthCareDiagnosisCode>
        </ns0:HI_SubLoop>
        <ns0:NM1_SubLoop_4>
          <ns0:TS837_2310B_Loop>
            <ns0:NM1_RenderingProviderName>
              <NM101_EntityIdentifierCode>82</NM101_EntityIdentifierCode>
              <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
              <NM103_RenderingProviderLastorOrganizationName>STP MED, LLC</NM103_RenderingProviderLastorOrganizationName>
            </ns0:NM1_RenderingProviderName>
            <ns0:PRV_RenderingProviderSpecialtyInformation>
              <PRV01_ProviderCode>PE</PRV01_ProviderCode>
              <PRV02_ReferenceIdentificationQualifier>PXC</PRV02_ReferenceIdentificationQualifier>
              <PRV03_ProviderTaxonomyCode>193200000X</PRV03_ProviderTaxonomyCode>
            </ns0:PRV_RenderingProviderSpecialtyInformation>
          </ns0:TS837_2310B_Loop>
          <ns0:TS837_2310C_Loop>
            <ns0:NM1_ServiceFacilityLocationName>
              <NM101_EntityIdentifierCode>77</NM101_EntityIdentifierCode>
              <NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>
              <NM103_LaboratoryorFacilityName>REGIONAL AIRPORT</NM103_LaboratoryorFacilityName>
            </ns0:NM1_ServiceFacilityLocationName>
            <ns0:N3_ServiceFacilityLocationAddress>
              <N301_LaboratoryorFacilityAddressLine>TO COLONEL</N301_LaboratoryorFacilityAddressLine>
            </ns0:N3_ServiceFacilityLocationAddress>
            <ns0:N4_ServiceFacilityLocationCity_State_ZIPCode>
              <N401_LaboratoryorFacilityCityName>DODGE CITY</N401_LaboratoryorFacilityCityName>
              <N402_LaboratoryorFacilityStateorProvinceCode>KS</N402_LaboratoryorFacilityStateorProvinceCode>
              <N403_LaboratoryorFacilityPostalZoneorZIPCode>678019998</N403_LaboratoryorFacilityPostalZoneorZIPCode>
            </ns0:N4_ServiceFacilityLocationCity_State_ZIPCode>
          </ns0:TS837_2310C_Loop>
        </ns0:NM1_SubLoop_4>
        <ns0:TS837_2400_Loop>
          <ns0:LX_ServiceLineNumber>
            <LX01_AssignedNumber>1</LX01_AssignedNumber>
          </ns0:LX_ServiceLineNumber>
          <ns0:SV1_ProfessionalService>
            <ns0:C003_CompositeMedicalProcedureIdentifier>
              <C00301_ProductorServiceIDQualifier>HC</C00301_ProductorServiceIDQualifier>
              <C00302_ProcedureCode>A0430</C00302_ProcedureCode>
            </ns0:C003_CompositeMedicalProcedureIdentifier>
            <SV102_LineItemChargeAmount>19250</SV102_LineItemChargeAmount>
            <SV103_UnitorBasisforMeasurementCode>UN</SV103_UnitorBasisforMeasurementCode>
            <SV104_ServiceUnitCount>1</SV104_ServiceUnitCount>
            <ns0:C004_CompositeDiagnosisCodePointer>
              <C00401_DiagnosisCodePointer>1</C00401_DiagnosisCodePointer>
              <C00402_DiagnosisCodePointer>2</C00402_DiagnosisCodePointer>
            </ns0:C004_CompositeDiagnosisCodePointer>
          </ns0:SV1_ProfessionalService>
          <ns0:DTP_SubLoop_2>
            <ns0:DTP_Date_ServiceDate>
              <DTP01_DateTimeQualifier>472</DTP01_DateTimeQualifier>
              <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
              <DTP03_ServiceDate>20141205</DTP03_ServiceDate>
            </ns0:DTP_Date_ServiceDate>
          </ns0:DTP_SubLoop_2>
        </ns0:TS837_2400_Loop>
        <ns0:TS837_2400_Loop>
          <ns0:LX_ServiceLineNumber>
            <LX01_AssignedNumber>2</LX01_AssignedNumber>
          </ns0:LX_ServiceLineNumber>
          <ns0:SV1_ProfessionalService>
            <ns0:C003_CompositeMedicalProcedureIdentifier>
              <C00301_ProductorServiceIDQualifier>HC</C00301_ProductorServiceIDQualifier>
              <C00302_ProcedureCode>A0435</C00302_ProcedureCode>
            </ns0:C003_CompositeMedicalProcedureIdentifier>
            <SV102_LineItemChargeAmount>4048</SV102_LineItemChargeAmount>
            <SV103_UnitorBasisforMeasurementCode>UN</SV103_UnitorBasisforMeasurementCode>
            <SV104_ServiceUnitCount>46</SV104_ServiceUnitCount>
            <ns0:C004_CompositeDiagnosisCodePointer>
              <C00401_DiagnosisCodePointer>1</C00401_DiagnosisCodePointer>
              <C00402_DiagnosisCodePointer>2</C00402_DiagnosisCodePointer>
            </ns0:C004_CompositeDiagnosisCodePointer>
          </ns0:SV1_ProfessionalService>
          <ns0:DTP_SubLoop_2>
            <ns0:DTP_Date_ServiceDate>
              <DTP01_DateTimeQualifier>472</DTP01_DateTimeQualifier>
              <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
              <DTP03_ServiceDate>20141205</DTP03_ServiceDate>
            </ns0:DTP_Date_ServiceDate>
          </ns0:DTP_SubLoop_2>
        </ns0:TS837_2400_Loop>
        <ns0:TS837_2400_Loop>
          <ns0:LX_ServiceLineNumber>
            <LX01_AssignedNumber>3</LX01_AssignedNumber>
          </ns0:LX_ServiceLineNumber>
          <ns0:SV1_ProfessionalService>
            <ns0:C003_CompositeMedicalProcedureIdentifier>
              <C00301_ProductorServiceIDQualifier>HC</C00301_ProductorServiceIDQualifier>
              <C00302_ProcedureCode>A0422</C00302_ProcedureCode>
            </ns0:C003_CompositeMedicalProcedureIdentifier>
            <SV102_LineItemChargeAmount>587.25</SV102_LineItemChargeAmount>
            <SV103_UnitorBasisforMeasurementCode>UN</SV103_UnitorBasisforMeasurementCode>
            <SV104_ServiceUnitCount>1</SV104_ServiceUnitCount>
            <ns0:C004_CompositeDiagnosisCodePointer>
              <C00401_DiagnosisCodePointer>1</C00401_DiagnosisCodePointer>
              <C00402_DiagnosisCodePointer>2</C00402_DiagnosisCodePointer>
            </ns0:C004_CompositeDiagnosisCodePointer>
          </ns0:SV1_ProfessionalService>
          <ns0:DTP_SubLoop_2>
            <ns0:DTP_Date_ServiceDate>
              <DTP01_DateTimeQualifier>472</DTP01_DateTimeQualifier>
              <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
              <DTP03_ServiceDate>20141205</DTP03_ServiceDate>
            </ns0:DTP_Date_ServiceDate>
          </ns0:DTP_SubLoop_2>
        </ns0:TS837_2400_Loop>
        <ns0:TS837_2400_Loop>
          <ns0:LX_ServiceLineNumber>
            <LX01_AssignedNumber>4</LX01_AssignedNumber>
          </ns0:LX_ServiceLineNumber>
          <ns0:SV1_ProfessionalService>
            <ns0:C003_CompositeMedicalProcedureIdentifier>
              <C00301_ProductorServiceIDQualifier>HC</C00301_ProductorServiceIDQualifier>
              <C00302_ProcedureCode>93041</C00302_ProcedureCode>
            </ns0:C003_CompositeMedicalProcedureIdentifier>
            <SV102_LineItemChargeAmount>70.02</SV102_LineItemChargeAmount>
            <SV103_UnitorBasisforMeasurementCode>UN</SV103_UnitorBasisforMeasurementCode>
            <SV104_ServiceUnitCount>1</SV104_ServiceUnitCount>
            <ns0:C004_CompositeDiagnosisCodePointer>
              <C00401_DiagnosisCodePointer>1</C00401_DiagnosisCodePointer>
              <C00402_DiagnosisCodePointer>2</C00402_DiagnosisCodePointer>
            </ns0:C004_CompositeDiagnosisCodePointer>
          </ns0:SV1_ProfessionalService>
          <ns0:DTP_SubLoop_2>
            <ns0:DTP_Date_ServiceDate>
              <DTP01_DateTimeQualifier>472</DTP01_DateTimeQualifier>
              <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
              <DTP03_ServiceDate>20141205</DTP03_ServiceDate>
            </ns0:DTP_Date_ServiceDate>
          </ns0:DTP_SubLoop_2>
        </ns0:TS837_2400_Loop>
        <ns0:TS837_2400_Loop>
          <ns0:LX_ServiceLineNumber>
            <LX01_AssignedNumber>5</LX01_AssignedNumber>
          </ns0:LX_ServiceLineNumber>
          <ns0:SV1_ProfessionalService>
            <ns0:C003_CompositeMedicalProcedureIdentifier>
              <C00301_ProductorServiceIDQualifier>HC</C00301_ProductorServiceIDQualifier>
              <C00302_ProcedureCode>A0398</C00302_ProcedureCode>
            </ns0:C003_CompositeMedicalProcedureIdentifier>
            <SV102_LineItemChargeAmount>172.5</SV102_LineItemChargeAmount>
            <SV103_UnitorBasisforMeasurementCode>UN</SV103_UnitorBasisforMeasurementCode>
            <SV104_ServiceUnitCount>1</SV104_ServiceUnitCount>
            <ns0:C004_CompositeDiagnosisCodePointer>
              <C00401_DiagnosisCodePointer>1</C00401_DiagnosisCodePointer>
              <C00402_DiagnosisCodePointer>2</C00402_DiagnosisCodePointer>
            </ns0:C004_CompositeDiagnosisCodePointer>
          </ns0:SV1_ProfessionalService>
          <ns0:DTP_SubLoop_2>
            <ns0:DTP_Date_ServiceDate>
              <DTP01_DateTimeQualifier>472</DTP01_DateTimeQualifier>
              <DTP02_DateTimePeriodFormatQualifier>D8</DTP02_DateTimePeriodFormatQualifier>
              <DTP03_ServiceDate>20141205</DTP03_ServiceDate>
            </ns0:DTP_Date_ServiceDate>
          </ns0:DTP_SubLoop_2>
        </ns0:TS837_2400_Loop>
      </ns0:TS837_2300_Loop>
    </ns0:TS837_2000B_Loop>
  </ns0:TS837_2000A_Loop>
  <SE>
    <SE01_TransactionSegmentCount>47</SE01_TransactionSegmentCount>
    <SE02_TransactionSetControlNumber>2036763</SE02_TransactionSetControlNumber>
  </SE>
</ns0:X12_00501_837_P>

July 30th, 2015 6:26pm

Ok, I went back to the basics...  Re created my maps to cover just the required field...  Used the Test in VS to check an input file.  Now I get an output file but no results in the EDI...

Basic Input

- <ns0:X12_00603_837 xmlns:ns0="http://Company.BizTalk.SQLSource"> 
- <ST><ST01>837</ST01><ST02>0000</ST02><ST03>0000</ST03></ST>
- <ns0:BHT><BHT01>0001</BHT01><BHT02>00</BHT02><BHT03>BHT03_OriginatorApplicationTransactionIdentifier_0</BHT03><BHT04>20150101</BHT04><BHT05>1000</BHT05><BHT06>01</BHT06></ns0:BHT>
- <ns0:NM1Loop1>
- <ns0:NM1><NM101>98</NM101><NM102>1</NM102><NM103>NM103_SubmitterLastorOrganizationName_0</NM103><NM104>NM108_IdentificationCodeQualifier_0</NM104><NM109>NM109_SubmitterIdentifier_0</NM109><NM110>01</NM110><NM111>00</NM111><NM112>NM112_NameLastorOrganizationName_0</NM112></ns0:NM1></ns0:NM1Loop1>
- <ns0:HLLoop1>
- <ns0:HL><HL01>0001</HL01><HL03>1</HL03><HL04>1</HL04></ns0:HL></ns0:HLLoop1></ns0:X12_00603_837>

Result File....

ISA*00*          *00*          *ZZ*BTS-SENDER     *ZZ*RECEIVE-PARTNER*150731*1130*U*00401*000008037*0*T*:~
GS*HC*BTS-SENDER*RECEIVE-APP*150731*1130*8037*T*00401~
ST*837*2348~
~
SE*2*2348~
GE*1*8037~
IEA*1*000008037~

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 2:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics