Search This Blog

Thursday, June 1, 2017

Fusion Queries for Bank Name and Nationality


Bank Query:

Select distinct bank_name from pay_bank_accounts

 

Nationality:

select lookup_code,meaning from hr_lookups where lookup_type like 'NATIONALITY' and enabled_flag = 'Y'

Wednesday, May 24, 2017

Fusion Payroll Query to get Payroll Relationship and BU Name

select p.person_number,
py.payroll_name,haou.name BUName
from PAY_ASSIGNED_PAYROLLS_DN ap
,    pay_PAYROLL_TERMS pt
,    PAY_PAY_RELATIONSHIPS_DN pr
,    PAY_ALL_PAYROLLS_F py
,    PER_ALL_PEOPLE_F p
,    per_all_assignments_m paam
,    hr_all_organization_units haou
,    (select distinct person_id from per_person_secured_list_v) ppsl
where ap.payroll_term_id = pt.payroll_term_id
and   pt.payroll_relationship_id = pr.payroll_relationship_id
and   ap.payroll_id = py.payroll_id
and   pr.person_id = p.person_id
--and p.person_number = '2824'
and ap.lsed is null
and paam.person_id=p.person_id
and trunc(sysdate) between paam.effective_start_date and paam.effective_end_date
and trunc(sysdate) between p.effective_start_date and p.effective_end_date
and paam.assignment_type = 'E'
and paam.primary_flag = 'Y'
and haou.organization_id = paam.business_unit_id
and ppsl.person_id = p.person_id

Sunday, May 7, 2017

Encryption Concept

1. Customer will encrypt the date using Fusion provided public key.
2. Security Console setup will be done in Fusion which will decrypt the data before loading to system
3. Data to be sent out will be encrypted using Customer provided public key. So customer needs to provide public key.
4. Always public keys are shared.

Thursday, March 16, 2017

Taleo Client Connect (TCC) erroring out with Workflow Execution Failed error

Error while running TCC from Unix server

While running TCC through UNIX below error is coming.

2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.
2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.
2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.

Resolution:

In the cfg file for Send, Poll and Retrieve tabs, End Point source should be "Provided in the Current Step"