PranikaC
Member
Hi Experts
Can someone help me .
1)We have data coming into JDE tables F47011 and F47012 from Boomi directly connecting to ODBC/database and entering data into JDE tables F47011 and F4701.
2)Boomi is scheduled to enter the data (Sales order ) in F47011 and F47012 every 5 min
3)R47011 picks data from both tables(F47011 and F47012) and enters into Sales order tables F4211 and F4201 (F4211 editline BSFN's)
4)R47011 is scheduled to run after every 15 min
5) There are 2 versions of R47011 with different data selection where DCTO= SF and in other version where DCTO=SW and both versions of the report runs in single threaded queue
6) Now the problem is whenever the data volume is high the data selection of the report picks the record more than actual.
e.g.:-
a. data selection is where EDSP=Y and DCTO=SF and KCOO=00005 or 00037 etc
b.let say report runs at
1)Lets say at 12:00,R47011 runs and there were 50 records already in the table F47011 with date 8th may and time <=12:00 (or 11:55 am)
2)At 12:00,Boomi also runs at the same time and it inserted 20 records with time 12:00 and date 8th may 2022
3)Now when report R47011 was running at 12:00 ,it picked 50 records that were already there in table F47011(time- 11:55 am ) and also 20+records of Boomi(time-12:00) as both ran at the same time and time stamp them as 12:00 in F47011 (records with time stamp 11:55 and 12:00)
4) But the problem is that R47011 has also picked records that came after 12:00 e.g. records that came at 12:05,12:10,12:30,12:40 etc.
Can someone tell why this is happening? Is this because Boomi is directly updating tables and thats why when data selection picks records ,its picking more than actual data selection? What can be the solution for this? Can we make another check in the data selection for Date and time (where Time <= 12:00 so that it picks the records equals to or less than time when report runs)
Data selection as-where EDSP=Y and DCTO=SF and KCOO=00005 or 00037 and date =current date and Time<=current time?
Kindly suggest
Can someone help me .
1)We have data coming into JDE tables F47011 and F47012 from Boomi directly connecting to ODBC/database and entering data into JDE tables F47011 and F4701.
2)Boomi is scheduled to enter the data (Sales order ) in F47011 and F47012 every 5 min
3)R47011 picks data from both tables(F47011 and F47012) and enters into Sales order tables F4211 and F4201 (F4211 editline BSFN's)
4)R47011 is scheduled to run after every 15 min
5) There are 2 versions of R47011 with different data selection where DCTO= SF and in other version where DCTO=SW and both versions of the report runs in single threaded queue
6) Now the problem is whenever the data volume is high the data selection of the report picks the record more than actual.
e.g.:-
a. data selection is where EDSP=Y and DCTO=SF and KCOO=00005 or 00037 etc
b.let say report runs at
1)Lets say at 12:00,R47011 runs and there were 50 records already in the table F47011 with date 8th may and time <=12:00 (or 11:55 am)
2)At 12:00,Boomi also runs at the same time and it inserted 20 records with time 12:00 and date 8th may 2022
3)Now when report R47011 was running at 12:00 ,it picked 50 records that were already there in table F47011(time- 11:55 am ) and also 20+records of Boomi(time-12:00) as both ran at the same time and time stamp them as 12:00 in F47011 (records with time stamp 11:55 and 12:00)
4) But the problem is that R47011 has also picked records that came after 12:00 e.g. records that came at 12:05,12:10,12:30,12:40 etc.
Can someone tell why this is happening? Is this because Boomi is directly updating tables and thats why when data selection picks records ,its picking more than actual data selection? What can be the solution for this? Can we make another check in the data selection for Date and time (where Time <= 12:00 so that it picks the records equals to or less than time when report runs)
Data selection as-where EDSP=Y and DCTO=SF and KCOO=00005 or 00037 and date =current date and Time<=current time?
Kindly suggest