Copy data from one database to another

Copy Command:

SQL> COPY FROM apps/xxxx@uat TO apps/xxxx@prod INSERT XXHR_EMP_DOJ USING SELECT * FROM XXHR_EMP_DOJ;

Cannot end date or delete the element in Oracle Payroll

Cannot end date or delete the element in Oracle Payroll:

Requirement: When I am trying to end date the element as of 01-Jan-2010 it is giving me the following error:

APP-PAY-06213: Formula result rule use this input value
Check you formula result rules for indirect results that feed this input value.

Solution:

Please run this updated query to see if there is any run results attached to the element.

SELECT  ET.ELEMENT_NAME,psp.PROCESSING_RULE, ff.FORMULA_NAME, pfr.RESULT_NAME,

pfr.RESULT_RULE_TYPE, et1.ELEMENT_NAME et_to_end_date,iv.NAME,iv.UOM, et.REPORTING_NAME,RESULT_RULE_TYPE ,

Psp.EFFECTIVE_START_DATE rule_start_date,PSP.EFFECTIVE_END_DATE rule_end_date

FROM

PAY_STATUS_PROCESSING_RULES_F psp,

PAY_FORMULA_RESULT_RULES_F pfr,

ff_formulas_f ff,

PAY_ELEMENT_TYPES_F ET,

PAY_ELEMENT_TYPES_F ET1,

PAY_INPUT_VALUES_F IV

WHERE

psp.FORMULA_ID=ff.FORMULA_ID

AND pfr.STATUS_PROCESSING_RULE_ID=psp.STATUS_PROCESSING_RULE_ID

AND et.ELEMENT_TYPE_ID=psp.ELEMENT_TYPE_ID

AND et1.ELEMENT_TYPE_ID=pfr.ELEMENT_TYPE_ID

AND iv.INPUT_VALUE_ID=pfr.INPUT_VALUE_ID

--AND pfr.RESULT_RULE_TYPE = 'I'

AND ET1.ELEMENT_NAME = --'Pension Adjustment'

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