topic Re: Deleting publications to deactivated GLNs in _Ask A Question for Item Management (IM)

Deleting publications to deactivated GLNs

collin_kindred — Tue, 27 Sep 2022 21:25:37 GMT

When deleting a publication to a deactivated subscriber GLN, I receive the following error:

Publication DELETE for ... resulted in a validation error

~~201-Invalid subscriber GLN (...)~222-Publication does not exist to perform the DELETE operation

The issue is that because I'm not able to delete these publications, filtering items by "Published Items = Yes" results in false positives. Evidently, the publications to the deactivated GLN count as valid publications!

Is there a way I can remove the publication without running a DELETE operation?

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Tue, 27 Sep 2022 12:08:56 GMT

Hello @collin_kindred and thank you for reaching out via the customer community. Welcome. Can you provide me an example GTIN and the invalid recipient GLN in question so I can take a close look for you?

Re: Deleting publications to deactivated GLNs

collin_kindred — Tue, 27 Sep 2022 17:33:21 GMT

Hi @CommunityJedi22,

An example GTIN would be 10077661142971 with GLN 0819316010005!

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Tue, 27 Sep 2022 19:21:54 GMT

Hello, you are correct, That recipient appears to no longer have a GLN registered with any data pool in the GDSN. As a result, it does not exist and any pubs to it technically do not exist. Are you trying to delete that pub because it is causing errors in reporting or something along those lines for you?

Re: Deleting publications to deactivated GLNs

Food_Fiend — Tue, 27 Sep 2022 20:29:32 GMT

Hello,

I am having basically the same issue. SuperValu consolidated to a single GLN now under UNFI. The old GLNs for individual SuperValu locations were removed but the phantom publications to them remain. This causes various issues.

When I run the publication report by GTIN, the phantoms show up in the list. But I can't run the report by the old GLN.
When an item is updated, it tries to sync with the old GLNs and results in various errors.
We use the SAP MDM GDS product to link to 1WorldSync via AS2. We have dozens of publications in GDS that we can't unpublish because it errors out with rejects or publication doesn't exist as examples. It is extremely painful to remove these publications by hand from GDS.

Before withdrawing GLNs, providers should be notified so they can withdraw publications. We now get false positives in 1WorldSync reporting as @collin_kindred points out and have a mess to clean up in our GDS system that will take several hours of manual work.

Attached is a screen print from our publication report showing several of these phantom publications.

Re: Deleting publications to deactivated GLNs

collin_kindred — Tue, 27 Sep 2022 22:39:03 GMT

I'm trying to delete these publications because the items are discontinued and I don't want them to be present when filtering by "Published Items = Yes" in Item Management. This is important as I export the published items to a FUSE sheet that then interfaces with our internal pipeline for updating product data.

Edit: Added screenshots

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Wed, 28 Sep 2022 15:49:20 GMT

Thank you for your explanation. I assumed that would be your response but wanted to be sure. I will need to create a ticket with our Service Desk and escalate it to our engineering team to have these removed for you in the backend. I will provide your ticket number here as soon as I have it created and escalated.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Wed, 28 Sep 2022 15:54:36 GMT

Here you go... SDU-431288

Re: Deleting publications to deactivated GLNs

Food_Fiend — Wed, 28 Sep 2022 18:32:45 GMT

Is this solution only for the OP? As mentioned in this thread earlier, I have the same issue.

Is there a way I can initiate an unpublish from my system that would remove the phantom publication and send back a successful unpublish response? If only the 1WS phantom publications for missing GLNs are deleted, that still leaves me with numerous invalid publications in my system.

Thank you for your time.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Mon, 03 Oct 2022 13:36:47 GMT

Hello @Food_Fiend . What recipient GLN are you having this issue with that is no longer registered to a dp in GDSN?

Re: Deleting publications to deactivated GLNs

Food_Fiend — Mon, 03 Oct 2022 14:44:52 GMT

My best estimate is my PIM system has approximately 266 items published in various combinations to the following 25 obsolete GLNs. I cannot submit an unpublish for them because I receive back errors that they are rejected or don't exist. It would be preferred if there is a phantom publication stored in 1WorldSync that the phantom gets removed and a successful unpublish message is returned to our PIM. This would keep 1WS clean and our PIM clean. There needs to be a reasonable process to recover when a customer suddenly withdraws a GLN. Thank you for your attention to this concern.

0041130039966	SUPERVALU - BWS [Stockton, CA]
0041130039072	SUPERVALU - Commerce, CA
0041130039409	SUPERVALU - Portland, OR
0041130039829	SUPERVALU - Santa Fe Springs, CA
0041130039249	SUPERVALU - Stockton, CA
0041130029912	SUPERVALU Carlisle, PA
0041130079856	SUPERVALU Joliet, IL
0041130051623	SUPERVALU-Anniston AL
0041130079238	SUPERVALU-Billings MT
0041130079122	SUPERVALU-Bismarck ND
0041130039461	SUPERVALU-Centralia WA
0041130051616	SUPERVALU-Champaign/Urbana IL
0041130079146	SUPERVALU-Fargo ND
0041130079115	SUPERVALU-Ft. Wayne IN
0041130051180	SUPERVALU-Green Bay WI
0041130051715	SUPERVALU-Indianola MS
0041130029455	SUPERVALU-Lancaster/Denver PA [Independents]
0041130029448	SUPERVALU-Mechanicsville VA
0041130051487	SUPERVALU-MRDC [Ogelsby IL - Midwest Region Dist Ctr]
0041130029219	SUPERVALU-Pittsburgh/New Stanton PA
0041130029813	SUPERVALU-Pompano Beach, FL
0041130051807	SUPERVALU-Quincy FL
0041130051678	SUPERVALU-SERF [Anniston AL - Southeast Regional Facility]
0041130079436	SUPERVALU-Stevens Point WI
0041130079757	SUPERVALU-Tacoma WA

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Tue, 04 Oct 2022 12:27:39 GMT

Hello @Food_Fiend and thank you for those details. I am escalating this and discussing it with our technology team and will get back to you with a Service Desk ticket once I get it created and escalated for you.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Tue, 04 Oct 2022 15:18:01 GMT

I am still looking into this to see if I can find a solution and have not yet. I recognize your note about a reasonable process for departing GLNs and would like to respond that GLNs being removed rather than moved from one data pool to another is rare. In this case, UNFI moved from over 30 GLNs to just one for publications. That project, over time, included updates asking customers to publish to the new GLNs instead of the older ones as they would be going away. The best practice is to delete the publications to these retiring GLNs before they are turned off.

I will talk to UNFI and our engineering teams about an idea I have but at least these types of GLNs moves to not occur often. Whew...

Re: Deleting publications to deactivated GLNs

Food_Fiend — Tue, 04 Oct 2022 15:41:25 GMT

I completely understand what was supposed to happen. Unfortunately, I don't manage the publications but am just the tech guy who gets to clean up later. It is quite possible the department(s) responsible received notifications prior to removal but I will never know. I appreciate that you are looking for a solution.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Tue, 04 Oct 2022 16:04:41 GMT

👍 I totally understand. I am working on it and appreciate your patience.

Re: Deleting publications to deactivated GLNs

collin_kindred — Mon, 10 Oct 2022 16:41:57 GMT

Would you be able to check in on the ticket? The publications are still "up". I'm also not able to access or view the ticket in Jira, and my response to the initial email I received has been unanswered for about 4 business days now.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Mon, 10 Oct 2022 16:45:45 GMT

Hello, I am working with UNFI and our technology teams. After talking to them this week, we are evaluating if/how we can do this for customers that did not delete pubs to these GLNs before they were deactivated. This will likely be a project that will take quite some time and require support from our Dev teams and coordination with UNFI. I asked if we could complete it by the end of 2022 and we are seeing what we can do here to help you out.

Re: Deleting publications to deactivated GLNs

collin_kindred — Mon, 10 Oct 2022 16:47:50 GMT

Awesome, I will stay tuned. I really appreciate your coordination on this issue.

Re: Deleting publications to deactivated GLNs

CommunityJedi22 — Mon, 10 Oct 2022 16:49:09 GMT

Of course, and like I said before, thanks for your patience...

Re: Deleting publications to deactivated GLNs

lflanary — Tue, 29 Nov 2022 21:21:12 GMT

May I piggyback on this thread to say that I too have Obsolete GLN's that do not show publications to anymore but when I update a GTIN it creates an error log on my end showing the item as rejected.