Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read MorePost Email Messages on Microsoft Teams
Introduction: Microsoft Teams has become a central hub for collaboration in many organizations, allowing teams to communicate, share files, and manage projects seamlessly. However, emails remain an essential part of…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreReading Outlook Emails with Microsoft Graph API using OAuth 2.0 Authentication
Introduction: – The Microsoft Graph API provides a powerful way to interact with a wide range of Microsoft 365 services, including Outlook, using a unified endpoint. By leveraging OAuth 2.0…
Read MoreEmail Validation using PL/SQL Function
Email Validation Function using plsql function CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10);…
Read More