Export To Project costing Not Exporting Time sheets For Entire Week

(Doc ID 2419510.1)

Last updated on JULY 05, 2018

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running the Export to Project costing process :"SPA_PROJ_EXP" is not pulling the full week when exporting to project costing, it is only picking the first day (8 Hours) and ignores the rest of the week.

The issue can be reproduced at will with the following steps:
1-Create anew Workorder and release it.
2-Create time sheet.
3-Create invoice for that time sheet and approve it.
4-Run the SPA_PROJ_EXP process and query the staging table, notice that the process only picked the first day which is 8 hours only and ignores the rest of hours.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms