Integration with Oracle Payroll - Employees with Multiple Assignments
We have implemented OIC (version 11.5.10.2) for a customer in Egypt. Sales reps are paid throught Oracle Payroll. There are few sales reps which have multiple assignments. Ideally for these sales rep the batch element entry must be created against their primary assignment. But that's not the case. Below are my findings:
When we click on Pay Payrun... "cn_payrun_pvt.Build_Parse_Fetch_Call" package procedure gets called. Within this package we have a cursor which retrives the assignment id based on the salesrep_id. See below.
SELECT p.assignment_id assignment_id,
p.assignment_number assignment_number,
rre.source_business_grp_id source_business_grp_id,