SQL deleting non-financial assets in AM
Hi, we are on PS 9.2 Image 35. We recently discovered that the PO/AP to AM process had unexpectedly created tens of thousands of non-financial assets from PO lines that incorrectly had an Asset Profile ID and thus triggered RECV_02. We are hoping to delete them so that they don't appear in queries and reports.
I've written SQL deletes to accomplish this but want to make sure I'm hitting all the needed tables so that we don't end up with orphaned rows. I have included the following tables that have records to delete:
PS_ASSET_ACQ_DET
PS_ASSET_LOCATION
PS_ASSET_CUSTODIAN