Oracle HRMS – Create Employee API
Description: This blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide…
Read MoreQuery of 11i to R12 Table Changes
Description: In this article, I am going to cover minimum database object level changes done by Oracle in the upgrade like object obsolete, package level changes, API changes. Accounts Payable…
Read MoreCreating Lookup and Lookup Values through API
Description: The custom lookup parameters can be passed to the below API’s to insert data into Oracle standard tables fnd_lookup_values and fnd_lookup_types *fnd_lookup_types_pkg.insert_row *fnd_lookup_values_pkg.insert_row Sample script with description to upload…
Read MoreADF 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 MoreProgress Bar in Reports in APEX5
Description: APEX can create “Percentage Bars” within a report. This can be achieved using HTML Code in your Report SQL Query. Steps: 1- Create your report: Create an Interactive or Classic Report using SQL query : SELECT CASE WHEN COLUMN <= 30 THEN ‘<div class=”a-Report-percentChart” style=”background-color:#000000;width:100%;”><div class=”a-Report-percentChart-fill” style=”width:’ || COLUMN || ‘% ; background-color: 330099;”></div><span class=”u-VisuallyHidden”>’ || COLUMN || ‘</span></div>’ || COLUMN || ‘%’ WHEN COLUMN BETWEEN 30 AND 50…
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 More