The Problem: When Good Code Goes Slow Picture this: You have a Python application that needs to insert thousands of records into a database. Your code works perfectly for small…
Read MoreSELECT eer.expense_report_num AS “EXPENSE REPORT NUM”, ee.expense_source AS “EXPENSE SOURCE”, papf.person_number AS “EMPLOYEE NUMBER”, ppnf.full_name AS “EMPLOYEE NAME”, pea.email_address AS “EMPLOYEE EMAIL”, ecp.card_program_name AS “CREDIT CARD TYPE”, ec.card_reference_id AS “CARD_REFERENCE_ID”,…
Read MoreSELECT taxdet.invoice_id, taxdet.invoice_amount, taxdet.line_type_lookup_code, taxdet.description, taxdet.invoice_date, taxdet.gl_date, taxdet.supplier_site_name, taxdet.supplier_name, taxdet.supplier_number, taxdet.party_state, taxdet.supplier_gst_number, taxdet.invoice_number, taxdet.invoice_currency_code, taxdet.related_invoice_number, taxdet.line_number, taxdet.rec_nonrec_flag, taxdet.uom_code, taxdet.quantity, taxdet.unit_price, taxdet.transaction_line_amount, taxdet.taxable_line_amount, taxdet.tax_type_code, taxdet.hsn_code, taxdet.sac_code, taxdet.tax_rate, taxdet.charge_account_ap, taxdet.tax_natural_account, taxdet.cancelled_date, (…
Read MoreIntroduction Transparent Data Encryption (TDE) in SQL Server secures sensitive data by encrypting database files at rest without impacting application access, helping organizations protect against unauthorized data exposure. Steps to…
Read MoreIntroduction Removing Transparent Data Encryption (TDE) from SQL Server involves carefully disabling encryption and cleaning up encryption keys to ensure your database is decrypted and accessible. Steps to remove TDE: …
Read MoreIntroduction/ Issue: In modern web applications, users expect a seamless experience that adapts to their environment and preferences. One common requirement is supporting both light and dark themes. By default, many sites…
Read MoreINTRODUCTION/ ISSUE In today’s web development landscape, authentication isn’t just about allowing users to log in — it’s about securing their data, keeping them logged in efficiently, and ensuring smooth…
Read MoreINTRODUCTION/ ISSUE In today’s fast-paced digital world, user expectations are higher than ever — speed, responsiveness, and smooth user experience are non-negotiable. Even the most beautifully designed Angular application will…
Read MoreIntroduction Taking screenshots is a common need during development, testing, or documentation in Oracle APEX applications. While partial screen captures are easy, capturing a full-page screenshot (including content below the…
Read MoreIntroduction: AHFFI is a function that collects data collected by AHF from multiple servers and displays it on a single screen. Why we need to do Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root cause of each issue-If necessary, drill down into specific insight reports to identify detailed. Support Platform: (OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later system requirements for ahffi : 4 cores CPU, 16GB RAM, 4GB disk space yum install cronie sudo yum install iproute sudo yum install hostname INSTALLATION STEPS: Download ahffi from link 3043060.1 mos Prerequisite setup Install jdk-24 Install instant client sqlplus 23.4.0 Install instant client basic 23.4.0 Create a user for ahffi on 23ai database create user ahffi identified by ahffi; grant create session to ahffi; grant connect, resource to ahffi; grant create table to ahffi; grant insert any table to ahffi; alter user ahffi quota unlimited on users; Download the ahffi file and upload it to the server …
Read More