Hi All,
I am working on Proxy to JDBC using Stored Procedure scenario.
When i am sending proxy data to the data base,its showing successful in the adapter engine and reciver channel but the data is not getting populated in the target structure.Rather its taking default blank values...
Source side :
<ZDT_CUST_HIER_ECC_4283_REQ_ITE>
<CONTROLLER />
<CUST_LIFE_NO>112244</CUST_LIFE_NO>
<UPDATE_TMS>2012-02-29 22:11:48</UPDATE_TMS>
<ACTION_CODE>A</ACTION_CODE>
<SALES_ORG>CA01</SALES_ORG>
<DIST_CHAN>45</DIST_CHAN>
Target Side:
<Statement>
- <Customer_Hierarchy_TypeG action="EXECUTE">
<table>W2W_sp_InboundTypeGCustHier_CAN</table>
<cust_life_num type="VARCHAR" />
<last_updated_tms type="VARCHAR">1900-01-01</last_updated_tms>
<action_code type="VARCHAR" />
<sales_org type="VARCHAR" />
<dist_channel type="VARCHAR" />
<division type="VARCHAR" />
I think Statement is not mapped to right field...but i dnt know thw right field...
Please help urgently !!!!