Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

jdbc receiver adapter using stored procedure

Hi All,

My requirement :

Sender : Proxy

Receiver : JDBC  with STORED PROCEDURE.

Can any one explain me the steps in ESR.

Thanks in advance,

harsha

Former Member
Former Member replied

Hi raj,

This is my message in sxmb_moni.

When checked this in message mapping its working fine.But i am unable to insert record into the table.

<?xml version="1.0" encoding="utf-8"?>

<nm:MOAEmployeePersonnelData xmlns:prx="urn:sap.com:proxy:DE1:/1SAI/TAS2D2D5DD53FDE25480899:702" xmlns:nm="urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems">

   <EmployeePersonnelData>

      <EMPLID>00070001</EMPLID>

      <EFFDT>2012-01-02</EFFDT>

      <DEPTID>1814100</DEPTID>

      <FTE> 71.42</FTE>

      <STD_HOURS>40.00</STD_HOURS>

      <BIRTHDATE>1976-01-01</BIRTHDATE>

      <FIRST_NAME>Anchorage</FIRST_NAME>

      <MIDDLE_NAME>jhon</MIDDLE_NAME>

      <LAST_NAME>Firefighter</LAST_NAME>

      <REG_TEMP>1</REG_TEMP>

      <FULL_PART_TIME>1T</FULL_PART_TIME>

      <HIRE_DT>2012-01-10</HIRE_DT>

      <REHIRE_DT>2012-01-10</REHIRE_DT>

      <MLP_HIRE_DATE>2012-01-02</MLP_HIRE_DATE>

      <SERVICE_DT>2012-01-10</SERVICE_DT>

      <EMAIL_ADDRES>test@gmail.com</EMAIL_ADDRES>

      <STREET_HOUSENUMBER>1000 G ST  TEST</STREET_HOUSENUMBER>

      <CITY>Anchorage</CITY>

      <DISTRICT>Anchorage</DISTRICT>

      <POSTAL_CODE>99501</POSTAL_CODE>

      <COUNTRY_CODE>USA</COUNTRY_CODE>

      <USER_ID>user</USER_ID>

      <NETWORK_ID>IDSXK</NETWORK_ID>

      <SUPV>manager</SUPV>

      <WAGE_EFFDT>2012-05-15</WAGE_EFFDT>

      <ORIG_HIRE_DT>2012-02-10</ORIG_HIRE_DT>

      <CMPNY_SENIORITY_DT>2012-02-10</CMPNY_SENIORITY_DT>

      <PAY_RATE>234</PAY_RATE>

      <PAY_RATE_HOURLY>465</PAY_RATE_HOURLY>

      <EMP_STATUS>3</EMP_STATUS>

      <IS_MANAGER>1</IS_MANAGER>

      <EMERGENCY_PHNNUM/>

      <WORK_PHONE>1234567891</WORK_PHONE>

      <CELL_PHONE>1234567891</CELL_PHONE>

      <HOME_PHONE>1234567891</HOME_PHONE>

      <POSITION_NUMBER>99999999</POSITION_NUMBER>

      <JOB_CODE>1234567891</JOB_CODE>

      <JOB_CODE_DESCRIPTION>Accounting Clerk</JOB_CODE_DESCRIPTION>

      <WORK_SCH_RULE>KELLY-A</WORK_SCH_RULE>

      <WORK_SCH_RULE_DESC>5735  00</WORK_SCH_RULE_DESC>

      <COST_CENTER>6589656523</COST_CENTER>

      <PRI_LBR_ACC_SDATE>2012-02-10</PRI_LBR_ACC_SDATE>

      <DIY_WORK_HRS>M123456789</DIY_WORK_HRS>

      <INTERNAL_ORDER>1234567892</INTERNAL_ORDER>

      <WBS_ELEMENT>M1234567</WBS_ELEMENT>

      <FUND>987654321</FUND>

      <FUNCTIONAL_AREA>365214552</FUNCTIONAL_AREA>

      <GRANT>Not Applicable</GRANT>

      <BUSINESS_AREA>3400</BUSINESS_AREA>

      <PA_TEXT>FIRE</PA_TEXT>

      <PSA_TEXT>Executives EX</PSA_TEXT>

      <EG_TEXT>Regular Full-Time</EG_TEXT>

      <ESG_TEXT>w/LV No-IN &amp; Retire</ESG_TEXT>

      <POS_TEXT>Default position</POS_TEXT>

      <ORG_UNIT>00000000</ORG_UNIT>

      <ORG_UNIT_TEXT>Employment</ORG_UNIT_TEXT>

      <COST_CENTER_TEXT>Employment</COST_CENTER_TEXT>

   </EmployeePersonnelData>

</nm:MOAEmployeePersonnelData>

Please tell me how to check my stored procedure is active or not.

Thanks & regards,

harsha

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question