EMPLOYEE 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 MoreWheebox Assessment tests (ORC-HCM) Query
Introduction: This SQL query is used to fetching the data for candidates who are applied various assessment tests (Wheebox) at the time of recruiting like one candidate can apply two…
Read MoreQuery to get Data Accesses of Users – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…
Read MoreSales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected…
Read MoreSQL Server installation Slipstream
Slipstream in SQL Server What is the slipstream how to use slipstream to install SQL server? Slipstream is a technique used by System Admins to easily update the setup packages…
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 MoreWHAT IS THE DIFFERENCE BETWEEN SRVCTL AND CRSCTL?
SERVER CONTROL UTILITY (SRVCTL) Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances. Use SRVCTL to manage Oracle supplied resources such as:…
Read More