1 2 Previous Next 17 Replies Latest reply on Apr 19, 2018 7:01 AM by Ankit kalanoria

    Getting error message on XSLT mapper while performing the test on JDEV

    Hari Selva

      Hi,

       

      Please advise how to fix this issue. I get following error message when I do a "Test XSLT Map" operation on the XSLT designer view on Oracle JDev 12c. I pasted the error message and the logs below.

       

      Error Message:

       

      JDEV logs:

      Apr 03, 2018 11:21:30 AM oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator generateInstance

      SEVERE: Error occurred while generating the sample instance.

      null

      oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerationException: Error occurred while generating the sample instance.

      null

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.generateInstance(InstanceGenerator.java:366)

      at oracle.tip.tools.ide.tx_multi.test.MapTestUtils.generateInstance(MapTestUtils.java:179)

      at oracle.tip.tools.ide.tx_multi.test.MapperTester.generateSource(MapperTester.java:428)

      at oracle.tip.tools.ide.tx_multi.test.MapperTester.doTest(MapperTester.java:347)

      at oracle.tip.tools.ide.tx_multi.test.MapperTester.test(MapperTester.java:160)

      at oracle.tip.tools.ide.tx_multi.gui.assign.panel.MapPanel$24$2.actionPerformed(MapPanel.java:1218)

      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)

      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)

      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

      at javax.swing.AbstractButton.doClick(AbstractButton.java:376)

      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

      at java.awt.Component.processMouseEvent(Component.java:6533)

      at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

      at java.awt.Component.processEvent(Component.java:6298)

      at java.awt.Container.processEvent(Container.java:2236)

      at java.awt.Component.dispatchEventImpl(Component.java:4889)

      at java.awt.Container.dispatchEventImpl(Container.java:2294)

      at java.awt.Component.dispatchEvent(Component.java:4711)

      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)

      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)

      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

      at java.awt.Container.dispatchEventImpl(Container.java:2280)

      at java.awt.Window.dispatchEventImpl(Window.java:2746)

      at java.awt.Component.dispatchEvent(Component.java:4711)

      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

      at java.awt.EventQueue.access$500(EventQueue.java:97)

      at java.awt.EventQueue$3.run(EventQueue.java:709)

      at java.awt.EventQueue$3.run(EventQueue.java:703)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

      at java.awt.EventQueue$4.run(EventQueue.java:731)

      at java.awt.EventQueue$4.run(EventQueue.java:729)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

      at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

      at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

      Caused by: java.lang.NullPointerException

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.applyFacets(InstanceGenerator.java:1250)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.getValue(InstanceGenerator.java:1133)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createValue(InstanceGenerator.java:1002)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForType(InstanceGenerator.java:547)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForElement(InstanceGenerator.java:663)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForGroup(InstanceGenerator.java:626)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForType(InstanceGenerator.java:523)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForElement(InstanceGenerator.java:663)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForGroup(InstanceGenerator.java:626)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.createInstanceForType(InstanceGenerator.java:523)

      at oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerator.generateInstance(InstanceGenerator.java:344)

      ... 45 more

        • 1. Re: Getting error message on XSLT mapper while performing the test on JDEV
          Ankit kalanoria

          Hello,

           

          Please verify if source schema is valid? You can try to see if XML based on your source schema is generating by right clicking on xsd and clicking on generate. If there is some issue in doing this as well then it will be problem with source schema itself.

           

          Regards,

          Ankit K

          • 2. Re: Getting error message on XSLT mapper while performing the test on JDEV
            Martien van den Akker

            Also, the variable should be based on an element (but the create map dialog should already complain on that).

            Sometimes a restart of JDeveloper, with a remove of the .data folders helps...

             

            If you based your map on a WSDL, then try to load the WSDL in SoapUI. The log tab will tell you neatly if the WSDL can be imported, together with all the imports. Then see if SoapUI can generated a request message.

             

            Regards,

            Martien

            • 3. Re: Getting error message on XSLT mapper while performing the test on JDEV
              Hari Selva

              Hi Martien,

               

              Thanks for your response!!

               

              Here is the error message when I tried to load the WSDL file from local onto SOAP UI. cause, the WSDL is related to JMS queue.

               

               

              Thanks..

              • 4. Re: Getting error message on XSLT mapper while performing the test on JDEV
                Martien van den Akker

                Of course. It is in fact a WISF (WebService invocation framework) WSDL on the jms adapter. SoapUI can't do anything with that.

                 

                You should base the XSLT transformation on the xsd of the message content of the queue.

                Make sure it contains an element definition for the queue-content. Then define a BPEL variable on that element from the xsd.

                Create an assign that assigns the message from the queue to that variable.

                Then create an transformation with that variable as source.

                 

                Regards,

                Martien

                • 5. Re: Getting error message on XSLT mapper while performing the test on JDEV
                  Hari Selva

                  Hi Martien,

                   

                  I am already following the approach you mentioned above. I am still receiving the error message.

                   

                  Input payload :


                  <ProfXDataToEDI837XML>

                  <Transaction-837 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.edifecs.com/xdata/200/PFF" XDataVersion="2.0" Standard="HIPAA" Version="V5010X222A1" CreatedDate="2018-03-28T11:28:44" CreatedBy="XEngine_4017" GUID="{2C8C6248-327B-11E8-9BDC-0050569A7068}">

                  <Internal-Properties>

                  <Data-Structure Name="Interchange">

                  <Lookup Name="ClaimOrigin">EDIX12</Lookup>

                  <Lookup Name="InterchangeControlVersion">00501</Lookup>

                  <Lookup Name="InterchangeReceiverID">04-3149694</Lookup>

                  <Lookup Name="InterchangeReceiverQual">ZZ</Lookup>

                  <Lookup Name="InterchangeSenderID">COBA</Lookup>

                  <Lookup Name="InterchangeSenderQual">ZZ</Lookup>

                  <Lookup Name="InterchangeUsageIndicator">T</Lookup>

                  <Lookup Name="Standard">X12</Lookup>

                  <Lookup Name="TPM_Direction">Inbound</Lookup>

                  <Lookup Name="TPM_Mode">Batch</Lookup>

                  <Lookup Name="XData">True</Lookup>

                  <Property Name="ClaimOrigin">EDIX12</Property>

                  <Property Name="ElementDelimiter">0x2a</Property>

                  <Property Name="InterchangeAckRequested">0</Property>

                  <Property Name="InterchangeAuthorizationInfo"></Property>

                  <Property Name="InterchangeAuthorizationInfoQual">00</Property>

                  <Property Name="InterchangeChildCount">1</Property>

                  <Property Name="InterchangeComponentElementSep">0x3a</Property>

                  <Property Name="InterchangeControlNumber">180160658</Property>

                  <Property Name="InterchangeControlStandard_RepeatingSeparator">|</Property>

                  <Property Name="InterchangeControlVersion">00501</Property>

                  <Property Name="InterchangeDate">180117</Property>

                  <Property Name="InterchangeReceiverID">04-3149694</Property>

                  <Property Name="InterchangeReceiverQual">ZZ</Property>

                  <Property Name="InterchangeSecurityInfo"></Property>

                  <Property Name="InterchangeSecurityInfoQual">00</Property>

                  <Property Name="InterchangeSenderID">COBA</Property>

                  <Property Name="InterchangeSenderQual">ZZ</Property>

                  <Property Name="InterchangeTime">0002</Property>

                  <Property Name="InterchangeTrailerControlNumber">180160658</Property>

                  <Property Name="InterchangeUsageIndicator">T</Property>

                  <Property Name="RepeatingSeparator">0x7c</Property>

                  <Property Name="SegmentDelimiter">0x7e</Property>

                  <Property Name="Standard">X12</Property>

                  <Property Name="SubelementDelimiter">0x3a</Property>

                  <Property Name="TPM_DestinationPartnerSID">100001</Property>

                  <Property Name="TPM_Direction">Inbound</Property>

                  <Property Name="TPM_Mode">Batch</Property>

                  <Property Name="TPM_OriginatorPartnerSID">105750</Property>

                  <Property Name="TPM_ReceiverPartnerSID">100001</Property>

                  <Property Name="TPM_SenderPartnerSID">105750</Property>

                  <Property Name="TPName"/>

                  <Property Name="XData">True</Property>

                  <Data-Structure Name="Group">

                  <Lookup Name="GroupReceiverID">04-3149694</Lookup>

                  <Lookup Name="GroupSenderID">COBA</Lookup>

                  <Lookup Name="GroupVersionNumber">005010X222A1</Lookup>

                  <Property Name="GroupAgencyCode">X</Property>

                  <Property Name="GroupChildCount">1</Property>

                  <Property Name="GroupControlNumber">200005527</Property>

                  <Property Name="GroupDate">20180117</Property>

                  <Property Name="GroupID">HC</Property>

                  <Property Name="GroupReceiverID">04-3149694</Property>

                  <Property Name="GroupSenderID">COBA</Property>

                  <Property Name="GroupTime">000218</Property>

                  <Property Name="GroupTrailerControlNumber">200005527</Property>

                  <Property Name="GroupVersionNumber">005010X222A1</Property>

                  <Property Name="TPM_DestinationPartnerSID">100001</Property>

                  <Property Name="TPM_OriginatorPartnerSID">105750</Property>

                  <Property Name="TPM_ReceiverPartnerSID">100001</Property>

                  <Property Name="TPM_SenderPartnerSID">105750</Property>

                  <Property Name="TPM_TradeRelationshipSID">3024</Property>

                  <Property Name="TPName"/>

                  <Data-Structure Name="Transaction">

                  <Lookup Name="TransactionID">837</Lookup>

                  <Lookup Name="TransactionPurposeCode">00</Lookup>

                  <Property Name="HTR_CID_TrackingID">180328MI0215</Property>

                  <Property Name="TPM_DestinationPartnerSID">100001</Property>

                  <Property Name="TPM_OriginatorPartnerSID">105750</Property>

                  <Property Name="TPM_ReceiverPartnerSID">100001</Property>

                  <Property Name="TPM_SenderPartnerSID">105750</Property>

                  <Property Name="TPM_TradeRelationshipSID">3024</Property>

                  <Property Name="TPName">COMPInboundBatcha837P</Property>

                  <Property Name="TransactionChildCount">50</Property>

                  <Property Name="TransactionControlNumber">000000012</Property>

                  <Property Name="TransactionID">837</Property>

                  <Property Name="TransactionImplementationReference">005010X222A1</Property>

                  <Property Name="TransactionPurposeCode">00</Property>

                  <Property Name="TransactionTrailerControlNumber">000000012</Property>

                  </Data-Structure>

                  </Data-Structure>

                  </Data-Structure>

                  </Internal-Properties>

                  <Segment-ST>

                  <Element-143>837</Element-143>

                  <Element-329>000000012</Element-329>

                  <Element-1705>005010X222A1</Element-1705>

                  </Segment-ST>

                  <Segment-BHT>

                  <Element-1005>0019</Element-1005>

                  <Element-353>00</Element-353>

                  <Element-127>16013 180150024050PO</Element-127>

                  <Element-373>20180116</Element-373>

                  <Element-337>2118</Element-337>

                  <Element-640>CH</Element-640>

                  </Segment-BHT>

                  <Loop-1000A>

                  <Segment-NM1>

                  <Element-98>41</Element-98>

                  <Element-1065>2</Element-1065>

                  <Element-1035>NORIDIAN - DMEMAC JURISDICTION A</Element-1035>

                  <Element-1036 xsi:nil="true"/>

                  <Element-1037 xsi:nil="true"/>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>46</Element-66>

                  <Element-67>16013</Element-67>

                  </Segment-NM1>

                  <Segment-PER>

                  <Element-366>IC</Element-366>

                  <Element-93>BCRC EDI DEPARTMENT</Element-93>

                  <Element-365>TE</Element-365>

                  <Element-364>6464586740</Element-364>

                  </Segment-PER>

                  </Loop-1000A>

                  <Loop-1000B>

                  <Segment-NM1>

                  <Element-98>40</Element-98>

                  <Element-1065>2</Element-1065>

                  <Element-1035>COMP COMPANY</Element-1035>

                  <Element-1036 xsi:nil="true"/>

                  <Element-1037 xsi:nil="true"/>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>46</Element-66>

                  <Element-67>30330</Element-67>

                  </Segment-NM1>

                  </Loop-1000B>

                  <Loop-2000A>

                  <Segment-HL>

                  <Element-628>1</Element-628>

                  <Element-734 xsi:nil="true"/>

                  <Element-735>20</Element-735>

                  <Element-736>1</Element-736>

                  </Segment-HL>

                  <Segment-PRV>

                  <Element-1221>BI</Element-1221>

                  <Element-128>PXC</Element-128>

                  <Element-127>332B00000X</Element-127>

                  </Segment-PRV>

                  <Loop-2010AA>

                  <Segment-NM1>

                  <Element-98>85</Element-98>

                  <Element-1065>2</Element-1065>

                  <Element-1035>LINCARE INC</Element-1035>

                  <Element-1036 xsi:nil="true"/>

                  <Element-1037 xsi:nil="true"/>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>XX</Element-66>

                  <Element-67>1811925993</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>8 CHESTNUT DR</Element-166>

                  <Element-166_1>STE 6</Element-166_1>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>BEDFORD</Element-19>

                  <Element-156>NH</Element-156>

                  <Element-116>0311055021</Element-116>

                  </Segment-N4>

                  <Segment-REF>

                  <Element-128>EI</Element-128>

                  <Element-127>592852900</Element-127>

                  </Segment-REF>

                  <Segment-PER>

                  <Element-366>IC</Element-366>

                  <Element-93>LINCARE INC</Element-93>

                  <Element-365>TE</Element-365>

                  <Element-364>6034719162</Element-364>

                  <Element-365_1>FX</Element-365_1>

                  <Element-364_1>6034719104</Element-364_1>

                  </Segment-PER>

                  </Loop-2010AA>

                  <Loop-2010AB>

                  <Segment-NM1>

                  <Element-98>87</Element-98>

                  <Element-1065>2</Element-1065>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>PO BOX 9521</Element-166>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>AMHERST</Element-19>

                  <Element-156>NY</Element-156>

                  <Element-116>142269521</Element-116>

                  </Segment-N4>

                  </Loop-2010AB>

                  </Loop-2000A>

                  <Loop-2000B>

                  <Segment-HL>

                  <Element-628>2</Element-628>

                  <Element-734>1</Element-734>

                  <Element-735>22</Element-735>

                  <Element-736>0</Element-736>

                  </Segment-HL>

                  <Segment-SBR>

                  <Element-1138>U</Element-1138>

                  <Element-1069>18</Element-1069>

                  <Element-127 xsi:nil="true"/>

                  <Element-93 xsi:nil="true"/>

                  <Element-1336 xsi:nil="true"/>

                  <Element-1143 xsi:nil="true"/>

                  <Element-1073 xsi:nil="true"/>

                  <Element-584 xsi:nil="true"/>

                  <Element-1032>CI</Element-1032>

                  </Segment-SBR>

                  <Loop-2010BA>

                  <Segment-NM1>

                  <Element-98>IL</Element-98>

                  <Element-1065>1</Element-1065>

                  <Element-1035>JENKINS</Element-1035>

                  <Element-1036>MARY</Element-1036>

                  <Element-1037>A</Element-1037>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>MI</Element-66>

                  <Element-67>1234</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>38 HALL RD</Element-166>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>LONDONDERRY</Element-19>

                  <Element-156>NH</Element-156>

                  <Element-116>030532305</Element-116>

                  </Segment-N4>

                  <Segment-DMG>

                  <Element-1250>D8</Element-1250>

                  <Element-1251>19500619</Element-1251>

                  <Element-1068>F</Element-1068>

                  </Segment-DMG>

                  </Loop-2010BA>

                  <Loop-2010BB>

                  <Segment-NM1>

                  <Element-98>PR</Element-98>

                  <Element-1065>2</Element-1065>

                  <Element-1035>COMP INSURANCE COMPANY</Element-1035>

                  <Element-1036 xsi:nil="true"/>

                  <Element-1037 xsi:nil="true"/>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>PI</Element-66>

                  <Element-67>30330</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>XYZ</Element-166>

                  <Element-166_1>SUITE 100</Element-166_1>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>XYZ</Element-19>

                  <Element-156>MA</Element-156>

                  <Element-116>02481</Element-116>

                  </Segment-N4>

                  </Loop-2010BB>

                  <Loop-2300>

                  <Segment-CLM>

                  <Element-1028>TKRNM869011603565</Element-1028>

                  <Element-782>50.73</Element-782>

                  <Element-1032 xsi:nil="true"/>

                  <Element-1343 xsi:nil="true"/>

                  <Composite-C023>

                  <Element-1331>12</Element-1331>

                  <Element-1332>B</Element-1332>

                  <Element-1325>1</Element-1325>

                  </Composite-C023>

                  <Element-1073>Y</Element-1073>

                  <Element-1359>A</Element-1359>

                  <Element-1073_1>Y</Element-1073_1>

                  <Element-1363>Y</Element-1363>

                  </Segment-CLM>

                  <Segment-REF_1>

                  <Element-128>F5</Element-128>

                  <Element-127>N</Element-127>

                  </Segment-REF_1>

                  <Segment-HI>

                  <Composite-C022>

                  <Element-1270>ABK</Element-1270>

                  <Element-1271>J449</Element-1271>

                  </Composite-C022>

                  </Segment-HI>

                  <Loop-2320>

                  <Segment-SBR>

                  <Element-1138>P</Element-1138>

                  <Element-1069>18</Element-1069>

                  <Element-127 xsi:nil="true"/>

                  <Element-93 xsi:nil="true"/>

                  <Element-1336 xsi:nil="true"/>

                  <Element-1143 xsi:nil="true"/>

                  <Element-1073 xsi:nil="true"/>

                  <Element-584 xsi:nil="true"/>

                  <Element-1032>MB</Element-1032>

                  </Segment-SBR>

                  <Segment-AMT>

                  <Element-522>D</Element-522>

                  <Element-782>5.88</Element-782>

                  </Segment-AMT>

                  <Segment-OI>

                  <Element-1032 xsi:nil="true"/>

                  <Element-1383 xsi:nil="true"/>

                  <Element-1073>Y</Element-1073>

                  <Element-1351 xsi:nil="true"/>

                  <Element-1360 xsi:nil="true"/>

                  <Element-1363>Y</Element-1363>

                  </Segment-OI>

                  <Segment-MOA>

                  <Element-954 xsi:nil="true"/>

                  <Element-782 xsi:nil="true"/>

                  <Element-127>MA13</Element-127>

                  <Element-127_1>MA18</Element-127_1>

                  <Element-127_2>MA01</Element-127_2>

                  </Segment-MOA>

                  <Loop-2330A>

                  <Segment-NM1>

                  <Element-98>IL</Element-98>

                  <Element-1065>1</Element-1065>

                  <Element-1035>JENKINS</Element-1035>

                  <Element-1036>MARY</Element-1036>

                  <Element-1037>A</Element-1037>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>MI</Element-66>

                  <Element-67>010420373A</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>38 HALL RD</Element-166>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>LONDONDERRY</Element-19>

                  <Element-156>NH</Element-156>

                  <Element-116>030532305</Element-116>

                  </Segment-N4>

                  </Loop-2330A>

                  <Loop-2330B>

                  <Segment-NM1>

                  <Element-98>PR</Element-98>

                  <Element-1065>2</Element-1065>

                  <Element-1035>NORIDIAN - DMEMAC JURISDICTION A</Element-1035>

                  <Element-1036 xsi:nil="true"/>

                  <Element-1037 xsi:nil="true"/>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>PI</Element-66>

                  <Element-67>16013</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>P O BOX 6780</Element-166>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>FARGO</Element-19>

                  <Element-156>ND</Element-156>

                  <Element-116>58108</Element-116>

                  </Segment-N4>

                  <Segment-REF_4>

                  <Element-128>F8</Element-128>

                  <Element-127>18002764038000</Element-127>

                  </Segment-REF_4>

                  </Loop-2330B>

                  </Loop-2320>

                  <Loop-2400>

                  <Segment-LX>

                  <Element-554>1</Element-554>

                  </Segment-LX>

                  <Segment-SV1>

                  <Composite-C003>

                  <Element-235>HC</Element-235>

                  <Element-234>E0570</Element-234>

                  <Element-1339>RR</Element-1339>

                  <Element-1339_1>KH</Element-1339_1>

                  </Composite-C003>

                  <Element-782>50.73</Element-782>

                  <Element-355>UN</Element-355>

                  <Element-380>1</Element-380>

                  <Element-1331 xsi:nil="true"/>

                  <Element-1365 xsi:nil="true"/>

                  <Composite-C004>

                  <Element-1328>1</Element-1328>

                  </Composite-C004>

                  </Segment-SV1>

                  <Segment-DTP>

                  <Element-374>472</Element-374>

                  <Element-1250>RD8</Element-1250>

                  <Element-1251>20171213-20171213</Element-1251>

                  </Segment-DTP>

                  <Segment-REF_3>

                  <Element-128>6R</Element-128>

                  <Element-127>000000793602802TKRNM869001</Element-127>

                  </Segment-REF_3>

                  <Loop-2420E>

                  <Segment-NM1>

                  <Element-98>DK</Element-98>

                  <Element-1065>1</Element-1065>

                  <Element-1035>STONE</Element-1035>

                  <Element-1036>AMY</Element-1036>

                  <Element-1037>C</Element-1037>

                  <Element-1038 xsi:nil="true"/>

                  <Element-1039 xsi:nil="true"/>

                  <Element-66>XX</Element-66>

                  <Element-67>1588624894</Element-67>

                  </Segment-NM1>

                  <Segment-N3>

                  <Element-166>ONE ELLIOT WAY</Element-166>

                  <Element-166_1>HOSPITALIST PROGRAM   ELL</Element-166_1>

                  </Segment-N3>

                  <Segment-N4>

                  <Element-19>MANCHESTER</Element-19>

                  <Element-156>NH</Element-156>

                  <Element-116>03103</Element-116>

                  </Segment-N4>

                  </Loop-2420E>

                  <Loop-2430>

                  <Segment-SVD>

                  <Element-67>16013</Element-67>

                  <Element-782>5.88</Element-782>

                  <Composite-C003>

                  <Element-235>HC</Element-235>

                  <Element-234>E0570</Element-234>

                  <Element-1339>RR</Element-1339>

                  <Element-1339_1>KH</Element-1339_1>

                  </Composite-C003>

                  <Element-234 xsi:nil="true"/>

                  <Element-380>1</Element-380>

                  </Segment-SVD>

                  <Segment-CAS>

                  <Element-1033>CO</Element-1033>

                  <Element-1034>45</Element-1034>

                  <Element-782>43.23</Element-782>

                  <Element-380 xsi:nil="true"/>

                  <Element-1034_1>253</Element-1034_1>

                  <Element-782_1>.12</Element-782_1>

                  </Segment-CAS>

                  <Segment-CAS>

                  <Element-1033>PR</Element-1033>

                  <Element-1034>2</Element-1034>

                  <Element-782>1.5</Element-782>

                  </Segment-CAS>

                  <Segment-DTP>

                  <Element-374>573</Element-374>

                  <Element-1250>D8</Element-1250>

                  <Element-1251>20180105</Element-1251>

                  </Segment-DTP>

                  </Loop-2430>

                  </Loop-2400>

                  </Loop-2300>

                  </Loop-2000B>

                  <Segment-SE>

                  <Element-96>50</Element-96>

                  <Element-329>000000012</Element-329>

                  </Segment-SE>

                  </Transaction-837>

                  </ProfXDataToEDI837XML>

                   

                   

                   

                  XSLT :

                   

                  <?xml version="1.0" encoding="UTF-8" ?>

                  <xsl:stylesheet version="1.0"

                    xmlns:mhdr="http://www.oracle.com/XSL/Transform/java/oracle.tip.mediator.service.common.functions.MediatorExtnFunction"

                    xmlns:oraext="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"

                    xmlns:xsd="http://www.w3.org/2001/XMLSchema"

                    xmlns:xp20="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.Xpath20"

                    xmlns:xref="http://www.oracle.com/XSL/Transform/java/oracle.tip.xref.xpath.XRefXPathFunctions"

                    xmlns:socket="http://www.oracle.com/XSL/Transform/java/oracle.tip.adapter.socket.ProtocolTranslator"

                    xmlns:tns="http://XYZ.org/service/bpel/EdiClaimsRouting/837/Codes/V1"

                    xmlns:oracle-xsl-mapper="http://www.oracle.com/xsl/mapper/schemas"

                    xmlns:dvm="http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue"

                    xmlns:oraxsl="http://www.oracle.com/XSL/Transform/java"

                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns0="http://www.edifecs.com/xdata/200/PFF"

                  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

                    exclude-result-prefixes="xsd oracle-xsl-mapper xsi xsl ns0 tns mhdr oraext xp20 xref socket dvm oraxsl"

                    xmlns:ns2="http://www.edifecs.com/xdata/200/INST"

                    xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"

                    xmlns:ns7="http://XYZ.org/service/bpel/common/V1" xmlns:pc="http://xmlns.oracle.com/pcbpel/"

                    xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"

                    xmlns:ns6="http://XYZ.org/service/bpel/EdiClaimsRouting/837/PageLayout/V1"

                    xmlns:ns3="http://www.tibco.com/schemas/5010/837/PFF/FILENETProfessional"

                    xmlns:ns5="http://www.edifecs.com/xdata/200"

                  xmlns:ns1="http://xmlns.oracle.com/pcbpel/adapter/jms/EDIClaimsRouting/EDI837FileNet/jms837Canonical"

                    xmlns:jca="http://xmlns.oracle.com/pcbpel/wsdl/jca/"

                    xmlns:imp1="http://schemas.XYZ.org/Edi837Claim/V1">

                  <oracle-xsl-mapper:schema>

                  <!--SPECIFICATION OF MAP SOURCES AND TARGETS, DO NOT MODIFY.-->

                  <oracle-xsl-mapper:mapSources>

                  <oracle-xsl-mapper:source type="WSDL">

                  <oracle-xsl-mapper:schema location="../../WSDLs/jms837Canonical.wsdl"/>

                  <oracle-xsl-mapper:rootElement name="Transaction-837" namespace="http://www.edifecs.com/xdata/200/PFF"/>

                  </oracle-xsl-mapper:source>

                  </oracle-xsl-mapper:mapSources>

                  <oracle-xsl-mapper:mapTargets>

                  <oracle-xsl-mapper:target type="WSDL">

                  <oracle-xsl-mapper:schema location="../../WSDLs/jms837Canonical.wsdl"/>

                  <oracle-xsl-mapper:rootElement name="codes"

                    namespace="http://XYZ.org/service/bpel/EdiClaimsRouting/837/Codes/V1"/>

                  </oracle-xsl-mapper:target>

                  </oracle-xsl-mapper:mapTargets>

                  <!--GENERATED BY ORACLE XSL MAPPER 12.2.1.1.0(XSLT Build 160608.1900.0023) AT [SUN APR 08 22:24:18 EDT 2018].-->

                  </oracle-xsl-mapper:schema>

                  <!--User Editing allowed BELOW this line - DO NOT DELETE THIS LINE-->

                  <xsl:template match="/">

                  <tns:codes>

                  <tns:code>

                  <xsl:choose>

                  <xsl:when test="(/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270) and (/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270='BK')">

                  <tns:HdrDiagCd1>

                  <xsl:value-of select="/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1271"/>

                  </tns:HdrDiagCd1>

                  </xsl:when>

                  <xsl:when test="(/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270) and (/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270='BK')">

                  <tns:HdrDiagCd1>

                  <xsl:value-of select="/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1271"/>

                  </tns:HdrDiagCd1>

                  </xsl:when>

                  <xsl:when test="(/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270) and (/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270='ABK')">

                  <tns:HdrDiagCd1>

                  <xsl:value-of select="/ns0:Transaction-837/ns0:Loop-2000C[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1271"/>

                  </tns:HdrDiagCd1>

                  </xsl:when>

                  <xsl:when test="(/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270) and (/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1270='ABK')">

                  <tns:HdrDiagCd1>

                  <xsl:value-of select="/ns0:Transaction-837/ns0:Loop-2000B[1]/ns0:Loop-2300[1]/ns0:Segment-HI[1]/ns0:Composite-C022/ns0:Element-1271"/>

                  </tns:HdrDiagCd1>

                  </xsl:when>

                  <xsl:otherwise>

                  <tns:HdrDiagCd1>

                  <xsl:value-of select=""/>

                  </tns:HdrDiagCd1>

                  </xsl:otherwise>

                  </xsl:choose>

                  </tns:code>

                  </tns:codes>

                  </xsl:template>

                  </xsl:stylesheet>

                   

                   

                  Error Message on the BPEL Instance:

                  XPath expression failed to execute. An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc("../Transformations/Professional/Transform_GetDiagCodes_1.xsl", $ProfXDataToEDI837XML) The XPath expression failed to execute; the reason was: javax.xml.transform.TransformerConfigurationException: oracle.xml.xpath.XPathException: Expression error: Empty string. Check the detailed root cause described in the exception message text and verify that the XPath query is correct.

                  Please advise.
                  • 6. Re: Getting error message on XSLT mapper while performing the test on JDEV
                    Martien van den Akker

                    Ah, got that last week too.

                    The error states: Expression error: Empty string.

                     

                    And you've got:

                    ...

                    <tns:HdrDiagCd1>

                    <xsl:value-of select=""/>

                    </tns:HdrDiagCd1>

                    ...

                     

                    So either remove that block or fill in the select property...

                     

                    Regards,
                    Martien

                    1 person found this helpful
                    • 8. Re: Getting error message on XSLT mapper while performing the test on JDEV
                      Hari Selva

                      which tool are you using for XSLT parsing ?

                      • 9. Re: Getting error message on XSLT mapper while performing the test on JDEV
                        Martien van den Akker

                        JDeveloper and SOASuite.

                        But I also often use Notepad++ for simple editing, and XML formatting. I haven't done it much, but It should be able to do XSLT transformations too. But for me JDeveloper does the job properly.

                         

                        regards,
                        Martien

                        • 10. Re: Getting error message on XSLT mapper while performing the test on JDEV
                          Hari Selva

                          JDev crashes if the Transform is so big. So I started using Altova XMLSpy.

                           

                          Thanks..

                          • 11. Re: Getting error message on XSLT mapper while performing the test on JDEV
                            Martien van den Akker

                            You could increase the Xmx and Xmx values in jdev/ide/ide.conf...

                            I set these both to 2048M, so that JDev does not have to increase the heap repetatively. That helps in startup times.

                             

                            See for instance: https://blogs.oracle.com/ardaeralp/tune-your-jdeveloper-12c-1213 (not all the here mentioned settings are actual applicable).

                             

                            Regards,
                            Martien

                            1 person found this helpful
                            • 12. Re: Getting error message on XSLT mapper while performing the test on JDEV
                              Hari Selva

                              I followed this instruction already. it still causing the JDev slowness whenever I open up the huge XSLs.

                              • 13. Re: Getting error message on XSLT mapper while performing the test on JDEV
                                Martien van den Akker

                                Ok. What do you call Huge?

                                And are you running on a physical desktop or a VDI (Virtual Desktop Image)?

                                 

                                I experience similar problems at my customer on a VDI. What helped (slightly) is using the Garbage first collector (add the options -XX:+UseG1GC -XX:MaxGCPauseMillis=200 ass jvm options to the jdev/ide.conf ). Also do a clean application regularly (or delete the .data folder in the .jws folder)

                                 

                                Regards,

                                Martien

                                • 14. Re: Getting error message on XSLT mapper while performing the test on JDEV
                                  Hari Selva

                                  There are few things that affect the performance.

                                  1. XSL source and target has lot of elements.

                                  2. XSL file size is about 600 KB with lot of complex mappings.

                                   

                                  Its physical desktop. I am not on VDI. Let me check this option and will get back to you... add the options -XX:+UseG1GC -XX:MaxGCPauseMillis=200ass jvm options to the jdev/ide.conf

                                  1 2 Previous Next