SPO sql_performance_changed.txt; DEF days_of_history_accessed = ’31’; DEF captured_at_least_x_times = ‘1’; DEF captured_at_least_x_days_apart = ‘1’; DEF med_elap_microsecs_threshold = ‘1e4’; DEF min_slope_threshold = ‘0.1’; DEF max_num_rows = ’20’; SET lin 500 ver…
Read MoreSELECT DECODE ( CONCURRENT_QUEUE_NAME, ‘FNDICM’, ‘Internal Manager’, ‘FNDCRM’, ‘Conflict Resolution Manager’, ‘AMSDMIN’, ‘Marketing Data Mining Manager’, ‘C_AQCT_SVC’, ‘C AQCART Service’, ‘FFTM’, ‘FastFormula Transaction Manager’, ‘FNDCPOPP’, ‘Output Post Processor’, ‘FNDSCH’, ‘Scheduler/Prereleaser…
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 MoreIntroduction This Post illustrate steps required to Change the Item Cost Groups in Oracle EBS. Script to Change the Item Cost Groups DECLARE p_item VARCHAR2; p_organization_id NUMBER; p_subinventory VARCHAR2; p_locater…
Read MoreIntroduction This Post illustrate steps required to import bank account details of the suppliers in Oracle EBS R12. Script to import Bank account details for suppliers. PROCEDURE create_banks_accounts (p_change_type VARCHAR2)…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Leases which are Expired but not terminated in Oracle EBS R12. Script to Leases Expired but not terminated SELECT GCC.segment4 SOL_ID…
Read MoreSame Page is working for one user and is not working for another user. In this case sometimes due to some empty customization this issue will occur. You can run…
Read MoreBelow is the package you can download for AP Invoice Payments. ap-invoice-payments-api
Read MoreBelow is the query for getting expected shipments in Oracle Purchasing. SELECT reqh.type_lookup_code, reqh.requisition_header_id po_header_id, rsl.requisition_line_id po_line_id, rsl.req_distribution_id po_distribution_id, reqh.segment1 po_number, msi.segment1 AS item_code, rsl.item_description, rsh.shipment_num, rsl.line_num shipment_line_number, rsl.quantity_shipped expected_receipt_qty,…
Read More