With the hotfix provided we are able to generate committed cost from Expense management.
when we remove the line from Expense report the line is still available in “AvailUnattachedExpenses”. Therefore we can still see the removed expense line in the Expense report table, as it is not deleted.
The removed line has “ExpNumber” field has blank. And the SourceDocumentLine value is set to 0.
When we fetch the line from Unattached Expenses the “ExpNumber” field and SourceDocumentLine field are set.
With respect to our current scenario, after removing the line we are Generating the committed cost where the logic written to fetch the record from the TrvExpTrans as shown below
private void createExpenseManagement()
while select trvExpTrans
sourceDocumentLineItem = SourceDocumentLineItem::newFromSourceDocumentLineImplementation(trvExpTrans);
created = true;
From the above code the select Query fetches all the records which is having the ProjId, As the removed record still exist in the TRvExpTrans table but has sourcedocumentLine value set to zero the system is not able to generate sourceDocumentLineItem . Due to which it is throwing the error.