I'm attempting to insert into a table using the JDBC adapter and I need to specify the schema. Below is the format of my resulting xml mapped to insert into the table.
1. Am I missing something to make it specify ARIBAUSR.PO_RETURN as the table as opposed to just PO_RETURN? I'm using a different user for the JDBC connection in the adapter.
2. Is there somewhere I can look inside XI to see if this is really a SQL/database error? In the monitoring tool, it says it was successful everywhere I look. Only there's no insert into my table. I have tried to run a mannual SQL insert with the data in this file and it works perfectly.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns:PO_RETURN_insert xmlns:ns="urn:test_sap-ariba-PO:staging">
- <PO_RETURN action="INSERT">
<MESSAGE>Enter Document type</MESSAGE>