Introduction: This document explains the implementation of Multiple Session Restriction in Oracle APEX applications. The objective of this solution is to ensure that a single user cannot maintain multiple active sessions at the same time across di...
Read MoreIntroduction: This document explains the implementation of a Login and Logout Audit mechanism in Oracle APEX. The objective of this solution is to capture and track user activity within the application, specifically focusing on login and logout ev...
Read MoreWorking with time zones can be tricky—especially when Daylight Saving Time (DST) comes into play. This Oracle Integration recipe offers a ready-to-use solution to convert UTC into any local time zone while automatically accounting for DST rules ac...
Read MoreI have an integration with one or more invokes and I want to apply retry functionality to them, e.g. retry on failure up to 3 times etc. Now you could implement this yourself, but now just let OIC do the work – here is a simple example – ...
Read MoreIntroduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into Oracle. How do we Resolve: – Step 1:- First you need to take the details from Us...
Read MoreWhy we need to do /Cause of the issue: When we are uploading the AP Invoice Refund data into Oracle. In the Payables Open Interface Import Program We are getting Duplicate Invoice Error Supplier Supplier Invoice Invoice Invoice Invoi...
Read MoreIntroduction: This blog has the SQL query that retrieves the complete lot genealogy, detailing the full lifecycle of product creation. Cause of the issue: Business wants a report that contains the complete lot genealogy, detailing the full lifecyc...
Read MoreIntroduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details of the test samples with their results. How do we solve...
Read More