Dynamic alert recipient list (Oracle Alerts)

Scenario:
I want to send an alert to a recipient that is identified by the output of the alert SQL.
Solution:
Enter variables from the select into the recipient list and subject header

Transfer Process in SSHR

Requirement:In the Transfer process after all the approvals notification should go to the employee being transferred.

Solution:As per standard Oracle workflow process, after approval notification goes to the person who has initiated the request.
Process for Transfer - HR_TRANSFER_JSP_PRC Then go to HR_NOTIFICATION_PRC then Go to HR_HRSSA_V5_APPROVED_PRC then go to
notification HR_NTFY_APPROVAL_OWNER_V4_NTF. In the node change performer from Creator Person User Name to Current Person User Name.

Test the process

FYI Notification in Oracle SSHR AME

Business Requirement:

We implemented HRMS manager self service and using AME, For New Hire process, the approval is: HR Director, and FYI notifications to IT, Finance, Security department.

We are on AME B, oracle 12.0.5. As of now I am successful to send to HR Director for approval. I need help for FYI notifications

Please let me know how can I achieve this.
Solution:

Already rule is created for Approval process.

1. Create Approval Group(FYI recipeints)(You can use Position Roles)
2. Create new rule having Category as "For You Information".
3. Condition of FYI rule will be same as Approval rule.
4. Action will be notification to FYI recipients.
5. Test it.


 

SIT Approval Workflow Process

Process Name - HR_SIT_JSP_PRC

New Hire and Terminzation Process Workflows

New Hire - HR_NEW_HIRE_PLACE_JSP_PRC

Termination - HR_TERMINATION_JSP_PRC

The macro cannot be found or has been disabled (BI Publisher and Office 2010)

Recently I have upgraded MS Office from 2007 to 2010. As I work on some BI projects, part of mine set of oracle programs is oracle BI Publisher Desktop, which use Word as report template designer. When I run BI Publisher macros in Word 2010 I got following error:
The macro cannot be found or has been disabled because of your macro security settings

The solution

The solution shown here really works (tested on several computers), so I'm writing this down to be more like documentation for future reference to anyone stack on this case. Idea is to remove old *.EXD files from any location in %USERPROFILE% folders that might exists.
Because mine praxis is to have separate %USERPROFILE% folder location then where are OS files (different then partition then C:), exd file was found as shown. In mine case it was only in one folder:

D:\Users\Sandip\Application Data\Microsoft\Forms>dir

Volume in drive D is Data

Volume Serial Number is 505E-794F

Directory of D:\Users\Sandip\Application Data\Microsoft\Forms

01.02.2011  11:45    <DIR>          .

01.02.2011  11:45    <DIR>          ..

12.03.2009  15:17           165.808 MSComctlLib.exd

31.08.2010  10:34            11.776 WINPROJ.box

01.02.2011  11:19             7.168 WINWORD.box

3 File(s)        184.752 bytes

2 Dir(s)  51.699.859.456 bytes free

D:\Users\Sandip\Application Data\Microsoft\Forms>

So all you have to do is:

1. Rename existing "MSComctlLib.exd" file to "MSComctlLib.exd_bak"
2. Install BI Publisher again.

It should work....

Cherrrrrrrssssssssss...

Reference :- http://damir-vadas.blogspot.com/2011/02/macro-cannot-be-found-or-has-been.html?showComment=1303225868321#c4865170160256515104

Education and Qualification and Other Professional Qualifications Approval in SSHR

Education and Qualification and Other Professional Qualifications Approval in SSHR:

Process Name for Education and Qualification workflow - HR_QUALIFICATION_JSP_PRC

And Process Name for Other Professional Qualifications workflow - HR_AWARD_JSP_PRC