PeopleSoft Integration Broker related articles, setups, tips and tricks.
Go To subscription node in PeopleTools >> Integration Broker >> Monitor Integrations >> Sub Contracts and get teh the PUBID of the message in DONE status
For PT 8.47 and lower run the below SQL to verify that the message status is DONE
select * from PSAPMSGSUBCON where PUBID=
Then run the update below:
update PSAPMSGSUBCON set STATUSSTRING='CNCLD', RETRYCOUNT=0, SUBCONSTATUS=8 where PUBID=
For PT 8.48 and higher, run the below SQL to verify that the message status is DONE
select * from PSAPMSGSUBCON where QUEUESEQID=
Applies to
PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO:Enterprise, Peopletools, PT8.48+
This document was previously published as Customer Connection Solution 201065338
***Checked for relevance on 27-APR-2010***
***Checked for relevance on 12-JAN-2012***
***Checked for relevance on 09-JUL-2014***
Symptoms
Step:1 PeopleCode:
Local File &MYFILE;
Local string &str_cnt;
Local string &FPath;
&str_cnt = "Record Name" | Char(9) | "Count";
&FPath = "\\psapsftt\TTEF\OneSource\PC-Inbound\Record.xls";
&MYFILE = GetFile(&FPath, "W", %FilePath_Absolute);
&MYFILE.WriteLine(&str_cnt);
Step2:Doselect
%SelectInit(RECNAME)
SELECT RECNAME
FROM %Table(PSRECDEFN)
WHERE RECNAME NOT IN (Record Names)
AND RECTYPE NOT IN (2,3,5) /*2 - Derived/Work 3- Sub-Record 5- Dynamic View */
Step:3:SQl
%SelectInit(COUNTER1)
SELECT COUNT(*)
FROM %Table(%bind(RECNAME))
Step:4:PeopleCode:
Write the code in PeopleCode Action:
Local File &MYFILE;
&PS_SERVDIR = (GetEnv("PS_SERVDIR")) | "/";
&FPath = &PS_SERVDIR | "file.txt";
&MYFILE = GetFile(&FPath, "W", %FilePath_Absolute);
&MYFILE.WriteLine(&Input);
&MYFILE.Close();
SQLExec(SQL.CSGC_DB_NAME, &NAME);
SQLExec("SELECT URL FROM %Table(:2) WHERE DISTNODENAME=:1", &NAME, Record.CDM_DIST_NODE, &URL);
&PRCSOUTPUTDIR = &URL | "/CSGC_CSHEET1.pdf";
ViewContentURL(&PRCSOUTPUTDIR);
ViewContentURL(“www.gmail.com”);
Write the code in PeopleCode Action:
&FileName =
&ret = GetAttachment("RECORD://CSGC_CSHT_ATACH", &FileName, "/" | &FileName, "PS_SERVDIR", True);
&PS_SERVDIR = (GetEnv("PS_SERVDIR")) | "/";
&FilePath = &PS_SERVDIR | &FileName;
If &ret = %Attachment_Success And
FileExists(&FilePath, %FilePath_Absolute) Then
&TxtFile = (GetFile(&FilePath, "R", %FilePath_Absolute));
While &TxtFile.ReadLine(&Input)
&Input = LTrim(RTrim(&Input, " "), " ");
End-While;
End-If;
&TxtFile.Close();
Write the code in RowInit:
Local Rowset &Xlat;
&FLD = GetRecord(Record.PY_IC_WRK1).GetField(Field.ACCOUNT_TYPE_DD);
&FLD.ClearDropDownList();
&Xlat = CreateRowset(Record.PSXLATITEM);
&Xlat.Fill("WHERE FILL.FIELDNAME = 'ACCOUNT_TYPE_DD' AND FILL.FIELDVALUE IN ('C','S')");
&Xlat_cnt = &Xlat.ActiveRowCount;
For &I = 1 To &Xlat_cnt
&CodeIn = &Xlat.GetRow(&I).GetRecord(1).FIELDVALUE.Value;
&DescIn = &Xlat.GetRow(&I).GetRecord(1).XLATLONGNAME.Value;
&FLD.AddDropDownItem(&CodeIn, &DescIn);
End-For;
If &MYRQST.Status = 0 Then /* if Schedule status is success */
&LOOP = 0;
While &LOOP = 0
SQLExec("SELECT A.DISTSTATUS, A.RUNSTATUSDESCR FROM PS_PMN_PRCSLIST A WHERE A.PRCSNAME = :1 AND A.PRCSINSTANCE = (SELECT MAX(B.PRCSINSTANCE) FROM PS_PMN_PRCSLIST B WHERE B.PRCSNAME = A.PRCSNAME)", &MyAppName, &POSTED, &STATUS);
If &STATUS = "Success" And
&POSTED = 5 Then /* Posted */
&LOOP = 1
End-If;
If &STATUS = "Success" And /* Not Posted */
&POSTED = 4 Then
Couple PeopleCode functions I came across. One insures a string consists of numbers and one insures a string consists of letters.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 23 weeks ago
2 years 28 weeks ago
2 years 28 weeks ago
2 years 29 weeks ago
2 years 30 weeks ago
2 years 30 weeks ago
2 years 32 weeks ago
2 years 34 weeks ago
2 years 37 weeks ago
2 years 43 weeks ago