How to Monitor the Performance of MYSQL Database Introduction: – Monitoring MySQL performance is crucial for maintaining a healthy and efficient database system. There are several tools and techniques you…
Read MoreHow to Monitor the Performance of Amazon DynamoDB Introduction: – Monitoring the performance of Amazon DynamoDB involves tracking key metrics, setting up alarms for thresholds, and using tools like AWS…
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 MoreData Integrator on the other are very useful for moving and converting data between systems, databases and various platforms. Here’s a detailed overview of the typical steps involved in using a…
Read MoreIntroduction Oracle APEX Tree Regions are excellent for displaying hierarchical data like employee-manager relationships. In this blog post, we’ll explore how to capture the selected employee’s name and their hierarchical…
Read MoreIntroduction Oracle APEX offers powerful tools to create interactive, dynamic applications. One common requirement is to update the header of an Interactive Grid region based on the value of a…
Read MoreThe Fundamentals of User Interface Design Introduction: In digital experiences, user interface (UI) design is pivotal in shaping how users interact with and perceive a product or service.…
Read MoreThe Evolution of User Experience Design: From origins of Modern Trends Introduction: In the digital age, user experience (UX) design is more than just a buzzword—it’s a…
Read MoreDESCRIPTION: When attempting to shut down database, the database hangs and the alert log contains the below messages. “SHUTDOWN: Waiting for active calls to complete” CAUSES: Database is waiting for…
Read More