Lot Genealogy Report
Introduction: 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…
Read MoreQuality Test Sample Throughput Report
Introduction: 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…
Read MoreAPI to Update Item Status in Oracle E-Business Suite
API to Update Item Status in Oracle E-Business Suite Introduction In Oracle E-Business Suite (EBS), Item Status controls key aspects of how an item behaves across different modules such as…
Read MoreAPI to Update the Item Categories in Oracle EBS
API to Update the Item Categories in Oracle EBS Introduction In Oracle E-Business Suite (EBS), item categories play a crucial role in organizing and classifying items for inventory, costing, and…
Read MoreSample code to create a Qualifier for an Existing Modifier
DECLARE lc_uom VARCHAR2 (5); lc_cust_account_id NUMBER; lc_list_type_code VARCHAR2 (150); lc_list_line_type_code VARCHAR2 (150); lc_prod_attr_value VARCHAR2 (25); lc_segment_mapping_column VARCHAR2 (150); lc_prc_context_name VARCHAR2 (150); lc_prc_mapping_column VARCHAR2 (150); lc_prcing_context_name VARCHAR2 (150); lc_account_number VARCHAR2 (15);…
Read MoreQuery to find the historical Quantity for an item
SELECT SUM (target_qty) FROM (SELECT segment1, description, mtl.primary_uom_code, moqv.subinventory_code subinv, moqv.inventory_item_id item_id, SUM (transaction_quantity) target_qty FROM apps.mtl_onhand_qty_cost_v moqv, apps.mtl_system_items_vl mtl WHERE moqv.organization_id = :p_organization_id AND moqv.inventory_item_id = :p_inventory_item_id AND moqv.inventory_item_id…
Read MoreReducing AWS Costs by Right-Sizing Kubernetes Workloads
Introduction/Issue:Running Kubernetes on AWS gave us flexibility, but we noticed our monthly bills were climbing fast. On closer inspection, we found workloads consuming way more resources than they needed, leading…
Read MoreFixing CrashLoopBackOff in Kubernetes Pods
Introduction/Issue:During one of our deployments, we noticed several pods stuck in a CrashLoopBackOff state. This immediately raised alarms since critical services were unavailable. The CrashLoopBackOff loop happens when a container…
Read MoreCreating a Wizard-Style Progress Bar in Oracle APEX
Introduction/ Issue: Multi-step forms are common in applications — onboarding flows, surveys, registrations, or wizards. But in Oracle APEX, when you build multi-step forms using multiple regions, the user can…
Read MoreCascading LOVs in Oracle VBCS
Introduction/ Issue: When building business applications, it’s common to have dropdowns (Lists of Values) where the available options in one field depend on the selection in another. For example, in…
Read More