Questions tagged [peoplesoft]

PeopleSoft is an Oracle ERP that has its pages generated from metadata. It has a development IDE for interaction with Application Engine programs, and PeopleCode. It also has legacy COBOL and Hyperion SQR code.

PeopleSoft is an Oracle ERP that has its pages generated from metadata. It has a development IDE for interaction with Application Engine programs, and PeopleCode. It also has legacy COBOL and Hyperion SQR code.

Oracle's Online PeopleBooks (documentation for PeopleSoft) http://www.oracle.com/pls/psft/homepage

An unofficial PeopleSoft wiki http://peoplesoft.wikidot.com/

499 questions
3
votes
0 answers

IN_VND_ITM_XLS Excel to CI - New field added to CI does not get inserted

I have added a new field into the IN_VND_ITM_XLS component interface, (BU_PRICE_STATUS), which is in a SQL View already part of the delivered template, ITM_VND_UMP_CVW. I modified the view (Record definition) in App Designer to pull in the…
Nick
  • 268
  • 8
  • 33
3
votes
1 answer

Peoplesoft CreateRowset with related display record

According to the Peoplebook here, CreateRowset function has the parameters {FIELD.fieldname, RECORD.recname} which is used to specify the related display record. I had tried to use it like the following (just for example): &rs1 =…
Coleman
  • 33
  • 3
3
votes
2 answers

Peoplecode - how to create cookies?

We are trying to create a cookie in the PeopleSoft Peoplecode by using the %Response object. However, the code we tried is failing. &YourCookie = %Response.AddCookie("YourCookieName", "LR"); Another snippet we tried to create the cookie Local…
VC1
  • 1,660
  • 4
  • 25
  • 42
3
votes
1 answer

peoplesoft schedule query to external server

Is it possible in peoplesoft to schedule a query daily and transfer the result file (for example in xls) to a server or to a local drive ? In other words to extract the result out of the peoplesoft application itself? I don't mean to transfer it by…
Bigjo
  • 613
  • 2
  • 10
  • 32
3
votes
1 answer

Log into Peoplesoft Using Web Service

I am trying to build a third party application which needs to be in sync with the PeopleSoft application. Is there any CI through which I can authenticate users into PeopleSoft database using web services? The authentication has to be from the third…
ayushman999
  • 511
  • 3
  • 6
  • 16
3
votes
1 answer

Regular expression for replacing everything after an underscore in a block of the URL

I have the following peoplecode to open a link in new window using new window logic in peoplecode. The following peoplecode and java functions does the job perfectly until a new window is tried to open from an already existing new window which…
Sat
  • 145
  • 1
  • 1
  • 14
3
votes
1 answer

User getting duplicate emails from Peoplesoft

One particular user is associated with 2 roles and those 2 roles are there in Workflow email list and so the user gets the same email twice. Is there anyway I could avoid this duplicate emails Thanks Gautham
gautham04
  • 53
  • 1
  • 3
3
votes
5 answers

PeopleSoft logins

I'm building a web application that will have access to PeopleSoft's database via jdbc. Is it possible that I can use PeopleSoft's id/password for my custom application, so users accessing my website will not have to have another username/password?
bmw0128
  • 13,470
  • 24
  • 68
  • 116
2
votes
1 answer

error finishes program instead of continuing

I have an application engine which has three steps: 1) peoplecode (load model user preferences) 2) do select & peoplecode (copy model user preferences into the preferences of a list of users) 3) peoplecode (append final results to the log) the…
Neets
  • 4,094
  • 10
  • 34
  • 46
2
votes
6 answers

What could be the cause of these java errors?

Does any1 have any idea what could be the cause of these java errors? The java version should be 1.4.1_05. This is related to PeopleSoft. "VM Thread" prio=5 tid=0x00B8EF28 nid=0x5f8 runnable "VM Periodic Task Thread" prio=10 tid=0x00CF4CF8…
user1037134
2
votes
2 answers

concat multiple strings of a column in different update statements

I need to update the column Remark that depends on the column in different update statements if it has an update and my code below doesn't work It also needs to be separated by a comma (,) UPDATE %Table(staging_tbl) S SET S.REMARK= %Concat(S.REMARK…
2
votes
3 answers

Integrating with people soft

I want to remotely query peoplesoft and fetch some data given user's credentials match. Is there a way to do this programatically? can I do it using python? If not, which language or tech would I need? Thanks in advance.
django
  • 77
  • 3
  • 11
2
votes
1 answer

Find User IDs not on OPRDEFN in PeopleSoft FIN

Our former security admin team off-boarded terminated users by deleting their user profiles from the system. We have changed that policy but there is potential for duplicates. I am attempting to find user ids on the various module tables that are…
2
votes
1 answer

How to interpret a PeopleSoft web server load test

I was conducting a load test on a PeopleSoft client's web server over the weekend. In all scenarios except the baseline scenario, I had a spike in errors around 4 mins into the test. In all scenarios the hits/s were different at this…
2
votes
1 answer

Using SQR to generate a Saved PDF document

I am using an older client/server version of PeopleSoft (7.53 Apps, 7.63 Tools) and trying to get my SQR to automatically generate and save a PDF document. Currently I can use a SQR Flag of -ZIV to open up the SQR Viewer which displays my output to…
Paul
  • 21
  • 1
1
2
3
33 34