...
1) allocate a new user_id as seen above, then go to the WSDRS subsystem and assign this new user to a company - or
2) go directly to WSDRS--> User Maintenance and perform the entire task from there
...
Recurrent Error
For reasons unknown, External registrants often receive the “This number is already in use” error.
Examining M79 usually shows that the document number is NOT already in use under the submitter type specified by the requestor (1-AME,2-AMO,3-AOC) , but the number DOES exist on M79, under other submitter types.
Documented in : PBI 115109 , PBI 115110
At the moment (2021-10-26) , this condition has been tested in all regions, and cannot be reproduced.
The system allows registry of the same document number, provided submitter types are different
In the case of AME numbers, they need to be “active”
The query below retrieves existing AMO/AOC/AME document numbers, where the entities co-incidentally having matching document numbers, and these numbers do not yet exist as SDR users (M79 table)
/* IDENTIFY COMMON NUMBERS FOR AMO,AOC,AME /
/ AMO/AOC MATCH /
SELECT 'AMO' TYP, TO_CHAR(X.APPROVAL_NO) NUM, X.LEGAL_NAME FROM AMO_INFO X
WHERE X.APPROVAL_NO IN (SELECT CERTIFICATE_NO FROM AOC_INFO)
and TO_CHAR(X.APPROVAL_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AOC/AMO MATCH /
SELECT 'AOC', TO_CHAR(X.CERTIFICATE_NO), X.LEGAL_NAME FROM AOC_INFO X
WHERE X.CERTIFICATE_NO IN (SELECT APPROVAL_NO FROM AMO_INFO)
AND TO_CHAR(X.CERTIFICATE_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AMO/AME MATCH /
SELECT 'AMO' TYP, TO_CHAR(X.APPROVAL_NO) NUM, X.LEGAL_NAME FROM AMO_INFO X
WHERE TO_CHAR(X.APPROVAL_NO) IN (SELECT NACIS_ID FROM AME_INFO)
and TO_CHAR(X.APPROVAL_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AME/AMO MATCH /
SELECT 'AME', TO_CHAR(X.NACIS_ID), X.LASTNAME ||','||
X.FIRSTNAME || '-' || X.INACTIVE FROM AME_INFO X
WHERE X.NACIS_ID IN (SELECT TO_CHAR(APPROVAL_NO) FROM AMO_INFO)
AND TO_CHAR(X.NACIS_ID) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AOC/AME MATCH /
SELECT 'AOC' TYP, TO_CHAR(X.CERTIFICATE_NO) NUM, X.LEGAL_NAME FROM AOC_INFO X
WHERE TO_CHAR(X.CERTIFICATE_NO) IN (SELECT NACIS_ID FROM AME_INFO)
and TO_CHAR(X.CERTIFICATE_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AME/AOC MATCH */
SELECT 'AME', TO_CHAR(X.NACIS_ID), X.LASTNAME ||','||
X.FIRSTNAME || '-' || X.INACTIVE FROM AME_INFO X
WHERE X.NACIS_ID IN (SELECT TO_CHAR(CERTIFICATE_NO) FROM AOC_INFO)
AND TO_CHAR(X.NACIS_ID) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER) ;