Forum Stats

  • 3,769,907 Users
  • 2,253,029 Discussions
  • 7,875,235 Comments

Discussions

How to create a new custom SOAP API in the Oracle EBS

Mihir P
Mihir P Member Posts: 7 Red Ribbon

How to create a new custom SOAP API in the Oracle EBS.

Basically ,

We are looking for a way where we can create a new custom SOAP api(not the seeded ones, where in we want to run the below query and return the result), so that this can be exported in some way and given to the end user to import this custom api on his EBS setup without causing any harm to the existing SOAP apis


Could you help out with documentation for this process?


SELECT wdd.source_header_type_name ORDER_TYPE,

wdd.source_header_number ORDER_NUMBER,

wdd.source_line_number ORDER_LINE_NUMBER,

wdd.delivery_Detail_id,

wdd.source_header_id,

wdd.organization_id,

wdd.creation_date,

wdd.inventory_item_id,

wdd.CUST_PO_NUMBER,

wnd.delivery_id,

wnd.ship_method_code,

wnd.waybill,

wdd.ORG_ID OPERATING_UNIT_ID,

wdd.SUBINVENTORY,

wdd.SHIPPED_QUANTITY

FROM APPS.wsh_new_deliveries wnd,

APPS.wsh_delivery_assignments wda,

APPS.wsh_delivery_details wdd

WHERE wnd.delivery_id = wda.delivery_id

AND wda.delivery_detail_id = wdd.delivery_detail_id

AND wdd.source_header_number = --Pass the Order Number

ORDER BY wdd.SOURCE_HEADER_NUMBER, wdd.SOURCE_LINE_NUMBER


Sorry for my lack on knowledge on this as I am quite new to EBS and looking for some urgent help as I am running on a tight deadline.

Could you help out on the way to proceed and the feasibility of export and import which I am looking for


Any help is greatly appreciated!

Answers