Blog

We use between clause in a SQL statement to see if a value falls within a range. This works fine for numbers, and characters. But, if you have both numbers, and characters in a string then you will see unexpected results. Let us say we have a table with ranges. A1 to A99 is range1. A100 to A199 is range 2, and A200 to A299 is range 3. CREATE TABLE RANGES (FROM_VALUE VARCHAR2(10), TO_VALUE VARCHAR2(10), RANGE NUMBER(1)); INSERT INTO RANGES VALUES ('A1', 'A99', 1); INSERT INTO RANGES VALUES ('A100', 'A199', 2); INSERT INTO RANGES VALUES ('A200', 'A299', 3); Now, when we run the below SQL SELECT...

Read More

In my role as part of the Remote Development and Support team, I encounter a number of issues that users encounter on a daily basis.  The following is an example of a typical day. An accounts payable client using PeopleSoft financials calls to tell me that something is not working, she doesn’t know what the problem is or what she did that could have caused the problem and she wants to know why she does not getting the expected results.  After some research, I determined that the problem resides in a custom voucher load process that populates quick invoice tables.  The file with the invoice...

Read More

While recently working with one of my clients, a large college which has an Oracle RAC 11g on Linux setup, I noticed that certain PeopleSoft batch processes were slow compared to what I have observed at other client sites. I confirmed with the user that the slow performance, in fact, was impacting the end user. I began to research the issue by taking some database snapshots and I reviewed other statistics that confirmed that there were a large number of enqueue waits for TAO tables. While an enqueue is not RAC specific, it can involves a global lock operation when RAC is enabled. Most of the global...

Read More

I recently resolved an issue for one of our clients. The client had upgraded their PeopleSoft system to the latest version and indicated some data was missing and wondered why the upgrade had not created the data. After researching it a bit and with experience with other clients, I discovered the problem was not with the upgrade.  Apparently, after the upgrade, a bundle was applied and a script from a bundle was either not run or was run at an improper time and, as a result, the data was not created. After reviewing the issue, we determined that the script could still be run.  Data then...

Read More