Recent Forum Posts

From categories:
page »

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
Vonita (guest) 13 Jan 2016 22:12
in discussion Forum / Help » SQR Connect Error

It only works on 2 employees computer and they are pointing to the same p drive.

by Vonita (guest), 13 Jan 2016 22:12
Vonita (guest) 13 Jan 2016 22:10
in discussion Forum / Help » SQR Connect Error

Where would I check the sqr setting?

by Vonita (guest), 13 Jan 2016 22:10
nsr_dev (guest) 13 Jan 2016 19:45
in discussion Forum / General » PeopleSoft Interfacing with Concur

If anyone has done this, was Concur's web services with OAuth authentication used?

by nsr_dev (guest), 13 Jan 2016 19:45

i am facing the same issue..

by Faheem (guest), 11 Jan 2016 11:44
Telly (guest) 08 Jan 2016 14:57
in discussion Forum / Help » Instantiating an Excel Object from Peoplesoft page

Can you read an .xlsx file using this application? If so, what would the code look like? Thank you.

by Telly (guest), 08 Jan 2016 14:57

spro invoices routing to 'submitted' instead of 'submitted to suppliers' - i am facing issue in production. i.e manually created invoices through 'Manage Invoices' are routing to the supplier for approval..however the status shows as 'submitted' instead of 'submitted to suppliers' . i couldnt trace out what could be the reason. please let me know if any one had faced this.

Ramesh Danduri (guest) 01 Dec 2015 16:14
in discussion Forum / Help » ARUPDATE log message

I had to reset Process instance to 0 (Step 4) to resolve the issue.


The usual causes are due to some form of non-selection criteria or prior data corruption.

Summary Checklist: If any of these conditions is met (answer is Yes), then the group should post. If any is not met, the group will not be selected or if selected will not be posted.

1. Group Post Action is Set to Post Now or Post Later?

2. Group Accounting Date within Run Control Date Parameters?
Check date including century (e.g. 20-Feb-06 may mean year 0006 or 2006)

3. Group Post Status is NOT Set to 'Complete'?
GROUP_CONTROL.POST_STATUS <> 'C' means group already posted.

4. Customers, Items or Groups Process Instance = 0?
If the PROCESS_INSTANCE <> 0 then the record(s) are still locked by a prior process.

5. Group or Pending Item Accounting Dates in Open Period?
FIN_OPEN_PERIOD table. If period is closed, the group if selected will return an error code of 'C' (Closed Period).

6. PS_RP_PARALLEL does NOT contain records of groups?
If the group_Id is left-over in PS_RP_PARALLEL, it will not be selected in the next Receivable Update run. This table is used by running processes only and should ideally be empty once a processs is completed successfully.

7. Origin IDs PS_AR/PS_BI and Group ORIGIN_ID defined AND Group ORIGIN_ID Effective Date is earlier or equal to Group Accounting Date (e.g. Origin PS_AR 01-Jan-2005 Group 01-Feb-2005)?

8. Bill-To-Customer Effective Date earlier or equal to Pending Item effective date?

9. Setup > Install > Options > Receivables 'No Mult Pending Item Selection' is checked and Item or Pending Item is New?
Check if the process used the same item number as a previously posted item.

10. The Payment Terms setup has correct Timing ID defined?
Check the payment terms. Verify that Timing ID was set up, such as payment terms equal NET30, and a timing ID set up for 30. You must define payment terms timing IDs before you set up payment terms. To define payment terms and payment terms timing IDs, use the following pages: Payment Terms. Payment Terms Timing.

The trace file step AR_POSTING.TRM_DEFN.GET_DEFN would show 0 items if there is a setup issue.. This step refers to Payment Terms and their timing. The tables are: PS_RP_TRMBAS_TAO4, PS_PAY_TRMS_NET, PS_PAY_TRMS_TIME.

11. Item Payment Method is populated (Not Blank)?
PS_ITEM.PAYMENT_METHOD If blank, the payment referencing that item will not be posted.

12. PENDING_ITEM.DST_ID_AR is populated (not blank)?
If this field is blank and the group selected, you will receive an ACTOB (accounting entries out of balance) error.

13. ARUPDATE Generates Error 'Group (BUnnn,ID) to be Generated Already Exists. Group Type='?' and a group is not posted?
Check Document ID 620227.1 for more detailed analysis.

If all the above seem OK (all answers = Yes), then try:

Receivable Update with a NEW Run Control parameters (the current may be corrupted)

These are the tables you will need to check:

PS_PENDING_VAT (only if VAT is relevant to BU)

PS_CUST_OPTION where CustID = 'xxxxx'
PS_CUST_DATA where CustID = 'xxxxx'
PS_SUBCUST_DATA where CustID = 'xxxxx'

PS_ITEM where Item = 'xxxxx'
PS_ITEM_ACTIVITY where Item = 'xxxxx'
PS_ITEM_DST where Item = 'xxxxx'
PS_ITEM_ACT_VAT where Item = 'xxxxx'


by Ramesh Danduri (guest), 01 Dec 2015 16:14

Just for a quick sanity check, if you make any other changes to expire.html e.g. change/add some text somewhere etc does it take effect?

Just wondering if it is actually the same file that is loading in both cases, that's all.

Re: PeopleSoft Expire.html by PrajPraj, 26 Nov 2015 04:32
page »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License