Oracle Forms to Oracle APEX Migration (Help)

  The database user for the connection pool named |apex|rt|, is not able to proxy to the schema named XXXX. This could be a configured restriction on the maximum number of database sessions or an authorization failure. Solution :-   alter user XXXXX  grant connect through APEX_REST_PUBLIC_USER;

 Signature in APEX Page  Special Thanks to Daniel Hochleitner Download Plug In:- https://github.com/Dani3lSun 1) Create Table CREATE TABLE  "SIGNATURE"     ( "COMPCD" VARCHAR2(2),  "LOCNCD" VARCHAR2(2),  "BRCD" VARCHAR2(3),  "DEPTCD" VARCHAR2(3),  "DOCNO" NUMBER,  "DOCDT" DATE,  "DOCTYP" VARCHAR2(2),  "REFCD" VARCHAR2(6),  "NETVALLC" NUMBER(17,3),  "NETVALFC" NUMBER(17,3),  "FILE_NAME" VARCHAR2(250),  "MIME_TYPE" VARCHAR2(250),  "DOCIMG" BLOB,  "CRTDT" DATE,  "CRTUSER" VARCHAR2(6)    ) / 2) Import Plugin  region_type_plugin_de_danielh_apexsignature.sql 3) Import Static file  apexsignature.js , apexsignature.min.js, signature_pad.js, signature_pad.min.js 4)  Copy the staic file path to  UserInterface -- Java Script  #APP_IMAGES#apexsignature.js #APP_IMAGES#apexsignature.min.js #APP_IMAGES#s...

Note 1:- Pre-rendering only advisable if you want to generate excel from Interactive Grid Page other wise below process you can directly call from submit Page --> process  Note 2:-  If calling from submit Page (button) --> then make sure Reload on Submit should be "Always" on page property  1) Create Blank Page --> Pre-Rendering --> Before Header --> Process --> Download Excel  declare     l_highlights     apex_data_export.t_highlights;     l_context        apex_exec.t_context;     l_export         apex_data_export.t_export;     l_print_config    apex_data_export.t_print_config; begin     -- apex_data_export.add_highlight(     --     p_highlights          => l_highlights,     --     p_id                  => ...

1)  BEGIN  apex_mail.send(p_to   => 'abc@gmail.com'/*l_to_addr*/,                                    p_from => 'def@gmail.com'/*l_from_addr*/,                  p_subj => 'Test33344',                  p_body => 'Service Request Note:- This is a system generated Email. Please DO NOT REPLY to it.'); APEX_MAIL.PUSH_QUEUE; END; Lets assume you are getting ORA-27492 Unable to run job "APEX_200200" ORACLE_APEX_MAIL_QUEUE scheduler unavailable error then perform following two line code 1) Login as sys/ dba without container  2)  alter system set job_queue_processes = 100; 3) connect now sys/<>@container as sysdba 4) Perfrom  begin APEX_MAIL.PUSH_QUEUE; end;

  Set the HTML Expression property on the RATING column to: < a href = "javascript:more('#DOCNO#,#DOCDT#');" > < span class = "fa u-hot-text report-star-rating" data-rating = "#RATING#" title = "Click For History" aria-hidden- "true" ></ span > < span class = "u-VisuallyHidden" > #RATING# </ span > </ a > Add this style sheet to the Custom CSS section of the Theme Roller: .report-star-rating { white-space : nowrap; } .report-star-rating [data-rating= "0" ] ::before { content : "\f006\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "1" ] ::before { content : "\f005\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "2" ] ::before { content : "\f005\f005\f006\f006\f006" ; } .report-star-rating [data-rating= "3" ] ::before { content : "\f005\f005...

what is Ajax call  and why Ajax  in Oracle APEX Ajax   stands for  Asynchronous JavaScript And XML .  In a nutshell, it is the use of the XMLHttpRequest object to communicate with servers. It can send and receive information in various formats, including JSON, XML, HTML, and text files. AJAX’s most appealing characteristic is its "asynchronous" nature, which means it can communicate with the server, exchange data, and update the page without having to refresh the page. The two major features of AJAX allow you to do the following: Make requests to the server without reloading the page Receive and work with data from the server. So basically, Ajax is a technique used to help you refresh (almost) any region in Apex without reloading the whole page which is so handy because imagine you have many regions on the page but you are only interested in getting the new data of a specific region after applying some filters. Furthermore, you can also get new Data based on use...

Thanks for  maxime_tremblay   Such nice  solution     Go to Page 0 ,  Page Load DA -- JavaScript  APEX 5 and 18 (function(ut, $) { var TREE_NAV_WIDGET_KEY = 'nav'; $(window).on('theme42ready', function() {     /* Make sure that the navigation menu is collapsed on page load */     if (ut.toggleWidgets.isExpanded(TREE_NAV_WIDGET_KEY)){         ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);     }     /* Expand on mouse over, collapse on mouse out */     $('.apex-side-nav.js-navCollapsed .t-Body-nav').hover(         function(){             ut.toggleWidgets.expandWidget(TREE_NAV_WIDGET_KEY);         },         function() {             ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);         }     ); }); })(apex.theme42, apex...