Financial Management - PSFT (MOSC)

MOSC Banner

Sometimes entry not deleted from PS_PAYMENT_ITEM table after AR Update process

edited Jul 17, 2020 5:05AM in Financial Management - PSFT (MOSC) 5 commentsAnswered

Dear Experts,

We are in PS Financials 9.2 Image 25.

Occasionally, we encounter an issue in production when entries in PS_PAYMENT_ITEM are not deleted after AR Update process completed successfully.

We see that all transactions are successfully posted to the PS_ITEM, PS_ITEM_ACTIVITY & PS_ITEM_DST tables but row was not deleted from PS_PAYMENT_ITEM table.

Mostly, this issue happens for On Account item.

As a workaround, we have to run SQL statement to manually delete rows from PS_PAYMENT_ITEM table.

1. Can one of you let me know if you have encountered similar issue before?

2. Also let me know the places where rows are deleted from PS_PAYMENT_ITEM table when AR Update is run. In our trace, we could see below code getting executed.

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