A command-line alternative to PeopleSoft SendMaster

If you are familiar with PeopleSoft Integration Broker, I'm sure you have dealt with SendMaster to some degree. This is a very simple but yet useful tool to perform unit tests of the Integration Broker incoming service operations using plain XML (if I'm dealing with SOAP Web Services, I normally use SoapUI, for which there is a very good article on PeopleSoft Wiki).

Most of the time it's enough with SendMaster, but today I (more...)

R12.2 Documentation link in html format

This link has the R12.2 documentation in HTML format:

https://docs.oracle.com/cd/E26401_01/index.htm 

Manually applying Global Payroll Rules Packages downloaded from an Update Image

Last week we've faced an issue while applying a Tax Update in one of our PeopleSoft HCM 9.2 customers. The Tax Update was delivered as a PeopleSoft Release Patchset, that needs to be first applied to the Update Image before creating the Change Package using PeopleSoft Update Manager.

Unfortunately, during the process, one rules package delivered in the Tax Update was not included within the Change Assistant steps, and therefore it was missed. Some (more...)

HP Mini T210 3F0 boot failure and System Rollback Data disk space issues with Roxio BackOnTrack / aswrvt.sys

If you have an HP Mini 210 or 100 and have had issues with disk running out of space, failures to boot, I feel for you. After a heap of hassle, I sorted my out problems without having to reinstall Windows, and so I'm sharing my experiences as I found many many people with the same issue, but no central resolution. The issues I've had are as follows

  • Failure to boot: 3F0 Harddisk does not (more...)

Which PeopleTools version goes with which Application?

If you’re ever in the situation where you’re wondering what your options are with PeopleTools versions, and which applications they can be used with, then we have just the document for you.

It shows you:

– the Applications, their release dates, and – more critically – the dates that Premier and Extended Support ends

– the PeopleTools versions, and the date that support ends (yes, 8.52 is now out of support)

– the combinations (more...)

Searching with USEEDIT

Because many of the record properties are hidden in the Bit Map field USEEDIT, it is hard to search for properties.  If you are on Oracle, here’s some SQL that might help…

This SQL lists all of the fields with their properties broken out of that field:

SELECT FIELDNAME,
       USEEDIT,
       Bitand(USEEDIT, 1)         KEY,
       Bitand(USEEDIT, 2)         DUP_KEY,
       Bitand(USEEDIT, 4)         SYS_MAINT,
       Bitand(USEEDIT, 8)         AUDIT_ADD,
       Bitand(USEEDIT, 16)        ALT_SEARCH_KEY,
       Bitand(USEEDIT, 32)        LIST_BOX_ITEM,
       Bitand(USEEDIT, 64)        ASCENDING_KEY,
       Bitand(USEEDIT, 128)       AUDIT_CHANGE,
       Bitand(USEEDIT, 256)       REQUIRED,
       Bitand(USEEDIT, 512)       XLAT,
       Bitand(USEEDIT, 1024)      AUDIT_DEL,
       Bitand(USEEDIT, 2048)      SEARCH_KEY,
       Bitand(USEEDIT, 4096)      EDIT_REASONABLE_DATE,
       Bitand(USEEDIT, 8192)      EDIT_YES_NO,
       Bitand(USEEDIT, 16384)     EDIT_PROMPT_TABLE,
       Bitand(USEEDIT, 32768)     AUTO_UPDATE,
       Bitand(USEEDIT, 65536)     BIT65536,
       Bitand(USEEDIT, 131072)    BIT131072,
       Bitand(USEEDIT, 262144)    FROM_SEARCH,
       Bitand(USEEDIT, 524288)    TO_SEARCH,
       Bitand(USEEDIT, 1048576)   EDIT_BINARY,
       Bitand(USEEDIT, 2097152)   DISABLE_ADV_SEARCH,
       Bitand(USEEDIT, 4194304)   REGULAR_FIELD,
       Bitand(USEEDIT, 8388608)   DEFAULT_SEARCH_FIELD,
       Bitand(USEEDIT, 16777216)  BIT16777216,
       Bitand(USEEDIT, 33554432)  SEARCH_EDIT_KEYS,
 (more...)

Search for a Field with Translates

I was looking for an “Internal/External” field.  I wanted a field already built that had two translate values: “E” and “I”.  This SQL did the trick:

SELECT A.FIELDNAME,
A.XLATLONGNAME,
B.XLATLONGNAME,
A.XLATSHORTNAME,
B.XLATSHORTNAME
FROM   PSXLATITEM A,
PSXLATITEM B
WHERE  A.FIELDNAME = B.FIELDNAME
AND A.FIELDVALUE = 'E'
AND B.FIELDVALUE = 'I'
AND Upper(A.XLATLONGNAME) LIKE 'EXT%'
AND NOT EXISTS (SELECT 'X'
FROM   PSXLATITEM C
WHERE  A.FIELDNAME = C.FIELDNAME
AND C.FIELDVALUE NOT IN ( 'E', 'I' )) 

I found the INTERNAL_EXTERNAL field, which works just perfect for me.

Share

HEUG Alliance 15 – What Looks Good To Me

The Higher Education User Group's Alliance 15 software conference kicks off this Sunday, March 15, in Nashville, Tennessee.  You're going, right?

I'm flying early this weekend myself.  Just have a few conference things to do to get ready for my little role in this big Oracle user group conference.


Looks to be a great conference.  I'm personally planning to dive into five areas of focus:  


  1. increasing my depth of understanding about customers and processes (more...)

Nashville Cat

Nashville cats, play clean as country water
Nashville cats, play wild as mountain dew
Nashville cats, been playin' since they's babies
Nashville cats, get work before they're two

            - From the Lovin' Spoonful's Nashville Cats

I'm heading out to HEUG's Alliance this weekend.  Gonna be a Nashville Cat for a few days.  My big job is to host three workshop/demo sessions on Oracle Cloud Applications, all in Room Delta (more...)

The Best Thing

I'm spending the latter part of my week at the Utah Oracle User Group Training Days conference.  It's a nice regional conference for me to engage with...it's local to me here in Salt Lake City.  So I get to participate in the conference and still go home every night.  Pretty sweet.

But being local is not the best thing about this conference.  The best thing about this...or most user group conferences, for that (more...)

PeopleTools 8.54: Performance Performance Monitor Enhancements

This is part of a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

Transaction History Search Component

There are a number of changes:
  • You can specify multiple system identifiers.  For example, you might be monitoring Portal, HR and CRM.  Now you can search across all of them in a single search.
  • It has always been the case that when you (more...)

Thoughts On Student Engagement

For those of us in the Higher Education portion of Oracle’s ecosystem, the big conference of the year - Alliance - is less than one week away.  But I already have a suspicion about the hot topic this year.  I’m betting on the subject of student engagement.

There was a time when student engagement was all about educational institutions reaching out to students and potential students.  But there were only a few ways to get (more...)

Installing Languages on PeopleSoft Update Images

One of great things about PeopleSoft Update Manager images is that they could be used as a Demo environment to try the latest and greatest features of the PeopleSoft application. All you need to do is to download the image and install it and you can already play with the application.

However, the initial install of the Update Image will only have the English language enabled. If you are using PeopleSoft Update Manager, once you (more...)

Collaborate 2015

Collaborate 2015 is just a few weeks away. I will be presenting PeopleSoft PeopleTools Developer: Tips and Techniques on Tuesday, 4/14/2015 at 3:15 PM in Surf B. If you are presenting a PeopleTools technical session, then please post a comment with your session title, date, time, and venue. I look forward to seeing you next month!

Undocumented Application Engine Parameter: EnableAEMonitoring

Oracle Support Document 1640355.1: E-AE: Performance Degradation When Using Do Loop Action to Process Large Amount of Data on PT 8.52 & PT 8.53 describes a performance problem in Application Engine when a small but frequently executed loop.  Application Engine calls DBMS_APPLICATION_INFO to set MODULE and ACTION on v$session each time it goes round the loop.

However, Oracle Bug 10130415  Latch contention on "resmgr group change latch" acknowledges a problem in (more...)

I’m In Love With My Car

I'm in love with my car
Gotta feel for my automobile
Get a grip on my boy racer rollbar
Such a thrill when your radials squeal.
                    -- From Queen's I'm In Love With My Car

As is typical with Queen, citing the lyrics fail to do the song justice.  You can hear the song and watch the official video here.  C'mon back when you're done.


(more...)

I’m William Reynolds and this is How I Work

William joined PeopleSoft in November of 1995 as a developer in the Inventory product. Since then he has worked in various roles within the FSCM pillar eventually landing in the Enterprise Architecture group where he straddles the world between PeopleTools and Applications. He currently works with other Architects in each of the pillars on various projects like security, accessibility and PUM.

William

Name: William Reynolds

Occupation: Senior Application Architect, Enterprise Architecture
Location: Home office, Chicago, IL
(more...)

The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes

I got this error while upgrading an R12.1.3 instance to R12.2.4, when I completed AD.C.Delta 5 patches with November 2014 bundle patches for AD.C and was in the process of applying TXK.C.Delta5 with November 2014 bundle patches for TXK.C :

Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[START 2015/03/01 04:53:16] Check if services are down
        [INFO] Run admin (more...)

Cedar’s Oracle Cloud and PeopleSoft Day

Cedar held it’s annual Oracle Cloud and PeopleSoft Day in London on Friday, with almost a hundred people in attendance (about 80 customers, plus staff from Oracle and Cedar).

It was a great success, with a really positive vibe – customers are looking to do great things with both PeopleSoft and Oracle’s Cloud suite – and a privilege to be part of.

Here are some photos from the day:

Graham welcomes everyone
2015-02-27 10.05.59

 

Marc Weintraub gave (more...)

PeopleTools 8.54: Oracle Resource Manager

This is part of a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

Oracle Resource manager is about prioritising one database session over another, or about restricting the overhead of one session for the good of the other database users.  A resource plan is a set of rules that are applied to some or all database sessions for some or all (more...)