Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DVM lookup in XSLT

FrancisAug 18 2012 — edited Feb 26 2020
Hi all,

I am using DVM loopup for multiple selection , But everytime i am seeing the output as "NotFound"

DVM:
SenderID Receiver ID orderid ordertype custid bussid
006995419LATST 006995419LATST SA USAOP CRM138150 123456
006995419LATST 623448073TEST SS U SAOP CRM138150 CRM138150
006995419LATST 623448073TEST RN USAOS CRM138150 CRM138150

Ex: select BilltoCustid where SenderId=XX,ReceiverID=XX,Ordertype=XX

Can we do this by using DVMLOOKUP, if yes please suggest me with solution

I am using the below query , I am getting the output as "Notfound" everytime
<xsl:value-of select='dvm:lookupValue("EDIOrderFDM.dvm","Ordertype",../ns0:Segment-BEG/ns0:Element-92/@Type,"SoldtoCustid","NOTFOUND","SenderID","8642882432","ReceiverID","623448073")'/>

Correct me if I am wrong


Regards
francis
This post has been answered by NarsingPumandla on Aug 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2012
Added on Aug 18 2012
5 comments
3,225 views