Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Can you help with the SQL for a payroll costing report that includes the % allocation?
We need to write a report that returns payroll costing details by element together with the percentage allocation for each employee. We're using EBS 12.1.3 RUP10.
The report should look something like this:
| EMP_NO | ASG | ELEMENT | CLASSIFICATION | DEBIT | CREDIT | SEGMENT1 | SEGMENT2 | SEGMENT3 | SEGMENT4 | SEGMENT5 | SEGMENT6 | PROPORTION | PERCENTAGE |
| EMP1 | ASG1 | Salary | Earnings | 442.87 | 0.00 | CO | BU1 | DP1 | ACT1 | CC1 | NOM1 | 0.20 | 20.00 |
| EMP1 | ASG1 | Salary | Earnings | 1771.46 | 0.00 | CO | BU1 | DP1 | ACT1 | CC2 | NOM1 | 0.80 | 80.00 |
| EMP1 | ASG1 | Salary | Earnings | 0.00 | 2214.33 | CO | BU2 | DP2 | ACT2 | CC3 | NOMS | N/A | N/A |
The problem we're trying to solve is how to get this information without duplicating lines where costs are split across a multiple GL codes e.g. code 1 80% code 2 20% and ensuring that the % allocation is populated against the right GL code combination.
Tagged:
2