Recent Forum Posts

From categories:
page »
Eswar (guest) 29 Apr 2016 06:18
in discussion Forum / Help » Connected Query passing prompt value w pcode

Hi Peoplesoft,

i have created connected query and generated xml file and also created RTF template but i my code was not working on push button filed change give some idea code related knowledge pls share .any one working on bi publisher connected query reports please help me .

by Eswar (guest), 29 Apr 2016 06:18

Hi Annie,

Please see the partner courses at PeopleSoft Tutorial:

Be sure to mention the PeopleSoft wiki for a discount.

by PrajPraj, 18 Apr 2016 22:30
Annie (guest) 18 Apr 2016 21:24
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

I like to take Peoplesoft training class. Can you please give me more details on the online tutorials? what are the fees and how long are the classes?

thank you,

by Annie (guest), 18 Apr 2016 21:24

I've seen this issue several times in other posts but haven't been able to solve it yet. Maybe you guys can shed some light here.

I'm trying to perform an Update for Component Interface "LOCATION" using the Java Object Adapter library (psjoa.jar) but I'm stuck with the following error when trying to save a NEW record:

"No rows exist for the specified keys. {LOCATION} (91,50), Failed to execute PSBusComp request , The highlighted field is required. You must enter a value for it before proceeding.{LOCATION.LOCATION_TBL(1).DESCR} (15,54), Error saving Component Interface. {LOCATION} (91,37), Failed to execute PSBusComp request"

If the record exists, no error arises BUT the location is not updated. I was able to create and update a Location through the web/online application but can't do the same from CI.

Most probably, this is caused by the Effective Date behavior of the table. The Application Designer shows that Location component has a LOCATION_TBL table at Scroll Level 0 and Scroll Level 1. Below are the arguments I'm passing to the "invokeMethod(sName, args)" operation of psjoa.jar:

// level 0
LOCATION :"T00001", 

// level 1
   LOCATION :"T00001", 
   DESCR: "My Test", 
   EFFDT: |2016-03-16|, 

I've read in a few places that Effective-dated components may require custom implementations using PeopleCode, an such. But I'm really no familiar with it and would also like to know if that is actually the case or if I am wrongly invoking the CI operation, passing the wrong arguments, etc.

Thanks in advance.

Effective Date CI: No rows exist for the specified keys by TheReporter (guest), 16 Mar 2016 14:48
Margaret (guest) 16 Feb 2016 20:41
in discussion Forum / Help » Schema not present in WSDL

I'm having the same issue as well. I'm trying to provide the delivered web service QAS_EXEQRY_SYNC_REQ_MSG but the import of the schema location QAS_EXEQRY_SYNC_REQ.VERSION_1.xsd doesn't work.

by Margaret (guest), 16 Feb 2016 20:41

Hi All,

We have an Issue while generating large XMLP report (invoices) for some users who have got special character (such as ö, á, ë) in their names. Application Engine program that creates large XMLP report in RTF/PDF (1K+ billing invoice lines), failed to generate report:
Caught exception: Error generating report output: (235,2309) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport
However, if try to run for less amount of billing invoice lines (e.g., 100+ instead of 1K), then report completes successfully and RTF file with the special characters has been generated in the report manager. This issue is caused while running the process in UNIX server but can able to generate report file while running in NT server(it is taking 2-3 hrs. of processing time in NT Server).

I have checked the PeopleTools System Control table(PSSTATUS record) and found the unicode_enabled flag as 0 (Non-Unicode).

Below are few scenarios, which we tried to fix this issue, but none of them worked!

We tried to increase the java heap size (512MB, 1GB,..,4GB) in app server and process scheduler config files and bounced the server:

App server config : JavaVM Options=-Xms512m -Xmx512m -Xrs -Dxdo.ConfigFile=%PS_HOME%/appserv/xdo.cfg
PSUNX config : JavaVM Options=-Xms4096m -Xmx4096m -Xrs -Dxdo.ConfigFile=%PS_HOME%/appserv/xdo.cfg

Later we have added stack size to our config settings as below:
JavaVM Options=-Xmx512m -Xms256m -Xss256K -Xrs -Dxdo.ConfigFile=%PS_HOME%/appserv/xdo.cfg

2. We have placed the special character fonts in the server and map those fonts in the xdo.cfg file as below (example):

<font family="Albany WT" style="normal" weight="normal">
<truetype path="/appl/psft/env/tst/fs91/fonts/truetype/ALBANYWT.ttf" />
And also created system temp directory in the server and mapped the location in xdo config file, under properties as below:
<property name="system-temp-dir">/appl/psft/env/tst/fs91/appserv/systemtempdir</property>

3. Also we have tried running the process with different character set while writing/generating the xml file. Such as UTF8, ASCII, Java, ISO_8859-1, ISO_8859-15,etc.,

An XML file is getting generated in process scheduler with junk characters in it and failed to generate the report in report manager.

Please let me know if any solutions/suggestions.

Thank you!

Bob (guest) 12 Feb 2016 04:08
in discussion Forum / Help » Remote Call Error

Do you have a think-time function in your ScrollSelect PeopleCode? Is it the remote call itself, or something like a messagebox?

by Bob (guest), 12 Feb 2016 04:08
Remote Call Error
GuiSAVALLGuiSAVALL 10 Feb 2016 20:52
in discussion Forum / Help » Remote Call Error


I have a very weird issue I don't understand with Application Engine using a RemoteCall peoplecode function for generating document sequence number.
- When the commit action for the step before RemoteCall is set to "After Step", the remote call is successful.
- When the commit action for the step before RemoteCall is set to "Default", the remote call is in error : Think-time PeopleCode event (Think-time PeopleCode event (R) invoked from ScrollSelect is illegal.

I can't find what is the problem, how I can fix it and it's driving me crazy…
Application Engine impacted are AR_UPDATE / AR_DIRDEBIT, for Peoplesoft FSCM 8.1

If you have some ideas It will be great.
Thank You!!!

Remote Call Error by GuiSAVALLGuiSAVALL, 10 Feb 2016 20:52

I need a SQL script to find out what the top 50 institutions we are sending transcripts to. In addition, which institutions are receiving transcripts from us that have been order both through the student/alumni student centre and also by paper request. If possible, I am looking for whether a percentage can also be tagged to the institution to show that Institution “ABC” has 33% of all transcripts sent to it.

Script - Find Insitution list for Transcripts by Andrew (guest), 09 Feb 2016 17:40
Tapas (guest) 06 Feb 2016 13:11
in discussion Forum / Help » Schema not present in WSDL

I am having the same issue, did you guys found a solution for this?

by Tapas (guest), 06 Feb 2016 13:11

This looks a lot like a bug to me, particularly if you look at the FieldDefault PeopleCode on SA_REQUEST_DTL.REQUEST_SEQ_NBR:

 If &SEQNO > 99 Then
      Error (MsgGet(14600, 217, "The maximum number (999999) has been assigned."));
      &SEQNO = 99;

The field is 5 digits in length (app designer), the error message suggests that the maximum is 999999 (6 digits) but if the sequence number is > 99 it is reverted to 99. I'd suggest customising that field edit to meet your requirements in this particular instance.

For further details and to book your spot today, please visit:

The course includes

  • Free bonuses worth $1750
  • Life Time online access to session recordings & training material
  • 15-day 100% money back guarantee


We have a custom process (ap engine) that inserts rows to a custom ps table, containing transcript requests harvested from a custom web app. A custom Component Interface was created based on component SSR_TSCRPT_RQST. This CI is crashing upon trying to insert to our table beyond a count of 99, due to FieldEdit peoplecode on field SA_REQUEST_DTL.REQUEST_SEQ_NBR.

Is there any valid reason why this field edit is in place? The field REQUEST_SEQ_NBR has type of 'number', to five integer positions. We have days where more than 99 transcript requests are captured.

Any input is appreciated! Thanks!

Hi, check to see if your SP_INVOICE Approval process - Supplier - User List has external Approver checked or not. Check that box and resubmit the invoice.

by Siva (guest), 18 Jan 2016 16:11
PrajPraj 14 Jan 2016 20:12
in discussion Forum / Help » SQR Connect Error

A few other things to check:

  • On the process scheduler in the psprcs.cfg file the DBBIN settings are correct for database connectivity
  • On the process scheduler ODBC settings are correct
  • On the client PC ODBC settings are correct and have connectivity

What's a bit strange with your case is that it works for *some* users but not all, which suggests the process scheduler itself is probably working ok, and it appears to be due to connectivity issues for certain client PCs, however if process are running through the process scheduler on those PCs, it shouldn't matter?

by PrajPraj, 14 Jan 2016 20:12
Vonita (guest) 14 Jan 2016 20:02
in discussion Forum / Help » SQR Connect Error

SQL Server. PSNT

by Vonita (guest), 14 Jan 2016 20:02
PrajPraj 14 Jan 2016 19:47
in discussion Forum / Help » SQR Connect Error

So to understand this correctly, on 2 employees computer's they can run an SQR process and it runs successfully in the process scheduler. For everyone else they get the SQR 1803 CONNECT error?

Which database platform are you using (SQL Server, Oracle?) and which process scheduler type (PSNT, PSUNX?)

by PrajPraj, 14 Jan 2016 19:47
Vonita (guest) 14 Jan 2016 17:39
in discussion Forum / Help » SQR Connect Error

The file does not show a server name or connection name. What should I be looking for?

by Vonita (guest), 14 Jan 2016 17:39
Vonita (guest) 14 Jan 2016 15:12
in discussion Forum / Help » SQR Connect Error

The pssqr.ini file is on the p drive but it is not my pc.

by Vonita (guest), 14 Jan 2016 15:12
PrajPraj 14 Jan 2016 07:49
in discussion Forum / Help » SQR Connect Error

You should be able to find the connection settings in your pssqr.ini file on the PCs where you have PeopleSoft installed. Check the settings there.

by PrajPraj, 14 Jan 2016 07:49
page »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License