BhushanC
Active Member
Dear JDElist,
Our client has implemented E1 9.1 version and they would like use JDE BSSV through SSRS (SQL Server Reporting Services).
Please tell us, how we should call JDE web services from SSRS.
We are using following query function to call simple address book JDE BSSV from SSRS; however we are not getting correct data/output from below query function.
********************SSRS Query to JDE address book BSSV ******************
<query>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlnsrac="http://oracle.e1.bssv.JPR01000/" xmlns:java="javaracle.e1.bssv.JPR01000.valueobject" xmlns:java1="javaracle.e1.bssv.JR010020.valueobject">
<soapenv:Header>
<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
soapenv:mustUnderstand="1">
</wsse:Security>
</soapenv:Header>
<soapenv:Body>
<orac:getAddressBookElement>
<java:Entity>
<java1:EntityId>5562256</java1:EntityId>
</java:Entity>
</orac:getAddressBookElement>
</soapenv:Body>
</soapenv:Envelope>
</query>
********************SSRS Query to JDE address book BSSV ******************
Thanks in advance for your help.
Best regards,
Bhushan
Our client has implemented E1 9.1 version and they would like use JDE BSSV through SSRS (SQL Server Reporting Services).
Please tell us, how we should call JDE web services from SSRS.
We are using following query function to call simple address book JDE BSSV from SSRS; however we are not getting correct data/output from below query function.
********************SSRS Query to JDE address book BSSV ******************
<query>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlnsrac="http://oracle.e1.bssv.JPR01000/" xmlns:java="javaracle.e1.bssv.JPR01000.valueobject" xmlns:java1="javaracle.e1.bssv.JR010020.valueobject">
<soapenv:Header>
<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
soapenv:mustUnderstand="1">
</wsse:Security>
</soapenv:Header>
<soapenv:Body>
<orac:getAddressBookElement>
<java:Entity>
<java1:EntityId>5562256</java1:EntityId>
</java:Entity>
</orac:getAddressBookElement>
</soapenv:Body>
</soapenv:Envelope>
</query>
********************SSRS Query to JDE address book BSSV ******************
Thanks in advance for your help.
Best regards,
Bhushan