SELECT DISTINCT aiha.invoice_id, response, aiha.creation_date, ai.invoice_date, (SELECT vendor_name FROM apps.po_vendors WHERE vendor_id = ai.vendor_id) vendorname, (SELECT ai.invoice_num FROM ap_invoices_all ai WHERE ai.invoice_id = aiha.invoice_id) invoice_number, (SELECT ai.invoice_amount FROM ap_invoices_all ai…
Read MoreIncrease on-hand quantity interface using miscellaneous receipt To increase on-hand quantity via a miscellaneous receipt interface, you use an ERP/Inventory system ( to record items found during a physical count that exceed…
Read MoreCreating a BOM Item Creating a Bill of Materials (BOM) item in Oracle Apps R12 involves defining the parent assembly and its components within the Bills of Material module, ensuring prerequisites like items…
Read MoreIntroduction: – This document explains the process of creating a custom button inside an Interactive Grid (IG) and dynamically setting the value of another column by using JavaScript and PL/SQL…
Read MoreIntroduction: – This document explains how to dynamically change column labels on page load for an Interactive Grid (IG) in Oracle APEX using JavaScript. This approach helps when column names…
Read MoreIntroduction/ Issue: To reload all existing shipment history into Fusion that was deleted when the Load Planning Data from Flat Files process was run in Target mode instead of Net…
Read MoreIntroduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we need to do / Cause of the…
Read MoreIntroduction: In Oracle Order Management, We have two Shipping methods post Sales Order creation, Full Shipment and Partial Shipment. They are carried out by specifying the quantity while creating Shipment in OMS (Fusion). In this blog we will…
Read MoreIntroduction: Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF pages have traditionally been used to develop enterprise-grade web applications…
Read MoreIntroduction: – Interactive Grids are widely used to display and manage large volumes of data efficiently. However, one common challenge users face is handling column widths—especially when data length varies…
Read More