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 to be run.  [...]

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. It does not [...]

 PO SHIPMENT LINE  UPDATE USING API Objective:  [...]

           Delete ITEM Category in EBS using API. Introduction: [...]

  Intro:-This script will provide all related Bom Routing department details.  Code:-  SELECT         xep.legal_entity_id        “Legal Entity ID”,         [...]

      Intro:-This script will provide all related Form Personalization details.  Code:-  SELECT ffv.form_id          “Form ID”,         ffv.form_name        “Form [...]

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 the record [...]

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 [...]

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 details like [...]

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 . How do we solve: Create an [...]