Recent Forum Posts

From categories:
page 1123...next »
Bob (guest) 19 Aug 2014 23:31
in discussion Forum / Help » PeopleSoft Grid - Use tab issue

Have you cleared you App Designer cache?

by Bob (guest), 19 Aug 2014 23:31
S Douglas (guest) 19 Aug 2014 13:29
in discussion Forum / Help » PeopleSoft Grid - Use tab issue

I just had this problem appear - even though things have looked good in the past. Has anyone come up with a solution?
Using People Tools 8.52.12 on a Windows Server 2008 R2 Standard Service Pack 1

by S Douglas (guest), 19 Aug 2014 13:29
Query for users online
Alberto (guest) 15 Aug 2014 21:16
in discussion Forum / Help » Query for users online

Hello peopple.
I have a question for you….

I want to know how many persons are connected to the web of pepplesoft, and from where they are connected..

Do you know wich is the query that i have to run on the Oracle DATA Base ?

I hope you can help me on this question..

Thanks in advance.

Query for users online by Alberto (guest), 15 Aug 2014 21:16
Goutham (guest) 11 Aug 2014 14:24
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hi,

This is Goutham,am a peoplesoft technical consultant having two years of experience in one of the reputed companies in Bangalore.
Can anyone tell me ,Is there Good Peoplesoft Training institute In Banglore?
Or Can any faculty is available to teach Technical/Functional online?

Regards,
Goutham.

by Goutham (guest), 11 Aug 2014 14:24

Interestingly if you try to do a MessageBox before a Transfer call, it won't appear. This is due to the fact that the MessageBox call doesn't get a chance to be called as the Transfer has already taken place. You *could* track this with a global variable and display a message after the transfer, or quite simply you can use WinMessage instead.

Message before Transfer by PrajPraj, 08 Aug 2014 09:42
Jyotshna (guest) 08 Aug 2014 06:29
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hi,

I am looking for peoplesoft finance training Fast track only,Please give details of online/class room Training. Finance (GL,AP,AR,AA).

Thanks & Regard
JU 9975731111

by Jyotshna (guest), 08 Aug 2014 06:29

I am trying to install Peoplesoft HCM9.2 with Peopletools8.53 in my laptop(Windows-7 64 bit).I have installed tuxedo,weblogic server ,Peopletools and HCM and then
created database by editing scripts(dbowner.sq,createdb10.sql etc).I have an issue when logging in datamover its showing error message as below
File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12154 - ORA-12154: TNS:could not resolve the connect identifier specified
I have wasted 2 days of rectifying this issue.Please help me to solve this.I have installed Oracle client too and set DDBIN pointing to "C:\app\ACER\product\11.2.0\client_2\BIN" in configuration manager

tnsname.ora file

  1. tnsnames.ora Network Configuration File: C:\app\ACER\product\11.2.0\dbhome_1\NETWORK\ADMIN\ tnsnames.ora
  2. Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

PSHRDEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSHRDEMO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
listener.ora file

  1. listener.ora Network Configuration File: C:\app\ACER\product\11.2.0\dbhome_1\network\admin\ listener.ora
  2. Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\ACER\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\ACER\product\11.2.0\ dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = PSHRDEMO)
(ORACLE_HOME = C:\app\ACER\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ASTAR.localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\ACER
Tnsping output
C:\Users\ACER>tnsping PSHRDEMO
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-AUG-2
014 12:16:19
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\ACER\product\11.2.0\client_2\network\admin\ sqlnet.ora
TNS-03505: Failed to resolve name

lsnrctl status
C:\Users\ACER>lsnrctl status PSHRDEMO
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-AUG-2014 12:19
:31
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost )(PORT=1521))(C
ONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PSHRDE MO)))
STATUS of the LISTENER


Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-AUG-2014 11:11:32
Uptime 0 days 1 hr. 8 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\ACER\product\11.2.0\dbhome_1\network\admin\ list
ener.ora
Listener Log File c:\app\acer\diag\tnslsnr\ASTAR\listener\alert\log. xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ASTAR)(PO RT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1 )(PORT=1521)))
Services Summary…
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service…
Service "PSHRDEMO" has 1 instance(s).
Instance "PSHRDEMO", status UNKNOWN, has 1 handler(s) for this service…
Service "orcl.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service…
Service "orclXDB.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service…
The command completed successfully

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
page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License