Skip to content

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.

Oracle database 19c step by step installation guide on oracle linux 7.6

Oracle database 19c installation document

Oracle Database 19c step by step installation guide on Oracle Linux 7.6

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”

How to calculate archivelog growth per day

archivelog size each day

select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc(COMPLETION_TIME) order by 1;

archivelog size each hour

alter session set nls_date_format = ‘YYYY-MM-DD HH24′;

select trunc(COMPLETION_TIME,’HH24′) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,’HH24’) order by 1;

Drop all synonym from owner

Drop all synonym from owner

set head off
set newpage none
set pagesize 9999

spool drop_synonym.sql

select ‘drop synonym ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from dba_objects where OWNER =’OWNER’ and OBJECT_TYPE =’SYNONYM’;

spool off

Databaselink extract

Database link extract

 

SELECT DBMS_METADATA.GET_DDL(‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;

 

 

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

VMware free self paced e-learning course

https://mylearn.vmware.com/mgrReg/plan.cfm?plan=33611&src=so_5a314d05ddb83&cid=70134000001SkJd

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.