peoplesoft

Are PeopleSoft Integration Broker asynchronous messages fired serially on the receiving end?

I have a strange problem on a PeopleSoft application. It appears that integration broker messages are being processed out of order. There is another possibility, and that is that the commit is being fired asynchronously, allowing the transactions to complete out of order. There are many inserts of detail records, followed by a trail...

Setting global_names parameter.

Greetings, My company uses Peoplesoft for its financials and HR. Our implementation is on Oracle databases. Setting global_names = TRUE forces you to name your database link the same as the target. My question is does anyone know the ramification of setting global_names to false in the init.ora parameter file? More specifically, I...

How do you configure your PeopleSoft Test Environments?

What are some the items you change in your test environments to make them standout from production, and how do you go about make these changes? I know you can change the PS LOGO, but what else do you change in your test environments? Colors, fonts, etc. Any good examples, links, how-to's would be much appreciated. ...

Working with effective dated records

How to fetch an Employees, say 5 latest Action_reason rows which are in an effective dated record, no future rows, should select only current and history rows(effective date <= sysdate). Can I fetch these in single row or will it be 5 rows for an Employee? select emplid, effdt, action_reasons -- we have to build a logic here. -- Should ...

Logging into Peoplesoft App-Designer in 2 Tier using LDAP authentication.

I have a database with LDAP login enabled. It works fine when logging in through the PIA or when logging into app-designer through the application server. I need to make app-designer allow me to login with 2-tier mode using LDAP authentication. Is this possible without customization? ...

Pagelets in PeopleSoft

Can we dynamically pass parameters for a Pagelet in tools 8.50? I am looking to create dashboards using Pagelets where the user needs to pass parameters on the fly ...

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 the options, and I welcome any recommendations. ...

SQL0100W Error on DB2

I get the following error when running an sqr report on DB2: SQL0100W - No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 The sql in question runs correctly when I paste it into RapidSQL, replacing the parameters. The sql in question is an insert-select. No rows are returned by t...

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? ...

Webservice returning text/plain whern text/xml is expected?

I need to use People Soft's component interface in order to communicate with People Soft. I can't find any sort of documentation for this so I'm having to go off an old version of software in house that interfaces with an old version of People Soft to learn it. The People Soft people I work with also don't know anything about the Compon...

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 on ip address or web server ? ...

Process scheduler runtime parameter

Hello, Can anyone recommend a fairly clean method for determining the process scheduler an app-engine is running on at run-time (NT or UNIX). I need to set a file path that is obviously dependent upon the server the process is being executed on. I understand the GetEnv command can be used, but I don't want to set an environment variab...

Is there a size limit for the SQL text in a PeopleSoft App Engine SQL Step/Action?

I'm getting the following error: AeSymResolveStatement [775] ... Meta-SQL error at or near position 34338 in statement (108,512). The SQL statement itself is over 40,000 chars long, hence the question. The DB is oracle. Running on Tools 8.49.24. ...

How to change mime type of email notifications sent by PeopleSoft?

I work near some PeopleSoft guys and they asked how to change a link in an email notification sent by PeopleSoft so that it is friendly, basically they just wanted the use of an HTML anchor. After sitting down with them and looking through the code I found that the default mime type for all email notifications is text/plain and there do...

porting enterprise one reports from crystal to jasper server framework

my employer is considering migrating our e1 reporting from crystal reports 10 to another solution. i want to use jasper server and i was wondering if there is a standard migration path or standard report package that we could use to make the task easier/faster. also, any experience shared about creating the user objects for jasper busine...

Learning JD Edwards Enterprise one

Can someone specify some good books for JD Edwards Enterprise one to get started and work on some hands on related stuff? ...

PeopleSoft Crystal process remains queued if part of PSJob

Hi I am being driven mad with some PeopleSoft jobs that I'm scheduling. Job Sets and PSJobs with Crystal will not initiate the Crystal processes. The process (or any other Cyrstal process I try) will run if scheduled independently but in any form of PSJob or Job Set they remain with teh first Crystal job status=queued. I've spent a ...

How do I dynamically size HTMLAREA objects in PeopleTools 8.50?

Hi, 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 the application designer. Any text input into the area would expand the area at ru...

PS Financials Payments tab VCHR_PAYMENT_PNL

In Payments tab fields are disabled, There is code behind it and I am trying to find to enable the fields for AP user role. I appreciate your help ...

Peoplesoft queries - performance

Hi, I'm facing a problem with PeopleSoft queries (using Oracle backend database): when a rather complex query involving multiple records is set off by a user, PS does an enforced join of security records, thus producing SQL like this: select .... from ps_job a, PS_EMPL_SRCQRY a1, ps_table2 b, ps_sec_rcd2 b1, ps_table3 c, ps_sec_...