Recent Forum Posts

---

From categories:

All categories Forum: Existing Content Forum: New Content Forum: Help Forum: General Discussion Forum: Comments Forum: Hints, Tips & Gotchas

page 1123...next »

PeopleSoft and Active Directory

AOlson (guest) 1257435086|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » PeopleSoft and Active Directory

Hello,
I have a question for those users out there using PeopleSoft with Active Directory. We are in the early stages of getting a common Active Directory setup for all of our locations. We want PeopleSoft to be the instigator for User Creation as 95% of all users are first created in peoplesoft. We would like this to all be real time if possible.

My questions are.
How are users out there currently using Active Directory with Peoplesoft?

Does PeopleSoft have the ability to query or write directly to Active Directory? If so how?

My initial thoughts were to have PeopleSoft instigate the creation of the user and then pass needed information to a web service or something to have the Active Directory account portion created. is this an ok method?

Looking for any assitance or direction one could provide.

Thanks.

Debugging / Tracing XML Publisher

Praj 1256853513|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / General Discussion » Debugging / Tracing XML Publisher

Didn't realise XML publisher had a debugging / tracing option, but this great post by PeopleSoft / Oracle tips goes through how to turn it on.

I tested this on a unix system, and set the log path to a folder I created: $PS_HOME/log/XMLP. Note that the LogDir doesn't like environment variables, e.g. I had to hard code the path to $PS_HOME and it will throw an error if you specify a location it can't write to.

Using Oracle Database Links

Praj 1256768093|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / General Discussion » Using Oracle Database Links

The PeopleSoft DBA Blog has a great article that explains good and bad uses of Oracle database links. Definitely worth a read if you use them at your organisation. As pointed out, potential alternatives include using application messaging or materialized views. Like most things, they can work very well if used in the right way.

Re: How to Communicate with Peoplesoft Application

Ducatiss (guest) 1256600084|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » How to Communicate with Peoplesoft Application

Hi MMP
Sometimes it is more useful for you to take the time to explain yourself if indeed you want assistance. Your explanation is lacking in detail to say the least.

Meow!!

You may be referring to Guest access which is set up via your web profile under the Security tab of the web profile.

PeopleTools > Web Profile > Web Profile Configuration » Security

Look for the Publis Users section and you will see a UserId and a password.

This says what user will be automatically logged in when a direct link is served. Obviously the user (normally a GUEST user) will need access to the direct link. You could then publish your defaulter list generation process under the Guest user (via a role and permission of course) and then directly serve the link to this menu/component.

Let us know if this helps…

How to Communicate with Peoplesoft Application

mmp (guest) 1256541256|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » How to Communicate with Peoplesoft Application

Hi,
We are developing an application that will help manager’s generate defaulters of timesheet easily at the click of button. We will try to automate and remove the traversal steps that are between the login and the defaulter list generation process currently in Peoplesoft. Can anyone please help us for starting this up??

Re: Overriding a Component's Search Record for a Component Interface

Gavin (guest) 1256303101|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Overriding a Component's Search Record for a Component Interface

You could change the search record on the component to one that allows access to all employees/customers/persons/students etc. i.e. No Security at all.

Then on each menu where the componet is accessed use the search view override to override this search view with the search view you wish to use online i.e. The one with the security in it.

If you are using the CI within an Application Engine or other batch process then you most likely dont need security on the search view thus increasing performance.

Hope this helps for those using AE.

Re: sqr reports

Praj 1256249218|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » sqr reports

Hi, what's the full path to the SQRW application you are using?

There are two different SQR binary paths, one with ORA for Oracle and one with MSS for Microsoft SQL Server.
The path to the SQRW tool is something like this: %PS_HOME%\bin\sqr\ORA\BINW or %PS_HOME%\bin\sqr\MSS\BINW.

Not sure if this makes a difference ?

sqr reports

shyam (guest) 1256055570|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » sqr reports

Using SQRW tool I can run sqr reports when database is Oracle and HRMS,but when I want to run the sqr report using Finance and SQL Server I am getting error.

Showing error in Command prompt as

Oracle OCIServerAttach error
Cannot logon to the database.

When running Microsoft SQL Server as databse.why i am getting Oracle error.

IN SQRW i gave
Username = sa
Password = sa
Database = FSCM89

Username and Password are same as of Microsoft SQL Server database.

I think there may be settings to change my database from Oracle to Sql server.Can any one help me in resolving this issue.

Re: Glad I found your site!

Nan (guest) 1256049471|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Comments » Glad I found your site!

My keys were mismatched between my Level 1 and Level 2 on my page.
The level 2's view keys were out of order and did not follow the order of the Level 1's table's keys.
That is what really caused my No Matching Buffer error.

Level 1 table: setid (key), recnbr (key), effdt (key), effseq (key),…
Level 2 view: setid (key), descr (key), recnbr (key), effdt (key), effseq(key),…

However when I fixed it, I put the 'descr (key)' after the last Level 1 key and it then did not give me the No Matching Buffer error.
I was confused when I got the error because I didn't even realize that I had changed the order of the keys in the Level 2 view.
thanks for your site!

Re: Feedback on the readability of the site

melban 1255957114|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Comments » Feedback on the readability of the site

Looks good for me. I'm at 1440x900 and using Chrome.

Re: Component Interface PeopleCode

Praj 1255573409|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Component Interface PeopleCode

Hi,

This might be possible using Component Interface PeopleCode.

I believe you would need to:

1. Create the appropriate method in your CI method PeopleCode
2. Call the method as part of the code you use to access the CI

Some delivered examples are the USER_PROFILE component interface which includes additional methods (functions) like ResetPassword and SetPassword. Another example is the PROCESSREQUEST component interface.

Step 2 is really the trick. If you are using a CI for the inbound data conversion then it should simply be a matter of calling the "pre-edit" method before you insert/update/delete and save data using the CI. However, I'm not sure if that's what you are actually doing?

Print Project Alternative for PeopleCode

Praj 1255563487|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / General Discussion » Print Project Alternative for PeopleCode

A work colleague put me onto this great tip for modifying the XML in your exported project definition so that you can view PeopleCode in a better format.

A couple of catches:

• Once you format the project XML it is no longer valid for re-import. So make a copy of it when doing this.
• You need an additional file PeopleCodeViewer.xsl to exist in the same directory as your edited project XML. The source for this file is on the site, but doesn't work with a straight copy and paste so, here's a formatted version of it (note all credit goes to the original site for this code)
• Simply open your edited project XML file in a browser to see the formatted results.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/root">
        <html>
            <header>
                <xsl:variable name="project" select="instance[@class='PJM']" />
                <h1>
                    Project:
                    <xsl:value-of select="$project/rowset/row/szProjectName" />
                </h1>
                <h3>
                    Description:
                    <xsl:value-of select="$project/rowset/row/szProjectDescr" />
                </h3>
            </header>
            <body>
                <xsl:for-each select="instance[@class='PCM']">
                    <table>
                        <tr>
                            <td>
                                <h5>
                                    <xsl:value-of select="rowset/row/szObjectValue_0" />:
                                    <xsl:value-of select="rowset/row/szObjectValue_1" />:
                                    <xsl:value-of select="rowset/row/szObjectValue_2" />:
                                    <xsl:value-of select="rowset/row/szObjectValue_3" />:
                                    <xsl:value-of select="rowset/row/szObjectValue_4" />
                                </h5>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <pre>
                                    <xsl:value-of select="peoplecode_text" />
                                </pre>
                            </td>
                        </tr>
                        </table>
            </xsl:for-each>
            </body>
            </html>
    </xsl:template>
</xsl:stylesheet>

Component Interface PeopleCode

David Vandiver (guest) 1255543244|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Component Interface PeopleCode

I am looking for a way to "pre-edit" and possibly cross reference data in the component interface. Here's an example:

I have inbound conversion data using a business unit from legacy. I need to change this field to be the new PeopleSoft business unit. I have a PeopleSoft record where I can access this cross reference, and would like to write the code in the Component Interface. My goal is to not touch delivered components/pages/record peoplecode, but to somehow use the component interface's peoplecode. Is this possible?

Re: Web Service Help

Praj 1255432622|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Web Service Help

With the error you are getting:

… content type text/html of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly …

Just wondering if the line where you pass data to the web service object, you should be passing the actual EmplID rather than the object?

So change the line to:

emplResponse = MyWebService.EmpCreate(emplRqst.EMPLID)

It would seem like this is a type mismatch error. Not sure if I'm reading your code right so apologies if that's what you are in fact doing.

Re: Web Service Help

Praj 1255431723|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Web Service Help

Sounds like you're making some good progress. I'll try to post individual answers to each of your questions so bear with me :)

The service operations security link is supposed to bring up a pop-up window. So if you are using IE you may need to tweak your security settings (Tools > Internet Options > Security) to allow pop ups etc. I've generally found the easiest solution is to make the entire PeopleSoft site (or even the entire domain e.g. *.peoplesoftwiki.com) a trusted site. If that doesn't work then, yes there may be something quite wrong, but hopefully that's all it is.

Re: Glad I found your site!

Praj 1255431294|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Comments » Glad I found your site!

Great to hear you find the site useful.

Thanks for the no matching buffer error tip too. I've added it to the article.

Glad I found your site!

Nan (guest) 1255373049|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Comments » Glad I found your site!

Thanks for all your help! I was wondering why I got that strange Excel error STYK file… And I was wondering if you wanted to add to your 'No matching buffer found for level' error help that it doesn't matter what you pick from the list if your data is bad (mismatched) the error will show. I was concentrating on the particular record I selected. There were other keys mismatched not that one. And still the error shows up. I'm bookmarking your site. Very easy to use. Thanks a bunch!!!

Re: Web Service Help

AOlson (guest) 1255364756|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Web Service Help

Sorry, I did something to have it post before I was done. Also making sure the External Alias is GetWSDL is not set either. It looks like it used the alias name that I was setting up for the create event with the version number? Can I change this or do i need to republish?

Thanks again for the help and sorry for the multiple posts here.

Re: Web Service Help

AOlson (guest) 1255364524|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Web Service Help

I should make a note as I was curious about the steps you posted and started going through them.

I got up to: Click on the Service Operation Security link, confirm the delivered permission list PTPT1200 is there and that access is set to Full Access

When I click the Service Operations Security Link it doesn't go any place. No error or anything. It is like it refreshes the Service Operations page is all. I tried a couple of other services with the same result. Maybe this is why these are not working?

Re: Web Service Help

AOlson (guest) 1255358072|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Web Service Help

Thanks again.
I haven't checked everything you mentioned, but shortly before your reply i got it to connect to some degree. I am using VB and a test form to simply test this out.
Here is what I had to do. I had to use the IP address URL and add to the URL your mention of the specific node i was on.

However, I am still having an issue with making it work and maybe one of the things you mention above will solve this too and if so please let me know and I will try them out.

My form has 3 boxes, am emlid, last name, first name and a button. This code is part of the click event on the button:

Dim MyWebService As New MyEmployeeWebService.CI_NDU_AO_EMP2_T_PortTypeClient
Dim emplRqst As New MyEmployeeWebService.CreateCompIntfcNDU_AO_EMP2_TTypeShape

Dim EmplID As New MyEmployeeWebService.EMPLIDTypeShape
Dim LastName As New MyEmployeeWebService.LAST_NAMETypeShape
Dim FirstName As New MyEmployeeWebService.FIRST_NAMETypeShape

EmplID.Value = txtEmplID.Text
LastName.Value = txtLastName.Text
FirstName.Value = txtFirstName.Text

emplRqst.EMPLID = EmplID
emplRqst.LAST_NAME = LastName
emplRqst.FIRST_NAME = FirstName

Dim emplResponse As New MyEmployeeWebService.CreateCompIntfcNDU_AO_EMP2_TResponseTypeShape

emplResponse = MyWebService.EmpCreate(emplRqst)

I get to the the last line (emplResponse = MyWebService.empCreate(emplRqst) and an error is thrown below:

The content type text/html of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 572 bytes of the response were: '<?xml version="1.0" ?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring>null</faultstring><detail><IBResponse type="error"><DefaultTitle>Integration Broker Response</DefaultTitle><StatusCode>20</StatusCode><MessageID>505</MessageID><DefaultMessage><![CDATA[Unable to find a Routing corresponding to the incoming request message.]]></DefaultMessage><MessageParameters></MessageParameters></IBResponse></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>'.

Any ideas?

Also, is there a spot where you can check what the statuscodes or MessageID's mean?