Hi Prajwal
I downloaded Appx files(x64 & x86) for this software "Microsoft_VP9_Video_Extensions" from Microsoft store website and bundled them together using Makeappx.exe tool.
Then I created application in SCCM for .Appxbundle file and advertised to device collection.
When I try to install it from software center, I get this error message 0x80070002(-2147024894)
But that software files are installed in C:\program Files\WindowsApps folder
Please suggest for this this issue.

This is the detection method:

Log Files:
This is the message I got from AppDiscovery.log file
Entering ExecQueryAsync for query "select * from CCM_AppDeliveryType where (AppDeliveryTypeId = "ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63" AND Revision = 2)" AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
Performing detection of app deployment type PSA 1412(ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, revision 2) for system. AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
++++ Not Discovered (Microsoft.VP9VideoExtensions_1.0.52781.0_neutral_~_8wekyb3d8bbwe) ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63 2 AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
+++ Did not detect app deployment type PSA 1412(ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, revision 2) for system. AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
ActionType - Install will use Content Id: Content_ea3395e9-837c-4063-a951-c76206b2e41a + Content Version: 1 for AppDT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision - 2 AppDiscovery 12/6/2022 8:48:23 AM 10500 (0x2904)
ActionType - Install will use Content Id: Content_ea3395e9-837c-4063-a951-c76206b2e41a + Content Version: 1 for AppDT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision - 2 AppDiscovery 12/6/2022 8:48:24 AM 10500 (0x2904)
And this is the message I got from AppEnforce.log file
+++ Starting Install enforcement for App DT "PSA 1412" ApplicationDeliveryType - ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, Revision - 2, ContentPath - C:\Windows\ccmcache\1t, Execution Context - System AppEnforce 12/6/2022 8:48:30 AM 10500 (0x2904)
Install package uri: C:\\Windows\\ccmcache\\1t\\Microsoft_VP9_Video_Extensions_1.0.52781.0.appxbundle AppEnforce 12/6/2022 8:48:30 AM 10500 (0x2904)
Installation failure, error code = 0x80070002 AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
+++ Enforce completed for ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, 2 using Package: Microsoft.VP9VideoExtensions_1.0.52781.0_neutral_~_8wekyb3d8bbwe. Returning: 80070002 AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
+++ AppX Install Info added. [AppDT Id: ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63] AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
++++++ App enforcement completed (1 seconds) for App DT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision: 2, User SID: ] ++++++ AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
I downloaded Appx files(x64 & x86) for this software "Microsoft_VP9_Video_Extensions" from Microsoft store website and bundled them together using Makeappx.exe tool.
Then I created application in SCCM for .Appxbundle file and advertised to device collection.
When I try to install it from software center, I get this error message 0x80070002(-2147024894)
But that software files are installed in C:\program Files\WindowsApps folder
Please suggest for this this issue.

This is the detection method:

Log Files:
This is the message I got from AppDiscovery.log file
Entering ExecQueryAsync for query "select * from CCM_AppDeliveryType where (AppDeliveryTypeId = "ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63" AND Revision = 2)" AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
Performing detection of app deployment type PSA 1412(ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, revision 2) for system. AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
++++ Not Discovered (Microsoft.VP9VideoExtensions_1.0.52781.0_neutral_~_8wekyb3d8bbwe) ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63 2 AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
+++ Did not detect app deployment type PSA 1412(ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, revision 2) for system. AppDiscovery 12/6/2022 8:48:22 AM 10500 (0x2904)
ActionType - Install will use Content Id: Content_ea3395e9-837c-4063-a951-c76206b2e41a + Content Version: 1 for AppDT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision - 2 AppDiscovery 12/6/2022 8:48:23 AM 10500 (0x2904)
ActionType - Install will use Content Id: Content_ea3395e9-837c-4063-a951-c76206b2e41a + Content Version: 1 for AppDT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision - 2 AppDiscovery 12/6/2022 8:48:24 AM 10500 (0x2904)
And this is the message I got from AppEnforce.log file
+++ Starting Install enforcement for App DT "PSA 1412" ApplicationDeliveryType - ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, Revision - 2, ContentPath - C:\Windows\ccmcache\1t, Execution Context - System AppEnforce 12/6/2022 8:48:30 AM 10500 (0x2904)
Install package uri: C:\\Windows\\ccmcache\\1t\\Microsoft_VP9_Video_Extensions_1.0.52781.0.appxbundle AppEnforce 12/6/2022 8:48:30 AM 10500 (0x2904)
Installation failure, error code = 0x80070002 AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
+++ Enforce completed for ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63, 2 using Package: Microsoft.VP9VideoExtensions_1.0.52781.0_neutral_~_8wekyb3d8bbwe. Returning: 80070002 AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
+++ AppX Install Info added. [AppDT Id: ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63] AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)
++++++ App enforcement completed (1 seconds) for App DT "PSA 1412" [ScopeId_B95260E5-1634-410F-8D99-4CFE012E1ED8/DeploymentType_9b1e3471-400e-4085-be46-a121f7398c63], Revision: 2, User SID: ] ++++++ AppEnforce 12/6/2022 8:48:31 AM 10500 (0x2904)