Financial Management - PSFT (MOSC)

MOSC Banner

How do I delete/remove a deposit that has been fully duplicated?

edited Oct 6, 2020 5:05PM in Financial Management - PSFT (MOSC) 2 commentsAnswered

I don't know the root cause of our problem, but Accounting has somehow fully duplicated a deposit and they are unable to delete the duplicate through the front end.

I have two rows and two DEPOSIT_IDs in the PS_DEPOSIT_CONTROL table. The GL_DISTRIB_STATUS is 'G' and DEPOSIT_STATUS = 'C'.

For each DEPOSIT_ID, I have a duplication of 21 rows in both the PS_PAYMENT table and PS_PAYMENT_ID_ITEM.

How do I either adjust flags on the duplicate deposit to make it "available" again so that Accounting can delete it through the PeopleSoft front end, OR delete it via SQL (this makes me nervous as I'm guessing that there are more than just the three tables that I have identified involved).

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