po requisitions with oracel xml gateway
hi all,
i was given a requirement to use oracle xml gateway in importing data from an external source... client gave me 2 files to play with.
XML
<?xml version = "1.0"?>
<MSG_IP_MAT_ISSUE ID = "WMIS-616002" SRC_SYSTEM_CODE = "WMIS" SRC_SYSTEM_INSTANCE = "WMIS">
<MATREQ:MAT_REQ xmlns:MATREQ = "MATREQ" >
<MATREQ:COMMENTS>Testing PLS email</MATREQ:COMMENTS>
<MATREQ:DELIVERY_DATE>01/22/2010</MATREQ:DELIVERY_DATE>
<MATREQ:MAT_REQ_BY_PERSON_NO>1782</MATREQ:MAT_REQ_BY_PERSON_NO>
<MATREQ:MAT_REQ_DATE>01/22/2010</MATREQ:MAT_REQ_DATE>
<MATREQ:MAT_REQ_ID>71500</MATREQ:MAT_REQ_ID>
<MATREQ:PROJECT_NO>119488</MATREQ:PROJECT_NO>
<MATREQ:SHIP_TO_ADDRESS>10TH</MATREQ:SHIP_TO_ADDRESS>
i was given a requirement to use oracle xml gateway in importing data from an external source... client gave me 2 files to play with.
XML
<?xml version = "1.0"?>
<MSG_IP_MAT_ISSUE ID = "WMIS-616002" SRC_SYSTEM_CODE = "WMIS" SRC_SYSTEM_INSTANCE = "WMIS">
<MATREQ:MAT_REQ xmlns:MATREQ = "MATREQ" >
<MATREQ:COMMENTS>Testing PLS email</MATREQ:COMMENTS>
<MATREQ:DELIVERY_DATE>01/22/2010</MATREQ:DELIVERY_DATE>
<MATREQ:MAT_REQ_BY_PERSON_NO>1782</MATREQ:MAT_REQ_BY_PERSON_NO>
<MATREQ:MAT_REQ_DATE>01/22/2010</MATREQ:MAT_REQ_DATE>
<MATREQ:MAT_REQ_ID>71500</MATREQ:MAT_REQ_ID>
<MATREQ:PROJECT_NO>119488</MATREQ:PROJECT_NO>
<MATREQ:SHIP_TO_ADDRESS>10TH</MATREQ:SHIP_TO_ADDRESS>
0