We see several records in prlock where PRNAME= prImportExport and PRTABLENAME = SRM_PROJECTS but the records are not available to delete from the UI under security.locks.
This can happen when the investment is deleted from Delete Investments job, but the project was still locked from OWB or MSP.
STEPS TO REPRODUCE
1. Create Project
2. Inactivate it
3. Mark for Deletion
4. Open in OWB
- note it is in PRLOCK table as well as security.locks
5. Leave OWB open so it remains in PRLOCK
6. Run Delete Investments
Expected Results: entry is removed from PRLOCK table as well as security.locks
Actual Results: entry remains in PRLOCK but is not visible in security.locks
Verify that the investment is no longer in the database using following query:
Note: For this example my PRRECORDID = 5008011 in the prlock table.
select * from inv_investments where id = 5008011
If no records are returned, you can delete the record from the prlock table using this query (change the prrecordid to match yours)
delete from PRLOCK where PRTABLENAME = 'SRM_PROJECTS' and PRRECORDID = 5008011
commit; (oracle users)
For SaaS customers please open a support case so the records can be deleted.
This has been reported as Defect DE44167 and has been fixed in 15.5 01.