SaveSavedRemoved 0

Create Reservation API Sample

Using inv_reservation_pub.create_reservation DECLARE p_rsv inv_reservation_global.mtl_reservation_rec_type; p_dummy_sn inv_reservation_global.serial_number_tbl_type; x_msg_count NUMBER; x_msg_data VARCHAR2(240); x_rsv_id ...

READ MORE +

SaveSavedRemoved 0

wms_container_pub.Create_LPN

To create new LPN Sample script to pack using wms_container_pub.Create_LPN API  create or replace procedure IDC_pack_to_LPN( p_sub_inv varchar2,p_item_id number,p_qty number,loc_id number) is l_return_status varchar2(5); l_msg_count number; l_msg_data varchar2(1000); l_lpn_id number; l_lpn ...

READ MORE +

SaveSavedRemoved 0

Bulk Price List Upload in Oracle EBS

Using QP_INTERFACE_LIST_HEADERS , QP_INTERFACE_LIST_LINES Sample script to import price list using interface tables QP_INTERFACE_LIST_HEADERS QP_INTERFACE_QUALIFIERS  create or replace package idc_bulk_Pricelist_pkg as procedure IDC_BulkUpload (p_PriceList_Name in varchar2, p_item in ...

READ MORE +

Check it Out

SaveSavedRemoved 0

Create sales order using interface OE_HEADERS_IFACE_ALL ,OE_LINES_IFACE_ALL

Sample PL Sql Package for creating Order in Oracle EBS create or replace PROCEDURE idc_create_so_from_sa_prc1(p_header_id IN NUMBER) IS --declare v_header_id NUMBER; v_org_id NUMBER; v_order_type_id NUMBER; v_price_list_id NUMBER; ...

READ MORE +

SaveSavedRemoved 0

Create Project API PA_Project_pub

Sample PL Sql Package for creating projects in Oracle EBS create table idc_msgs (data varchar2(2000)); / create or replace procedure idc_create_proj_SO (v_ord_num varchar2) is -- Variables needed to create task hierachy a NUMBER; m NUMBER; parent ...

READ MORE +

SaveSavedRemoved 0

AR Invoice Import In Oracle EBS

Sample PL Sql Package for importing AR Invoices in Oracle EBS CREATE OR REPLACE PACKAGE IDC_IMPORT_ARINV_PKG AS PROCEDURE IDC_INSERT_ARINV (P_TRX_TYPE VARCHAR2, P_BILL_TO VARCHAR2, P_ITEM_DESCRIPTION VARCHAR2, P_PAYMENT_TERM VARCHAR2, P_INVOICE_DATE VARCHAR2, P_QUANTITY VARCHAR2, P_UNITSELLPRICE VARCHAR2, ...

READ MORE +

SaveSavedRemoved 0

PO Requisitions Import EBS

Sample PL Sql Package for importing requisitions in Oracle EBS CREATE OR REPLACE PACKAGE IDC_IMPORT_POREQ_PKG AS PROCEDURE IDC_INSERT_REQS (P_REQ_NUMBER_SEGMENT1 VARCHAR2, P_INTERFACE_SOURCE_CODE VARCHAR2, P_REQUISITION_TYPE VARCHAR2, P_AUTHORIZATION_STATUS VARCHAR2, P_SOURCE_TYPE_CODE VARCHAR2, ...

READ MORE +

SaveSavedRemoved 0

EBS Integrated SOA Gateway

What is EBS SOA Gateway Integration Repository EBS Integrated SOA Gateway is a module in the Oracle e-business suite to integrate with other applications. As the term implies "Integrated", it is part of the Oracle E-business suite and is the Door for external applications to talk to EBS. Thus Integrated SOA ...

READ MORE +