Skip to Content
0
Feb 22, 2011 at 05:36 AM

Deleting Duplicate Entries in sender JDBC adapter

159 Views

Hi i am working on JDBC to IDOC scenario.

When i am fetching the records from the Oracle database table using select query, i am getting the records but its getting duplicated many a times and hence its failing at an idoc processing at ECC side..

Could someone help me in deleting the Duplicate entries and passing only the required entries from Oracle databse to IDOC.

Here is my select query.:

Select a.order_num, a.sap_delivery_number, a.sap_delivery_line_number, a.warehouse, a.product, a.product_size, a.order_qty, a.ship_qty from XXX_h a,tr_log t where a.Prod_id = 101..

Appreciate your help.

Regards