Stack Overflow
Stack Overflow

Questions tagged [peoplesoft-query]

14 questions
2
votes
2 answers

Peoplesoft Queries - range report

I'm new to Peoplesoft and their query tool. I'm used to SQL (in the Ceridian Powerquery environment and TOAD) and I'm wondering if you can create a range report (ex. 1/1/2016 to 12/31/2016)? There are some legacy reports in this environment and it…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
2
votes
1 answer

Running PeopleSoft Query with Excel VBA Hyperlink

I've used similar code below to run "public" PeopleSoft queries from Excel using VBA. When I look at the hyperlink produced from the code below, it is similar to the public queries we run with this method. The only difference is this is a…
Shaves
  • 884
  • 5
  • 16
  • 46
1
vote
3 answers

SQL Error, Code=1843, Message=ORA-01843: not a valid month (50,380). Matching format exactly using TO_CHAR(TO_DATE()) function

Goal is to extract YYYY from A.SCC_ROW_ADD_DTTM with format of DateTm Using peoplesoft Query Manager, adding an expression hoping to pull Year from a DateTm field. Running a query on the DateTm field displays date in the following format: 03/19/2017…
cody johnson
  • 21
  • 2
1
vote
1 answer

Using YEAR from Prompt entry in Date Selection Criteria

I'm trying to figure out how to use a YEAR entered via a prompt in a date selection criteria... so the user enters 2018 for the Balance_Year... and I want to look for the TAXFORM_DED record with an EFFDT between 01/01/YEAR and 31/12/YEAR. Where YEAR…
Heather Graham
  • 11
  • 1
1
vote
4 answers

Selecting the most recent date from a table in PeopleSoft using Peoplesoft Query (Max() doesn't work)

I am building a query in people soft using Peoplesoft query manager. I am trying to pull the most recent date from the date column. I have tried using max() as an expression, however, the query doesn't pull any records. I have checked with…
Ryan
  • 19
  • 2
  • 3
0
votes
0 answers

Crystal Report to BI conversion - Query Expression

We are currently in the process of upgrade to PeopleTools 8.56 and eventually to 8.59 and as such, we have to convert the Crystal Reports to BI publisher. In one of the Crystal reports, They have an expression as below and named it @Worked Worked is…
Vincent Ikaneng Vuma
  • 1
0
votes
0 answers

How to modify PeopleSoft Reporting Tools Scheduled Query Run Control

I am using Oracle's PeopleSoft Campus Solutions and I use Scheduled Queries to run data reports every morning. I am wondering if it is possible to adjust a run control (such as updating the Distribution List or Scheduled Run Time) without needing to…
psycoperl
  • 121
  • 1
  • 15
0
votes
0 answers

PeopleSoft - Query Manager - Use aggregate function with MAX

I have a query built from 2 different tables using joins and I want to keep the records that have younger date from rows with same ID. I tried to use WHERE clause on aggregate function but learned that I cant use it in WHERE clause. I tried to set…
Stribor50
  • 31
  • 1
  • 7
0
votes
2 answers

PeopleSoft Power Query convert inside of a Case statement

Okay I'm using PeopleSoft's Query Manager trying to write an expression. The original expression converted a date format into DD MON YY, here's the original expression that works: CONVERT(VARCHAR(10), A.TERMINATION_DT, 103) AS [DD MON YY] I need to…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
0
votes
0 answers

Create Blank Field in Peoplesoft Query Manager

I want to generate an output with blank/empty column with a "Select" query in oracle. I'm able to achieve this with below sql query: SELECT CustomerName AS Customer, "" AS Contact FROM Customers; How is this blank field ('' as Contact) created…
Michele
  • 1
  • 2
0
votes
1 answer

PeopleSoft Query and date prompts

I have a PS Query and one of its prompts is ADM_CREATION_DT where the condition is: This is a FROM date. All records starting from the selected date to the current date will be included in the report. Leaving this blank will default this to the…
Link
  • 171
  • 2
  • 19
0
votes
1 answer

cant we write subquery in select statement in peoplesoft queries

Cant we write sub queries in select statement of sql/views of peoplesoft as follows select t1.*, (select count(id) from t as t2 where t2.id<=t1.id) as row_number from t as t1 order by Id Thanks, Shyam
Shyam
  • 23
  • 1
  • 7
-1
votes
1 answer

Case Statement with multiple criteria for the then

Okay I'm writing an expression - it's a case statement. What I want is this, if an email address isn't in the G.EMAIL field, then I want the email address in the Q.EMAIL_ADDR - but only the 'OTHR' ones in that table. Right now my case statement…
Phlegon_of_Tralles
  • 181
  • 1
  • 14
-2
votes
2 answers

How can we make the fields unique in Query Manager in PeopleSoft?

How can we make the fields unique in Query Manager in PeopleSoft ?
Marco Parra
  • 1