Portal Navigation December 9, 2007
Posted by Tipster in Oracle, PeopleSoft, SQL.add a comment
I would imagine many of you are familiar with the PSPRSMDEFN table as it is tremendously useful. I would gamble most have a SQL snippet tucked away somewhere that will query it to find the PIA navigation to any given component. However Jim Marion has posted some SQL on his blog that is the tidiest I’ve seen to date (it’s Oracle specific BTW).
Most SQL snippets use multiple joins to the table, I’ve seen one before that used connect_by_prior, but this one is the smallest script yet.
Thanks Jim!
Edit:
this slightly more succinct version may be even better.
select distinct rtrim(reverse
(sys_connect_by_path(reverse
(portal_label), ' > ')), ' > ') path
from psprsmdefn
where portal_name = 'EMPLOYEE'
and portal_prntobjname = 'PORTAL_ROOT_OBJECT'
start with portal_uri_seg2 = :1
connect by prior
portal_prntobjname = portal_objname
Oracle Survey Results December 3, 2007
Posted by Tipster in Fusion, Oracle, PeopleSoft.add a comment
I’m off to the UK Oracle User Group tomorrow, but here’s a quick survey conducted on UKOUG attendees in the meantime:
http://www.regdeveloper.co.uk/2007/12/03/oracle_uk_users_survey/
Apparently “Customers’ opinion of Oracle’s licensing has hit a new low in the UK while the company’s Fusion plans remain a mystery to half of its users”.
The good news is that satisfaction with PeopleSoft is still very high (up to 75%).
Oracle Open World Presentations November 21, 2007
Posted by Tipster in Oracle, PeopleSoft.add a comment
Some of the presentations from Oracle Open World have been posted online.
Regardless of whether you’re technical or functional – or what modules your company has licensed – there’ll be something there of interest.
http://www28.cplan.com/cc176/catalog.jsp
(The username and password you’ll need to download the files is at the top of the page)
Larry gives some Fusion answers November 15, 2007
Posted by Tipster in Fusion, Oracle, PeopleSoft.add a comment
From Oracle Open World 2007:
It seems as though the first applications out of the Fusion stable are all going to be CRM related. According to Larry’s keynote, the first three will be sales prospector, sales references and sales tools.
Possibly of more interest was that we’ve had a glimpse of an answer to the ‘what database platforms will Fusion support’ question. It turns out that it’s going to vary for each application. Larry spoke about Financials and said that it’s going to be Oracle, plus DB2 (providing IBM build in some features that Oracle are requesting). There was no word on the other modules.
The best exchange was possibly this one though:
“We will have a Fusion version for every application,” Ellison stated. “So you’re moving off these brands (PeopleSoft, Siebel etc)?” he was asked, LArry responded “No, well yes – by 2025.”
Article here:
http://www.regdeveloper.co.uk/2007/11/15/ellison_audience_smack_down/
Oracle Open World – PeopleSoft Perspective November 14, 2007
Posted by Tipster in PeopleSoft.2 comments
Brent Martin over at the PeopleSoft Corner Blog is putting together a daily update of the Open World conference from a PeopleSoft perspective. Pretty handy if – like me – you’re trying to keep up to date with what’s going on as it saves us all from wading through the Oracle Apps content …
Is all well with Fusion? November 14, 2007
Posted by Tipster in Fusion, Oracle, PeopleSoft.add a comment
There are rumours of hold-ups and delays within the Fusion camp.
It was only a couple of weeks ago that the ‘Head of Fusion’ John Wookey left amidst talk of a fall-out with Larry Ellison. Apparently “Oracle was trying to woo him back, though the circumstances around Wookey’s departure have not been confirmed.“
Now it appears that there is some backtracking – or at least redefining phrases from earlier statements – to allow for delays in the release. Seeing as we are only a couple of months away from the New Year, surely a release date a little more precise than between Jan 1st and Dec 31st 2008 should be possible?
It’s not as if we expect the full suite of Apps on that date. I would anticipate something more akin to the PeopleSoft Version 9.0 release, where a smallish module (was it ELM?) came out first with much fanfare about ‘Oracle meeting schedules to release PeopleSoft v9.0′, and then the main modules (HR, Financials etc) drip-fed out months later.
A Custom Message on the Signon Page (part 3) November 9, 2007
Posted by Tipster in Oracle, PeopleSoft, PIA.9 comments
A further solution to the ‘Message of the Day’ problem has presented itself which may or may not (depending upon the client’s requirements) be a neater solution.
This is quicker and cleaner to implement, but only works with IE. If your client uses Firefox this isn’t the answer for you!
A Custom Message on the Signon Page (part 2) November 6, 2007
Posted by Tipster in Oracle, PeopleSoft, PIA.4 comments
One of the criticisms that could be leveled at the previous post ‘A Custom Message on the Signon Page’ and its attempt to provide ‘Message of the Day’ functionality is that it’s static. If you need to change the message, you need to bounce the PIA. At some clients this would be fine – and at others not – so another solution was needed.
One way is to embed an iFrame in the signin.html page that points to the file containing the ‘Message of the Day’ text. The signin.html loads on PIA boot and knows it has an iFrame in it, but doesn’t look for the file until someone loads the page. Then you can change the text as often as you like without having to bounce the PIA. If the message text is longer than the box, a vertical scroll bar appears.
(This solution is better for mixed browser clients, however if you are Internet Explorer only consider this solution instead.)
A Custom Message on the Signon Page November 5, 2007
Posted by Tipster in Oracle, PeopleSoft, PIA.comments closed
A quick and easy one today. I was asked by a colleague how to have a custom message appear on the signon page. Partly out of curiosity and partly inspired by these posts (1 and 2) I thought I’d have a look.
As the signon page is (obviously) presented before signin, it’s not going to be a ‘PeopleCode and database’ kind of solution, but I wanted something neater than just hacking the HTML each time. It turns out that it’s simpler than I feared.
XML Publisher and Out of Memory Errors October 30, 2007
Posted by Tipster in Oracle, PeopleSoft, PeopleTools, XML Publisher.2 comments
I’m getting a lot of comments on the XML Publisher posts about ‘Out of Memory’ errors. I’ve not experienced this myself so can’t give a fix or workaround, but wondered whether anyone else had hit this issue and found a resolution?
Doing a bit of digging there are a number of suggestions, none of them relate to the PeopleSoft implementation of XMLP however so I’m unconvinced by any solution in particular.
There’s a Tools patch out for this issue (8.48.06 and up contains the fix), so check your version of Tools:
http://www.peoplesoft.com/psp/portprd/CUSTOMER/CRM/c/C1C_MENU.C1_SOLN_SUMMARY.GBL?page=C1_SOLN_SUMMARY&SETID=SHARE&SOLUTION_ID=201046967
There’s a suggestion to change a parameter for XMLP (I guess this would be on the Process Defn or more likely the Process Type in PeopleSoft):
http://forums.oracle.com/forums/thread.jspa?threadID=568832&tstart=0&messageID=2116283
There’s a suggestion to create a config file (it is not delivered) to specify a temporary directory for processing large files:
http://asun.ifmo.ru/docs/XMLP/help/en_US/htmfiles/B25951_01/T421739T422152.htm
And there’s also a suggestion that a patch will fix it:
http://www.oracle.com/technology/products/xml-publisher/docs/AboutXMLP562.htm
If I was troubleshooting it and was already on 8.48.06 or greater, I’d probably try the parameter followed by the config file.
If anyone has encountered this error and fixed it, it’d be great if you posted a comment to let us know the resolution.
