Workflow notification mailer not starting after auto config run on ebs 12.1.
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.
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 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”
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
set head off
set newpage none
set pagesize 9999
select ‘drop synonym ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from dba_objects where OWNER =’OWNER’ and OBJECT_TYPE =’SYNONYM’;
Database link extract
SELECT DBMS_METADATA.GET_DDL(‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;
Stop application service
[appltrng@ebsdev bin]$ perl ojspCompile.pl –compile –flush -p 2
we need to check compiled successfully
start application service
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,
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
into &emp_num,&emp_name, &posi, &department,&Joining ,&Loc,&Sup,&UsrName
FROM per_all_people_f ppf,
WHERE 1 = 1
AND ppf.person_id = paf.person_id
AND ppf.business_group_id = paf.business_group_id
AND pq.person_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);
In some situation, User not able to view them responsibilities after logon EBS.
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.