Recent Forum Posts

From categories:
page 1123...next »

Within PS Application Designer (PT8.53) I created a CXCR_ID field with a type of Number and integer positions of 10. I inserted this field into a new view, setting the Record Field Properties to a Key, Search Key, and List Box Item. Within the Edits tab I set checked the Required checkbox.

Within the SQL Definition I defined the column as follows:

ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS 'CXCR_ID'

I then built the view. In MicroSoft SQL Server Management Studio (SQL Server 2008 R2) the field is listed as CXCR_ID(int, null). I would like the field to be defined as CXCR_ID(int, not null).

Does anyone know how to create the view in PS Application Designer so that the field is listed as CXCR_ID(int, not null)?

Thank you,
Steve

by PrajPraj, 15 Jul 2014 22:02
Praveen (guest) 15 Jul 2014 21:52
in discussion Forum / Help » How to hide CANCEL button while using domodalcomponent function.

Sorry I meant can you all repost the link by any chance.

by Praveen (guest), 15 Jul 2014 21:52
Praveen (guest) 15 Jul 2014 21:51
in discussion Forum / Help » How to hide CANCEL button while using domodalcomponent function.

This link did not work, can you all leave.
Thanks
Praveen Sudarsanam

by Praveen (guest), 15 Jul 2014 21:51
Siva Teja (guest) 13 Jul 2014 18:26
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hello Team,

Good Day!

Could you let me know is there any basic requesties(any other basic level course to understand peoplesoft) to learn "Peoplesoft".

Thanks in advance.

Regards,
Siva Teja

by Siva Teja (guest), 13 Jul 2014 18:26

When I search "DataStage" here, I get nothing! Are there some resources regarding the relationship between PeopleTools and DataStage? Specifically, I'm looking for a discussion of PeopleTools 8.53 and which version(s) of DataStage for Peoplesoft are supported on this release, potential issues to avoid, etc.

DataStage for PeopleSoft resources by David (guest), 10 Jul 2014 20:41
Scott Eastin (guest) 09 Jul 2014 16:03
in discussion Forum / Help » Consume PeopleSoft CI in .Net WCF Client

Thanks, this article solve it.

weblog.west-wind.com WCF-WSSecurity-and-WSE-Nonce-Authentication

by Scott Eastin (guest), 09 Jul 2014 16:03

Hi Scott,

Do you happen to know if there are any errors in the Application Server or Integration Broker logs that come up when you send your request?

Do you get an error message, or simply told that that you don't have the credentials? I'm assuming you've checked user/permission list security. Also have you confirmed security for the service operation is correct?

Praj

giri kalyan (guest) 05 Jul 2014 07:06
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

i want to join in peoplesoft training, i'm a Electrical engineering student can u give me which one similar to my course.

by giri kalyan (guest), 05 Jul 2014 07:06
PrajPraj 03 Jul 2014 20:55
in discussion Forum / Comments » PSPad Meta-SQL syntax file

Unfortunately I have well and truly moved on from using PSPad since first posting this thread :)

I now use Sublime Text as my text editor (which is available on Windows, Mac and Linux) and there is an excellent plugin available called PeopleCodeTools available for syntax highlighting and working with trace files.

by PrajPraj, 03 Jul 2014 20:55

All,

I am trying to make a .net WCF call that I think should be simple but has proved incredibly difficult. I could really use some help and in full disclosure I am a WCF newbie. Here's the scenario:

I am trying to call a PeopleSoft CI web service, from C#, that is secured with a user name and password on the PeopleSoft side.
The core problem is that the security headers, such as username and password, are not being sent correctly to the PeopleSoft web service.

I have done a lot of research and made a lot of attempts over the last several days and made some progress but the bottom line is that I can not get this to work.

The items presented below are my original starting blocks and I will not cloud the thread with all of the options I have tried.
The original WSDL pointed to a standard HTTP site. I have tried this with HTTPS as well thinking this would solve the problem. No luck

The web service schema is the following:

<HEADER>
<USERID>myID</USERID>
<PASSWORD>????</PASSWORD>
<LANGUAGE_CD>ENG</LANGUAGE_CD>
</HEADER>
<that>Ithid</that>
<Strcurrent_action>target</Strcurrent_action>
<Strnew_action>action</Strnew_action>
<StractionConfirm>action</StrpasswordConfirm>
</MyActionThisStuff_SELF>
I generated the C# class and config file from svcutil. The app.config appears as such:

<system.serviceModel>
<bindings>
<basicHttpBinding>
<binding name="MyStuff_Binding" />
</basicHttpBinding>
</bindings>
I make the call with the following code:

MyStuff_PortTypeClient client = new MyStuff_PortTypeClient("MyStuff_Port"); client.ClientCredentials.UserName.UserName = "MyLogon"; client.ClientCredentials.UserName.Password = "MyPassword";
MyActionCompIntfcUSER_PROFILETypeShape actionShape = new MyActionCompIntfcUSER_PROFILETypeShape(); UserIDTypeShape targetUser = new UserIDTypeShape(); try {client.MyStuff_MyAction(actionShape); //Make the call}

As I mentioned I have tried this numerous ways including changing the security, message and transport options in basicHttpBinding, trying this with wsHttpBinding,custom headers etc…and no joy.

I would really appreciate any assistance and successful examples of how to call a PeopleSoft web service secured with a user name and password over http or https.

Thanks

Consume PeopleSoft CI in .Net WCF Client by Scott Eastin (guest), 03 Jul 2014 19:21
juan (guest) 03 Jul 2014 12:37
in discussion Forum / Comments » PSPad Meta-SQL syntax file

Yes please you may as well do it and post it.

by juan (guest), 03 Jul 2014 12:37
Jacquelynn (guest) 01 Jul 2014 13:44
in discussion Forum / Help » Writing a Date expression in PS Query

Figured that one out but now need to do the following:

Only retrieve employees on Action of LOA 10 business days in the past. How would I do write this so I can schedule the query to run daily. Thanks.

by Jacquelynn (guest), 01 Jul 2014 13:44
Jacquelynn (guest) 01 Jul 2014 13:21
in discussion Forum / Help » Writing a Date expression in PS Query

How do I enter an expression in PeopleSoft query to subtract 10 business days from the job data action date?

by Jacquelynn (guest), 01 Jul 2014 13:21

To find the privileges (grants) on a particular table or view in Oracle use the following query:

select *
from table_privileges
where table_name = '<PS_EXAMPLE>';

Very handy as it tells you what privileges that user has (e.g. select, insert, delete, update, references, alter, index) as well as who granted the privileges.

Ram (guest) 23 Jun 2014 04:32
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hi,

I am B-tech(c.s.e) background student.

I want to learn peoplesoft ,dont have any idea about that can u suggest it good for me or not.

by Ram (guest), 23 Jun 2014 04:32
mozhibharathi (guest) 19 Jun 2014 09:19
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

hi all,

having 6 years incluing online training for peoplesoft hrms functional. if anyone required kindly contact 7708351597 or mail id. giving more than 8 module training with realtime exp if require will guide you the testing practice for the same domain.

will provide Mockup interview, sample PeopleSoft HR or PS HRMS Tester profile , Peoplesoft softcopy , Assignment with Assessment for the following topics: Introducton and Basic Terms,ESS,MSS,CoreHR, AWF,Eperf,NA Payroll, Absence Mgmt and Benefits etc..

by mozhibharathi (guest), 19 Jun 2014 09:19
PeopleSoft Guest (guest) 16 Jun 2014 22:51
in discussion Forum / Help » BI Publisher - Run with Excel Format

Thanks Praj.

In PeopleSoft 9.2, I updated the report definition properties (PeopleTools Settings > psxp_excel_outputformat) to XLS-MHTML as you suggested. Afterwards, I was able to run the report into one Excel sheet. Thank you

by PeopleSoft Guest (guest), 16 Jun 2014 22:51

Does it make any difference if you change the report definition properties to say XLS-MHTML format (if you have that option?).

BI Publisher - Run with Excel Format
PeopleSoft Guest (guest) 16 Jun 2014 18:31
in discussion Forum / Help » BI Publisher - Run with Excel Format

When running a BI Publisher and selecting XLS format, the Excel file created has multiple sheets. Every page break on the report generate a new sheet in the same workbook. Is there a way to create just one Excel sheet?

BI Publisher - Run with Excel Format by PeopleSoft Guest (guest), 16 Jun 2014 18:31
page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License