Skip to content

Archive for

VMware free self paced e-learning course

script for send alert email to itsupport when new employee joining

the below script for send alert email to itsupport when new employee joining


the HR team will update the new employee details in HRMS and after if we schedule the alert,  it will send alert to itsupport team for prepare the email/ext/laptop and others.


SELECT Distinct ppf.employee_number, ppf.full_name emp_name,
hr_general.decode_job (paf.job_id) POSITION,
xxhr_ace.get_dept_name (paf.organization_id,
) department,
TO_CHAR (ppf.effective_start_date, ‘DD-MON-YYYY’) Joining_date,
hl.location_code,(select full_name from per_all_people_f where person_id=paf.SUPERVISOR_ID AND TRUNC (SYSDATE) BETWEEN effective_start_date
AND effective_end_date)Supervisor_name,fu.user_name
into &emp_num,&emp_name, &posi, &department,&Joining ,&Loc,&Sup,&UsrName
FROM per_all_people_f ppf,
per_all_assignments_f paf,
per_qualifications pq,
hr_locations hl,
fnd_user fu
WHERE 1 = 1
AND ppf.person_id = paf.person_id
AND ppf.business_group_id = paf.business_group_id
and paf.location_id=hl.location_id
AND pq.person_id(+) = ppf.person_id
and ppf.CREATION_DATE>=trunc(sysdate)
AND ppf.last_update_date> TO_DATE(:DATE_LAST_CHECKED, ‘DD-MON-YYYY HH24:MI:SS’)
and not exists(select 1 from per_all_people_f where person_id=ppf.person_id and TRUNC (SYSDATE)-365 BETWEEN effective_start_date
AND effective_end_date )
ORDER BY Location_code,TO_NUMBER (ppf.employee_number);

User not able to view them responsibilities after logon EBS

In some situation, User not able to view them responsibilities after logon EBS.


Solution :

Submit Workflow Directory Services User/Role Validation concurrent request  and run


now they can able to view the responsibilities.

In case Still not view responsibilities,  run the Synchronize WF LOCAL tables concurrent request as well.

Oracle Linux 7.6 black screen while boot from virtualbox

I am trying to boot my oracle linux 7.6 which is running under virtual box but black screen appear long time


Causes :


Network manager & network manager wait online service have a problem

Solution :

Boot as rescue mode like below

Edit mode (e)

end of line linux16, add below command


control + x  –> enter


Maintenance mode will appear

Enter root password maintenance

Execute below command

systemctl mask systemd-NetworkManager-wait-online.service

reboot the machine

The network manager may have a problem after restarted the machine, so start the network manager like below

systemctl enable NetworkManager

systemctl unmask NetworkManager.service

systemctl start NetworkManager.service


In case selinux may also making issue for black screen appeared while booting. Please disable and reboot the machine.

Error while executing service Service execution error – target name xml-multiple of processing instruction at line {1}

Custom REST web service failed with below errors

Tue Jun 18 17:09:13 AST 2019 : : ServiceExecError: Error while executing service Service execution error – target name xml-multiple of processing instruction at line {1}, column {2} is reserved target name xml-multiple of processing instruction at line {1}, column {2} is reserved
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(
at com.sun.jersey.spi.container.servlet.WebComponent.service(
at com.sun.jersey.spi.container.servlet.ServletContainer.service(
at com.sun.jersey.spi.container.servlet.ServletContainer.service(
at javax.servlet.http.HttpServlet.service(
at com.evermind.server.http.ServletRequestDispatcher.invoke(
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(
at com.evermind.server.http.HttpRequestHandler.processRequest(
at com.evermind.util.ReleasableResourcePooledExecutor$
Tue Jun 18 17:09:13 AST 2019 : : Response Media Type – application/json
Tue Jun 18 17:09:13 AST 2019 : : Error Response –
“ISGServiceFault” : {
“Message” : “Error while executing service”,
“Resolution” : “System error, please see service log trace for details”,
“ServiceDetails” : {
“ServiceName” : “XXACE_REV_SOA_CMS_PKG1”,
“OperationName” : “get_transaction_proc”,
“InstanceId” : “0”

Solution :

Download and apply the Patch 17428617 at Oracle Home (10.1.3) path on Application server using opatch

Custom REST webservice with nested array based package is failing while invoking (Doc ID 2439803.1)