employee-assignment-update-integrationEmployee Assignment Update Integration – Oracle Fusion HCM. Introduction: This blog explains about how to call a bip report placed in the oracle fusion hcm instance. And then transfer the…
Read More1. Overview This blog explains about, how we Configure formsweb.cfg to Run Oracle Forms Application. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle Configuration Files 3. Use Case To invoke an application in Oracle Forms using URL, you must configure it in formsweb.cfg file. Then you would be able to access it by providing config parameter is equal to your application name 4. Architecture Oracle FORMS Using FORMS BUILDER 5. Examples Step 1: To add the below code in formsweb.cfg file [yourappname] workingDirectory=c:\serverdir\ userid=yourid/psw@orcl form=mainform.fmx Save the changes in formsweb.cfg file and then access it as follows. Step 2: Run Oracle Forms Application by using the below URL http://localhost:8889/forms/frmservlet?config=yourappname 6. Conclusion You can see above the application URL using the config parameter with your application name [yourappname], you defined in formsweb.cfg file using square brackets [].
Read More1. Overview This blog explains about, how we can hide Password in oracle FORMS. In Oracle Forms, if you are creating any custom login screen or giving any password security option, then there is a need to hide the password. This…
Read MoreIntroduction: 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 MoreIntroduction: 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 MoreOverview The Purpose of the document is to highlight the security features in Oracle APEX.Oracle Application Express (APEX) is a low-code development platform that allows users to build web-based applications…
Read MoreOverview This blog will explains, how to disable the APEX application by end user during the release or it is under maintenance . Technologies and Tools Used The following technology…
Read More1. 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 More1. Overview This document talks about how to send report with excel file automatically to Finance Team every month of 21st. This report for employee referred the candidate who will complete the 90 days and above for the current month of 21st. 2. Technologies and Tools Used The following technologies has been used to automatically send report to Finance Team. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to automatically send report to Finance Team. 4. Architecture Following steps explains in detail, Step 1: First we have to check whether joined candidates reach 90 days for current month of 21st. To select Current Year, Month , Date and calculate candidate cross 90 days. DATEDIFF(DAY, DateofJoin, GETDATE())>=90 AND DATEDIFF (DAY, DateofJoin, GETDATE())<=Datedifference BEGIN DECLARE @DateDifference int=0; DECLARE @LastMonth int=0; DECLARE @CurrentYear int=0; DECLARE @CurrentMonth int=0; DECLARE @PreviousYear int=0; SELECT @CurrentMonth =DATEPART(mm,DATEADD(mm,0,GETDATE()); SELECT @LastMonth =DATEPART(mm,DATEADD(mm,-1,GETDATE()); SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,0,GETDATE()); set @PreviousYear=@CurrentYear; if(@LastMonth=12) BEGIN SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,-1,GETDATE()); END DECLARE @FromDate varchar(10), @ToDate varchar(10); set @FromDate=convert(varchar,@LastMonth) +’/’+’21’+’/’+convert(varchar,@PreviousYear);…
Read MoreDescription : Oratop is an interface that takes data from top and oracle databases on a host. The utility combines the data to OS data and session data. It allows…
Read More