Recent Forum Posts

From categories:
page 1123...next »
Record (Table) Name to Page Map
Jacob (guest) 16 Oct 2019 19:07
in discussion Forum / Help » Record (Table) Name to Page Map

Hello all,

I am new to Campus Solutions (am using 9.2), and am wondering if there exists a document that shows how the out-of-the-box Record (Table) Names map to various pages throughout the software. I am referrring to the Record (Table) Names shown at Set Up SACR > Common Definitions > Common Attributes Setup > Record Context. I understand that this would be a rather large/extensive document, but I figure it is worth asking.

I am being tasked with learning this software as quickly as possible, and am currently stumbling through how to use the Common Attribute Framework (CAF). If a document as outlined above exists somewhere, I imagine it will save me quite a bit of time in trail and error/research in learning where fields in specific tables can be found/displayed on various pages.

Hopefully my question isn't too vague. If so, I will try my best to add more detail. However, I am in the beginning stages of this learning process.

Thank you in advance for any help/rference you may be able to provide!

Record (Table) Name to Page Map by Jacob (guest), 16 Oct 2019 19:07
anku (guest) 16 Oct 2019 11:39
in discussion Forum / Help » Web Service Help

I am new to PeopleSoft Development, actually i am facing some issues that is, some application messages are stuck in working status and when i saw the details it seems no errors but in XML file it is showing one's oprid is reassigning to other user instead of submitting.I checked both oprid are in active status.I am not getting exactly what could be the issue. Could you please do needful regarding this.

Thanks in advance.

by anku (guest), 16 Oct 2019 11:39

I'm using the current case statement as an expression in my query to find service anniversaries. The why it's working now is if I run it anytime during September it's gives me employees whose anniversary is during September. I need to change the case statement so that when I run it in September, it gives me list of employees whose anniversary is in October. When I run it in October, I should get employee's whose service anniversary is in November.

Any help would be appreciated.

CASE
WHEN (ADD_MONTHS(B.SERVICE_DT, 60)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 5
WHEN (ADD_MONTHS(B.SERVICE_DT, 120)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 10
WHEN (ADD_MONTHS(B.SERVICE_DT, 180)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 15
WHEN (ADD_MONTHS(B.SERVICE_DT, 240)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 20
WHEN (ADD_MONTHS(B.SERVICE_DT, 300)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 25
WHEN (ADD_MONTHS(B.SERVICE_DT, 360)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 30
WHEN (ADD_MONTHS(B.SERVICE_DT, 420)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 35
WHEN (ADD_MONTHS(B.SERVICE_DT, 480)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 40
WHEN (ADD_MONTHS(B.SERVICE_DT, 540)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 45
WHEN (ADD_MONTHS(B.SERVICE_DT, 600)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 50
WHEN (ADD_MONTHS(B.SERVICE_DT, 660)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 55
WHEN (ADD_MONTHS(B.SERVICE_DT, 720)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 60
WHEN (ADD_MONTHS(B.SERVICE_DT, 780)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 65
WHEN (ADD_MONTHS(B.SERVICE_DT, 840)) BETWEEN (TO_DATE((TO_DATE((ADD_MONTHS(LAST_DAY(SYSDATE),-1)), 'YYYY-MM-DD') + 1),'YYYY-MM-DD')) AND (TO_DATE ((LAST_DAY(SYSDATE)),'YYYY-MM-DD')) THEN 70
ELSE 0 END

sony (guest) 14 Aug 2019 10:47
in discussion Forum / Help » PSQUERY App Engine email query results

Hey anyone can help on this? I am not receiving email with attachment. What confi should i tell admin to check w.r.t SMTP server?Please put your thoughts.

by sony (guest), 14 Aug 2019 10:47
NAG (guest) 13 Aug 2019 16:20
in discussion Forum / Help » SQRs completing, but showing Error in process scheduler

I am having same issue, can you please let me know any solution for this.

by NAG (guest), 13 Aug 2019 16:20

SET SERVEROUTPUT ON SIZE 100000

DECLARE
match_count INTEGER;
BEGIN
FOR t IN (SELECT owner, table_name, column_name
FROM all_tab_columns
WHERE owner = 'FSUSER' and data_type LIKE '%CHAR%' and COLUMN_NAME like '%SERVER%') LOOP

EXECUTE IMMEDIATE
'SELECT COUNT(*) FROM ' || t.owner || '.' || t.table_name ||
' WHERE '||t.column_name||' = :1'
INTO match_count
USING 'PSNT';

IF match_count > 0 THEN
dbms_output.put_line( t.table_name ||' '||t.column_name||' '||match_count );
END IF;

END LOOP;

END;

data finder sql by RahulAgrawalRahulAgrawal, 09 Aug 2019 08:51

I need to develop a query for Admissions where they can see the ADMT row and corresponding Action Reason, even if the person has been Matriculated. The MATR row covers up the ADMT/Action Reason. Can anyone help?

creating a query to get the row *prior* to MATR by Janet Renze (guest), 15 May 2019 15:56
danry (guest) 15 May 2019 02:36
in discussion Forum / Help » Connected Query passing prompt value w pcode

Thanks, it worked.

by danry (guest), 15 May 2019 02:36
Thomas (guest) 19 Apr 2019 11:11
in discussion Forum / Help » Overriding a Component's Search Record for a Component Interface

Yeong (or anyone else), have you figured out how to override the component's Add Search Record when running a component interface? When the CI executes we want users to be able to insert a new row into a component that typically they wouldn't be able to online because of business unit security. ie if they went online to "Add" a row, they wouldn't have the business unit available to choose on the Add Search record…but if we are adding it through the CI we want it to ignore BU Security. As it stands when the CI executes it says prompt value is invalid since the create keys are specifying a BU that they don't have access to….

Thanks!

by Thomas (guest), 19 Apr 2019 11:11

SELECT distinct ROUND(a.FILE_SIZE/(1024*1024)) as SIZE_MB,
a.prcsinstance,
b.prcsname,
b.oprid,
b.RUNCNTLID,
C.DESCR,
—,
—c.descrlong
outputdir
FROM PS_CDM_FILE_LIST a,
PSprcsrqst b,
PS_PRCSDEFN C,
PS_CDM_LIST D
WHERE ROUND(a.FILE_SIZE/(1024*1024)) >100
AND b.prcsinstance =a.prcsinstance
AND b.PRCSTYPE =c.PRCSTYPE
AND C.PRCSNAME =b.PRCSNAME
and d.prcsinstance =a.prcsinstance
order by prcsinstance desc

SELECT servername,
listagg(PRCSCAtegory
||'#Prty-'
||DECODE(prcspriority,1,'Low',5,'Medium',9,'High')
||'#maxc-'
||maxconcurrent, ',') within GROUP (
ORDER BY PRCSCAtegory) AS PRCSCATEGORY_CONCURRENT
FROM ps_servercategory
WHERE servername NOT IN ('PSOS390','PSCDB','PSNT4','PSNT5')
GROUP BY servername;

SELECT servername,
listagg(prcstype
||'-'
||'#Prty-'||DECODE(prcspriority,1,'Low',5,'Medium',9,'High')
||'#maxc-'
||maxconcurrent, ',') within GROUP (
ORDER BY prcstype) AS Swim_lanes
FROM PS_SERVERCLASS
WHERE servername NOT IN ('PSOS390','PSCDB','PSNT4','PSNT5')
GROUP BY servername;

SET echo ON;
SET serveroutput ON;
DECLARE
BEGIN
FOR i IN
(SELECT DISTINCT TABLE_NAME,
num_rows
FROM all_tables c
WHERE TABLE_NAME IN
(SELECT table_name
FROM dba_TAB_STATISTICS
WHERE STALE_STATS='YES'
AND owner ='FSUSER'
—and num_rows between 100000 and 500000
)
)
LOOP
dbms_output.put_line(TO_CHAR(sysdate,'dd-mon-yyyy:hh24:mi:ss')||' start '|| i.table_name);
IF i.num_rows <5000000 then
dbms_stats.gather_table_stats('FSUSER',i.table_name);
END IF ;
dbms_stats.gather_table_stats('FSUSER',i.table_name,estimate_percent => dbms_stats.auto_sample_size,degree => 32,METHOD_OPT =>'FOR ALL INDEXED COLUMNS SIZE 1');
dbms_output.put_line(TO_CHAR(sysdate,'dd-mon-yyyy:hh24:mi:ss')||' end '|| i.table_name);
COMMIT;
END LOOP;
END;
/

Can anyone help me to write a PS query expression to get only Date and Month from Birthdate? We are using PS 9.2

Gary Chismar (guest) 11 Dec 2018 20:06
in discussion Forum / Help » Retrieve Multiple Rows from a Single CreateSQL /SQL Fetch into a Variable

Did this ever get resolved? If not, what database / version are you on? Oracle has a function that will retrieve multiple rows of data into one row with a separator. That comes to mind after reading this post. I believe it is call LISTAGG. If you search for Oracle with LISTAGG you should find what you are looking for. That is, if my assumption is correct.

by Gary Chismar (guest), 11 Dec 2018 20:06
Anand (guest) 06 Dec 2018 06:06
in discussion Forum / Help » CI Based Web Service - Generic Error messages generated

This may be because of the reason that the connector properties of the routing of the given service operation is not configured properly. Please make sure the primary URL of the connector property is configured properly. I faced the same issue and in my case the URL was not correct.

by Anand (guest), 06 Dec 2018 06:06

Hi,
We've reached the limit of an int field (int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) 4 Bytes)
SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'UPM'
2147483647
and getting the error "Arithmetic overflow error converting expression to data type int." when running an application engine job to create user profiles.
What can we do? Our immediate thoughts are to
1. Change int to bigint for the field VERSION on table PSVERSION
2. Reset the Version number for UPM to 0
However, we do not know the impact of doing this.
Also contacted Oracle for resolution
Peter

Limit reached on PSVERSION.VERSION field by Peter Morris (guest), 04 Dec 2018 22:12
Ricky (guest) 24 Oct 2018 17:43
in discussion Forum / Help » Connected Query passing prompt value w pcode

Works! Thanks!

by Ricky (guest), 24 Oct 2018 17:43

I haven't been able to get a clear answer on this and I am hoping someone here can help. I have an App Engine Program that I am modifying the PeopleCode and I have a CreateSQL function that I know will sometimes result in more than 1 row being returned (at least in the DBMS/SQL Server). My question is whether the &SQL.Fetch(&UOMResult) will store all resulting row values into a variable in a single fetch (non-looping), or am I required to loop through and can only select a single row/value per iteration? Ideally I would like to be able to use the first method and evaluate all the values retrieved in a single fetch against another variable in the program. Is this possible and how do I access each row returned and do a comparison? I wasn't sure if some type of array might be required.

I would like to get the result set (1 column/1 or more rows) and then use an If statement to compare the value(s) in the &UOMResult variable to another variable called &UOM, and do some logic on it, else do other logic. I can provide additional clarification if needed. Thank you for any feedback / code examples you can provide.

SQR 3203 file writing issue
Vins (guest) 13 Oct 2018 12:27
in discussion Forum / Help » SQR 3203 file writing issue

I am running a process in which we are processing many employees but for any certain employee I am getting sqr 3203 file writing error.
Please help me as if it is file issue i should get it for first employee itself

SQR 3203 file writing issue by Vins (guest), 13 Oct 2018 12:27

In Service Operations Setup there is an option to check "User/Password Required".

If I do not check it I can make a simple call with this body and it works fine:

<?xml version='1.0' encoding='utf-8'?>
<Envelope xmlns:s1='test'>
<Header/>
<Body>
<GetCompIntfcPO_EXPRESS_CI >
<BUSINESS_UNIT>US001</BUSINESS_UNIT>
<PO_ID>TEST</PO_ID>
</GetCompIntfcPO_EXPRESS_CI >
</Body>
</Envelope>

But when I check that box I get this:

User Password required for Service Operation CI_PO_EXPRESS_CI_G. (158,535)

Which is OK, just telling me to fill in the header. Here is the header I add:

<Header/>
<Security>
<UsernameToken>
<Username>VP1</Username>
<Password>VP1</Password>
</UsernameToken>
</Security>
</Header>

Which as far as I can tell is correct. But PeopleSoft gives me the exact same error, as though it does not even bother to read the Header data.

Is there something else required? Do I need to fill in HTTP headers as well?

page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License