We would like to clean up lot of error WorkIDs that are showing up in the ‘PCS-Product Composer System’,s ‘Import Portfolio’ screen. PLease let me know the process as these are filled in the whole screen report.
Thanks in advance for help
Here’s a clean, safe way to clear them. First, identify the exact work class used by Import Portfolio and run a quick report on that class filtering pyStatusWork = Failed/Error to list the Work IDs. Decide which ones need a proper retry (fix the source file and reprocess) and which are just clutter. For clutter, bulk close them as Withdrawn/Resolved-Obsolete using Dev Studio → Configure → Case Management → Bulk Actions (or a small utility that calls pxForceCaseClose). If you truly need them gone, use the Purge/Archive Wizard on that class with a filter on status and age (e.g., Failed older than 30 days), and schedule it. For very large volumes, run a one-time activity/job scheduler that browses in pages and resolves then deletes in small batches with commits. Update the Import Portfolio list/report to exclude resolved statuses so closed items disappear immediately. Always test in lower env, take a DB backup, and confirm there are no open assignments or references before purging. Optional: add a nightly job to auto-resolve failed imports older than N days so the screen stays clean.
@Sairohith Thank you very much @Sairohith for your notes and options. Let me pass these to my DEV team and update you on how we accomplished. Thanks again.
Hello @Sairohith
I had a meeting with our DEV team and Business and both are agreed upon having a batch activity in Dev studio for all the Delete Entities for WO and even PFI and PI case IDs. So we would like to go in that approach and thanks again for your time, info and suggestion.