Patrickjk
Active Member
JDE 9.2 32 bit
Oracle Database = 19.c
Regarding the next number table F0002 for the System Code 00 (Foundation)...I run the following query to see how many batch numbers have been used up for each of the batch types for index 01 (NNN001).
select icicut, count(*) from proddta.f0011 group by icicut
Does anyone have/know the query to determine how many System Code 00 (Foundation) index 04 (Job Number) have been used up, which would be table F986110 - Job Control Status Master?
NOTE: It's getting close where F0002.NNN001 and F0002.NNN004 need to be reset back to 0. Both are getting close to the max value of 99,999,999. I'm especially interested in how many F986110 records are still available.
Any input would be greatly appreciated.
Thank you.
Regards,
Patrick
Oracle Database = 19.c
Regarding the next number table F0002 for the System Code 00 (Foundation)...I run the following query to see how many batch numbers have been used up for each of the batch types for index 01 (NNN001).
select icicut, count(*) from proddta.f0011 group by icicut
Does anyone have/know the query to determine how many System Code 00 (Foundation) index 04 (Job Number) have been used up, which would be table F986110 - Job Control Status Master?
NOTE: It's getting close where F0002.NNN001 and F0002.NNN004 need to be reset back to 0. Both are getting close to the max value of 99,999,999. I'm especially interested in how many F986110 records are still available.
Any input would be greatly appreciated.
Thank you.
Regards,
Patrick