APEX Lessons

APEX Confirm Message With Custom Event Dynamic Action

1 Comment / APEX, Dynamic Actions / By

APEX Confirm Message With Custom Event Dynamic Action Video Tutorial https://www.youtube.com/watch?v=kgUS7_u7520 Demo : https://apex.oracle.com/pls/apex/f?p=APEXLESSONS:APEX-CONFIRM-WITH-CUSTOM-EVENT Purpose In this tutorial you will learn how to fire a Dynamic Action (You can call procedure, perform update/insert or anything) after user clicks “OK” button  on APEX Confirm Message. Step 1 1) Create a Dynamic Action to perform DML or call …

APEX Confirm Message With Custom Event Dynamic Action Read More »

Interactive Report Column – Searchable Data Masking

Leave a Comment / Dynamic Actions / By

Interactive Report Column – Searchable Data Masking Video Tutorial https://www.youtube.com/watch?v=-7Z2xXgDeOM Demo : https://apex.oracle.com/pls/apex/f?p=APEXLESSONS:DATA-MASKING Data Masking Enable user to search specific record without knowing them other row’s data. 1) Column Formatting Add below text in HTML Expression HTML Expression<span> #CNIC# </span> 2) Function and Global Variable Declaration Create function in Function and Global Variable Declaration section Function …

Interactive Report Column – Searchable Data Masking Read More »

How to increase Page File size or Virtual Memory in Windows 10

Leave a Comment / Windows / By

To increase Page File size so in Windows 10, follow these steps:   Right-click on This PC and open Properties. Select Advanced System Properties Click Advanced tab Under Performance, click Settings Under Performance Options, click Advanced tab Here, under Virtual memory, select Change Uncheck Automatically manage paging file size for all drives Highlight your Windows system drive Select Custom size Change the Initial size value and the Maximum size value to a higher value Click Set …

How to increase Page File size or Virtual Memory in Windows 10 Read More »

How to use Custom Event in Dynamic Actions

Leave a Comment / Dynamic Actions / By

Oracle APEX – Dynamic Actions (Custom Event) Video Tutorial Demo : https://apex.oracle.com/pls/apex/f?p=APEXLESSONS:CUSTOM_EVENT Username : apexlessons Password : apexlessons Example 1 1) Create Custom Event Dynamic Action 1) IdentificationName: Custom Event Alert 2) WhenEvent: CustomCustom Event: CustomEvent1Selection Type: JavaScript ExpressionJavaScript Expression: document Add True Action1)IdentificationAction: Alert 2) SettingsText: Custom event fired successfully. 3) Execution OptionsFire on Initialization: False 2) Create Dynamic Action (To fire custom …

How to use Custom Event in Dynamic Actions Read More »

How to install and configure Oracle APEX with Tomcat step by step

Leave a Comment / APEX, Tomcat / By

How to Install and configure Oracle Apex 19.1 with Apache Tomcat Video Tutorial https://www.youtube.com/watch?v=oUX67DWnUJw APEX 19.1 Installation Reqirements. Oracle Application Express release 19.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE). Download Installation Files Click on below links to download required installation files. Click on Oracle APEX …

How to install and configure Oracle APEX with Tomcat step by step Read More »

Oracle APEX Known Issues – APEX 19.1

1 Comment / APEX / By

APEX 19.1.0.00.15 was released on March 29, 2019. 29912558 – APP IMPORT WITH SAME APP ID AND SOCIAL AUTH SCHEME: ERROR WITH WWV_FLOW_AUTHN_FK_CREDWhen importing an application with authentication scheme Social Sign-In, the import can fail withORA-02291: integrity constraint (APEX_180200.WWV_FLOW_AUTHN_FK_CRED) violated.This will happen when the credential already exists in the workspace and when re-using the existing application …

Oracle APEX Known Issues – APEX 19.1 Read More »