APEX

DISABLING KEYS USING JAVASCRIPT IN APEX

Application customization, by using JavaScript “Key Disabling” can be achieved, thereby preventing the user from feeding the particular key input value into the system. It restricts the characters which need not to be entered into a particular field in a Form or Report  column. To disable a key, follow these steps: Step 1: Creation of JavaScript Function        Create the following JavaScript Function in the page HTML Header Region. Source Code: <SCRIPT language=JavaScript> <!— function isNumberKey(evt) { var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 || charCode > 57)) return false; return true; } //–> </SCRIPT> Step 2: Calling the JavaScript Function Call the JavaScript function on the particular Report Column/Field  in which the Keys has to be disabled. onkeypress=“return isNumberKey(event);” (Or) onclick=“return isNumberKey(event);” OUTPUT: The Input Key does not work in the field where the JavaScript function is called, provided if the Input Key code falls between the char-code entered in to the JavaScript function.

Read More

Session State Protection in APEX

Session State Protection is a built-in functionality that prevents hackers from tampering with the URLs within your application. URL tampering can adversely affect program logic, session state contents, and information…

Read More

Clearing Session State in APEX

As you develop your applications, you may find it useful to clear the cached value for specific items, all items on a page, all pages in an application, or the…

Read More

Multiple User Interface for Oracle APEX

User Interface User Interfaces ·         Within a single Application you can have Desktop and Mobile Pages with individual Themes each ·         That means an Application can have multiple active Themes…

Read More

Integrating With Fusion Application Using Services (APEX)

Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for…

Read More

Oracle Application Express 4.0 EA2

Oracle Application Express 4.0 Early Adopter Phase II (EA2) is now available. Fill out the survey and request a NEW workspace on oracle’s hosted instance @ http://tryapexnow.com

Read More

Apex Interactive Report Cosmetics

 To Change the Report Field Title color  .apexir_WORKSHEET_DATA th div {font-size:12px; color:black; }  To draw border for the Report  table.apexir_WORKSHEET_DATA th div{text-decoration:none;} table.apexir_WORKSHEET_DATA td, table.apexir_WORKSHEET_DATA th {border:1px solid darkblue}  To Give Background color for report and change the report font color  .apexir_WORKSHEET_DATA td {font-size:11px; color:DarkBlue;background-color:whitesmoke;} The above code will print like white smoke as background color of report and text color of the report  will be dark blue.[The above codes should be written in HTML Header of the page, within the below tag]<style></style>

Read More

Hide the Report Column based on User Condition

 Get the interactive repot table id  Example : var apexform = $x{interactive report tableid};  Mention the rows and column  Example: var hidecell1= apexform.rows[4].cells[0];  Script used to hide the particular cell  Example: hidecell1.style.display=’none’;

Read More

Append the Data Base value to Tabular Form Read only Column

 Get the interactive repot table id  Example : var apexform = $x{tableid};Mention the rows and column  Example: var ApexTableId =filter.id; var row= ApexTableId.substring(4,8);var newCell = ApexTableId.rows[row].cells[4];newCell.innerHTML = Databasevalue;Ajax(Application Process) used to get the value from Data Base then append into Table cell output : In our project Product Description is Tabular Form Read only Column

Read More

Configuring APEX to use BI Publisher

To use BI Publisher as your Report Server, first, access the Report Printing parameters:Go to The following navigation in APEX with Admin credentials. 1 Access the Administration Services home page 2 Select Manage Service 3 Select Instance Settings, under Manage Environment Settings 4 Click Report Printing to focus on just the Report Printing attributes Now, specify the following attributes:  Oracle BI Publisher: Advanced Support  Print Server Protocol: HTTP or HTTPS (depends on your configuration)  Print Server Host Address: the hostname for the machine where you installed BI Publisher – e.g. myhost.mycompany.com  Print Server Port: the port given at the end of the BI Publisher installation – e.g. 9704  Print Server Script: /xmlpserver/convert

Read More