Step 1: Create XML Data Template <?xml version=”1.0″ encoding=”UTF-8″ ?> <dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″> <properties> <property name=”xml_tag_case” value=”upper”/> <property name=”Include_Parameters” value=”True”/> </properties> <parameters> <parameter name=”P_VENDOR_ID” dataType=”NUMBER”/> <parameter name=”P_INVOICE_NUM” dataType=”CHARACTER”/> <parameter…
Read MoreKanban Board Implementation in Oracle APEX Introduction This document explains how to build a dynamic Kanban Board in Oracle APEX using JavaScript, SortableJS, and AJAX Callbacks. A Kanban Board is…
Read MoreDynamic Printable PDF Document in Oracle APEX Introduction In this document, we demonstrate how to create a dynamic printable document in Oracle APEX using a Dynamic Content Region.The content is…
Read MoreIntroduction In Oracle APEX Interactive Grids, users often add a new row while other existing rows are still editable. This can lead to accidental clicks, unintended edits, or triggering Dynamic…
Read MoreIntroduction In Oracle APEX Interactive Reports (IR), aggregate values such as SUM or AVG are always displayed at the bottom of the report. For reports with many rows, users must…
Read MoreA Practical Guide for Oracle DBAs Indexes play a critical role in Oracle database performance. While well-designed indexes can dramatically improve query response time, unused or missing indexes can just…
Read MoreA Practical Guide for DBAs Auditing helps Oracle DBAs track who did what, when, and from where. Whether for security reviews, compliance, or incident investigations, having ready-to-use audit queries saves…
Read MoreSELECT WWOB.WORK_ORDER_NUMBER WO_NUMBER ,WWOT.WORK_ORDER_DESCRIPTION WO_DESCRIPTION ,WWST.WO_STATUS_NAME WO_STATUS ,HOU.NAME ORG_NAME ,CASE WHEN ROW_NUMBER() OVER (PARTITION BY HOU.NAME ORDER BY HOU.NAME) = 1 THEN HOU.NAME ELSE NULL END AS ORG_PARAMETER, CASE WHEN…
Read MoreSELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Procurement Business Unit” ,Qry_rslt.”Currency” ,Qry_rslt.”Total Amount” ,Qry_rslt.”No Data…
Read MoreError While starting an Oracle RAC database using srvctl, the startup failed with: PRCR-1079: Failed to start resource ora.RACDB.db CRS-5076: Startup of database resource ‘ora.RACDB.db’ is failing because DB_UNIQUE_NAME ‘RAC_DB’ is not expected Description …
Read More