Skip to main content

Dynamically Setting APEX Logo Based on Logged-In User

 In Oracle APEX applications, enhancing user experience through personally is a key aspect of modern UI design. One effective way to achieve this is by dynamically setting the application logo based on the currently logged-in user. This approach allows us to display different logos for example, company-specific branding, department icons, or user-type indicators tailored to each user.

Step1: Store the logo image in the user details table.

Step2: Create a Module from Restful service

Step3: Add a Template

Step4: Add a Handler

Step5: Paste the following PLSQL code

DECLARE

v_blob BLOB;

v_mime_type VARCHAR2(50);

v_length NUMBER;

v_user_id NUMBER;

BEGIN

v_user_id := TO_NUMBER(:USER_ID);

SELECT USER_LOGO, MIME_TYPE

INTO v_blob, v_mime_type

FROM USER_TABLE

WHERE USER_ID = v_user_id;

v_length := DBMS_LOB.GETLENGTH(v_blob);

IF v_length > 0 THEN

OWA_UTIL.MIME_HEADER(NVL(v_mime_type, 'image/png'), FALSE);

HTP.PRN('');

WPG_DOCLOAD.DOWNLOAD_FILE(v_blob);

ELSE

OWA_UTIL.STATUS_LINE(404, 'Not Found');

END IF;

END;

Step6: Now copy the Full URL from Resource Handler.

Step7: Create One Application Page Item with the name of P_USER_ID

Step8: Create One Application Process Process_Point - After Authentication (paste the following code)

BEGIN

SELECT USER_ID

INTO :P_USER_ID

FROM USER_TABLE

WHERE UPPER(USER_NAME) = UPPER(:APP_USER);

EXCEPTION

WHEN NO_DATA_FOUND THEN

:P_USER_ID := NULL; 

WHEN TOO_MANY_ROWS THEN

:P_USER_ID := NULL; 

WHEN OTHERS THEN

:P_USER_ID := NULL; 

END;

Step9: Now go-to UI Interface under shared component and select logo

Logo

Image

Image URL

Paste Full URL and add application item

Sample_URL

https://yourdomain/ords/dms/get/user_logo/&P_USER_ID.

Step10: Save and run the application.

User1:-

User2:-







 

Comments

Post a Comment

Popular posts from this blog

Reusable JS Functions for Field Validation in Oracle APEX Forms

 These reusable JavaScript functions provide client-side validation for Oracle APEX forms, improving data accuracy before submission. They allow developers to enforce mandatory fields and ensure certain fields contain only numeric values . By using these functions, APEX forms become more user-friendly and robust , reducing the chance of invalid data entry. Step 1: Create a Static Content region on the Global Page using the Blank with Attributes template. Step 2: Paste the following code into the HTML Source section of the region. <script>     function validateInputField(inputFieldId, pageItemName, errorMessage) {         $(inputFieldId).focusout(function() {             var itemValue = apex.item(pageItemName).getValue();             apex.message.clearErrors(pageItemName);             if (!itemValue) {               ...
Post a Comment
Read more

Reusable JavaScript Function to Highlight Holidays on APEX Date Picker Item

Date pickers are an essential part of web applications, especially when users need to select dates for bookings, reports, or scheduling tasks. However, in many business scenarios, certain dates like holidays, weekends, or special events need to be visually distinguished to prevent users from selecting them by mistake. In this blog, we will create a reusable JavaScript function that highlights holiday dates in an Oracle APEX date picker. This approach allows developers to call the function anywhere in their application, ensuring consistency and reducing redundant code. By the end, you’ll have a flexible solution to visually mark holidays on any date picker item in your APEX applications. Step 1: Create a Static Content region and set it to Blank with Content under the region attributes. Step 2: Inside that region, enclose a <script> tag and paste the following JavaScript function. function applyHolidayFormatterToDateItems(itemNames) {   const holidayList = [   ...
Post a Comment
Read more

Customizing Classic Card Report Template with Collapse Option in Oracle APEX

 This customization adds collapse/expand controls to a Classic Card Report in Oracle APEX, enhancing user interaction and report usability. Step 1: Copy the existing Classic Report Card template and save it with a new name. Step 2: Add the following customized code in the Row Template 2 section. <li class="t-Cards-item #CARD_MODIFIERS#">   <div class="t-Card">     <!-- Icon and Title/Subtitle -->     <a href="javascript:void(0);" class="t-Card-wrap">       <div class="t-Card-icon u-color #CARD_COLOR#">         <span class="t-Icon fa #CARD_ICON#">           <span class="t-Card-initials" role="presentation">#CARD_INITIALS#</span>         </span>       </div>       <div class="t-Card-titleWrap">         <h3 class="t-Card-title">#CARD_TITLE#</h3> ...
Post a Comment
Read more