Invoice, shipping, credit memo records missing, when archive orders are restored to order management

[github-jira-sync-bot]

ISSUE:
If an order is moved to the archive and then restored, if the ID numbers don't match, then invoice, shipping, credit memo records are missing from that order.

STEPS TO REPLICATE:

1. Create and complete an order, including Shipping, Invoice and Credit Memo.
2. Ensure the Shipping, Invoice and Credit memo IDs are not the same as the order number.
3. Move the order to Archive
4. Restore the archived order to Order Management.
5. Check Invoice, Shipping and Credit Memo details under respective "Invoice", "Shipping"
   , "Credit Memo" - 'We couldn't find any records.'

ACTUAL RESULTS:
'We couldn't find any records.' for Shipping, Invoice and Credit Memo for restored orders if all the IDs are different.
If the order and related records have the same ID, then the records are returned.

EXPECTED RESULTS:
The original related records should be restored when the order is moved from archive list to order management.

[github-jira-sync-bot]

The issue was exported from the internal Jira. The link to the original Jira issue: https://jira.corp.adobe.com/browse/ACP2E-1597

[m2-assistant]

Hi @github-jira-sync-bot. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:

• @magento give me 2.4-develop instance - upcoming 2.4.x release
• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this
• To learn more about issue processing workflow, refer to the Code Contributions.

---

Join Magento Community Engineering Slack and ask your questions in #github channel.
⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[veloraven]

Internal team is working o9n this issue

[veloraven]

@magento I am working on this