Skip to content
Advertisements

Posts from the ‘EBS’ Category

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.

Advertisements

How to upload alert in r12

FNDLOAD Upload

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

cd $FND_TOP
[appltrng@ebsdev bin]$ perl ojspCompile.pl –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,
paf.business_group_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 fu.EMPLOYEE_ID(+)=ppf.PERSON_ID
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 : oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : oracle.apps.fnd.soa.rt.rest.common.IsgRestInvocationException: 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 oracle.apps.fnd.soa.rt.rest.common.ErrorContext.makeRestException(ErrorContext.java:106)
at oracle.apps.fnd.soa.rt.rest.common.ErrorContext.throwError(ErrorContext.java:88)
at oracle.apps.fnd.soa.rt.rest.provider.IsgRestServiceProvider.serviceJSONRequest(IsgRestServiceProvider.java:652)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:149)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:259)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:83)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:133)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:71)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:990)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:941)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:932)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:384)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:451)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:632)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:662)
Tue Jun 18 17:09:13 AST 2019 : oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : Response Media Type – application/json
Tue Jun 18 17:09:13 AST 2019 : oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : Error Response –
{
“ISGServiceFault” : {
“Code” : “ISG_SERVICE_EXECUTION_ERROR”,
“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.

 

 

java.sql.SQLException: invalid name pattern

We are trying to push the data to Oracle EBS via SOAP But We’re getting the below errors

Errors in log file

oracle.apps.fnd.soa.util.SOAException: ServiceProcessingError: Exception returned from JCA Service Runtime. file:/u01/…….soa/PLSQL/4457/XXACE_XXXXXXXX_LOAD.wsdl [ XXACE_XXXXXXXXXLOAD_ptt::XXACE_XXXXXXXXX_LOAD(InputParameters,OutputParameters) ] – WSIF JCA Execute of operation ‘XXACE_XXXXXXXXX_LOAD’ failed due to: Error while converting to a Java array object. Unable to convert the XSD element P_INVOICE_REC whose collection type is APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6. Cause: java.sql.SQLException: invalid name pattern: APPS.XXACE_XXXXXXX_SOA_PKG_XX_6 [Caused by: invalid name pattern: APPS.XXACE_XXXXXXX_SOA_PKG_XX_6] ; nested exception is: ORABPEL-11801 Error while converting to a Java array object. Unable to convert the XSD element P_INVOICE_REC whose collection type is APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6. Cause: java.sql.SQLException: invalid name pattern: APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6 [Caused by: invalid name pattern: APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6] Check to ensure that the XML data describing the collection matches the definition of the array in the XSD. Contact oracle support if error is not fixable. at oracle.apps.fnd.soa.provider.services.jca.JCAHandler.invoke(JCAHandler.java:173) at oracle.apps.fnd.soa.provider.services.jca.JCAHandler.handleRequest(JCAHandler.java:120) at oracle.apps.fnd.soa.provider.SOAProvider.processMessage(SOAProvider.java:342) at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:958) at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:388) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:385) at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:481) at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:114) at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:96) at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:200) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:662) org.collaxa.thirdparty.apache.wsif.WSIFException:

Solution :Regenerate the WSDL and deploy

We push the data, its successful.

Please be note : We cloned the data only not entire application files, so that reason the above error occurred.

EBS 12.2.6 Generate Automatically and Enter Manually Options Are Missing In User Management

When you try to reset password for asadmin and other users in User management, Its invisible.

Solution :

 

12.2.6 Reset Password Options: Generate Automatically and Enter Manually Options Are Missing In User Management > Users Page (Doc ID 2260179.1)

ORA-20008: No Concurrent Manager is defined that can run concurrent program

When I am trying to prepare phase in ADOP, I am getting below issue

Submitting ADZDPATCH concurrent program.
Waiting for conflicting requests to complete.
[ERROR] Failed to execute sql statement:
select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(5775506) from dual
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 – Production on Wed Jan 23 16:39:59 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(5775506) from dual
*
ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program
ADZDPATCH
ORA-06512: at “APPS.AD_ZD_ADOP”, line 274
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[UNEXPECTED]Error calling runConcurrentProgram subroutine.
Stopping services on patch file system.
Stopping admin server.
Stopping node manager.
[ERROR] Prepare phase has failed.

[STATEMENT] Please run adopscanlog utility, using the command

“adopscanlog -latest=yes”

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

 

Solution :

Please check your concurrent manager are working fine and then start to do prepare phase again, It will work.

If concurrent manager does not have issue, check the support document (Doc ID 2334520.1).