Skip to content

Posts from the ‘EBS’ Category

AD Splicer error environment does not match computed value

During upgrade from 12.1 to 12.2

this issue may be occurs due to the old 12.1 environment set. unset the old environment and set the 12.2 run edition environment and rerun the adsplice again. taking long time running to complete long time running to complete patch installation or remove patch.


Apply follow the patch

Patch 27238412

Increase the memory value :

MEM_ARGS=”-Xms4096m -Xmx4096m -XX:+UseParallelGC”


Refer note :

Enhancement for WLS BSU (Smart Update): Resolves Very Long Time to Apply Patches – Especially When Checking for Patch Conflicts (Doc ID 2271366.1)


New OA Framework 12.2.7 Bundle 5 Now Available

Please refer



java.lang.RuntimeException: Connection refused

Workflow notification mailer not starting after auto config run on ebs 12.1.

Solution :

check your workflow notification mailer as advanced tab, can you able to reach the outbound and inbound server. If not, check outbound email server name with port and inbound server name with port. If those information was correct, Still you have issue then Can you try to reach the outbound and inbound servers with port from application servers.

How to upload alert in r12


FNDLOAD apps/password 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_Probation_period_alert15days.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXACE Alert_name=”Probation Period Alert 15 Days”

FNDLOAD Download

FNDLOAD apps/password 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_Probation_period_alert15days.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXACE Alert_name=”Probation Period Alert 15 Days”

compile jsp in r12

Stop application service

[appltrng@ebsdev bin]$ perl –compile –flush -p 2

we need to check compiled successfully

start application service

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.

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)

could not lock request concurrent manager

When we try to cancel a some request in concurrent manager, we might got the below issue


“could not lock request” ,

Solution :

Output post processor may have a issue, so terminate the output post processor and activate again.


But still the old request running on long time and complete with warnings or the request keep on running, so you need to cancel the request from database backend.


open two session as a apps user

Cancel the request :


update fnd_concurrent_requests set phase_code=’C’ , status_code=’X’ where request_id=’8239849′;

the command may be taking long time for complete or keep running. so you please check any blocking session there in the system


select sid, username, event, blocking_session,
seconds_in_wait, wait_time
from v$session where state in (‘WAITING’)
and wait_class != ‘Idle’;


kill the blocking session and you can see the cancel update command done and commit. now the request has been  terminated.

Hopefully after output post processor activated, the future concurrent request are running without issues.