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!