Recent Forum Posts

From categories:
page 1123...next »

Where you find this path (e.g. functions, component/record/page PeopleCode).

Best Regards.

I Dont understand specificly what do you want to do?, but if you assign the role to yours users; it is all. Other think i look is you write %userid and the only peoplecode i know is %OperatorId.

Best Regards.

Hi, do you want to know the tracing of a process like a App Engine or Crystal?

Re: How to use tracing by jcmayjcmay, 17 Apr 2015 17:29
Bank Reconciliation
jcmayjcmay 17 Apr 2015 17:01
in discussion Forum / Help » Bank Reconciliation

First i apologize for my english, i have been working in the module of Bank Reconciliation. I can give you support about this process. The worst problem was the PSDB1 format was desconfigured and i must reconfigure for to Import Bank Statements.

All the configuration is in the App Package "TR_FORMAT" in the class "PSDB1Formatter", also i must to do an application in vb.net for do readable the format that sent the banks to PSDB1 format of PeopleSoft.

The issue is very large.

Best Regards.

Bank Reconciliation by jcmayjcmay, 17 Apr 2015 17:01
Bob (guest) 16 Apr 2015 23:06
in discussion Forum / Help » PTOOLS 8.20 for AIX 5.3

Defintely something to check with Oracle / Oracle Support directly.

by Bob (guest), 16 Apr 2015 23:06
Rajender (guest) 16 Apr 2015 11:18
in discussion Forum / Help » PTOOLS 8.20 for AIX 5.3

is anyone have PeopleSoft HRMS 7.5 Support matrix.

We have PeopleSoft HRMS 7.5
Peopletools7.6
AIX is 4.3
DB2 is database

and want to know is it will be fine to upgrade AIX 4.3 to 5.3 or 6.1 ? does AIX 5.3 or 6.1 Supports Peopletools 7.6 ?

by Rajender (guest), 16 Apr 2015 11:18

I am in the process of exposing Self service over the internet. So i am going to find the ipaddress range and depend upon that assigning roles dynamically to the user . So user will be able to see only ESS over the internet. I have written the peoplecode but it seems not working.

Function AssignExampleRole()

Local string &sOprid;

local string &ipaddr;
&ipaddr=%request.reoteaddr;
if &ipaddr="192.192.192.192" then
&userid=%userid;
%RoleDynamicMembers.Push(&sOprid);

end-if;
End-Function;

Will this code work. When i run the test rule in dynamic members, it gave result…when i execute the rule it fails with an error

it returns an error "SQL.Fetch: object isn't open on a select"

An i gave this code in signon peoplecode it never executes…

Execute Dynamic role rule in signon peoplecode by Velu (guest), 15 Apr 2015 22:16
Bob (guest) 06 Apr 2015 20:39
in discussion Forum / Help » Having multiple Validation errors in a single error message

Not with the standard field validation but you could perhaps write your own field edit/save edut validation PeopleCode and then use the built in Error PeopleCode function to stop processing and display a combined error. Use SetCursorPos to put the cursor on the field with the first error to help with usability.

by Bob (guest), 06 Apr 2015 20:39

Hi,

I was wondering if it is possible for there to be multiple error messages for missing required fields in a single error message to the user? For example, if I left all 5 of my required fields blank, the error message that is displayed when clicking Submit will show all 5 messages in the same window.

Thanks!

http://ajaypeoplesoft.blogspot.in/2014/06/some-nice-to-have-sql-scripts.html

ategory: Components, Component-Interfaces related queries
01) SQL Query to find search records in a CI
SELECT SEARCHRECNAME, ADDSRCHRECNAME
FROM PSBCDEFN
WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI';
02) SQL QUERY TO FIND OUT THE RECORDS EXPOSED BY A CI
SELECT DISTINCT RECNAME
FROM PSBCITEM
WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI';
03) SQL Query to find out the Component associated with a Component Interface
SELECT BCPGNAME,MARKET,MENUNAME
FROM PSBCDEFN
WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI';
04) Identify which USER, ROLE and PERMISSION-LIST has access to a Component Interface
SELECT DISTINCT R.ROLEUSER AS USER_IDS, C.ROLENAME as ROLE, P.CLASSID AS PERMISSION_LIST
FROM PSROLEUSER R, PSROLECLASS C, PSAUTHBUSCOMP P
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND P.BCNAME = 'AJ_MAP_XLAT_TBL_CI'
ORDER BY 1,2,3;
05) Find all records under a specified component.
SELECT DISTINCT RECNAME FROM PSRECDEFN
WHERE ( RECNAME IN (SELECT RECNAME FROM PSPNLFIELD WHERE PNLNAME IN (SELECT DISTINCT B.PNLNAME
FROM PSPNLGROUP A, PSPNLFIELD B WHERE (A.PNLNAME = B.PNLNAME OR A.PNLNAME = B.SUBPNLNAME)
AND A.PNLGRPNAME = 'AJ_MAP_XLAT_TBL'))
OR RECNAME IN (SELECT RECNAME FROM PSPNLFIELD WHERE PNLNAME IN (SELECT DISTINCT B.SUBPNLNAME
FROM PSPNLGROUP A, PSPNLFIELD B WHERE (A.PNLNAME = B.PNLNAME OR A.PNLNAME = B.SUBPNLNAME)
AND A.PNLGRPNAME = 'AJ_MAP_XLAT_TBL'))
)
AND RECNAME <> ' '
ORDER BY RECNAME ASC;
06) SQL query to get all the child records for a parent record:
SELECT RECNAME FROM PSRECDEFN
CONNECT BY PRIOR RECNAME=PARENTRECNAME
START WITH PARENTRECNAME = 'VOUCHER';

Category: Portal Navigation
01) Find the navigation to a Component
SELECT P1.PORTAL_NAME, P6.PORTAL_LABEL, P5.PORTAL_LABEL, P4.PORTAL_LABEL, P3.PORTAL_LABEL,
P2.PORTAL_LABEL, P1.PORTAL_LABEL
FROM PSPRSMDEFN P1
LEFT JOIN PSPRSMDEFN P2 ON P2.PORTAL_NAME = P1.PORTAL_NAME AND P2.PORTAL_OBJNAME = P1.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN P3 ON P3.PORTAL_NAME = P2.PORTAL_NAME AND P3.PORTAL_OBJNAME = P2.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN P4 ON P4.PORTAL_NAME = P3.PORTAL_NAME AND P4.PORTAL_OBJNAME = P3.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN P5 ON P5.PORTAL_NAME = P4.PORTAL_NAME AND P5.PORTAL_OBJNAME = P4.PORTAL_PRNTOBJNAME
LEFT JOIN PSPRSMDEFN P6 ON P6.PORTAL_NAME = P5.PORTAL_NAME AND P6.PORTAL_OBJNAME = P5.PORTAL_PRNTOBJNAME
WHERE P1.PORTAL_REFTYPE = 'C' AND P1.PORTAL_URI_SEG2 = 'ACCOUNTINGENTRY';
02) To the navigation of a particular process name, say 'FS_JGEN'
SELECT LPAD(' ', 10*LEVEL-10) || PS.PORTAL_LABEL
FROM PSPRSMDEFN PS
START WITH PS.PORTAL_URI_SEG2 IN (SELECT PSB.PNLGRPNAME FROM PS_PRCSDEFNPNL PSB WHERE PSB.PRCSNAME = 'FS_JGEN')
AND PS.PORTAL_URI_SEG3 IN ('GBL','USA')
CONNECT BY PRIOR PS.PORTAL_PRNTOBJNAME = PS.PORTAL_OBJNAME
AND PS.PORTAL_NAME = 'EMPLOYEE' AND PS.PORTAL_LABEL <> 'Root';

Category: Process Scheduler
01) Process Scheduler Server(s) status
SELECT S.SERVERNAME, X.XLATSHORTNAME,X.FIELDVALUE,S.MAXCPU,S.PRCSDISKSPACE,S.LASTUPDDTTM
FROM PSSERVERSTAT S, PSXLATITEM X
WHERE X.FIELDNAME = 'SERVERSTATUS' AND X.FIELDVALUE = S.SERVERSTATUS;
02) Processes running since yesterday
SELECT A.PRCSINSTANCE, A.OPRID, B.XLATLONGNAME "RUN_STATUS", A.JOBINSTANCE, A.PRCSJOBNAME, A.PRCSNAME, A.PRCSTYPE,
A.BEGINDTTM, A.ENDDTTM, to_char((A.ENDDTTM - A.BEGINDTTM),'HH.MM.SS')
FROM PSPRCSRQST A, PSXLATITEM B
WHERE B.FIELDNAME = 'RUNSTATUS' AND B.FIELDVALUE = A.RUNSTATUS and A.BEGINDTTM > (SYSDATE - 1)
ORDER BY A.PRCSINSTANCE DESC;

Category: Users, Roles and Permissions
01) Determine the list of query security trees that an oprid has access to
SELECT distinct P.TREE_NAME,P.ACCESS_GROUP,P.ACCESSIBLE
FROM PS_SCRTY_ACC_GRP P, PSROLECLASS C, PSROLEUSER R
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND R.ROLEUSER = 'AGGARWAA'
AND P.ACCESSIBLE = 'Y'
ORDER BY 1,2;
02) Identify which USERs, ROLEs and PERMISSION-LISTs have access to load data using ExceltoCI utility
SELECT DISTINCT R.ROLEUSER AS USER_IDS, C.ROLENAME as ROLE, P.CLASSID AS PERMISSION_LIST
FROM PSROLEUSER R, PSROLECLASS C, PSAUTHWEBLIBVW P
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND P.MENUNAME = 'WEBLIB_SOAPTOCI'
ORDER BY 1,2,3;
03) Identify through which user, role and permission-list access to a particular component interface
SELECT DISTINCT R.ROLEUSER AS USER_IDS, C.ROLENAME as ROLE, P.CLASSID AS PERMISSION_LIST
FROM PSROLEUSER R, PSROLECLASS C, PSAUTHBUSCOMP P
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND P.BCNAME = 'AJ_MAP_XLAT_TBL_CI'
ORDER BY 1,2,3;
04) Roles assigned to a permission-list
SELECT B.ROLENAME, B.CLASSID AS PERMISSION_LIST
FROM PSCLASSDEFN A, PSROLECLASS B
WHERE A.CLASSID = B.CLASSID AND A.CLASSID = 'PTPT1200'
ORDER BY 1,2;
05) List all user ids that are assigned to a specific permission-list
SELECT DISTINCT C.ROLEUSER AS USER_IDS
FROM PSCLASSDEFN A, PSROLECLASS B, PSROLEUSER C
WHERE A.CLASSID = B.CLASSID
AND B.ROLENAME = C.ROLENAME
AND A.CLASSID = 'PTPT1200';
06) Role and user ids assigned to a permission list
SELECT C.ROLEUSER AS USER_IDS, B.ROLENAME as ROLE
FROM PSCLASSDEFN A, PSROLECLASS B, PSROLEUSER C
WHERE A.CLASSID = B.CLASSID AND B.ROLENAME = C.ROLENAME AND A.CLASSID = 'PTPT1200'
ORDER BY 1,2;

Category: Users logged in
01) Number of users connected to the environment in last 30 days
SELECT TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD'),count(distinct A.OPRID) "Users"
FROM PSACCESSLOG A
WHERE TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') >= TO_CHAR(SYSDATE - 30,'YYYY-MM-DD')
GROUP BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD')
ORDER BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') DESC;
02) List of users connected to the environment in last 30 days, with connections count
SELECT TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD'),A.OPRID, sum(1) "Connections"
FROM PSACCESSLOG A
WHERE TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') >= TO_CHAR(SYSDATE - 30,'YYYY-MM-DD')
GROUP BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD'),A.OPRID
ORDER BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') DESC, A.OPRID;
03) Number of connections to the environment in last 30 days
SELECT TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD'),count(A.OPRID) "Connections"
FROM PSACCESSLOG A
WHERE TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') >= TO_CHAR(SYSDATE - 30,'YYYY-MM-DD')
GROUP BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD')
ORDER BY TO_CHAR(A.LOGINDTTM,'YYYY-MM-DD') DESC;

Category: SQLs related to PS-Query
01) If you forget the name of a query, but know that it contains certain fields for sure,
the following SQL could be helpful
SELECT A.OPRID, A.QRYNAME, A.DESCR
FROM PSQRYDEFN A
WHERE A.QRYNAME IN (SELECT B1.QRYNAME FROM PSQRYFIELD B1 WHERE B1.FIELDNAME = 'OPRID')
AND A.QRYNAME IN (SELECT B1.QRYNAME FROM PSQRYFIELD B1 WHERE B1.FIELDNAME = 'RUN_CNTL_ID')
AND A.QRYNAME IN (SELECT B1.QRYNAME FROM PSQRYFIELD B1 WHERE B1.FIELDNAME = 'JOURNAL_ID')
AND A.QRYNAME IN (SELECT B1.QRYNAME FROM PSQRYFIELD B1 WHERE B1.FIELDNAME LIKE '%CURRENCY%')
AND A.QRYNAME IN (SELECT B1.QRYNAME FROM PSQRYFIELD B1 WHERE B1.FIELDNAME LIKE '%AMT%') ;
02) Changing the OPRID(Owner) of a private query
(Please change the new OPRID, OLDOPRID and Private Query name appropriately)
update psqrydefn set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrydefnlang set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrybind set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrybindlang set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryexeclog set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryexpr set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryselect set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrycriteria set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryfield set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryfieldlang set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryfielddep set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqryrecord set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrystats set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update psqrydel set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update PSQRYXFORM set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update PSQRYTRANS set OPRID = 'NEWOPRID' where OPRID = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
update PSQRYFAVORITES set QRYOWNER = 'NEWOPRID' where QRYOWNER = 'OLDOPRID' AND qryname = 'PRIVATE_QUERY_NAME';
Note: a) For making a private query as public, change the OPRID from non-blank
to single space.
b) You may use the navigation
PEOPLETOOLS»UTILITIES»ADMINISTRATION—»QUERY-ADMINISTRATION
and assign a new owner, delete query or rename query.

Category: Trees
01) Getting the Tree Branches, Nodes and detail ranges for a tree.
SELECT J.TREE_NAME,J.TREE_NODE,N.DESCR "NODE NAME",J.TREE_BRANCH,K.RANGE_FROM, K.RANGE_TO
FROM PSTREENODE J, PS_TREE_NODE_TBL N, PSTREELEAF K
WHERE J.SETID = 'SHARE' — Change the SETID here, as appropriate
AND J.TREE_NAME = 'ACCTROLLUP' — Change the Tree Name here, as appropriate
AND J.EFFDT = (SELECT MAX(ED.EFFDT) FROM PSTREENODE ED WHERE J.SETID = ED.SETID
AND J.SETCNTRLVALUE = ED.SETCNTRLVALUE AND J.TREE_NAME = ED.TREE_NAME
AND ED.EFFDT <= SYSDATE)
AND EXISTS (select 'x' FROM PSTREENODE WHERE J.SETID = J.SETID
AND SETCNTRLVALUE = J.SETCNTRLVALUE AND TREE_NAME = J.TREE_NAME
AND EFFDT <= J.EFFDT AND TREE_NODE_NUM = J.PARENT_NODE_NUM)
AND N.SETID = J.SETID
AND N.TREE_NODE = J.TREE_NODE
AND N.EFFDT = (SELECT MAX(ND.EFFDT) FROM PS_TREE_NODE_TBL ND WHERE N.SETID = ND.SETID
AND N.TREE_NODE = ND.TREE_NODE AND ND.EFFDT <= SYSDATE)
AND J.SETID = K.SETID
AND J.TREE_NAME = K.TREE_NAME
AND K.EFFDT >= J.EFFDT
AND K.EFFDT = (SELECT MAX(KD.EFFDT) FROM PSTREELEAF KD WHERE K.SETID = KD.SETID
AND K.SETCNTRLVALUE = KD.SETCNTRLVALUE AND K.TREE_NAME = KD.TREE_NAME AND KD.EFFDT <= SYSDATE)
AND J.TREE_BRANCH = K.TREE_BRANCH
AND J.TREE_NODE_NUM = K.TREE_NODE_NUM ;
Note: The AND EXISTS line is added to exclude orphan nodes.

Kumar (guest) 31 Mar 2015 10:17
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hello Siva,

No specific prerequisites for learning peoplesoft. If you have an idea about basic SQL, is enough..

by Kumar (guest), 31 Mar 2015 10:17
Kumar (guest) 31 Mar 2015 10:15
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Excellent…(y)

by Kumar (guest), 31 Mar 2015 10:15
Kumar (guest) 31 Mar 2015 10:14
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hey Goutham, You are already working no..? Y do you need training again..?

by Kumar (guest), 31 Mar 2015 10:14

You can use the following to get the "hour", in 24 hour format from a timestamp field in Oracle (as well as the minute and second):

select 
  localtimestamp,
  extract(hour from(localtimestamp)),
  extract(minute from(localtimestamp)),
  extract(second from(localtimestamp))
 from dual;
PrajPraj 27 Mar 2015 19:58
in discussion Forum / Help » Web Service Help

Sounds like you've hit the limit for the number of requests you can make to that web service - as suggested you need to register to use it more. This isn't related to PeopleSoft it is related to the site you are consuming the web service/WSDL from.

by PrajPraj, 27 Mar 2015 19:58
srajan (guest) 27 Mar 2015 10:42
in discussion Forum / Help » Web Service Help

I am getting below error when trying to load data from WSDL..
XigniteCurrencies: Maximum number of unregistered requests exceeded. Consider registering or subscribing to expand usage. Can anyone please confirm how do we resolve this

by srajan (guest), 27 Mar 2015 10:42

You can use the Char function to find and replace the line feed character (ASCII Code 10) with an appropriate HTML equivalent such as a break or <br/> tag. Here's an example of how to do it with Substitute:

&formatted_html = Substitute(&input_data, char(10), '<br/>');

Where &input_data might be the data from the database (e.g. in a DESCRLONG field) and &formatted_html will replace all line feeds with the <br/> tag and therefore render line breaks in your output HTML.

Display line feeds in HTML by PrajPraj, 26 Mar 2015 11:04
Bob (guest) 25 Mar 2015 22:26
in discussion Forum / Help » Problems in consuming a peoplesoft webservice

Do you have a more detailed error message or lot. SOAP versions might be important e.g. v1.1 vs v1.2 for compatibility.

by Bob (guest), 25 Mar 2015 22:26

Hi,
I observe there is a difference in the way we test or consume webservices exposed by Peoplesoft. Through SOAPUI everything works fine. But when i try to use an ESB and send the same webservice request i end up with a lot of errors like "ExternalOperationName is a required field".

Could you please let me know how do i proceed with this. I have seen a lot of forums asking this question but none have been able to provide suitable answers.

Problems in consuming a peoplesoft webservice by Suns_Rays (guest), 25 Mar 2015 14:48

Two types of 1099 income example Royalties and nonconpensation. Royalties $12, Non Comp $150. Only $12 printing on form.

Our tax professional says that once one item becomes reportable all items become reportable. So the normal $600 cap on non-compensation would not apply because the Royalties are reportable and the $150 should be reported to IRS.

I could not find a delivered solution for this exception. Is there one? Has anyone used a work around?

1099 multiple reporting Items (boxes) by Hector (guest), 24 Mar 2015 15:34
page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License