AmrAbdeen

/** ###### PLEASE TAKE ATTENTION ###### //
  * (( $v(), $s(), $x(), apex.item )) are APEX API "SHOULD BE" using them instead of JQ, Just i added some JQ here as more info for you - in some cases the JQ returns some diff results so the API is better to use it always .. Take care..
---------------------------------------------------------------------------- */

// Getting Item Value
$v("P2_ENAME");  /* it's same same */  apex.item( "P2_ENAME" ).getValue(); /* it's same same */ $("#P2_ENAME").val();

// Set Item with Value
$s("P2_ENAME",'AMR');  /* it's same same */ apex.item( "P2_ENAME" ).setValue('AMR'); /* it's same same */ $("#P2_ENAME").val('AMR');

AmrAbdeen

apex_error.add_error 	(p_message          => 'check total after dedecation(Discount)',  
                      p_display_location => apex_error.c_inline_in_notification ); 
                      
APEX_ERROR.ADD_ERROR (
    p_message  => 'The employee name can´t be null',
    p_display_location => apex_error.c_inline_with_field_and_notif ,
    p_page_item_name => 'P1_ENAME');

AmrAbdeen

function numonly(evt){
	//onkeypress="return numonly(event)"
         var charCode = (evt.which) ? evt.which : evt.keyCode
         if (charCode > 31 && (charCode < 48 || charCode > 57))
         return false;
         return true;
}

AmrAbdeen

window.onerror = function () {alert("##############");}

AmrAbdeen

sudo update-alternatives --config java

AmrAbdeen

Please include the following block of code on all pages in which you want the navbar to always start collapsed by default:


$(window).on("theme42ready", function() {
   if ($("body").hasClass("js-navExpanded")) {
   $("#t_Button_navControl").click();
  }
});

AmrAbdeen

Case 1

I use 
COALESCE( v('APP_USER'),USER ); 
instead of
NVL( V('APP_USER'),USER );

Cause: 
More performance.

AmrAbdeen

Error “E:Encountered a section with no Package: header, E:Problem with MergeList …….”

Fix it by this steps ..  #linux_mint_17.2

1- Clean up..
sudo apt-get clean
sudo apt-get autoclean
sudo apt-get purge
sudo apt-get autoremove -y
sudo rm -fv /var/lib/apt/lists/*

AmrAbdeen

This is the root cause of your issue.
    The apex pool in ORDS corresponds to the database APEX_PUBLIC_USER and it is not correctly configured.
    Connect to the SQL Plus prompt with SYS user and SYSDBA privileges and run the following query:
    
// select username  
    , account_status  
    , profile  
   from dba_users 
   where username in ('APEX_PUBLIC_USER','APEX_LISTENER','APEX_REST_PUBLIC_USER');  

AmrAbdeen

Apex Installation Guide you will find the following paragraph:

"In the default profile in Oracle Database 11g, the parameter PASSWORD_LIFE_TIME is set to 180. If you are using Oracle Database 11g with Oracle Application Express, this causes the password for APEX_PUBLIC_USER to expire in 180 days. As a result, your Oracle Application Express instance will become unusable until you change the password.

To prevent this behavior, create another profile in which the PASSWORD_LIFE_TIME parameter is set to unlimited and alter the APEX_PUBLIC_USER account and assign it to the new profile."

Of course with a little help from google you can find out how to do this. I summarized it for you:

First let's see what the limits of the default profile (or the profile of your APEX_PUBLIC_USER) are:
/* --------------------------------------- */