My Oracle Support Banner

EAR 8.9+: Troubleshooting Which Tables are Updated when a AR_DUNNING Reset is Done (PS_AR_RESETSQL_TBL)? (Doc ID 1060992.1)

Last updated on NOVEMBER 28, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 8.9 and later
Information in this document applies to any platform.

Purpose

Process Instance Job failed when running Dunning Letters. This process instance ended up locking several items when we ran a query under the PS_ITEM record. We created a script to change the process instance to 0 to unlock these records. Is there are any other tables that need to be cleared/reset for a no success on AR_DUNNING?

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Troubleshooting Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.