Financial Management - PSFT (MOSC)

MOSC Banner

Conditions Monitor AR_CNDMON is taking a very long time to process the SETID

edited Nov 10, 2011 6:13PM in Financial Management - PSFT (MOSC) 3 commentsAnswered ✓
 Wondering if anyone is using Conditions Monitor, has a large customer base in PeopleSoft (we have over 130,000 customers in our database), and is running Conditions Monitor for the SETID (all customers).  

We are trying to set this up, and it is taking Conditions Monitor 4 days to finish processing the 130,000 customers with our custom assessment rules, that look at the PS_ITEM table for A/R items over $5000 and past due based on the due date.  

AppEngine section AR_CNDMON.CUST_SID.CUSTOMER.sql seems to be one of the first things to execute when running the Conditions Monitor by SETID, and it basically selects/inserts every single customer from the database, and then the program proceeds to process each one row by row.

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