Introduction:-This script will provide all concurrent programs under request set Code:- SELECT rs.user_request_set_name “Set_Name”, rs.request_set_name “Set_code”, rs.description “Description”, rss.display_sequence Seq, cp.user_concurrent_program_name “Conc_Program”, ap.application_name “Application”, e.executable_name “Executable”, e.execution_file_name “Executable File”, lv.meaning…
Read MoreIntroduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_NUM “PO Line”,TO_CHAR(P.CREATION_DATE,’DD-MON-RRRR HH24:MI:SS’) “PO Created…
Read MoreDear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore what is IOT…
Read MoreIntroduction: This blog is done to register a printer in oracle. Cause of the issue: Printer is not setup in oracle. How do we solve: Go to…
Read MoreIntroduction: This query is used to fetch the printer name .In this we will be passing concurrent program id and level value id(user id) as the parameter so that printer…
Read MoreObjective The intent of this document is to find out the request set name of given concurrent Program and the details of programs attached in the Request Set. Why we…
Read MoreObjective The intent of this document is to find out the error’s details when standard Program not able to process the records in interface table (RCV_TRANSACTIONS_INTERFACE). Why we need to…
Read MoreNavigating Auditing in Oracle E-Business Suite: Introduction: Oracle E-Business Suite (EBS) is a powerful enterprise resource planning (ERP) solution that manages a wide range of business processes. Ensuring…
Read MorePROCEDURE load_purchase_quotation as lv_currency_code fnd_currencies_vl.currency_code%type; lv_verify_flag varchar2 (1); lv_error_message varchar2 (5000); ln_vendor_id po_vendors.vendor_id%type; ln_vendor_site_id po_vendor_sites_all.vendor_site_id%type; ln_ship_to_locn_id hr_locations.location_id%type; ln_bill_to_locn_id hr_locations.location_id%type; ln_inventory_item_id mtl_system_items_b.inventory_item_id%type; lv_legacy_quotenum varchar2 (30); ln_batch_id number (3); ln_term_id number; lv_freight_code…
Read MoreIntroduction: This SQL query is used to fetching the data of FG Items where used details like Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, Effettivity…
Read More