PeopleSoft
This is My experience Note Book on PeopleSoft
Tuesday, 19 March 2013
Multiple SQL statements in one single Application Engine SQL Action
%Execute([/])
statment1{; | /}
statment2{; | /}
statment3{; | /}
ex:
%Execute(/)
statment1
/
statement2
/
statement3
/
Monday, 18 March 2013
How to find PeopleSoft current bundle number
use below Sql in DESCR place you can get bundle number info
SELECT
A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG
FROM
PS_MAINTENANCE_LOG A
WHERE
upper
(A.DESCRLONG) like
'%BUNDLE%'
ORDER
BY
3
DESC
Friday, 15 March 2013
Some good peoplesoft blogs :
http://peoplesofthrms.blogspot.in
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)