Oracle Forms to Oracle APEX Migration (Help)

Apex Migration 19.2 to 20.0.1   (Version Oracle 11.2.0 DB / Tomcat 9.0)   1) Download the 20.1      2) Unzip the Downloaded folder   3) Go to Command Prompt and go to location of unzip folder and perform sqlplus   4) Connect   Sys as sysdba SQL> @apexins1.sql sysaux sysaux temp /i/ Entire Phase will take 15 to 20 minute time. Make sure Phase 3 complete successfully. 5) Run the apex_rest_config command SQL> @apex_rest_config.sql )         6) Stop the tomcat Server   7 ) Copy Images folder data from apex_20.1_en/apex/images   and Past to apache-tomcat-version/webapps/i (before take the backup of   “I” folder)   8)  Copy  Images folder   from apex_20.1_en /apex/images     and past to ORDS/ Images folder (before take the backup of Images folder of ORDS)   9) Connect Sqlplus as sys user Perform Attached Sc...

var validity, message,     ui = this.data;   (function($) {       function update(model)     {         var salKey = model.getFieldKey("SAL"),             empnoKey = model.getFieldKey("EMPNO"),              recObj = [],              recArray = [];         model.forEach(function(record, index, id)         {             var sal = parseInt(record[salKey], 10),  // record[salKey] should be a little faster than using model.getValue in a loop                 empno = parseInt(record[empnoKey], 10),                 meta = model.getRecordMetadata(id); if (!isNaN(sal) && !meta.deleted && !meta.agg) {    recObj = {ID: ...

1)  Create a dynamic action for the Row Initialization event on the IG region. 2) Event :- Row Initialization    Action :- Execute Java Script code     Set Fire on Initialization to No' var val,     model = this.data.model,     rec = this.data.record,     erec =  $v("P404_ITEM_CODE"),     erec1=$v("P404_COMPCD"),     meta = model.getRecordMetadata(this.data.recordId); if ( meta.inserted ) {     val = model.getValue(rec, "ITEM_CODE")     if ( val.v === val.d )       { model.setValue(rec,"ITEM_CODE", {d:apex.item("ITEM_CODE").displayValueFor(erec), v: erec});     }     val = model.getValue(rec, "COMPCD");     if ( val.v === val.d ) {         model.setValue(rec,"COMPCD", {d:apex.item("COMPCD").displayValueFor(erec1), v:erec1});     }     }

1) Set DA Lose focus on Column .i.e XNQTY Event:- Lose Focus Column: XNQTY Client Side Condition :- Java Script Expression      ((apex.item('XNQTY').getValue() == '') ||      (apex.item('XNQTY').getValue() == 0)||       (apex.item('XNQTY').getValue() <= 0)) 2) Action :- Execute JavaScript Code    var recordId, grid$,     val = apex.item(this.triggeringElement).getValue();     grid$ = $(this.triggeringElement).closest(".a-GV");     recordId = grid$.grid("getActiveRecordId");    //End Here :- Get Current Cell Value  from Grid         apex.server.process("CheckNull",{x01: val},     { dataType: 'text', success: function(pData){ $s('MSG',pData); // store message in Item ,if required to display on page if (pData  != '') {             apex.message.alert("Quantity must be > 0", function() { ...

Auto (Sequence) Serial Number Assign to Column in IG - Oracle Apex 1) Function and Global Variable Declaration function UpdateSrno() { apex.region("GRVDTLID").widget().interactiveGrid("getActions").set("edit", true); apex.region("GRVDTLID").widget().interactiveGrid("getViews", "grid").view$.grid("selectAll"); var widget = apex.region("GRVDTLID").widget(); var grid = widget.interactiveGrid("getCurrentView"); var model = grid.model; var selectedRecords = grid.getSelectedRecords(); var i =1; if ( grid.supports.edit ) {       model.forEach(function(record, index, id)      {          meta = model.getRecordMetadata(id);          if (!meta.deleted)              {         sr  = model.getValue(record,"SRNO");           model.setValue(record,"SRNO", (i).toString());           ...

Remove Default First Row Selected Execute when Page Loads below for 5.1 or old version var ig$ = apex.region("emp").widget(); ig$.interactiveGrid("getViews", ig$.interactiveGrid("getCurrentViewId")).setSelection($()); Later 5.1 apex.region("grid_static_id").widget().interactiveGrid("setSelectedRecords", []); OR Add to Advanced JavaScript Initialization Code: function(config) {  config.initialSelection = false;  return config;}