ADF Menu | Menu Bar | command Menu Item Skinning
Description: Dropdown menus are a common requirement for web applications. In HTML we can create using elements like ul, li, div e.t.c. In ADF, We can achieve using menu bar…
Read MoreThe ultimate guide for skinning ADF table
Description: In ADF, Most commonly used component is table. Previously, I searched for so many blogs; I didn’t get any skinning related stuff to fulfill my requirement, then I realized and…
Read MoreDisplaying subtotal and total based on the group column in BI Publisher Template
Description: Business information processing requires advanced calculations, including complex ranking, subtotals, moving averages, and lead/lag comparisons. These aggregation and analysis tasks are essential in creating business intelligence queries, and are accomplished…
Read MoreBI Publisher Report with Excel Template
Description: The below process explains the step by step details about BI publisher report with excel template with screenshots. Step1: Concurrent Program Create a Concurrent Program with Executable File…
Read MoreAppend the DataBase value to Tabular Form Read-only Column
Description: “Tabular format” is simply information presented in the form of a table with rows and columns. Most office productivity software programs. The below steps explains how to append the database value…
Read MoreUseful SQL Queries – Oracle EBS
Description: To enhance performance, aggregate and analytic functions can each perform in parallel: multiple processes can simultaneously execute all of these functions. These capabilities make calculations, analysis, and reporting easier…
Read MoreUseful Discoverer Queries
Description: One of the distinct steps is to find if all the necessary columns are available in the EUL, and this can be visually done through scanning the Business Areas…
Read MoreSetting the VO query dynamically in OAF
Description: Generally, while creating the View Objects, we define a query to it. While rendering the OAF page, these view objects get executed (either by framework or by the java…
Read MoreSending E-mail with Excel Attachment Using UTL_SMTP
Description: The utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. The generic code is given to send e-mail with excel…
Read MorePerformance Issue – Hierarchical query LEVEL
Description: A parts hierarchy, particularly the case of parts in a kit with the kit/assembly having multiple levels. Another example is parts succession, where older parts are replaced by newer…
Read More