Description: In database management systems, query by example (QBE) refers to a method of forming queries in which the database program displays a new record with a space for each field. You can then enter…
Read MoreIntroduction This Post is About to Audit Trail Enabling For Employee Table Enable Audit Trail Profile Navigation: System Administrator à Profile à System Now enter AuditTrail:Activate in Profile and click on Find. Make sure it is…
Read MoreIntroduction This Post Is To Creating DFF in a Custom Form. QUERY TO CREATE DFF IN CUSTOMER FORM. 1. Go to Application Developer -> Flex Fields -> Descriptive -> Register…
Read MoreDescription This blog describes the technical information required for creating an Inventory organization and their classification using API. In order to create Inventory organization we can use three API which…
Read MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 More