My Oracle Support Banner

PAY_COSTING_PROJECTS_V View Is Not Picking All Payroll Costed Elements. (Doc ID 2508150.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payroll - Version 12.1.3 and later
Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.


PAY_COSTING_PROJECTS_V view is not picking up all payroll costed run results. When there is some change made mid period that results in prorated results, the view only picks up the results as of the date earned of the pay period. It is not picking up any costs where the element entry end date is prior to the date earned. Because of this, not all project costs are flowing to Oracle Project Costing through the 'PRC: Process Payroll Actuals' process.

Development verified in <Bug 28843339>:

"View PAY_COSTING_PROJECTS_V was designed to fetch the details as per the Date Earned. If an Element entry has date track update in the Payroll period, then the record which includes Date Earned is considered.

This view was created earlier as per requirements from Project team. If the requirement is to include all the element entry records with in the Payroll period, then please get the request validated by Projects team and raise a new bug against Payroll team for the change."

The issue can be reproduced at will with the following steps:
1. Make some change to assignment so that there are prorated payroll results in a pay period
2. Run Costing process
3. Run 'PRC: Process Payroll Actuals' process and find that not all payroll costs are transferred to Projects.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.