Stack Overflow
Stack Overflow

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
36
votes
4 answers

Updating a date in Oracle SQL table

I am trying to update a date in a SQL table. I am using Peoplesoft Oracle. When I run this query: Select ASOFDATE from PASOFDATE; I get 4/16/2012 I tried running this query UPDATE PASOFDATE SET ASOFDATE = '11/21/2012'; but it is not working. …
Stack Over
  • 371
  • 1
  • 3
  • 4
15
votes
5 answers

SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be used, but I'm not sure how.
John Doe
  • 1,950
  • 9
  • 32
  • 53
13
votes
2 answers

SOAP returns data, but C# says null response

My C# app won't give me anything but null results from SOAP calls. We have exposed some PeopleSoft ERP data with a SOAP web service. I am accessing this SOAP service from a Visual Studio 2012 ASP.NET C# app. I have a Service Reference named…
Aren Cambre
  • 6,540
  • 9
  • 30
  • 36
12
votes
2 answers

Standard web services API available in PeopleSoft?

I'm investigating integrating a 3rd party web application with PeopleSoft via web services. I'm not that familiar with PeopleSoft. After some initial investigation, it appears that in order to expose any PeopleSoft functionality as web services,…
sho222
  • 722
  • 1
  • 6
  • 14
8
votes
6 answers

Getting data out of PeopleSoft

We have a PeopleSoft installation and I am building a separate web application that needs to pull data from the PeopleSoft database. The web application will be on a different server than PeopleSoft, but the same internal network. What are my…
bmw0128
  • 13,470
  • 24
  • 68
  • 116
7
votes
10 answers

How can I speed up queries against huge data warehouse tables with effective-dated data?

So I am querying some extremely large tables. The reason they are so large is because PeopleSoft inserts new records every time a change is made to some data, rather than updating existing records. In effect, its transactional tables are also a…
aw crud
  • 8,791
  • 19
  • 71
  • 115
5
votes
3 answers

Is it possible to use jax-ws to generate xml, but NOT send it out

So here's the scenario: We have PeopleSoft and want to send messages back and forth from salesforce. Unfortunately PeopleSoft doesn't have a tool like wsimport which consumes a wsdl and generates classes for you. There is something that consumes…
willard
  • 252
  • 3
  • 10
5
votes
4 answers

Peoplesoft security

We want to give users peoplesoft portal access from outside network. But ..that access needs to be read only and very limited. Has anyone done location based role enabling is peoplesoft.. i.e. disable all roles and enable only particular role based…
ak
4
votes
1 answer

Query Manager: Trying to bring in the Manager's name

I'm using PeopleSoft's Query Manager to build a new hire report that brings in the manager's name. Unfortunately the Job - EE table captures the reports to position and not the manager. In an effort to get the manager's name I have to link to the…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
4
votes
0 answers

How to rebuild a Verity/PeopleSoft index?

We have a Verity K2 V6.1 file-based search system as implemented in RedDot LiveServer V3.1.1. The VerityDB folder (appears to hold search index) contains over 17,000 “.bif” (Verity’s ‘Bulk Insert File’ format) files that appear to contain…
Ryan Kreager
  • 3,571
  • 1
  • 20
  • 35
4
votes
1 answer

More efficient way to find employees with coverage between two dates

I have a requirement to retrieve a list of employees, and for each employee a list of months they were actively on benefits coverage in a given year. There is a table with job data, and a table with benefits information. There is also a delivered…
user2363207
4
votes
4 answers

Has anyone used version control on PeopleSoft?

We are looking at installing version control. We have found three that integrate with PeopleSoft: Phire, Grey Sparling, and Stat. Has anyone used these, and what experiences do you have with them?
Grant Johnson
  • 1,224
  • 10
  • 12
4
votes
1 answer

How do I dynamically size HTMLAREA objects in PeopleTools 8.50?

The organization I work for is upgrading from PeopleTools 8.47 to PeopleTools 8.50. We have run into a problem with HTMLAREAs. In 8.47, you were able to make a HTMLAREA on a page with as small a height as you wanted – saving page real estate within…
Nicholas Rule
  • 41
  • 2
4
votes
3 answers

SQL to Find Number of Weeks an Employee Was Active Between Two Dates

I have a table with a list of dates where an employee became Active/Inactive and I want to count the weeks that an employee was Active within a certain date range. So the table (ps_job) would have values like this: EMPLID EFFDT …
user2363207
3
votes
1 answer

How to get column names for SQL object in PeopleCode?

I have an iscript that runs one of a collection of previously created SQL statements, binds several parameters, and generates an XML result. The SQL used in each request varies in the number of parameters and the number of (and name of) columns…
jstur
  • 659
  • 6
  • 12
1
2 3
…
33 34