EMPLOYEE SALARY DETAILS QUERY (Core HCM)
Introduction: This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name etc .. Cause of…
Read MoreVirtual Private Database (VPD) in Oracle APEX for securing data access
Overview: This blog talks about VPD (Virtual Private Database) in Oracle Apex, a feature that helps address security concerns by restricting access to data at the row level based on…
Read MoreActive EBS users and their respective responsibilities in Oracle E-Business Suite
Every time a customer or client asks for a list of EBS Users and their responsibilities, the DBA team would generally execute the “Active Users” Concurrent Program from the System…
Read MoreEnhancing Log and Output File Management in Oracle E-Business Suite 12.2
Introduction: Effectively managing large log and output files is crucial for maintaining optimal performance in Oracle E-Business Suite 12.2. Despite the availability of purge programs to address both database and…
Read MoreSTEPS TO INSTALL SQLSERVER IN WINDOWS 10
STEP – 1 1 First download .netframework 3.5 Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the…
Read MoreEMPLOYEE WORK SCHEDULE UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Work Schedule changes like Work Schedule id, Name etc… In this Last update date is used as…
Read MoreEMPLOYEE ASSIGNMENT UPDATE (Core-HCM)
Introduction: This SQL query is used to fetching the data of Employees Assignment changes like Manager change, location change etc… In this Last update date is used as a parameter…
Read MoreGenerate OTP and Integrate SMS API
1. Overview This document talks about how to generate OTP & Integration of SMS. 2. Technologies and Tools Used The following technologies has been used to Integrating SMS & generating SMS. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to generate OTP & Send SMS to Respective Person. 4. Architecture Following steps explains in detail, Step 1: It validates and generate OTP , It allows to generate New OTP Maximum 3 times and resend OTP Maximum 5 Times. It is not allowed Maximum of OTP. This Query for generating OTP. SELECT CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) Step 2: Generating OTP and insert OTP into table. BEGIN SET NOCOUNT ON; DECLARE @EmployeeReferralID int; DECLARE @OTP varchar(6); DECLARE @CurrentDatetimeIST datetime=(SELECT (GETDATE() as TIME ZONE ‘Eastern Standard Time’) AT TIME ZONE ‘India Standard Time’); SELECT @OTP= CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) END Step 3: Verify OTP for respective Mobile Number. BEGIN DECLARE @OTPInput varchar(6); DECLARE @OTP varchar(6); SELECT @OTP=top 1 otp from tblemployeeOTP where mobileno=@mobileno order by desc; if(@OTPInput=@OTP)…
Read MoreOracle 23-C New Features Table Value Constructor
Introduction The database’s SQL engine now supports a VALUES clause for many types of statements. This new clause allows for materializing rows of data on the fly by specifying them…
Read MoreEmployee Revoke (Core Hr-HCM)
Introduction: This SQL query is used to fetching the data for Employees who are Revoked means cancelled the termination those employees will fetch based on last update date. SQL…
Read More