Asset Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQL deleting non-financial assets in AM

edited Aug 5, 2021 8:17PM in Asset Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center