Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Financial Management - PSFT (MOSC)

Payment Predictor Performance issues

Feb 14, 2013 6:38AM edited Feb 14, 2013 4:15PM in Financial Management - PSFT (MOSC) 3 commentsAnswered

We need some help from a Payment Predictor Performance guru

We are PS 9.1 installed thru bundle 22 - We are a high volume payment shop

Curently we average 9,000 - 11,000 payments on Mondays

and 2,000 - 4,000 on Tues - Friday By the time our implementation is completed those numbers will go up 4X

I am running predictor with 2 algorithms - #Balance - then #Ref

Tues - Friday Predictor runs in 1.5 - 2.0 Hours. Not great but acceptable

On Mondays however Predictor is running 12 - 15 hours and we don't understand why. Any suggestions would be appreciated.

AR_PREDICT1 is putting 3.2 Million rows in the PS_PP_ITEM_TAO and PS_PP_ITEM2_TAO tables and we only have 1 million Open items.

0

Howdy, Stranger!

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

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

Category Leaderboard

Top contributors this month