Introduction: This Post illustrates the steps required to get the Item Available to Transact Quantity in Inventory using API. Script FUNCTION xx_item_availble_to_transact ( p_inventory_item_id NUMBER, p_organization_id NUMBER, p_subinventory_code VARCHAR2, p_locater…
Read MoreIntroduction: This Post illustrates the steps required to update the Item Status using API. Script to Update the Item Status DECLARE p_item_number VARCHAR2 (300); p_organization_id NUMBER; p_inventory_item_id NUMBER; p_org_id NUMBER;…
Read MoreIntroduction: This Post illustrates the steps required to Send the Email in Autonomous Data Warehouse. Script to Send Email CREATE OR REPLACE PROCEDURE xx_sample_send_mail ( p_to IN VARCHAR2, p_from IN…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Item with BOM Details. Script to Fetch the Item with BOM Details SELECT msi.segment1 item, msi.description item_description, msi.organization_id, msi.primary_unit_of_measure primary_uom, msi.item_type,…
Read MoreIntroduction: This Post illustrates the steps required to check the stuck records in Inventory transactions. Scripts: –Unprocessed Material Transactions SELECT * FROM mtl_material_transactions_temp WHERE organization_id = (SELECT organization_id FROM apps.org_organization_definitions…
Read MoreIntroduction: This Post illustrates the steps required to fetch the Open Purchase Order Data in Oracle EBS. Script: SELECT pv.segment1 vendor_number, pv.vendor_name AS vendor_name, (SELECT location_code FROM hr_locations_all WHERE location_id…
Read MoreIntroduction: This Post illustrates the steps required to fetch the Sales History Data in Oracle EBS. Script: SELECT customer_number, customer_name, organization_code, order_number, line_number, sku, invoice_number, invoice_date, quantity_invoiced, unit_selling_price, (invoiced_quantity…
Read MoreIntroduction: This Post illustrates the steps required to Change the Employee User accounts to ‘SSO’ from ‘LOCAL’ in Oracle EBS . Script: DECLARE l_success BOOLEAN; CURSOR UID IS SELECT user_name,…
Read MoreIntroduction: This Post illustrates the steps required to delete the employee records in Oracle EBS HRMS Module. Script: Step 1 –Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); Step…
Read MoreIntroduction: This Post illustrates the steps required to Fetch the Invoice lines not transferred to GL in Oracle . Sql Script: SELECT rct.trx_number invoice_number, rctl.line_number, msib.segment1, hp.party_name bill_to_customer, DECODE (rctt.TYPE,…
Read More