Financial Management - PSFT (MOSC)

MOSC Banner

Question on mass deletion on AP vouchers in Recycled Status

in Financial Management - PSFT (MOSC) 1 commentAnswered

Hello,

We are on PeopleSoft 9.2 and we have quite a number of xml invoices that are stuck in Recycle status. Manually deletion will take time so we are planning to execute SQL to mass delete them. We will need to delete invoices from the voucher tables-

ps_voucher

ps_voucher_line

ps_distrib_line


Is there any other table that we need to look at?

Thanks,

Debolina

Tagged:

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

PSFT Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center