Blog / Category
SQL query
15 articles in this category
Sql Query to get Item wise lot quantity
Introduction/ Issue: This query will help us to get item wise lot quantity. Why we need to do / Cause of the issue: When we need to validate the lot quantity it…
How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…
SQL Server Audit File Enabled for Both Failed and Successful Logins
SQL Server Audit File Enabled for Both Failed and Successful Logins Introduction During a routine SQL Server security review, it was observed that SQL Server Au…
How To Generate Dynamic Numbers in MYSQL
Introduction: Generating dynamic numbers in MySQL involves creating a sequence of numbers or generating numbers dynamically in queries. This is useful in variou…
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
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 re…
Query to display the customer name and customer address details
Introduction: This query is used to fetch the data of customer name and also the details like the account number, addresses, city, country, postal code and cust…
Employee Recall Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business…
How to uninstall patch
How to uninstall patch file when need to downgrade and remove it What is the patch file. RTM is the original build version of the product when you download the…
Delete duplicate records in different ways
How to delete duplicate records in different ways in SQL. for example: Consider the combination of EMPNO & ENAME columns in EMP table is having duplicate record…
Customer Contact Points Import Error Query – FBDI Oracle Fusion
The below query extracts the error details along with interface attributes of Customer Contact Points import using FBDI in Fusion Applications. SELECT distinct…
Customer Account Import Error Query – FBDI
The below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.mes…
GL DRILL Down Query From GL into Fixed Assets Sub ledger Module.
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(all sources) sub-l…
Drill Down Query From GL into Project Accounting subledger
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accounting sub-ledger m…
ISO Receipt Register -GST Query
SELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid, send_orgname, recv_orgid, recv_org_name, gst_…
SQL to Find Employee – Supervisor Hierarchy details
Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval o…