Performance Issue – Hierarchical query LEVEL
Sample Query with Performance Issue: SELECT progress_date, LEVEL slno FROM (SELECT PROGRESS_ID,progress_date, MAX…
Read MoreLoad XML data into Oracle table
Steps to Load XML File to Oracle Tables Solution : Sample XML file has been used for illustration Step 1 : Create a directory using the below command. The below…
Read MoreCredit Check Functionality in Order Management
1) Overview: The ultimate goal of Credit Management processes is to minimize the financial risk that your organization assumes as a result of day-to-day operations. Order Management’s credit checking feature is…
Read MoreWater Mark Text in XML Publisher report
This blog outlines the steps involved to include the Watermark Text to XML reports. Let’s assume a base template as below : Step 1: Create a xml tag for the…
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 MoreOracle BI Publisher Introduction
Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports generated from XML/BI Publisher to many destinations like email, fax and printer using the standard API’s.Create a template to lay out the data in a report, and publish the report to numerous output formats. BI Publisher also enables to schedule reports and deliver the reports to any delivery channel required as per the business need.A report consumer may perform the following tasks: Run and view reports from the BI Publisher reports repository Schedule reports to run at selected intervals and to be delivered via any channel set up by your administrator Create an ad hoc analysis of report data using BI Publisher’s Analyzer feature Open and manipulate reports in Microsoft Excel using BI Publisher’s Analyzer for Microsoft Excel Process to generate the reportThe report attributes, what needs to display should be stored in database table. We can select the values from table and display as a report as per input template.Design the TemplateMicrosoft word is very useful to create the template for report designing. Design the template as per report need and add the database fields in the corresponding areas so that the report will be displayed in neat format. Name Job Title Department Name Salary F Odd Row:NAME JOB DNAME SAL Even Row:NAME JOB DNAME SAL E TOTAL (The template file should be stored as rich text format (rtf) file.)
Read MoreOracle BI Publisher Desktop
Making the relationship between Microsoft word and BI Publisher will be very convenient for template designing part. Because by using Microsoft word, user can draw the tables and they can do lots of designing parts.To enable the BI Publisher tool bar in to Microsoft word, we need to install the plug-in.To aid in the building of RTF templates BI Publisher provides the BI Publisher Template Builder for MSWord. Prior to starting the examples we should download this plug-in and install it. This is available from metalink; the latest version is 5.5 and can be found by downloading patch 4561835. Alternatively we can install from the BI Publisher window itself. We can install by clicking on the Template Builder link in that above picture. After that the add-ons will be installed and BI Publisher menu will be enabled in Microsoft word document. Add-Ins has enabled and displayed in word like the other optionsUnder the Add-Ins following tab has enabled. l Oracle BI Publisher l Data l Insert l Preview l Tools l Help By using the above method to enable Oracle BI Publisher add-ins in Microsoft word.
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 More