Update the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the project and its task using application [...]
API Script To Update Supplier Details
This blog has the script to update the supplier details using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR. Cause of the issue: Some of the fields are not visible and don’t have option to update [...]
Ship Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2)IS–Standard Parameters.p_api_version NUMBER := [...]
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; [...]
Ship Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_version NUMBER := 1.0; [...]
To Upload Credit Memos in EBS
DEclare l_tax_combination_id number; l_return_status VARCHAR2 (100); l_error VARCHAR2 (1000); v_request_id NUMBER; v_msg_count NUMBER; [...]
Interfacing EBS Orders with External Application
We made use of utl_http to post json_data. This piece of code will help in sending data to Custom Applications DECLARE vrequest CLOB; [...]
XML Publisher Bursting Barcode Font is Ignored
In XML Publisher Bursting Barcode Font is Ignored. An XML Publisher concurrent program that produces a PDF output with barcodes works when running the concurrent program and viewing the output. [...]
