Register a printer in oracle
Introduction: 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 MoreQuery to get the Printer Name
Introduction: 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 MoreQuery to find out the Request Set of a Program and its details in EBS R12
Objective 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 MoreQuery to find out the Receiving Transaction Interface error details in EBS R12
Objective 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 MoreAuditing in Oracle E-Business Suite
Navigating 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 to Upload Purchase Quotations
PROCEDURE 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 MoreItem Where Used Extract Query
Introduction: 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 MoreBill of Materials Explosion Extract Query
Introduction: This SQL query is used to fetching the data of Bill of Materials Explosion details like Order Level, Root Assembly, Assembly Item, Assembly Item Description, Assembly Item Type,…
Read MoreService contract reconciliation Report
SELECT okha.sts_code,okha.scs_code,okha.date_approved,okha.estimated_amount, xscb.price_list_id, xscb.customer_bill_to_number, xscb.customer_ship_to_number, xscb.contract_number, xscb.contract_type, xscb.cognomen, xscb.start_date, xscb.end_date, qslh.NAME AS price_list_name, ood.organization_code AS inventory_org_code, hou.NAME AS operating_unit_name, customer, xscb.payment_term, NULL price_list, line_item, DECODE (TRIM (xscb.err_msg), ‘/’, ‘SUCCESS’, xscb.err_msg)…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read More