Thanigai Solutions (Oracle APEX Blogs)

🚩Introduction  In Oracle APEX applications, users often need to upload Excel files to add or update data. Instead of using external plugins, this can be done using built-in APEX features, which keeps the application simple and easy to maintain. By using the apex_application_temp_files table along with PL/SQL, we can read the uploaded Excel file, process the data, and store it in an APEX collection. This gives better control over the data and keeps the application clean and efficient. 📑  Why This Approach Is Needed In Oracle APEX applications, users often need to upload Excel files to handle large amounts of data. Using plugins for this can make the application more complex and harder to maintain. It may also create compatibility and security issues in some cases. Handling Excel uploads without plugins is useful when: You want to avoid external dependencies The application needs to stay simple and lightweight Better control over data processing and validation is required Fil...

🚩Introduction  In Oracle APEX applications, reports may show both general and sensitive data like employee details, salary, or internal information. While this data can be shown on the screen, not all of it should be included when exporting to files like Excel or PDF for security and privacy reasons. To manage this, we can control what gets exported using conditions like :REQUEST to hide sensitive columns during download while still showing them in the report. This helps protect confidential data, improves security, and ensures proper access control in Oracle APEX reports. 📑  Why It is Important to Control Export Columns in Oracle APEX Reports In Oracle APEX applications, reports may show important data like employee details, salary, or other sensitive information. Sometimes, this data should be visible on the screen but should not be downloaded in Excel or PDF files. Controlling export columns becomes important when: Sensitive data like salary should not be included in dow...

🚩Introduction  In Oracle APEX applications, Tabs Container is used to organize multiple regions within a single page, making navigation easier for users. However, APEX does not automatically handle tab selection in a consistent way. When a user comes from another page, the first tab should ideally be selected by default, but this does not always happen as expected. At the same time, when the page is refreshed or submitted, users usually expect to stay on the same tab they were working on instead of being taken back to the first tab. To handle this properly, we can use a simple custom solution using Dynamic Action or JavaScript to track and control the active tab. This helps provide a smoother experience where tab selection behaves in a more natural and user-friendly way. 📑Why It is Essential to Track Tab Change in Tabs Container In Oracle APEX, Tabs Container has a “remember tab” option that keeps the last selected tab, but it does not work well in all cases. For example, when a...

🚩Introduction  In many Oracle APEX applications, users often need to upload files as part of their daily tasks  attaching a screenshot, submitting a document, or sharing an image directly from their work. A useful new feature introduced in Oracle APEX 26.1 is the Allow Copy and Paste setting for File Upload and Image Upload page item. It allows users to paste files directly into the upload area using Ctrl+V or Cmd+V, without opening the file explorer or dragging and dropping. This saves time, reduces effort, and makes the upload experience much smoother. 📑  Why This Approach Is Needed In Oracle APEX applications, users often need to upload files quickly as part of their regular work. If a file or screenshot is already copied to the clipboard, they have to open the file explorer, locate the file, and upload it manually, adds unnecessary steps. This feature becomes useful when: Users have a file or screenshot already copied and want to upload it instantly Repetitive fil...

🚩Introduction  In Oracle APEX 26.1, Select Lists and Popup LOVs come with a new feature called Quick Picks . This feature is designed to make it easier for users to choose values from long lists. Instead of scrolling through a long list every time, users can quickly pick from these suggested values, making data entry faster and more convenient. 📑  Why Quick Picks is Useful in Oracle APEX 26.1 In real-time applications, users often work with long lists in Select Lists or Popup LOVs. Scrolling through these lists again and again can take time and slow down data entry, especially when the same values are used frequently. Quick Picks becomes useful when: Users frequently select the same values again and again Select Lists or Popup LOVs contain a large number of options Data entry needs to be faster and easier Users want to avoid searching through long lists every time A smoother and more user-friendly experience is needed This feature helps users save time, reduces unnecessar...

🚩Introduction  In Oracle APEX 26.1, a new enhancement is introduced in the Faceted Search which allows users to exclude specific facet values in the filtering the reports. Instead of selecting the required values in the facet, user can now exclude the unwanted values from the results. This makes filtering easier and gives users more control when working with large amounts of data. This feature makes reports searching easier and more flexible. It helps users quickly find the information they need. It also allows developers to build more interactive and user-friendly Oracle APEX applications. 📑  Why This Approach Is Needed In Oracle APEX applications, users often work with large reports and need an easier way to filter data. In earlier versions, users can only select the values they wanted to include, which sometimes made searching less flexible and more time consuming. With Oracle APEX 26.1, the new Faceted Search enhancement allows users to directly exclude specific value...