Delete the concurrent programs
Delete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concurrent program needs…
Read MoreDeterministic Functions in Oracle
Deterministic Functions in Oracle Overview A deterministic function in Oracle is a function that always returns the same result for the same input values and has no side effects.…
Read MorePO SHIPMENT LINE UPDATE USING API
PO 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
Delete 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 MoreQuery to find the Legal Entity, Organization, Company Code in Oracle Apps EBS.
Intro:-This script will provide all related Bom Routing department details. Code:- SELECT xep.legal_entity_id “Legal Entity ID”, xep.name “Legal Entity”, hr_outl.name “Organization Name”, hr_outl.organization_id “Organization ID”, …
Read MoreQuery to find Form Personalization in Oracle apps
Intro:-This script will provide all related Form Personalization details. Code:- SELECT ffv.form_id “Form ID”, ffv.form_name “Form Name”, ffv.user_form_name “User Form Name”, ffv.description “Form Description”, …
Read MoreMultiple files upload in Oracle
External table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control file having issue to load…
Read MoreFeature Oracle Database 12c, 19c, 21c
Feature Oracle Database 12c, 19c, 21c Introduction: Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is…
Read MoreCustomer Contact Details in EBS
Introduction: This blog has the SQL query that can be used to pull the data Organization contact details. Cause of the issue: Business wants to reach the organization contact…
Read MoreSQL Loader using External table
Introduction: This blog has the SQL loader using external Table. Cause of the issue: Business wants to load the data with a field having multiple line we can use this…
Read More