Introduction: 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 MoreIntroduction: This Post illustrates the steps required to On Hand Quantity with Available To Transact in Oracle EBS. Script to Fetch the On Hand Quantity with Available To Transact Step-1…
Read MoreIntroduction: This Post illustrates the steps required to fetch data from AR to GL in Oracle EBS 11i. Script SELECT je_header_id, line_number, trx_number, item_number, customer_number, customer_name, SOURCE, CATEGORY, batch_name,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open work orders in Oracle EBS. Query to Fetch the Open Work Orders SELECT DISTINCT a.job, a.item item, a.item_description, a.product_category,…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Open sales orders in Oracle EBS. Script to Fetch the Open sales Orders SELECT customer_number, customer_name, organization_code, sku, request_date, schedule_ship_date,…
Read More