Regarding synchronizing the below 2 sequences : CSD_JOB_NAME_S and WIP_JOB_NUMBER_S
Hi Team,
Wanted to understand the purpose of these 2 different sequences (CSD_JOB_NAME_S and WIP_JOB_NUMBER_S).
At the moment in the test environment :
select CSD_JOB_NAME_S.nextval from dual --595846
Select WIP_JOB_NUMBER_S.nextval from dual; --18336295
one is 6 digit and other is 8 Digits.
if I alter the 6 digit sequence to 8 digit would it cause any negative impact on system? kindly advice. and would that sync in number of digits be maintained ( which I believe may not be the case)
reason to ask this query is , as per below screenshot we see the disparity in digits , which might not be suggested within the depot module.