Patch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015 Step: -1 Environment Details export ORACLE_HOME=/u01/app/19c/grid export PATH=/u01/app/19c/grid/bin: $PATH [oracle@rac1 ~]$ srvctl config database -verbose oradb /u01/app/oracle/product/19c/dbhome_1 19.0.0.0.0…
Read More1. Overview This blog explains about, How to insert bulk records within a milli seconds by using Bulk Collect with FORALL. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL 3. Use Case Create one procedure in database object. Run the procedure. 4. Architecture Oracle Database 18C PLSQL 5. Examples Step 1: Create one Procedure in Database object like below: CREATE OR REPLACE PROCEDURE increase_salary ( department_id_in IN employees.department_id%TYPE, increase_pct_in IN NUMBER) IS TYPE employee_ids_t IS TABLE OF employees.employee_id%TYPE INDEX BY PLS_INTEGER; l_employee_ids employee_ids_t; l_eligible_ids employee_ids_t; l_eligible BOOLEAN; BEGIN SELECT employee_id BULK COLLECT INTO l_employee_ids FROM employees WHERE department_id = increase_salary.department_id_in; FOR indx IN 1 .. l_employee_ids.COUNT LOOP check_eligibility (l_employee_ids (indx),…
Read More1. Overview This blog explains about, How to Use Webutil browse file from desktop to directory . 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create the form like the below. Use the below code In load file “button” using “when-button-pressed” trigger. 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one form like below: Step 2: using the below code In load file “button” using “when-button-pressed” trigger. Code: DECLARE l_userhome VARCHAR2 (200) := webutil_clientinfo.get_system_property (‘user.home’) || ‘\Desktop’; l_filename VARCHAR2 (200) := NULL; l_bare_filename VARCHAR2 (200) := NULL; l_fileprefix VARCHAR2 (200) := NULL; l_serverfilename VARCHAR2 (200) := NULL; l_upload_path VARCHAR2 (200) := NULL; l_version_path VARCHAR2 (200) := NULL; l_option_grade_path VARCHAR2 (200) := NULL; l_size_curve_path VARCHAR2 (200) := NULL; l_filesize NUMBER; al_con alert; l_status BOOLEAN;…
Read Moreoracle-ebs-query-to-concurrent-details-for-past-60-days SELECT distinct ft.user_concurrent_program_name “Concurrent Program Name”, fr.REQUEST_ID “Request ID”, to_char(fr.ACTUAL_START_DATE,’dd-MON-yy hh24:mi:ss’) “Started Date”, to_char(fr.ACTUAL_COMPLETION_DATE,’dd-MON-yy hh24:mi:ss’) “Completed Date”, decode(fr.PHASE_CODE,’C’,’Completed’,’I’,’Inactive’,’P’,’Pending’,’R’,’Running’,’NA’) “Phasecode”, decode(fr.STATUS_CODE, ‘A’,’Waiting’, ‘B’,’Resuming’, ‘C’,’Normal’, ‘D’,’Cancelled’, ‘E’,’Error’, ‘F’,’Scheduled’, ‘G’,’Warning’, ‘H’,’On Hold’,…
Read Moreoracle-ebs-query-to-get-po-details Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, supplier_number, supplier_name, po_number, po_creation_date, po_approved_date, …
Read MoreIntroduction to Google Cloud and Terraform Google Cloud Platform provides a comprehensive suite of cloud services, including computing, storage, databases, machine learning, and more. With its global network infrastructure and…
Read MoreWebADI Create Document Redirects From HTTP To HTTPS Error := Causing Error ERR_SSL_PROTOCOL_ERROR On Oracle EBS R12.2.5 the default URL is HTTP:// but when you navigate to Desktop…
Read MoreInventory load failed in Oracle APPS R12 Inventory load failed… OPatch cannot load inventory for the given Oracle Home in Oracle APPS R12. Possible causes are: oradev@oracle…
Read MoreThe Challenge:As infrastructures grow in complexity, maintaining and deploying resources across multiple environments can become a daunting task. Code duplication, consistency challenges, and scaling bottlenecks are common hurdles. The Terraform…
Read More