PeopleSoft Wiki

Is there a quick way to input invoices, basically at the moment the process is.

1.sort out the group control A/C
2.search vendor ID
3.then input amounts/invoice numbers/dates etc

Then I enter another screen where I need to enter A/C number and then operating unit.

What I am Looking for is. Is there an easier way to do this eg a excel spreadsheet or maybe some sort of batch upload.

As this whole process is grossly inefficient !!!!

Thanks.

Great tip, thanks.

Depending on your use, you can also pull all emplids, then use the =RAND() function in excel to assign a random number. Then sort and select the first 450. (or the middle 450… it doesn't matter. its random)

Good one. Did it have the wrong value?

I resolved this issue.. it was the import XML schema definition.

system-temp-dir is a setting defined in the $PS_HOME/appserv/xdo.cfg configuration file which relates to XML/BI publisher settings.

If you see the following error when you run a process:

ERROR: 'system-temp-dir' property is pointing to an invalid directory (235,3263) 
PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute  Name:SetSystemProperties  PCPC:1864

It means the system-temp-dir is invalid. Check the following line xdo.cfg to confirm:

<property name="system-temp-dir">/example/directory</property>

Well, that is pretty awesome! Nice work.

If you want, please go ahead and create wiki page for it as well

Hi, I am struggling with this issue for more than a week now. Little about my project: I am trying to expose CI-based Web Serive from PS and consume by Sharepoint Form (workflow). I created/exposed CI-based WS and tested with SOAPUI as well as .NET web form. It works. I can get/post data via WS. However, I cannot use same WS in any other environment for example Infopath or SHarepoint forms. I always get the following error:

SoapMapper:The SoapMapper for element CreateCompIntfcU_MY_TEST_CI could not be created. The parameter is incorrect.
- WSDLOperation:Initialization of a SoapMapper for operation EmplCreate failed. The parameter is incorrect.
- WSDLOperation:Initializing of the input message failed for operation EmplCreate. The parameter is incorrect.
- WSDLPort:An operation for port CI_U_MY_TEST_CI_Port could not be initialized. The parameter is incorrect.
- WSDLPort:Analyzing the binding information for port CI_U_MY_TEST_CI_Port failed. The parameter is incorrect.
- WSDLService:Initialization of the port for service U_MyTestEmployee failed. The parameter is incorrect.
- WSDLReader:Analyzing the WSDL file failed. The parameter is incorrect.

I tried to create proxy client in wsdl.exe and svcutil.exe and got similar error:

ERROR: Unable to to import binding 'CI_U_MY_TEST_CI_Binding' from message 'Http:xmlns.oracle.com/Enterprise/HCM/Services/U_ MyTestEmployee.1'
- Unable to import operation 'EmplCreate'
- The element 'Http:xmlns.oracle.com/Enterprise/Tools/Schemas/M 430148.v1:CreateCompIntfcU_MY_TEST_CI' is missing

Looks like it cannot locate the targent namespace or the Import .xsd file. Now, I am stuck and don't know where to go from here. I have seen ppl saying that if I have the .xsd file in the same location as .wsdl (in local drive ) it should work but I do not think I can get to that .xsd file.

is there any workaround to this. Since I am new to to XML for that matter PS as well, am I missing anything important here?
I would like to hear from you experts, please.

Thank you

Thank you very much! Praj.

We followed your steps. It turned out that the routing for GetWSDL was set inactive a while ago by other developers. Once we active the routing for GetWSDL operation. We were able to open the wsdl with browser. We are not seeing that "Unable to find a Routing corresponding to the incoming request message." message anymore.

Thanks again,

Pamela

We use the dynamic roles app engines on a regular basis. We found that if we click the button in the Role page, it calls DYNROLE_PUBL and it doesn't work. However, the app engine DYNROLE works.

The problem is that there's a hidden checkbox field on that PS page ROLE_DYNMEMBER that's labeled "Publish". It's defaulted as checked, which runs the DYNROLE_PUBL when you Execute Rule and dies. We made that field visible so we could uncheck the box, and the DYNROLE app engine runs instead.

(If I remember right, we had to contact Oracle to resolve this issue)

I've been working on a little helper extension for some time. It uses Google Chrome and really helps me out on a daily basis. I've not documented all the features on this below link but I think you'll find it very helpful.

melban.me/extensions/peoplesoft-chrome-helper-extension

I used this script for oracle DB

SELECT    'select '''
       || table_name
       || '.'
       || column_name
       || ''' recfield ,count(*) cnt from '
       || table_name
       || ' where '
       || column_name
       || ' = '''||:country||''' union '
  FROM all_tab_cols
 WHERE     column_name IN (SELECT fieldname
                             FROM psrecfield
                            WHERE edittable = 'COUNTRY_TBL')
       AND EXISTS
              (SELECT 'x'
                 FROM psrecdefn
                WHERE rectype = 0 AND recname = SUBSTR (table_name, 4, 255))
       AND Table_name LIKE 'PS%';

To generate SQL that can be plugged in to this script

select recfield, cnt from (
 --insert generated sql here
select ' ',0 from dual ) where cnt > 0

To find where a country code may be. I used all_tab_cols to avoid having to deal with subrecords.

The script is not guaranteed to find all instances, nor not to have any false results.

I figured it out.Thans you for your response.
But I am now stuck with a new error.The dynamin role AE:DYNROLE_PUBL is failing giving the following error:
Message Schema Validation errors: Message ROLESYNCHEXT_MSG, Version VERSION_1, Errors:Fatal Error: ( line: 0 column: 0 ) An exception occurred! Type:NetAccessorException, Message:Could not open file: http: // stlhrd01.soi.dir.solutia.com:7011/PSIGW/PeopleSoftServiceListeningConnector/ROLESYNCHEXT_MSG.VERSION_1.xsdError: ( line: 1 column: 40 ) Unknown element 'ROLESYNCHEXT_MSG'Error: ( line: 1 column: 52 ) Unknown element 'FieldTypes'Error: ( line: 1 column: 75 ) Unknown element 'DYNROLE_AET (158,530)

Schema validation failed for request message ROLESYNCHEXT_MSG, message version VERSION_1. (119,40) DYNROLE_PUBL.MAIN.GBL.default.1900-01-01.Step03.OnExecute PCPC:6603 Statement:111

Process 153202 ABENDED at Step DYNROLE_PUBL.MAIN.Step03 (PeopleCode) — RC = 24 (108,524)

Hmmm, in your gateway URL:
PSIGW/PeopleSoftServiceListeningConnector

May actually need to be:
PSIGW/PeopleSoftListeningConnector

Which might explain how all the target connectors are not loading. I think it will ping (and look correct with the other one, but that is for web services).

Thanks for quick response.
I clicked tha dvanced gateway setup link under quick configuration.I can see the connector detail and there are 9 default connectors that were loaded for LOCAL gateway.But there are no properties corresponding to PSFTTARGET.
I clicked on Gateway setupproperties ..provided the user id/password.
Got the screes with label : PeopleSoft Node Configuration.
Under Gateway Default App. Server ..provided the appserver URL as //machine name : 7009
Provided the detail sin PeopleSoft Nodes grid as
Node name : PSFT_HR , APP Server URL as //machine name : 7009
Provided user id/ password.
Saved but still not able to ping the node.Getting message : PeopleSoftTargetConnector - The application server is down (or not responding). Check AppServer URL

Might need to go into Advanced Gateway set up in the gateway settings and set up the nodes in there too?

Hi,
I am trying to configure IB on our Demo instance (tried on dev but getting issues so thought of first setting it up in demo), the purpose behind this is to enable using peoplesoft delivered App Engine/IB for populating dynamic roles.
I have done the following:
1)PT > IB > Configuration >Quick Configuration : Provided the gateway URL. I am able to ping it.Getting the following screes:
PeopleSoft Listening Connector
Tools Version : 8.50.08
Status: ACTIVE
2) I can see my our domain detail under IB domains section
3) PT > IB > Configuration > Gateways : Configured the Gateway ID - LOCAL.Able to ping gateway.
4) Successfully loaded connectors using "Load Gateway Connectors" button
5) PT > IB > Configuration > Service Configuration:
Service Namespace: ( Left as delivered)
Schema Namespace : (Left as delivered)
Target Location: appserver machine name : port number /PSIGW/PeopleSoftServiceListeningConnector
6) PT > IB > Integration Setup > Nodes (Node definition Page)
Selected the node PSFT_HT (Default Local node for my installation)
Authentication Option : Password
Gave node password as : PS
Default User ID : PS
left all other fields blank
7) PT>IB>Integration Setup —> Nodes (Connectors Page)
Node_name : PSFT_HR
Gateway ID - LOCAL
Conector ID - PSFTTARGET
Clicked on gateway Setup Properties.Provided the default user id/password administrator/password.
Under Gateway Default App. Server
Provided the appserver URL as :stlhrd01.soi.dir.solutia.com:7009
User ID/Password as PS/PS
Tools Release as : 8.50.08
Under PeopleSoft node gave the following
node Name :PSFT_HR
Appserver URL :stlhrd01.soi.dir.solutia.com:7009
User ID/Password : PS/PS
Tools Release as 8.50.08
Tried to ping node and got the following : PeopleSoftTargetConnector - The application server is down (or not responding). Check AppServer URL.

hi all

I have 1 year technical experience in peoplesoft,.also have 2 years java exp.
I have also done peopletools certification.i have no functional knowledge regarding any module.
can anybody suggest me,what are the options which brights up my career as a good PS techie.weather i should take any course or certification.or what the topics to concentrate.

regards
niha

Any one give me peoplecode for CONNECTED QUERY WITH PROMPTS for XML reports.

Dont just paste the one you find in BLOG.TRY to give me if you have worked

Any one give me peoplecode for CONNECTED QUERY WITH PROMPTS for XML reports.

Dont just paste the one you find in BLOG.TRY to give me if you have worked