APEX

Handling Dynamic Links in Tosca

Title: Handling Dynamic Links in Tosca Introduction/ Issue: In test automation with Tosca, one common challenge is handling dynamic links—those that change based on the data generated within the application.…

Read More

TOSCA Exception Handling

Title: TOSCA Exception Handling: Ensuring Reliable Test Automation Introduction/ Issue: In the world of test automation, unexpected errors and exceptions are inevitable. Whether it’s an element not found or a…

Read More

Automating Failure Notifications in Selenium Using Listeners and Internal issue tracker API Integration

Introduction/ Issue: Automating test failure notifications in Selenium is essential for timely communication with stakeholders, avoiding delays common in manual monitoring. This automation is especially vital in large projects where…

Read More

Dynamic Date selection from Calendar on Tosca Automation

Introduction/ Issue: Automating date selection in test cases can be challenging, especially when dealing with dynamic dates. Why we need to do / Cause of the issue: Automating date selection…

Read More

Working with Oracle APEX Tree Region: Capturing Selected Node Values

Introduction Oracle APEX Tree Regions are excellent for displaying hierarchical data like employee-manager relationships. In this blog post, we’ll explore how to capture the selected employee’s name and their hierarchical…

Read More

Dynamically Update Interactive Grid Header in Oracle APEX

Introduction Oracle APEX offers powerful tools to create interactive, dynamic applications. One common requirement is to update the header of an Interactive Grid region based on the value of a…

Read More

Custom footer in Oracle APEX

1. Introduction/ Issue: Creating a custom footer in Oracle Application Express (APEX) is a valuable skill for enhancing the look and feel of your applications. A well-designed footer can provide important…

Read More

Extracting user and roles information from fusion

1. Introduction / Issue In Oracle Fusion, managing user roles and permissions is crucial for maintaining security and ensuring that users have the appropriate access to perform their tasks. Extracting user and…

Read More

Steps to Enable the Trace/Debug for An Apex Session

Introduction: In this blog, we will walk through the process of enabling debug logging and tracing in Oracle APEX applications. Debug logging and tracing are essential techniques for diagnosing problems, understanding application behavior, and improving performance. By capturing detailed logs and execution traces, developers can gain insights into the inner workings of their APEX applications, making it easier to pinpoint and address issues. Step 1: In the Browser login into APEX as “DEVELOPER” Step 2: Run the application which will be running the Report Take down the URL’s session ID as like below. “https://***.**.*.**/ords/f?p=521:101:8786047580303:::::” In my scenario the session ID is 8786047580303 Navigate to Administration–>Monitor Activity as per below snip Step 3: Monitor Activity–>Active Sessions Search for the session ID of Apex runtime “8786047580303” The screen appears like below. Click on Active session id. We can find the session details below Step 4: Make below changes as per below image attached Debug Level –>”APEX Trace” & Trace Mode –>”SQL Trace” Apply the changes. Step 5: After applying changes we can able to see the Debug id as below Once you click the “Debug ID”, you should be seeing page Step 6: Clicking Actions–>Download–>HTML. Step 7: Finally we can download the trace file as PDF or HTML Format. Conclusion: Enabling debug logging and tracing for our Apex application is crucial for effectively diagnosing and resolving runtime issues. By carefully configuring debug logs, we can capture detailed information on code execution, database operations, and other critical components of our environment.This detailed logging allows us to identify and address problems efficiently.

Read More

Accelerating Data Uploads with APEX_DATA_PARSER in Oracle APEX

Introduction: APEX_DATA_PARSER is a feature in Oracle APEX (Application Express) that simplifies the process of uploading and parsing files in a web application.APEX_DATA_PARSER is a PL/SQL package provided by Oracle…

Read More