Safely Remove a Used Disk from ASM DiskGroup in Oracle 19c RAC
How to Safely Remove a Used Disk from ASM DiskGroup in Oracle 19c RAC In this post, I’m sharing a step-by-step process to safely remove a used disk from an…
Read MoreAFTER_PASTEBINARY_COMMENV
Issue: During adcfgclone execution in EBS 12.2, the commenv.sh file was populated with an incorrect JAVA_HOME path after the paste binary step. This caused the clone process to fail with…
Read MoreThe Oracle Migration Challenge – Datatype Conversion Nightmares
When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar – how hard can it be to…
Read MoreFrom Slow to Lightning Fast: Optimizing SQL Bulk Operations with Python’s executemany()
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 MoreQuery to get Employee Expense Report in fusion.
SELECT 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 MoreQuery to get India AP GST Tax Register Report in fusion
SELECT 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 MoreEncrypting SQL Server Database: Transparent Data Encryption (TDE)
Introduction 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 MoreRemoving Transparent Data Encryption (TDE) from SQL Server
Introduction 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 MoreImplement Light and Dark Themes in React App
Introduction/ 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 MoreImplementing JWT Authentication with .NET Core and React
INTRODUCTION/ 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 More