public void submitRequestPKS(OAPageContext oapagecontext, OAWebBean oawebbean, String s, String s1) { OAApplicationModule oaapplicationmodule = oapagecontext.getApplicationModule(oawebbean); OAException oaexception; try { OADBTransaction oadbtransaction = oaapplicationmodule.getOADBTransaction(); Connection connection = oadbtransaction.getJdbcConnection(); ConcurrentRequest concurrentrequest =…
Read MoreSELECT AI .INVOICE_ID, AI.INVOICE_NUM, TO_CHAR ( AI.INVOICE_AMOUNT + (SELECT NVL (SUM (amount), 0) FROM ap_invoice_lines_All WHERE invoice_id = AI.INVOICE_ID AND LINE_TYPE_LOOKUP_CODE = ‘AWT’), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30) ) invoice_amount, AI.INVOICE_DATE, TO_CHAR…
Read MoreSELECT DISTINCT pha.vendor_id, hou.name “Organization”, pha.segment1 “po number”, pla.line_num “po line num”, (TRUNC (pha.creation_date – TO_DATE (’01-01-1900′, ‘DD/MM/YYYY’)) + 2) as “PO creation Date”, aps.vendor_name “Supplier Name”, apss.vendor_site_code “Supplier site”,…
Read MoreSELECT * 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 MoreSELECT 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 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 More