My Oracle Support Banner

Fusion Time and Labor: Timesheets Failed To Import Into Oracle Projects (Doc ID 2611446.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Time and Labor Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

Time Sheets failed to import into Oracle Projects

It appears we have approximately 827 time sheets that failed to import into projects on 11-11-2019.
Attached you will find error logs and a spreadsheet that details the missing timecards in projects.
They seem to be "stuck" somewhere but I am unable to find them in any of the exceptions.

ERROR:
======
WfmTimeTransferJob : WfmTimeTransferJob execute method start: Tue Nov 12 18:29:56 UTC 2019
WfmTimeTransferJob : The starting Batch is:2
WfmTimeTransferJob : Total Number of Batches :1
WfmTimeTransferJob : The Job Number is:12345678910
WfmTimeTransferJob : Failure while carrying out transferTime operation: Exception oracle.jbo.AlreadyLockedException: JBO-26092: Failed to lock the record in table PJC_EXP_ITEMS_ALL with key oracle.jbo.Key[3094667 ], another user holds the lock.Batch 2 of Job Number 12345678910 has failed while being transferred.
WfmTimeTransferJob : Batch 2 of Job Number 12345678910 has failed while being transferred.

Second error: Related to ExpenditureTypeId is blank

WfmTimeTransferJob : WfmTimeTransferJob execute method start: Mon Nov 11 22:45:25 UTC 2019
WfmTimeTransferJob : The starting Batch is:1
WfmTimeTransferJob : Total Number of Batches :75
WfmTimeTransferJob : The Job Number is:12345678911
WfmTimeTransferJob : Failure while carrying out transferTime operation: Exception oracle.jbo.AttrValException: JBO-27014: Attribute ExpenditureTypeId in UnprocessedTimeTransferEO is required.Batch 4 of Job Number 12345678911 has failed while being transferred.
WfmTimeTransferJob : Batch 4 of Job Number 12345678911 has failed while being transferred.

STEPS TO REPLICATE:
==================
The issue can be reproduced at will with the following steps:
1. Run Import Project Costing Process
2. Failed with error

BUSINESS IMPACT:
================
The issue has the following business impact:
Due to this issue, time sheet failed to import into Oracle Projects

Cause

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
Symptoms
Cause
Solution


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