5 Replies Latest reply: Jan 26, 2012 3:51 PM by 788829 RSS

    LookXref issue in AIA 10g

    699915
      Hi All,

      We have a flow which consists of two BPELs. BPEL 'A' and BPEL 'B' which are connected through an ESB 'E'.

      In BPEL 'A', there is a transformation file 'FA.xsl' in which we are populating columns APP_01 and COMMON in xref table 'XREF_IDENTIFIER' with values say '100' and '35303038373030313531383831393837'. Value in COMMON field is generated using generate guid command. The values are getting populated properly.

      Please find the template and call template code below:

      Populate Xref Statement:
      xref:populateXRefRow($xrefTableName,$xrefReferenceColumnName,$xrefReferenceValue,$xrefColumnName,orcl:generate-guid(),'ADD') – statement in template

      Values passed to template:
      <xsl:call-template name="lookupXRef">
      <xsl:with-param name="xrefTableName" select='"XREF_IDENTIFIER"'/>
      <xsl:with-param name="xrefReferenceColumnName"
      select='"APP_01"'/>
      <xsl:with-param name="xrefReferenceValue"
      select="/ns0:SyncItemCompositionListEBM/ns0:DataArea/ns0:SyncItemCompositionList/corecomEBO:Item/corecom:ItemIdentification/corecom:ID"/>
      <xsl:with-param name="xrefColumnName" select='"COMMON"'/>
      </xsl:call-template>


      The COMMON value is passed to BPEL 'B'. In BPEL 'B', there is another transformation file 'FB.xsl' in which we are looking up the value of APP_01 using the COMMON value.
      Now although the APP_01 value is populated in XREF table, we are getting error as follows:

      Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.RepositoryException: lookup could not find
      values in column name "APP_01" for table name "XREF_IDENTIFIER" using reference column name "COMMON" and reference value
      "35303038373030313531383831393837"

      If I retrigger the flow again, it works fine.
      Can you please help me out in resolving the issue?

      Thanks in advance!!!!!!