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 item wise, we…
Read MoreHow 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 instance even…
Read MoreSQL 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 Audit was configured to capture both FAILED_LOGIN_GROUP and SUCCESSFUL_LOGIN_GROUP events. While…
Read MoreHow 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 various scenarios, such as creating IDs, generating row…
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 MoreQuery 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 customer account id. In…
Read MoreEmployee 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 wants…
Read MoreHow 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…
Read MoreDelete 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 records as below, SELECT…
Read MoreCustomer 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 err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,cpt.* FROM hz_imp_errors…
Read More