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 MoreIntegrating 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 MoreOracle 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 MoreApex 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 MoreHide 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 MoreAppend 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 MoreConfiguring 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 MoreAppend the Data Base value to Tabular Form Select List
Ajax(Application Process) used to Get the value from Data base Return value as node and attribute. Example : l_Opt_Xml.firstChild.nodeValue and l_Opt_Xml.getAttribute(‘value’). Create the Element of OPTION Example : var l_Opt = document.createElement(“option”); Add the OPTION to Target Select List and Append the OPTION to Target Select List Example : pSelect.options.add(l_Opt); pSelect.appendChild(l_Opt); Insert the select list content to OPTION and Append the select list content to OPTION Example : l_Opt.innerText = pContent;l_Opt.appendChild(document.createTextNode(pContent));
Read MoreApex used to call the Oracle JOB scheduler and Java
l Create the html link on apex l Ajax(Application Process) used to call the DBMS_SCHEDULER then generate the job name l Ajax(Application Process) used to call the DBMS_SCHEDULER .CREATE_JOB then Execute the job name Example : select DBMS_SCHEDULER.GENERATE_JOB_NAME(‘hariharhomes’) into jobnames from dual; dbms_scheduler.create_job( job_name=>jobnames, job_type=>’executable’, job_action=>’/u01/app/oracle/product/10.2.0/ias/Apache/Apache/images/mani.sh’, enabled=>TRUE );
Read MoreReport Generation from BI through APEX
Oracle APEX is user friendly for designing part as well as client side data entry and validation related things.Oracle BI Publisher is good for report output; it will give the output files like PDF, XLS etc, Very big advantage in BI Publisher is that can produce multiple output files as a report. With the option of Bursting.Bursting will be scheduled with the particular time interval, or can schedule by the time as per the report need.Template file is base for required output report. Because output will be produced based on the input template design.In APEX, under Shared components there is an option called Report Layouts, that is getting the input template file for report designing. That same navigation having the link called Report Queries, which is getting the query from user to generating report based on template and query.When the user clicking on the designed button, then the Report file will be generated based on template and query.The button option should be Download printable Report Query, and then only that printable option will work.
Read More