Hi,
We are using a custom application to fill timesheet. When I try to retrieve data for current month I first run Prepare_Week__ procedure (I don’t have any clue of what this function is doing has there is NOT documentation on it) and then I retrieve work
string PREPAREWEEK_QUERY = "&AO.Timman_Job_Trans_API.Prepare_Week__(:COMPANY_ID, :EMP_ID, :WEEK_START, :WEEK_END, 0, :SESSION_ID);";
FndPLSQLCommand cmdPrepW = new FndPLSQLCommand(_connection, PREPAREWEEK_QUERY);
// /...]
prepareWeekCollection.Add(cmdPrepW);
FndPLSQLSelectCommand cmdSelect= new FndPLSQLSelectCommand(_connection, GET_WORK_QUERY);
// /...]
workCollection.Add(cmdSelect);
The connection is still the same, those lines are in loop for each week in a month.
I created two FndPLSQLCommandCollection
variable, one for prepareWeek and the other for the select command. Once the collections are full I Invoke prepareWeekCollection
and the other one. I get an error on the work collection :
Ifs.Fnd.FndTransactionIdMismatchException : 'The server transaction has expired. Please redo your changes.'
I weird because I retrieve after that all expenses there is no error (with the same connection object)
Do you have any idea?
Thx