Skip to Content
0
Former Member
Mar 01, 2012 at 08:36 AM

Issue while testing Inbound Client Proxy to JDBC using SP

30 Views

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 !!!!