Calling External URL in a New window
Suppose if we want to call any external URL in OAF page. So you can call as like below. urlname = https://www.google.com/ pageContext.sendRedirect(urlname);
Read MoreValidation script for block corruption
Introduction: The following script is to validate if there are any corrupted rowids in FND_LOBS table Why we need to do this? When we run this validation script it will…
Read MoreEligible Po Details for Supplier Wise
SELECT * FROM (SELECT POH.SEGMENT1 PO_NUMBER, PRL.RELEASE_NUM RELEASE_NUM, DECODE ( PRL.PO_RELEASE_ID, NULL, POH.clm_document_number, POH.clm_document_number || ‘-‘ || TO_CHAR (PRL.RELEASE_NUM) ) DISPLAY_PO_NUMBER, POL.LINE_NUM LINE_NUM, POL.ITEM_ID ITEM_ID, POL.ITEM_REVISION ITEM_REVISION, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION, POL.VENDOR_PRODUCT_NUM…
Read MoreAdvance Shipment Notice details Query.
SELECT DISTINCT RHI.SHIPMENT_NUM, RHI.SHIPPED_DATE, RHI.EXPECTED_RECEIPT_DATE, RHI.FREIGHT_CARRIER_CODE, RHI.INVOICE_NUM, RHI.WAYBILL_AIRBILL_NUM, RHI.NUM_OF_CONTAINERS, RHI.FREIGHT_TERMS, RHI.BILL_OF_LADING, RHI.PACKING_SLIP, RHI.PACKAGING_CODE, POV.VENDOR_NAME, POV.SEGMENT1 VENDOR_NUMBER, PVS.VENDOR_SITE_CODE, RHI.SPECIAL_HANDLING_CODE, RHI.TAR_WEIGHT, RHI.TAR_WEIGHT_UOM_CODE, RHI.NET_WEIGHT, RHI.NET_WEIGHT_UOM_CODE, RHI.COMMENTS, ” CANCELLATION_STATUS, ” PROCESSING_STATUS, RHI.VENDOR_ID, RHI.VENDOR_SITE_ID, NULL…
Read MoreQuery to find the stuck records in Inventory Transaction
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 MoreQuery for Fetch the Open Purchase order Data in Oracle EBS
Introduction: 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 MoreQuery for Fetch the Sales History Data in Oracle EBS
Introduction: 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 MoreChange the Employee User accounts to ‘SSO’ from ‘LOCAL’
Introduction: 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 MorePurge the Employee Records using API in Oracle EBS R12
Introduction: 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 MoreQuery for Fetch the Invoice lines not transferred to GL in Oracle
Introduction: 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