Recent Forum Posts

From categories:
page »

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

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)
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

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'>
<GetCompIntfcPO_EXPRESS_CI >
</GetCompIntfcPO_EXPRESS_CI >

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:


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?

Are all of the user profiles tied back to an EMPLID in PSOPRDEN. If so, I can imagine a query that links PSOPRDEFN and PSROLEUSER to come up with a distinct list of roles that each user should have based on the combination of the roles all of their accounts had. From there, you'd have to determine how to programmatically choose which profile will be the one that is kept. You would then insert the necessary rows into PSROLEUSER. Unfortunately, I think that's the "easy" part.

The harder part would be all of the row level permissions, favorites, user defaults, etc. *IF* you knew where all of those things were stored, I guess you could do something similar to above.

Besides that, there are numerous places where a user name may be hard coded (e.g. process notifications, BI report group security, etc.). Those may need to be updated to refer to the proper user.

I'm in the same situation. If anyone comes up with a solution, I'd love to see it.

We currently have some users with two or more user profiles that we need to merge into one user profile. Has anyone had this situation before? If so, how did you tackle it? I wondered about using ExcelToCI however that will require creating a new component interface which we're not looking to do. There are a lot of them so we're not wanting to do it manually either. Ideas? Thoughts?

Merge User Profiles, PeopleSoft 9.0, PT 8.54 by Tracy (guest), 21 Sep 2018 15:21
Dave (guest) 06 Sep 2018 20:43
in discussion Forum / Help » Connected Query passing prompt value w pcode

Just wanted to say thank you to Johan for writing this article. I'm new to PeopleSoft and just spent two weeks trying to get a connected query BI Publisher report working from Process Scheduler. This write up gave me the information I needed to make it work.

by Dave (guest), 06 Sep 2018 20:43
Henrique (guest) 04 Sep 2018 16:56
in discussion Forum / Help » Creating Error Messages

Hi! The second message box appears because you are using two "message triggers", error and messageBox. Remove the "error" and set your message catalog priority to error, and the problem should be resolved.

by Henrique (guest), 04 Sep 2018 16:56
Carmen (guest) 13 Aug 2018 17:22
in discussion Forum / Help » Strange Behaviour of PeopleCode Global Variables in Firefox

This post is from 2009, but we are seeing this now in peoplesoft CS 9.2 PT 8.55. Did you ever find anything out related to this?

by Carmen (guest), 13 Aug 2018 17:22
Venkata Ghantasala (guest) 11 Aug 2018 16:02
in discussion Forum / Help » BI Publisher - Run with Excel Format

Using BI Publisher (PeopleSoft), can I create a Excel template with output as excel?

by Venkata Ghantasala (guest), 11 Aug 2018 16:02

I built the Connected Query and the RTF document and would like to send to target population but don't know how with Commgen. Does anyone have links to sites explaining process?

Jasmine (guest) 01 Jun 2018 17:46
in discussion Forum / Help » PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion made easy

How to transport Peoplesoft Crystal reports to Oracle BI Publisher report via Automation

With Oracle announcing the end of support for Peoplesoft based crystal reports following the end of Premier Support for 9.1 applications, customers are now evaluating multiple reporting tools to take advantage of the new reporting and analytic capabilities that PeopleSoft offers.
Oracle Business Intelligence Publisher (BI Publisher) is the preferred choice by customers.
Converting reports from Peoplesoft Crystal to Oracle Business Intelligence Publisher can be achieved through an automated process.
Deploying Automation tools not only brings in the advantages of speed, cost and quality, but also preserves years of efforts in designing the report sections /layouts when migrating to Oracle BI Publisher reports.
Four simple steps for report conversion.
1. Rationalization
2. Prioritization
3.Migration automation
4. Deployment

by Jasmine (guest), 01 Jun 2018 17:46
Shashi kant singh (guest) 28 Apr 2018 13:59

can you tell me how to install peoplesoft hcm and peoplesoft on localhost
i will be thankful to you

by Shashi kant singh (guest), 28 Apr 2018 13:59

I have question.

I add criteria field is character when running a Query Manager.
page display Database Driver Error. (30,11).

I want to add criteria not required for search data I should to use field is character or number.

Hi all so I have an assignment for my class but I don't know how create a parent of an existing case as it keeps reloading the site also what is a good summary for descriptions what are some questions I could ask? and I really don't know how to make Parent case to a child case on PeopleSoft any help is much appreciated.


Devwfb (guest) 01 Feb 2018 08:16
in discussion Forum / Help » PeopleSoft Grid - Use tab issue

This is related to an ActiveX control which is not registered properly. To prove it, select an entry from one of the "Label Image", an error message "Cannot display image preview" will be prompted, and the explanation to the error is "The ImgDisplay ActiveX control may not be properly registered. Use the Install Workstation functionality of the Configuration Manager to register this control." This means the whole Use properties tab showing blank values is because the error of ActiveX control.

It is quite easy to fix it, just follow the steps below:

1) Locate The ImgDisplay ActiveX control. It is in PT_HOME\bin\client\winx86\ImgDisplay.ocx
2) Unregister it: open a command window, execute: regsvr32 /u PT_HOME\bin\client\winx86\ImgDisplay.ocx
3) Re-register it: on the command window, execute: regsvr32 PT_HOME\bin\client\winx86\ImgDisplay.ocx
4) Reopen the app designer, you should be able to see setting values on Use properties tab now.

NOTE: there are 2 versions of regsvr32.exe in a 64bit Windows OS:
1) c:\windows\system32\regsvr32.exe, this is 64 bit version
2) c:\windows\sysWOW64\regsvr32.exe, this is 32 bit version
Depending on your tools version, you need to use correct version of regsvr32.exe to re-register the ActiveX control.

Hope this helps.

by Devwfb (guest), 01 Feb 2018 08:16
page »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License