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; p_init_msg_list VARCHAR2(30); –Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15); p_delivery_id NUMBER:= p_delivery_id_s; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER:=p_trip_id;…
Read MoreLIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilities. SQL Query: Execute the…
Read MoreQuery to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_number as the parameter. SQL Query:…
Read MoreMove concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…
Read MorePO SHIPMENT LINE UPDATE USING API Objective: The purpose of this document is to provide a comprehensive guide on how to update or split Purchase Order (PO) shipment lines using the relevant API. This includes a detailed explanation of the API endpoints, required and optional parameters, data structures, and sample requests and responses. The goal is to enable developers and system integrators to efficiently and accurately manage PO shipment lines within their applications line using API. Scenario: To achieve the goal of splitting the existing PO shipment lines into multiple lines via an API in Oracle, here’s a step-by-step outline of the process. This will include the general approach and considerations needed for splitting the shipment lines as described Currently below is the PO shipment line available in oracle, we would like to split the first shipment as 2 lines and second shipment line as 3 lines. PO Number PO Line Number Item Number Shipment Line number Org Quantity Promised Date Need by Date 100001 1 ABC1 1 USA 50 01-JUL-2022 100001 2 DCG2 2 USA 50 01-JUL-2022 Sample Data File to be prepare and load in to staging table PO_NUMBER…
Read MoreDelete ITEM Category in EBS using API. Introduction: To delete an Item Category in Oracle E-Business Suite (EBS) using an API, you’ll typically interact with an endpoint specifically designed for deleting or managing item categories. Prepare the Request: The request will generally involve sending the unique identifier of the item category you wish to delete. Script Code: DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); l_category_id NUMBER; BEGIN SELECT mcb.CATEGORY_ID INTO l_category_id FROM mtl_categories_b mcb WHERE mcb.SEGMENT1=’RED’ AND mcb.STRUCTURE_ID = (SELECT mcs_b.STRUCTURE_ID FROM mtl_category_sets_b mcs_b WHERE mcs_b.CATEGORY_SET_ID = (SELECT mcs_tl.CATEGORY_SET_ID FROM mtl_category_sets_tl mcs_tl WHERE CATEGORY_SET_NAME =’INV_COLORS_SET’ ) ); INV_ITEM_CATEGORY_PUB.Delete_Category ( p_api_version => 1.0,…
Read MoreManaging Oracle E-Business Suite Concurrent Processing and Cleaning concurrent processing tables Introduction: Oracle E-Business Suite (EBS) is a comprehensive suite of business applications, and its Concurrent Processing (CP) feature is…
Read MoreIntroduction In the demanding environment of database administration, managing multiple tasks efficiently is vital. For Oracle DBAs working on Linux systems, tmux (Terminal Multiplexer) is an essential tool. It enables…
Read MoreUnable to apply the receipts getting Error ACC DATE NOT IN OPEN PD Error message:- This error appears when Accounting Periods are not open in Payables Please make sure that…
Read Moredelete-icon-grayed-out Delete Button Does Not Appears On Transaction Page And Not Able To Delete An Invoice In Receivables STEPS ———————– The issue can be reproduced at will with…
Read More