The batch program CIPMMDSB (Meter Read Download Populate staging table), runs f
(Doc ID 618292.1)
Last updated on APRIL 14, 2025
Applies to:
PeopleSoft Enterprise Peoplesoft CIS - Version 7.6 and laterInformation in this document applies to any platform.
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 200739217
Symptoms
========
The batch program CIPMMDSB (Meter Read Download Populate staging table), runs for 2.5 hours.
DESCRIPTION:
============
The batch program CIPMMDSB (Meter Read Download Populate staging table), has three SQLs that it runs in the program.
The first SQL does a count of the number of pending Meter Read download records.
The second SQL has the same criteria (the WHERE Clause is exactly the same), and it does an Update).
The third SQL completes the record from Pending to Completed.
The first and second SQL statements take an average of two and half hours to complete. Even when the SQL statements are run in SQL Plus, it takes two and half hours to complete.
It is worthy of note that the problem persisted even after dropping and recreating the indices.
Cause
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
| Symptoms |
| Cause |
| Solution |