Recent Forum Posts

From categories:
page 1123...next »

I am also having same requirement where the user should not be able to create any user profiles. For this, I removed Component USERMAINT from a permission list. But since user is having Peoplesoft Administrator permission list too, user is able to create profiles even after removing that component USERMAINT. I cannot remove Peoplesoft Administrator permission list from user because it is causing problems in access of other components on PIA. Can anyone suggest any solution where we don't need to remove this permission list Peoplesoft Administrator from user and the user can not create profiles too at the same time?? If any solution please let me know.

by Dove (guest), 22 Feb 2023 13:20

Using PS Query Manager, how do I get a set of data from current to 'x' years back, or using the Term, instead of years. Thanks

Retrieve data from current to 3 yrs back by Edna (guest), 17 Feb 2023 00:04

SELECT q.prcsinstance, h.module, h.action, sample_time,sql.sql_text
FROM v$active_Session_history h ,dba_hist_sqltext sql
, psprcsrqst q
WHERE
h.sample_time BETWEEN q.begindttm AND NVL(q.enddttm,SYSDATE)
and
q.prcsinstance = 20346066
and h.sql_id = sql.sql_id
and action=prcsname
and oprid=client_id
and action=prcsname
order by h.sample_time,sample_id
;

SELECT
*
FROM
(
SELECT
to_char(begindttm, 'DDD') day_of_year,
COUNT(1) OVER(
PARTITION BY oprid, to_char(begindttm, 'DDD')
) count_for_user_in_day,
COUNT(1) OVER(
PARTITION BY to_char(begindttm, 'DDD'), to_char(begindttm, 'hh')
) count_in_day_hrs,
COUNT(1) OVER(
PARTITION BY to_char(begindttm, 'DDD')
) count_in_day,

trunc(EXTRACT(DAY FROM(a.enddttm - a.begindttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.enddttm - a.begindttm)) * 60 * 60 + EXTRACT
(MINUTE FROM(a.enddttm - a.begindttm)) * 60 + EXTRACT(SECOND FROM(a.enddttm - a.begindttm))) AS run_time_sec,

trunc( EXTRACT(DAY FROM( a.begindttm - a.rqstdttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.begindttm -a.rqstdttm)) * 60 * 60 + EXTRACT
(MINUTE FROM(a.begindttm - a.rqstdttm)) * 60 + EXTRACT(SECOND FROM(a.begindttm -a.rqstdttm))) AS wait_time_to_start_sec,
rqstdttm,
begindttm,
enddttm,
a.prcsinstance,
a.runcntlid,
a.oprid,
prcsname,
trunc(AVG(EXTRACT(DAY FROM(a.enddttm - a.begindttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.enddttm - a.begindttm)) * 60
* 60 + EXTRACT(MINUTE FROM(a.enddttm - a.begindttm)) * 60 + EXTRACT(SECOND FROM(a.enddttm - a.begindttm))) OVER(
PARTITION BY prcsname, oprid,runcntlid
)) AS avg_run_time_sec_oprid_rntcl,
trunc(MIN(EXTRACT(DAY FROM(a.enddttm - a.begindttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.enddttm - a.begindttm)) * 60
* 60 + EXTRACT(MINUTE FROM(a.enddttm - a.begindttm)) * 60 + EXTRACT(SECOND FROM(a.enddttm - a.begindttm))) OVER(
PARTITION BY prcsname, runcntlid
)) AS min_run_time_sec,
trunc(MAX(EXTRACT(DAY FROM(a.enddttm - a.begindttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.enddttm - a.begindttm)) * 60
* 60 + EXTRACT(MINUTE FROM(a.enddttm - a.begindttm)) * 60 + EXTRACT(SECOND FROM(a.enddttm - a.begindttm))) OVER(
PARTITION BY prcsname, oprid, runcntlid
)) AS max_run_time_sec_opr_rntcl,
trunc(MAX(EXTRACT(DAY FROM(a.enddttm - a.begindttm)) * 24 * 60 * 60 + EXTRACT(HOUR FROM(a.enddttm - a.begindttm)) * 60
* 60 + EXTRACT(MINUTE FROM(a.enddttm - a.begindttm)) * 60 + EXTRACT(SECOND FROM(a.enddttm - a.begindttm))) OVER(
PARTITION BY prcsname, oprid,runcntlid
) /(60 * 60)) AS max_run_time_hrs_opr_rnctl,
COUNT(*) OVER(
PARTITION BY to_char(begindttm, 'YYYYMM'), oprid, prcsname, runcntlid
) AS ncount_run_opr_run_mth
,
COUNT(*) OVER(
PARTITION BY oprid, runcntlid
) AS user_base_opr_runcntl

FROM
psprcsrqst a
WHERE
prcsname = '<>'
AND runstatus = 9 and enddttm >sysdate-360
ORDER BY
begindttm
)
ORDER BY

max_run_time_sec_opr_rntcl desc, run_time_sec desc,
count_in_day DESC,
count_in_day_hrs DESC

SELECT
*
FROM
(
SELECT DISTINCT
RANK() OVER(
PARTITION BY projectname, tgtdbname
ORDER BY
b.rundttm DESC
) AS latest_compare,
tgtdbname,
a.*
FROM
ps_pscompobjdif_vw a,
pscompsession b
WHERE
a.ptsessionid = b.ptsessionid
AND projectname LIKE '%ANZ%2199%'
AND ptsourcestatus LIKE '%C%'
AND pttargetstatus LIKE '%C%'
)
WHERE
latest_compare = 1;

HI,

I tried to assign a related content which works with other component to my component, I found the navigation in Manage Related COntent, but when I tried to select the page, the page is not there. Instead, a lot of pages not in my component show up. Does anyone know what is goind on? HOw can I bring my page up so I can pick it?

Thanks,

Samantha

Page missing in manage Related Content in peoplesoft by Samantha (guest), 16 Sep 2022 01:35

SELECT
objecttype,
CASE objecttype
WHEN 0 THEN
CASE nvl((
SELECT
rectype
FROM
psrecdefn
WHERE
recname = i.objectvalue1
), 99)
WHEN 0 THEN
'SQL Table in DB'
WHEN 1 THEN
'SQL View in DB'
WHEN 2 THEN
'Work Record'
WHEN 3 THEN
'Sub Record'
WHEN 5 THEN
'Dynamic View'
WHEN 6 THEN
'Query View'
WHEN 7 THEN
'Temporary Table'
ELSE
'Other Record or Deleted'
END
WHEN 1 THEN
'Index'
WHEN 2 THEN
'Field'
WHEN 3 THEN
'Field Format'
WHEN 4 THEN
'Translate Value'
WHEN 5 THEN
'Page'
WHEN 6 THEN
'Menu'
WHEN 7 THEN
'Component'
WHEN 8 THEN
'Record PeopleCode'
WHEN 9 THEN
'Menu PeopleCode'
WHEN 10 THEN
'Query'
WHEN 11 THEN
'Tree Structure'
WHEN 12 THEN
'Tree'
WHEN 13 THEN
'Access Group'
WHEN 14 THEN
'Color'
WHEN 15 THEN
'Style'
WHEN 16 THEN
'Business Process Map'
WHEN 17 THEN
'Business Process'
WHEN 18 THEN
'Activity'
WHEN 19 THEN
'Role'
WHEN 20 THEN
'Process Definition'
WHEN 21 THEN
'Process Server Definition'
WHEN 22 THEN
'Process Type Definition'
WHEN 23 THEN
'Process Job Definition'
WHEN 24 THEN
'Process Recurrence Definition'
WHEN 25 THEN
'Message Catalog'
WHEN 26 THEN
'Dimension'
WHEN 27 THEN
'Cube Definition'
WHEN 28 THEN
'Cube Instance Definition'
WHEN 29 THEN
'Business Interlink'
WHEN 30 THEN
CASE objectvalue2
WHEN '0' THEN
'SQL Object'
WHEN '1' THEN
'App Engine SQL'
WHEN '2' THEN
'Record View SQL'
WHEN '5' THEN
'Query for DDAUDIT or SYSAUDIT'
WHEN '6' THEN
'App Engine XML SQL'
ELSE
'SQL'
END
WHEN 31 THEN
'File Layout'
WHEN 32 THEN
'Component Interface'
WHEN 33 THEN
'Application Engine Program'
WHEN 34 THEN
'Application Engine Section'
WHEN 35 THEN
'Message Node'
WHEN 36 THEN
'Message Channel'
WHEN 37 THEN
'Message'
WHEN 38 THEN
'Approval rule set'
WHEN 39 THEN
'Message PeopleCode'
WHEN 40 THEN
'Subscription PeopleCode'
WHEN 41 THEN
'N/A'
WHEN 42 THEN
'Component Interface PeopleCode'
WHEN 43 THEN
'Application Engine PeopleCode'
WHEN 44 THEN
'Page PeopleCode'
WHEN 45 THEN
'Page Field PeopleCode'
WHEN 46 THEN
'Component PeopleCode'
WHEN 47 THEN
'Component Record PeopleCode'
WHEN 48 THEN
'Component Record Field PeopleCode'
WHEN 49 THEN
'Image'
WHEN 50 THEN
'Style sheet'
WHEN 51 THEN
'HTML'
WHEN 52 THEN
'Not used'
WHEN 53 THEN
'Permission List'
WHEN 54 THEN
'Portal Registry Definitions'
WHEN 55 THEN
'Portal Registry Structure'
WHEN 56 THEN
'URL Definitions'
WHEN 57 THEN
'Application Packages'
WHEN 58 THEN
'Application Package PeopleCode'
WHEN 59 THEN
'Portal Registry User Homepage'
WHEN 60 THEN
'Problem Type'
WHEN 61 THEN
'Archive Templates'
WHEN 62 THEN
'XSLT'
WHEN 63 THEN
'Portal Registry User Favorite'
WHEN 64 THEN
'Mobile Page'
WHEN 65 THEN
'Relationships'
WHEN 66 THEN
'Component Interface Property PeopleCode'
WHEN 67 THEN
'Optimization Models'
WHEN 68 THEN
'File References'
WHEN 69 THEN
'File Type Codes'
WHEN 70 THEN
'Archive Object Definitions'
WHEN 71 THEN
'Archive Templates (Type 2)'
WHEN 72 THEN
'Diagnostic Plug In'
WHEN 73 THEN
'Analytic Model'
WHEN 79 THEN
'Service'
WHEN 80 THEN
'Service Operation'
WHEN 81 THEN
'Service Operation Handler'
WHEN 82 THEN
'Service Operation Version'
WHEN 83 THEN
'Service Operation Routing'
WHEN 84 THEN
'Info Broker Queues'
WHEN 85 THEN
'XLMP Template Definition'
WHEN 86 THEN
'XLMP Report Definition'
WHEN 87 THEN
'XMLP File Definition'
WHEN 88 THEN
'XMPL Data Source Definition'
ELSE
'Unknown ' || objecttype
END AS object_type,
CASE objecttype
WHEN 12 THEN
objectvalue3
WHEN 30 THEN
CASE
WHEN objectvalue2 = 0 THEN
objectvalue1 /* SQL Object */
WHEN objectvalue2 = 1 THEN
substr(objectvalue1, 1, 12)
WHEN objectvalue2 = 2 THEN
objectvalue1 /* Record View SQL */
ELSE
' '
END
WHEN 34 THEN
TRIM(objectvalue1)
|| '.'
|| TRIM(objectvalue2)
WHEN 62 THEN
TRIM(substr(objectvalue1, 1, 12))
ELSE
objectvalue1
END AS name,
CASE
WHEN objecttype = 1 THEN
'Index: ' || objectvalue2
WHEN objecttype = 4 THEN
'XLAT: '
|| objectvalue2
|| '; Date: '
|| objectvalue3
|| '; '
|| nvl((
SELECT
'ShortName: '
|| xlatshortname
|| '; LongName: '
|| xlatlongname
|| '; Status: '
|| eff_status
FROM
psxlatitem
WHERE
fieldname = i.objectvalue1
AND fieldvalue = i.objectvalue2
AND effdt = to_date(i.objectvalue3, 'YYYY-MM-DD')
), 'XLAT Deleted')
WHEN objecttype = 7 THEN
'Market: ' || objectvalue2
WHEN objecttype = 8 THEN
objectvalue1
|| '.'
|| objectvalue2
|| '.'
|| objectvalue3
WHEN objecttype = 9 THEN
objectvalue2
|| '.'
|| objectvalue3
|| '.'
|| objectvalue4
WHEN objecttype = 12 THEN
'EFFDT: ' || objectvalue4
WHEN objecttype = 20 THEN
'Process Name: ' || objectvalue2
WHEN objecttype IN (
22,
40
) THEN
objectvalue2
|| '.'
|| objectvalue3
WHEN objecttype = 25 THEN
'Message: '
|| objectvalue2
|| ' (Message Set Descr: '
|| objectvalue3
|| ')'
WHEN objecttype = 30 THEN
CASE
WHEN objectvalue2 = 0 THEN
' ' /* SQL Object */
WHEN objectvalue2 = 1 THEN
'AE Progam: '
|| substr(objectvalue1, 1, 12)
|| ' Section: '
|| substr(i.objectvalue1, 13, 8)
|| ' Step: '
|| substr(objectvalue1, 21, 8)
|| ' Type: '
|| decode(substr(objectvalue1, 29, 1), 'S', 'SQL', 'D', 'Do Select',
'W', 'Do While', 'H', 'Do When', 'N',
'Do Until', substr(objectvalue1, 29, 1))
WHEN objectvalue2 = 2 THEN
' ' /* Record View SQL */
ELSE
' '
END
WHEN objecttype = 38 THEN
'EFFDT: ' || objectvalue2
WHEN objecttype IN (
39,
42,
44
) THEN
objectvalue2
WHEN objecttype = 43 THEN
CASE
WHEN TRIM(objectvalue4) = 'OnExecute' THEN
'Section: '
|| substr(i.objectvalue2, 1, 8)
|| '; Step: '
|| objectvalue3
|| '; Market: '
|| substr(i.objectvalue2, 9, 3)
|| '; Database: '
|| TRIM(substr(objectvalue2, 12, 8))
|| '; EFFDT: '
|| TRIM(substr(objectvalue2, 21, 10))
ELSE
'Section: '
|| objectvalue2
|| '; Market: '
|| objectvalue3
|| '; Database: '
|| TRIM(substr(objectvalue4, 12, 8))
|| '; EFFDT: '
|| TRIM(substr(objectvalue4, 21, 10))
END
WHEN objecttype = 46 THEN
'Market: '
|| objectvalue2
|| '; Event: '
|| objectvalue3
WHEN objecttype = 47 THEN
'Market: '
|| objectvalue2
|| '; Record: '
|| objectvalue3
|| '; Event: '
|| objectvalue4
WHEN objecttype = 48 THEN
'Market: '
|| objectvalue2
|| '; Record: '
|| objectvalue3
|| '; Field: '
|| TRIM(substr(objectvalue4, 1, 18))
|| '; Event: '
|| TRIM(substr(objectvalue4, 19, 16))
WHEN objecttype = 55 THEN
decode(objectvalue2, 'C', 'Content: ', 'F', 'Folder: ')
|| objectvalue3
WHEN objecttype = 57 THEN
CASE
WHEN TRIM(objectvalue4) NOT IN (
' ',
':',
'.'
) THEN
'Subclass: '
|| TRIM(objectvalue2)
|| ':'
|| TRIM(objectvalue3)
|| ':'
|| TRIM(objectvalue4)
ELSE
CASE
WHEN TRIM(objectvalue3) NOT IN (
' ',
':',
'.'
) THEN
'Subclass: '
|| TRIM(objectvalue2)
|| ':'
|| TRIM(objectvalue3)
ELSE
CASE
WHEN TRIM(objectvalue2) NOT IN (
' ',
':',
'.'
) THEN
'Subclass: ' || TRIM(objectvalue2)
ELSE
' '
END
END
END
WHEN objecttype IN (
58,
63,
68,
81,
82,
83,
87,
88
) THEN
CASE
WHEN TRIM(objectvalue4) IS NOT NULL THEN
TRIM(objectvalue2)
|| '.'
|| TRIM(objectvalue3)
|| '.'
|| TRIM(objectvalue4)
ELSE
CASE
WHEN TRIM(objectvalue3) IS NOT NULL THEN
TRIM(objectvalue2)
|| '.'
|| TRIM(objectvalue3)
ELSE
CASE
WHEN TRIM(objectvalue2) IS NOT NULL THEN
TRIM(objectvalue2)
ELSE
' '
END
END
END
WHEN objecttype = 59 THEN
TRIM(objectvalue2)
WHEN objecttype = 62 THEN
'AE Progam: '
|| substr(objectvalue1, 1, 12)
|| ' Section: '
|| substr(i.objectvalue1, 13, 8)
|| ' Step: '
|| substr(objectvalue1, 21, 8)
ELSE
' '
END AS extended_obj_name,
CASE objecttype
WHEN 0 THEN
nvl((
SELECT
recdescr
FROM
psrecdefn
WHERE
recname = i.objectvalue1
), ' ')
WHEN 1 THEN
nvl((
SELECT
idxcomments
FROM
psindexdefn
WHERE
recname = i.objectvalue1
AND indexid = i.objectvalue2
), ' ')
WHEN 3 THEN
nvl((
SELECT
descr
FROM
psfmtdefn
WHERE
formatfamily = i.objectvalue1
), ' ')
WHEN 5 THEN
nvl((
SELECT
descr
FROM
pspnldefn
WHERE
pnlname = i.objectvalue1
), ' ')
WHEN 6 THEN
nvl((
SELECT
descr
FROM
psmenudefn
WHERE
menuname = i.objectvalue1
), ' ')
WHEN 7 THEN
nvl((
SELECT
descr
FROM
pspnlgrpdefn
WHERE
pnlgrpname = i.objectvalue1
AND market = i.objectvalue2
), ' ')
WHEN 20 THEN
nvl((
SELECT
descr
FROM
ps_prcsdefn
WHERE
prcstype = i.objectvalue1
AND prcsname = i.objectvalue2
), ' ')
WHEN 32 THEN
nvl((
SELECT
descr
FROM
psbcdefn
WHERE
bcname = i.objectvalue1
), ' ')
WHEN 33 THEN
nvl((
SELECT
descr
FROM
psaeappldefn
WHERE
ae_applid = i.objectvalue1
), ' ')
ELSE
' '
END AS descr,
objectvalue1,
objectid2,
objectvalue2,
objectid3,
objectvalue3,
objectid4,
objectvalue4,
nodetype,
decode(sourcestatus, 1, 'ABSENT', 3, ' UNCHANGED',6,'Same',
2, 'CHANGED', 5, '* UNCHANGED', 4,
'* CHANGED', sourcestatus) AS sourcestatus,
decode(targetstatus, 1, 'ABSENT', 3, ' UNCHANGED',6,'Same',
2, 'CHANGED', 5, '* UNCHANGED', 4,
'* CHANGED', targetstatus) AS targetstatus,
decode(upgradeaction, 0, 'Copy', 1, 'Delete',
2, 'None', 3, 'Copy Prop', upgradeaction) AS upgradeaction
FROM
psprojectitem i
WHERE
projectname = '<ProejctName>'
ORDER BY
objecttype,
2,
objectvalue1,
objectvalue2,
objectvalue3,
objectvalue4;

temp by RahulAgrawalRahulAgrawal, 26 Jul 2022 02:53

I have an html area on a peoplesoft page. In the html area I have an input text called 'drivers_lic' to capture the employees driver license number. If we have the drivers license number I'm sending it over to the html area text box as the value. When clicking a submit button to process the peoplecode to perform the update/insert to the database, the %Request.GetParameter returns a null value. Why?

Adding to the mystery is, if I make a change to the page, tab to the field, create a messagebox with an message, the first time the page loads, the value is returned to %Request.GetParameter. If I don't touch the page at all and click only the submit button, the %Request.GetParameter is null or blank the first time around. The second time around, the %Request.GetParameter will pick up the value I sent to the html area. I tried many different things and can't figure out how to force a change to the page after it loads. I've tried dosavenow to the page, set a value on the page after it loads, and refresh a page. Below is the input statement sent to the html area:

<input type="text" name="DRIVERS_LIC" style="position:relative; width: 13em; left:3pt; top:3pt;color: #000000; font-family:Arial, sans-serif; font-weight: bold; font-size: 10pt; background-color: #FAFAD2;" size="13" placeholder="Example:N1234567" required="" maxlength="13" value="R291992929399" autofocus="">

Oh yea I tried setting the tab order in the input text html code thinking that might work. However autofocus is not working.

Peoplecode to process the value:

&drivers_license = %Request.GetParameter("DRIVERS_LIC");

SELECT D.SESSIONIDNUM,PRCSINSTANCE,
a.sql_fulltext,
TO_CHAR(b.last_update_time,'DDMonYYY-HH24:MI:SS'),
B.*,
C.*
FROM
v$sqlarea a,
v$session_longops b,
V$SESSION C,
PSPRCSQUE D
WHERE
a.sql_id = b.sql_id
AND target_desc IS NULL
AND B.SID=C.SID
AND C.PROCESS=D.SESSIONIDNUM
ORDER BY
b.sql_exec_id DESC;

https://peoplesofttutorial.com/sql-to-list-project-items-in-peoplesoft/

Every PeopleSoft Developer may have worked on App Designer projects which have so many PeopleSoft objects and code changes that it’s very hard to keep track of these and document them.

Instead of opening every project and listing down the objects one by one, you can simply run a SQL query to list all the objects in a project.

Note: Please replace ‘PEOPLESOFT_PROJECT_NAME’ with your project name.

SELECT OBJECTTYPE,
CASE OBJECTTYPE
WHEN 0 THEN CASE NVL((SELECT RECTYPE FROM PSRECDEFN WHERE RECNAME = I.OBJECTVALUE1), 99)
WHEN 0 THEN 'SQL Table in DB'
WHEN 1 THEN 'SQL View in DB'
WHEN 2 THEN 'Work Record'
WHEN 3 THEN 'Sub Record'
WHEN 5 THEN 'Dynamic View'
WHEN 6 THEN 'Query View'
WHEN 7 THEN 'Temporary Table'
ELSE 'Other Record or Deleted' END
WHEN 1 THEN 'Index'
WHEN 2 THEN 'Field'
WHEN 3 THEN 'Field Format'
WHEN 4 THEN 'Translate Value'
WHEN 5 THEN 'Page'
WHEN 6 THEN 'Menu'
WHEN 7 THEN 'Component'
WHEN 8 THEN 'Record PeopleCode'
WHEN 9 THEN 'Menu PeopleCode'
WHEN 10 THEN 'Query'
WHEN 11 THEN 'Tree Structure'
WHEN 12 THEN 'Tree'
WHEN 13 THEN 'Access Group'
WHEN 14 THEN 'Color'
WHEN 15 THEN 'Style'
WHEN 16 THEN 'Business Process Map'
WHEN 17 THEN 'Business Process'
WHEN 18 THEN 'Activity'
WHEN 19 THEN 'Role'
WHEN 20 THEN 'Process Definition'
WHEN 21 THEN 'Process Server Definition'
WHEN 22 THEN 'Process Type Definition'
WHEN 23 THEN 'Process Job Definition'
WHEN 24 THEN 'Process Recurrence Definition'
WHEN 25 THEN 'Message Catalog'
WHEN 26 THEN 'Dimension'
WHEN 27 THEN 'Cube Definition'
WHEN 28 THEN 'Cube Instance Definition'
WHEN 29 THEN 'Business Interlink'
WHEN 30 THEN CASE OBJECTVALUE2
WHEN '0' THEN 'SQL Object'
WHEN '1' THEN 'App Engine SQL'
WHEN '2' THEN 'Record View SQL'
WHEN '5' THEN 'Query for DDAUDIT or SYSAUDIT'
WHEN '6' THEN 'App Engine XML SQL'
ELSE 'SQL' END
WHEN 31 THEN 'File Layout'
WHEN 32 THEN 'Component Interface'
WHEN 33 THEN 'Application Engine Program'
WHEN 34 THEN 'Application Engine Section'
WHEN 35 THEN 'Message Node'
WHEN 36 THEN 'Message Channel'
WHEN 37 THEN 'Message'
WHEN 38 THEN 'Approval rule set'
WHEN 39 THEN 'Message PeopleCode'
WHEN 40 THEN 'Subscription PeopleCode'
WHEN 41 THEN 'N/A'
WHEN 42 THEN 'Component Interface PeopleCode'
WHEN 43 THEN 'Application Engine PeopleCode'
WHEN 44 THEN 'Page PeopleCode'
WHEN 45 THEN 'Page Field PeopleCode'
WHEN 46 THEN 'Component PeopleCode'
WHEN 47 THEN 'Component Record PeopleCode'
WHEN 48 THEN 'Component Record Field PeopleCode'
WHEN 49 THEN 'Image'
WHEN 50 THEN 'Style sheet'
WHEN 51 THEN 'HTML'
WHEN 52 THEN 'Not used'
WHEN 53 THEN 'Permission List'
WHEN 54 THEN 'Portal Registry Definitions'
WHEN 55 THEN 'Portal Registry Structure'
WHEN 56 THEN 'URL Definitions'
WHEN 57 THEN 'Application Packages'
WHEN 58 THEN 'Application Package PeopleCode'
WHEN 59 THEN 'Portal Registry User Homepage'
WHEN 60 THEN 'Problem Type'
WHEN 61 THEN 'Archive Templates'
WHEN 62 THEN 'XSLT'
WHEN 63 THEN 'Portal Registry User Favorite'
WHEN 64 THEN 'Mobile Page'
WHEN 65 THEN 'Relationships'
WHEN 66 THEN 'Component Interface Property PeopleCode'
WHEN 67 THEN 'Optimization Models'
WHEN 68 THEN 'File References'
WHEN 69 THEN 'File Type Codes'
WHEN 70 THEN 'Archive Object Definitions'
WHEN 71 THEN 'Archive Templates (Type 2)'
WHEN 72 THEN 'Diagnostic Plug In'
WHEN 73 THEN 'Analytic Model'
WHEN 79 THEN 'Service'
WHEN 80 THEN 'Service Operation'
WHEN 81 THEN 'Service Operation Handler'
WHEN 82 THEN 'Service Operation Version'
WHEN 83 THEN 'Service Operation Routing'
WHEN 84 THEN 'Info Broker Queues'
WHEN 85 THEN 'XLMP Template Definition'
WHEN 86 THEN 'XLMP Report Definition'
WHEN 87 THEN 'XMLP File Definition'
WHEN 88 THEN 'XMPL Data Source Definition'
ELSE 'Unknown ' || OBJECTTYPE END AS Object_Type,
CASE OBJECTTYPE
WHEN 12 THEN OBJECTVALUE3
WHEN 30 THEN CASE WHEN OBJECTVALUE2 = 0 THEN OBJECTVALUE1 /* SQL Object */
WHEN OBJECTVALUE2 = 1 THEN SUBSTR(OBJECTVALUE1, 1, 12)
WHEN OBJECTVALUE2 = 2 THEN OBJECTVALUE1 /* Record View SQL */
ELSE ' ' END
WHEN 34 THEN TRIM(OBJECTVALUE1) || '.' || TRIM(OBJECTVALUE2)
WHEN 62 THEN TRIM(SUBSTR(OBJECTVALUE1, 1, 12))
ELSE OBJECTVALUE1 END AS NAME,
CASE
WHEN OBJECTTYPE = 1 THEN 'Index: ' || OBJECTVALUE2
WHEN OBJECTTYPE = 4 THEN 'XLAT: ' || OBJECTVALUE2 || '; Date: ' || OBJECTVALUE3 || '; ' ||
NVL((SELECT 'ShortName: ' || XLATSHORTNAME || '; LongName: ' ||
XLATLONGNAME || '; Status: ' || EFF_STATUS
FROM PSXLATITEM
WHERE FIELDNAME = I.OBJECTVALUE1 AND FIELDVALUE = I.OBJECTVALUE2
AND EFFDT = TO_DATE(I.OBJECTVALUE3, 'YYYY-MM-DD')
), 'XLAT Deleted')
WHEN OBJECTTYPE = 7 THEN 'Market: ' || OBJECTVALUE2
WHEN OBJECTTYPE = 8 THEN OBJECTVALUE1 || '.' || OBJECTVALUE2 || '.' || OBJECTVALUE3
WHEN OBJECTTYPE = 9 THEN OBJECTVALUE2 || '.' || OBJECTVALUE3 || '.' || OBJECTVALUE4
WHEN OBJECTTYPE = 12 THEN 'EFFDT: ' || OBJECTVALUE4
WHEN OBJECTTYPE = 20 THEN 'Process Name: ' || OBJECTVALUE2
WHEN OBJECTTYPE IN(22, 40) THEN OBJECTVALUE2 || '.' || OBJECTVALUE3
WHEN OBJECTTYPE = 25 THEN 'Message: ' || OBJECTVALUE2 ||
' (Message Set Descr: ' || OBJECTVALUE3 || ')'
WHEN OBJECTTYPE = 30 THEN
CASE WHEN OBJECTVALUE2 = 0 THEN ' ' /* SQL Object */
WHEN OBJECTVALUE2 = 1 THEN 'AE Progam: ' ||
SUBSTR(OBJECTVALUE1, 1, 12) || ' Section: ' ||
SUBSTR(I.OBJECTVALUE1, 13, 8) || ' Step: ' ||
SUBSTR(OBJECTVALUE1, 21, 8) || ' Type: ' ||
DECODE(SUBSTR(OBJECTVALUE1, 29, 1), 'S', 'SQL',
'D', 'Do Select', 'W', 'Do While',
'H', 'Do When', 'N', 'Do Until',
SUBSTR(OBJECTVALUE1, 29, 1))
WHEN OBJECTVALUE2 = 2 THEN ' ' /* Record View SQL */
ELSE ' ' END
WHEN OBJECTTYPE = 38 THEN 'EFFDT: ' || OBJECTVALUE2
WHEN OBJECTTYPE IN(39, 42, 44) THEN OBJECTVALUE2
WHEN OBJECTTYPE = 43 THEN
CASE WHEN TRIM(OBJECTVALUE4) = 'OnExecute' THEN
'Section: ' || SUBSTR(I.OBJECTVALUE2, 1, 8) || '; Step: ' ||
OBJECTVALUE3 || '; Market: ' || SUBSTR(I.OBJECTVALUE2, 9, 3) ||
'; Database: ' || TRIM(SUBSTR(OBJECTVALUE2, 12, 8)) ||
'; EFFDT: ' || TRIM(SUBSTR(OBJECTVALUE2, 21, 10))
ELSE 'Section: ' || OBJECTVALUE2 || '; Market: ' || OBJECTVALUE3
|| '; Database: ' || TRIM(SUBSTR(OBJECTVALUE4, 12, 8)) ||
'; EFFDT: ' || TRIM(SUBSTR(OBJECTVALUE4, 21, 10)) END
WHEN OBJECTTYPE = 46 THEN 'Market: ' || OBJECTVALUE2 || '; Event: ' || OBJECTVALUE3
WHEN OBJECTTYPE = 47 THEN 'Market: ' || OBJECTVALUE2 || '; Record: ' || OBJECTVALUE3
|| '; Event: ' || OBJECTVALUE4
WHEN OBJECTTYPE = 48 THEN 'Market: ' || OBJECTVALUE2 || '; Record: ' || OBJECTVALUE3
|| '; Field: ' || TRIM(SUBSTR(OBJECTVALUE4, 1, 18))
|| '; Event: ' || TRIM(SUBSTR(OBJECTVALUE4, 19, 16))
WHEN OBJECTTYPE = 55 THEN DECODE(OBJECTVALUE2, 'C', 'Content: ', 'F', 'Folder: ') || OBJECTVALUE3
WHEN OBJECTTYPE = 57 THEN
CASE WHEN TRIM(OBJECTVALUE4) NOT IN(' ', ':', '.') THEN
'Subclass: ' || TRIM(OBJECTVALUE2) || ':' || TRIM(OBJECTVALUE3)
|| ':' || TRIM(OBJECTVALUE4)
ELSE
CASE WHEN TRIM(OBJECTVALUE3) NOT IN(' ', ':', '.') THEN
'Subclass: ' || TRIM(OBJECTVALUE2) || ':' ||
TRIM(OBJECTVALUE3)
ELSE
CASE WHEN TRIM(OBJECTVALUE2) NOT IN(' ', ':', '.') THEN
'Subclass: ' || TRIM(OBJECTVALUE2)
ELSE ' '
END
END
END
WHEN OBJECTTYPE IN(58, 63, 68, 81, 82, 83, 87, 88) THEN
CASE WHEN TRIM(OBJECTVALUE4) IS NOT NULL THEN
TRIM(OBJECTVALUE2) || '.' || TRIM(OBJECTVALUE3) || '.'
|| TRIM(OBJECTVALUE4)
ELSE
CASE WHEN TRIM(OBJECTVALUE3) IS NOT NULL THEN
TRIM(OBJECTVALUE2) || '.' || TRIM(OBJECTVALUE3)
ELSE
CASE WHEN TRIM(OBJECTVALUE2) IS NOT NULL THEN
TRIM(OBJECTVALUE2)
ELSE ' '
END
END
END
WHEN OBJECTTYPE = 59 THEN TRIM(OBJECTVALUE2)
WHEN OBJECTTYPE = 62 THEN 'AE Progam: ' || SUBSTR(OBJECTVALUE1, 1, 12) || ' Section: ' ||
SUBSTR(I.OBJECTVALUE1, 13, 8) || ' Step: ' ||
SUBSTR(OBJECTVALUE1, 21, 8)
ELSE ' ' END AS EXTENDED_OBJ_NAME,
CASE OBJECTTYPE
WHEN 0 THEN NVL((SELECT RECDESCR FROM PSRECDEFN WHERE RECNAME = I.OBJECTVALUE1), ' ')
WHEN 1 THEN NVL((SELECT IDXCOMMENTS FROM PSINDEXDEFN WHERE RECNAME = I.OBJECTVALUE1
AND INDEXID = I.OBJECTVALUE2), ' ')
WHEN 3 THEN NVL((SELECT DESCR FROM PSFMTDEFN WHERE FORMATFAMILY = I.OBJECTVALUE1), ' ')
WHEN 5 THEN NVL((SELECT DESCR FROM PSPNLDEFN WHERE PNLNAME = I.OBJECTVALUE1), ' ')
WHEN 6 THEN NVL((SELECT DESCR FROM PSMENUDEFN WHERE MENUNAME = I.OBJECTVALUE1), ' ')
WHEN 7 THEN NVL((SELECT DESCR FROM PSPNLGRPDEFN WHERE PNLGRPNAME = I.OBJECTVALUE1
AND MARKET = I.OBJECTVALUE2), ' ')
WHEN 20 THEN NVL((SELECT DESCR FROM PS_PRCSDEFN WHERE PRCSTYPE = I.OBJECTVALUE1
AND PRCSNAME = I.OBJECTVALUE2), ' ')
WHEN 32 THEN NVL((SELECT DESCR FROM PSBCDEFN WHERE BCNAME = I.OBJECTVALUE1), ' ')
WHEN 33 THEN NVL((SELECT DESCR FROM PSAEAPPLDEFN WHERE AE_APPLID = I.OBJECTVALUE1), ' ')
ELSE ' ' END AS DESCR
FROM PSPROJECTITEM I
WHERE PROJECTNAME ='PEOPLESOFT_PROJECT_NAME'
ORDER BY OBJECTTYPE, 2, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4;

Thomas, did you get any response for that, I'm basically trying to do the same "override Add Search Record" without having to clone Component Interface

by Gus (guest), 25 Nov 2021 23:36

Application engine is crashing when generating more than 1000 PDF files. Log file doesn't have any error.

Does anybody have any idea the cause and solution to this? Any help is greatly appreciated.

Thanks!

XML Publisher to PDF via Application Engine crashing by Ember (guest), 02 Sep 2021 10:06

I am trying to send a message from Postman to PeopleSoft 8.4 Financial using CustomerSync Message. It passes through the monitor message but it doesn't create a Customer or modify an existing customer.

I created a Postman node (External/Implicit) - I didn't put any connector as I am unsure what should be the proper Connector for this.
I am sending the message to the default local node of Financials.

So URL would be <host>:<port>/PSIGW/HttpListeningConnector?From=POSTMAN&To=<localnode>&MessageName=CUSTOMER_SYNC&MessageVersion=VERSION_1

but again it didn't create a customer. Are there any other setup I am missing?

Any help is greatly appreciated.

Thanks!

Third Party to PeopleSoft Financial 8.4 by PDCMagno (guest), 21 Jul 2021 01:36

I have an Asynchronous Message and when I call PUBLISH from Record Peoplecode,it is working fine and it is showing me DONE status in
Service Operations monitor.
However,when I try to use same peoplecode in Application Engine Peoplecode,it is showing me Service Operation in NEW status.

Does anybody have any idea what changes should I do to work from Application Engine Peoplecode?

Thanks

publish Asynchronous Message in Application Engine by Riad (guest), 02 Mar 2021 17:25
Lost admin password
Melba (guest) 28 Jan 2021 06:25
in discussion Forum / Help » Lost admin password

Is there a way to regain lost admin password in PSFT v7.5 ?

Lost admin password by Melba (guest), 28 Jan 2021 06:25
anas (guest) 04 Dec 2020 13:45
in discussion Forum / Help » Error message - please help

I got extensive experience as a representative of international cooperation in the Presidential Council . (From April \2017 to \ April 2020)

My activates includes:

Project coordinator with the Italian Agency for Development Cooperation, UNDP. United Nations Children's Fund (UNICEF) for 24 municipalities in “Recovery, Stability and Social -economic Development in Libya”

Chairman of the stalled infrastructure projects committee with the Public Projects Authority and the Administration Centers Development Authority

Coordination and preparation of international economic and technical conferences, and the most important was in Tunis, Berlin, Rome

Follow up and analyze the political situation on a daily basis, which includes international and local meetings, local and international newspapers

Following up the debts of foreign companies with foreign chambers of commerce

In addition, I have dealt with some representatives of foreign governments regarding the issue of immigration and local conflicts and their impact on the political, economic and security levels.

From (17th July 2010 to 31th of July 2016)

Starting work in Eni Saipem as Process engineer and Technical Director which Located in: Libya (Tripoli) / Italy (Fano)

My activates includes

Flow Assurance Engineer

SOR- Statement of required.

Risk Strategies.

Planning management definition

Qualifications that allow obtaining this position:

Extensive experience related to working with NGOs

Very Strong relationships with middle and upper administrations at the governmental level

constantly pushing to achieve high quality team performance to reach goals

Very punctual in meeting deadline and achievement results

Ability to manage multi stakeholder process

And regarding my skills, as a professional I credit my technical skills with hands on the following software’s and applications;

• Microsoft office (Full Package)

• Hysys Simulation Program

• PVT-Sim software

• OLGA Simulation Program

• EIM Documentation and Scheduling Program

by anas (guest), 04 Dec 2020 13:45

SELECT B.PRCSNAME,
RUNCNTLID,
—MAX(PRCSINSTANCE) +1 PRCSINSTANCE_PLUS_ONE,
— Y = MX+B
round(((REGR_SLOPE(PERCENTAGE_FAILURE, PRCSINSTANCE) * (MAX(PRCSINSTANCE) + 1) + REGR_INTERCEPT(B.PERCENTAGE_FAILURE, B.PRCSINSTANCE))),2) AS FAILURE_CHANCE ,
round(REGR_SLOPE(PERCENTAGE_FAILURE, PRCSINSTANCE),4)as slope ,
AVG_FAILURE
FROM
(SELECT PRCSNAME,
RUNCNTLID,
DECODE(RUNSTATUS,9,0,1) AS boolFAILURE,
COUNT( *) OVER(PARTITION BY PRCSNAME,RUNCNTLID ) AS TOTAL_RUNS,
(SUM(DECODE(RUNSTATUS,9,0,1)) OVER(PARTITION BY PRCSNAME,RUNCNTLID) / COUNT(*) OVER(PARTITION BY PRCSNAME,RUNCNTLID ))*100 AS AVG_FAILURE,
(SUM(DECODE(RUNSTATUS,9,0,1)) OVER(PARTITION BY PRCSNAME,RUNCNTLID ORDER BY PRCSINSTANCE)/ COUNT(1) OVER(PARTITION BY PRCSNAME,RUNCNTLID ORDER BY PRCSINSTANCE))*100 AS PERCENTAGE_FAILURE ,
COUNT(1) OVER(PARTITION BY PRCSNAME,RUNCNTLID ORDER BY PRCSINSTANCE) AS RUNNING_COUNT_OF_RUNS,
SUM(DECODE(RUNSTATUS,9,0,1)) OVER(PARTITION BY PRCSNAME,RUNCNTLID ORDER BY PRCSINSTANCE) AS RUNNING_COUNT_OF_RUNS_FAILURE ,
PRCSINSTANCE
FROM PSPRCSRQST

ORDER BY PRCSNAME,
RUNCNTLID ,
PRCSINSTANCE
) B
where TOTAL_RUNS >1
and PERCENTAGE_FAILURE >0
GROUP BY B.PRCSNAME,
RUNCNTLID ,
AVG_FAILURE;

SELECT B.PRCSNAME,
RUNCNTLID,
—MAX(PRCSINSTANCE) +1 PRCSINSTANCE_PLUS_ONE,
— Y = MX+B
TRUNC(REGR_SLOPE(RUN_TIME_SEC, PRCSINSTANCE) * (MAX(PRCSINSTANCE) + 1) + REGR_INTERCEPT(B.RUN_TIME_SEC, B.PRCSINSTANCE)) AS FORECASTED_TIME,

TRUNC(REGR_SLOPE(RUN_TIME_SEC, PRCSINSTANCE),3) AS SLOPE_COEFFICIENT ,
AVG_RUN_TIME_SEC ,
MIN_RUN_TIME_SEC ,
MAX_RUN_TIME_SEC ,
NCOUNT_RUN
FROM
(SELECT TRUNC(AVG( EXTRACT(DAY FROM (A.ENDDTTM -A.BEGINDTTM))*24*60*60 + EXTRACT(HOUR FROM (A.ENDDTTM -A.BEGINDTTM))*60*60 + EXTRACT(MINUTE FROM (A.ENDDTTM -A.BEGINDTTM))*60 + EXTRACT(SECOND FROM (A.ENDDTTM -A.BEGINDTTM))) OVER(PARTITION BY PRCSNAME, RUNCNTLID)) AS AVG_RUN_TIME_SEC,
MIN( EXTRACT(DAY FROM (A.ENDDTTM -A.BEGINDTTM))*24*60*60 + EXTRACT(HOUR FROM (A.ENDDTTM -A.BEGINDTTM))*60*60 + EXTRACT(MINUTE FROM (A.ENDDTTM -A.BEGINDTTM))*60 + EXTRACT(SECOND FROM (A.ENDDTTM -A.BEGINDTTM))) OVER(PARTITION BY PRCSNAME, RUNCNTLID) AS MIN_RUN_TIME_SEC ,
MAX( EXTRACT(DAY FROM (A.ENDDTTM -A.BEGINDTTM))*24*60*60 + EXTRACT(HOUR FROM (A.ENDDTTM -A.BEGINDTTM))*60*60 + EXTRACT(MINUTE FROM (A.ENDDTTM -A.BEGINDTTM))*60 + EXTRACT(SECOND FROM (A.ENDDTTM -A.BEGINDTTM))) OVER(PARTITION BY PRCSNAME, RUNCNTLID) AS MAX_RUN_TIME_SEC ,
EXTRACT(DAY FROM (A.ENDDTTM -A.BEGINDTTM))*24*60*60 + EXTRACT(HOUR FROM (A.ENDDTTM -A.BEGINDTTM))*60*60 + EXTRACT(MINUTE FROM (A.ENDDTTM -A.BEGINDTTM))*60 + EXTRACT(SECOND FROM (A.ENDDTTM -A.BEGINDTTM)) AS RUN_TIME_SEC ,
COUNT( *) OVER(PARTITION BY PRCSNAME, RUNCNTLID) AS NCOUNT_RUN,
TO_CHAR(BEGINDTTM,'DDD') ,
RQSTDTTM ,
BEGINDTTM ,
ENDDTTM ,
A.PRCSINSTANCE,
A.RUNCNTLID,
A.OPRID ,
PRCSNAME
FROM PSPRCSRQST A
WHERE
—PRCSNAME='ANZ2071A' AND
RUNSTATUS=9
ORDER BY BEGINDTTM
) B
GROUP BY PRCSNAME,
RUNCNTLID ,
AVG_RUN_TIME_SEC ,
MIN_RUN_TIME_SEC ,
MAX_RUN_TIME_SEC ,
NCOUNT_RUN

SQR report 6.2 printing chinese
bryan (guest) 18 Jun 2020 13:25
in discussion Forum / Help » SQR report 6.2 printing chinese

Our SQR version is very old 6.2 2000 and run on sun microsystem Solaris 10 and database is Sybase12.

We have tried some suggestions from newer version but fail.
like
(override option —(-zifD:\PT8.51\SQR\PSSQRCHN.INI ))
and pssqr.ini file .
/* Changes in pssqr.ini file /
ENCODING=UTF8
ENCODING-REPORT-OUTPUT=UCS2
ENCODING-DATABASE=UTF8
/
**/

If anyone with same or older version can succeed in printing chinese . please kindly share your setting.

SQR report 6.2 printing chinese by bryan (guest), 18 Jun 2020 13:25
bryan (guest) 18 Jun 2020 02:13
in discussion Forum / Help » sqr reports

Hi all,
I have SQR release 6.2 dateback to 2000.
Is there anyone know if it can suppport chinese char. printing.
We fail to print Chinese char and

(override option —(-zifD:\PT8.51\SQR\PSSQRCHN.INI ))
and pssqr.ini file .
/* Changes in pssqr.ini file /
ENCODING=UTF8
ENCODING-REPORT-OUTPUT=UCS2
ENCODING-DATABASE=UTF8
/
**/

Many thanks anyone has used that version or earlier version to print chinese successfully.

by bryan (guest), 18 Jun 2020 02:13
page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License