Oracle EBS-Query to get Service Contract Details
Query to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_number as the parameter. SQL Query:…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreMove concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…
Read MoreInventory Onhand By Location Report
Introduction: This SQL query is used to fetch the data Inventory Onhand By Location Cause of the issue: Business wants a report that details Inventory Onhand By Location How do…
Read MoreBacklog Report With Freight Details
Introduction: This SQL query is used to fetching the data Backlog Orders with freight Details Cause of the issue: Business wants a report that details of Backlog Orders…
Read MoreQuery to get details of all Concurrent programs used by a Request Set
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 MoreCountry wise Catalog and Non Catalog Po’s in Oracle EBS
Introduction:- 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 MoreOracle Internet Of Things (IoT)
Dear 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 MoreRegister 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 More