This discussion is archived
7 Replies Latest reply: Dec 6, 2012 7:46 PM by VikrantKorde 1 RSS

OFR -> I/PM Integration (Input Agents) How to process XML that has metadata

user12953613 Newbie
Currently Being Moderated
Hi,

I am trying to configure ODC => OFR => I/PM.

Using OFR AP solution project, I am able to generate the below files under OFR/export folder.

1.The TIF image file.
2.The .XML output file.
3.The TXT file.

I have configured an Input Agents (Created application, Input definitions ) and I can see that the documents are being processed and getting created in imaging by Agents.

But, When it comes to metadata, only application fields those were mapped as input column based on sample data while configuring inputs are getting populated. The additional metadata values those are in .XML file are not getting populated. Do we need to configure BPEL process to update the metadata values separately? How to process this .XML file that contains additional metadata for that particular content ?

TXT file generated by OFR :
/home/Input/INV0000000000051_F5F74F15B58D4101858D969C2DB3DCD9_12042012.tif|INV0000000000051|F5F74F15B58D4101858D969C2DB3DCD9|04/12/12
@support|InvoiceImport|/home/Input/INV0000000000051_F5F74F15B58D4101858D969C2DB3DCD9_12042012.XML


XML file generated by OFR :

<- <invoiceImport>
<ScanDate>2012-04-12</ScanDate>
<URN>F5F74F15B58D4101858D969C2DB3DCD9</URN>
<BatchName>INV0000000000051</BatchName>
- <header>
<documentType>INVOICE</documentType>
<invoiceType>PO</invoiceType>
<orgID />
<invoiceNumber>SIDI039</invoiceNumber>
<invoiceDate>03/12/12</invoiceDate>
<vendorNumber>15</vendorNumber>
<vendorSiteID>6926</vendorSiteID>
<PONumber>4080008374</PONumber>
<invoiceTotalAmount>1.00</invoiceTotalAmount>
<currencyCode>USD</currencyCode>
<employeeName />
<invalidReason>NONE</invalidReason>
<invalidCode>0</invalidCode>
</header>
</invoiceImport>


Thanks in advance.

Jay
  • 1. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    VikrantKorde 1 Explorer
    Currently Being Moderated
    Hi Jay,

    check the first payload received by document routing for OFR instance. It should have all the information. something like this


    <inputVariable>
    <part name="payload">
    <process>
    <ns1:injectionId>6</ns1:injectionId>
    <ns1:attachment>
    <ns2:name>6.IPM_001119</ns2:name>
    <ns2:URI>https://ipm/imaging/faces/Pages/UrlTools.jspx?ToolName=AWVWR&DocumentId=6.IPM_001119</ns2:URI>
    </ns1:attachment>
    <ns1:document>
    <ns3:classification>OFR</ns3:classification>
    </ns1:document>
    <ns1:invoice>
    <ns3:scanArchiveID/>
    <ns3:scanBatchID/>
    <ns3:scanDocumentID/>
    <ns3:status/>
    <ns3:priority>0</ns3:priority>
    <ns3:organization>2041111</ns3:organization>
    <ns3:processingGroup/>
    </ns1:invoice>
    <ns1:invoiceImport>
    <ns1:header>
    <ns1:documentType>INVOICE</ns1:documentType>
    <ns1:invoiceType>NO-PO</ns1:invoiceType>
    <ns1:invoiceNumber>11463884</ns1:invoiceNumber>
    <ns1:invoiceDate>2012-06-11</ns1:invoiceDate>
    <ns1:vendorNumber>114395</ns1:vendorNumber>
    <ns1:PONumber/>
    <ns1:invoiceTotalAmount>11.33</ns1:invoiceTotalAmount>
    <ns1:currencyCode>USD</ns1:currencyCode>
    <ns1:vendorSiteID/>
    <ns1:employeeName/>
    <ns1:orgID>2041111</ns1:orgID>
    <ns1:invalidReason>NONE</ns1:invalidReason>
    <ns1:PAGENUMBER/>
    <ns1:SERIALNUMBER/>
    <ns1:BENEFITSTATUS/>
    </ns1:header>
    <ns1:lineItems>
    <ns1:lineItem>
    <ns1:lineNumber>1</ns1:lineNumber>
    <ns1:linePONumber/>
    <ns1:linePOLineNumber/>
    <ns1:description/>
    <ns1:quantity>1</ns1:quantity>
    <ns1:unitPrice>5.14</ns1:unitPrice>
    <ns1:lineTotalAmount>5.14</ns1:lineTotalAmount>
    <ns1:lineType/>
    <ns1:UOM/>
    </ns1:lineItem>
    <ns1:lineItem>
    <ns1:lineNumber>2</ns1:lineNumber>
    <ns1:linePONumber/>
    <ns1:linePOLineNumber/>
    <ns1:description>FREIGHT</ns1:description>
    <ns1:quantity>1</ns1:quantity>
    <ns1:unitPrice>6.13</ns1:unitPrice>
    <ns1:lineTotalAmount>6.13</ns1:lineTotalAmount>
    <ns1:lineType/>
    <ns1:UOM/>
    </ns1:lineItem>
    </ns1:lineItems>
    </ns1:invoiceImport>
    </process>
    </part>
    </inputVariable>

    If this is not happening then you need to do check the mapping in "Application" for BPEL integration.
    - login to Imaging with admin user
    - go to Manage application -> invoices
    - Check for Workflow Configuration
    - under that check payload properties
    This should have entry for "process.invoiceImport     Supporting Content          InvoiceImport:/invoiceImport"

    Regards,
    Vikrant Korde.
  • 2. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    user12953613 Newbie
    Currently Being Moderated
    Hi Vikrant,

    Thanks for your response.

    It shows the below error when i get into Application > Workflow Configuration …

    "You do not have access to any workflow connections. You will not be able to add or modify workflow configurations until you have access to at least one workflow connection."

    Does it require an additional setting?

    Jay
  • 3. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    VikrantKorde 1 Explorer
    Currently Being Moderated
    Hi Jay,

    Yes you need to create a connection between IPM and SOA server. Do the below mentioned steps
    - Login to imaging with admin user
    - Goto Manage connections
    - Click on Create Workflow connection
    - enter the details in it for SOA server
    - make sure the provider is based on t3 protocol i.e. t3://{host}:8001 instead of http.

    Regards,
    Vikrant Korde.
  • 4. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    user12953613 Newbie
    Currently Being Moderated
    Thanks Vikrant.

    I am able to make a successful connection with SOA.

    Do we need to deploy any default service into SOA that provided by oracle ? or we need to create a new service based on our requirements?

    Thanks,
    Jay
  • 5. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    VikrantKorde 1 Explorer
    Currently Being Moderated
    Hi Jay,

    Yes we need to deploy the BPEL provided by AP solution accelerators on that SOA server.
    Document routing - default needs to be configured with workflow connection with IPM application-Invoices.

    Regards,
    Vikrant Korde.
  • 6. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    user12953613 Newbie
    Currently Being Moderated
    Hi Vikrant,

    Thanks a lot for your response and guidance.

    Ha! Is that something we can download it from oracle or we should speak to oracle?

    I don’t see anything called "accelerators" in OFR - AP solution project bundle.

    Note : Just to summarise, I am looking for the way to populate metadata values from OFR to I/PM / Content server.

    Please advice.

    -J
  • 7. Re: OFR -> I/PM Integration (Input Agents) How to process XML that has metadata
    VikrantKorde 1 Explorer
    Currently Being Moderated
    Hi Jay,

    As of now AP solution accelerator is not available freely. You need to talk to Oracle and get the copy.

    About your summary question...
    you can push the data in IPM application (which is actually stored in UCM) without having workflow also. But that is useless.
    So ideally you need solution accelerator BPEL to make it proper and make some sense out of it.

    Regards,
    Vikrant Korde.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points