Ask the Hexaware Expert

by Hexaware on April 2, 2008 in Ask the Expert - Submit Questions

Do you have a question on PeopleSoft Upgrades, Deployment or just about the best PeopleSoft business practices in general? No hassles! Submit your question in the comments section below. Experts from our PeopleSoft practice will answers your questions twice a week and the answers will be published in the Ask the Expert Answers Section.

You might want to read these awesome related posts

{ 328 comments }

← Previous Comments

1 Preethi August 24, 2010 at 5:52 am: Hi all,
I have to monitor job table if any new value is added to that i want to report that in a portal page. Can anyone help me out in coding.
2 Ravi krishna September 9, 2010 at 11:16 am: Hi.. Do any one have query to find whether a peoplesoft record is physical record or derived record through query only…thank you all
3 Ranjith September 15, 2010 at 8:43 am: Ravi Krishna – here is the query for you
select RECNAME ,
CASE RECTYPE
WHEN 0 THEN ‘Table’
WHEN 1 THEN ‘View’
WHEN 2 THEN ‘Derived’
WHEN 3 THEN ‘Sub Record’
WHEN 5 THEN ‘Dynamic View’
WHEN 6 THEN ‘Query View’
WHEN 7 THEN ‘Temporary Table’
END AS RECORD_TYPE from PSRECDEFN
WHERE RECNAME = ‘JOB’

Me to had asked a question if possible give me some inputs for that.
4 Dhana September 23, 2010 at 8:16 am: Hi,
I need to suppress the Search page when a component is opened, what are the various ways to do this.
Thanks in advance.
5 satish September 24, 2010 at 1:11 pm: Hi,

I need to set a work flow for an event in HRMS, which would be notifying the user who is updating it. This is working fine. But again this user needs to be send recurring mails within 15 days after first mail has been sent then again after 30 days , if he has left the data page partially filled.

this recurring mail should via Workflow should be active to only those who have partially filled data page. ex dependent benefit

regards

satish
6 Shobhan October 11, 2010 at 8:34 pm: We have currently upgraded the existing(FSCM 8.9 ) to FSCM9.1. We have a problem while running the crystals(2008) to network printer. I can run the report to file and also to a local printer from the designer. When I run the same report to printer from process scheduler doesn’t works, while running it to a file does work on scheduler. Trace file reads as below. The same crystal runs fine in the earlier version. Any ideas why this is happening. Thanks in Advance.

0 6756 888518 10/11/10 15:05:30 AppName=, DBType=ORACLE, ServerName=, DBName=FINACCP1, OprId=PS_DEV, ProcessInstance=888518, ReportPath=QPCCHK, OutputType=3, OutputFormat=11, OutputDestination=\\ISOPRT01\12S_Finan_B, LanguageDir=ENG, Orientation=P, LinesPerPage=4294892
1 6756 888518 10/11/10 15:05:30 Getting options
2 6756 888518 10/11/10 15:05:30 Options got
3 6756 888518 10/11/10 15:05:30 ENG\QPCCHK.RPT not found
4 6756 888518 10/11/10 15:05:30 Using report: D:\psft\fin91\CRW\ENG\QPCCHK.RPT
5 6756 888518 10/11/10 15:05:51 About to RunReport()
6 6756 888518 10/11/10 15:05:53 Logon info set
7 6756 888518 10/11/10 15:06:07 Parameters: -CTORACLE -CDFINACCP1 -COPS_DEV -CPUnavailable -I888518 -RP”QPCCHK” -OT”3″ -OP”\\ISOPRT01\12S_Finan_B” -LG”ENG” -OF11 -ORIENTP “ALL_CO” “2281″ “AISG” “CHASE” “AIAP” “CHK” “005837″ “005838″
8 6756 888518 10/11/10 15:06:07 Parameter count: 8 Main: 8 Subreport: 0
9 6756 888518 10/11/10 15:06:08 Checking for suppression flag
10 6756 888518 10/11/10 15:06:08 Found suppression flag
11 6756 888518 10/11/10 15:06:08 Getting printer parameters
12 6756 888518 10/11/10 15:06:08 Printer name=\\ISOPRT01\12S_Finan_B, driver name=HP LaserJet 8100 Series PCL 6
13 6756 888518 10/11/10 15:06:08 Select printer: begin
14 6756 888518 10/11/10 15:06:09 Select printer: end
15 6756 888518 10/11/10 15:06:09 About to set status to PROCESSING
16 6756 888518 10/11/10 15:06:09 Report not printed
17 6756 888518 10/11/10 15:06:09 Crystal Runtime exception: The printer specified can not be found. It may not be accessible in the current security context.
18 6756 888518 10/11/10 15:06:09 Back from RunReport()
19 6756 888518 10/11/10 15:06:09 All done
7 Testing October 15, 2010 at 11:14 am: testing
8 Partha November 26, 2010 at 4:57 am: hello..
I am stucked in a problem while creating a report in Xml publisher.
The data source is PS Query where I can see all the data i required but in the XMLP when i try to generate it in PDF it only taking the first row.
Can anybody tell me where the problem exactly is?
Is it the template problem or anything else?
9 Shanmugavel.K November 26, 2010 at 8:59 pm: To just confirm, are you displaying it with a table in the Report template? If not, you will have to insert a new table with the “Oracle BI Publisher > Insert > Table Wizard” which will insert a For-each tag before your field.
10 vijay January 27, 2011 at 3:49 am: Hi All,

I am implementing template based hire on PS 9.1.
I am receiving the applicant details from a third party vendor in a xml message.

Requirement is to insert the applicant details into template based hire records (HR_TBH_HDR and HR_TBH_DATA).

I am able to subscribe the field values from xml message. But facing the problem while inserting the values into base records.
I am trying to use Component Interface on HR_TBH_JOB component. The pages on this component are dynamically build and so the records.

If anyone has worked on the third party integration for Template Based Hire in PS 9.1, please let me know your suggestion for insertion into template based hire records.

Thanks,
Vijay
11 nikhil February 1, 2011 at 10:13 pm: hey vijay, were u able to get thru with ur requirement, i have a similar requirement where i have to accept data from a 3rd party which will be in xml format and insert it into peoplesoft records, if u went thru successfully with your requirement could u please help me do the same. thanks my emial is nickel369@yahoo.com. appreciate it.
nikhil
12 Nikhil S February 1, 2011 at 10:19 pm: Hi Experts,

I have a requirement to integrate with a 3rd party system called Edge, this is basically a company which does back ground verification for employees. So basically what my requirement is to pick up data from existing records or component buffer and create an xml and post it to the 3rd party system.

This xml has to be in the HR-XML consrotium format, u can check out the website for the format, that doesnt matter.

Please can anyone help me on the approach, how do i create an xml from a Record ? do i use rowset or non rowset based message? how do i create a message does it have to have the same structure as the record that im picking from, if im picking the data directly from the component buffer can i use a non rowset based message. please send me an email on nickel369@yahoo.com any kind of input would be higly appreciated. thank u so much.

Regards,
Nikhil S
13 Sharad Patel February 2, 2011 at 6:34 am: Hello Nikhil,

First of all you need to decide which technology you are going to use for integration (Http web service, Tuxedo service , MQ Queue, JMS ..etc), also from your requirement I can assume that you are only sending the data to third party system and there will not be any response.(Asynchronous communication)

Regarding Row set and Non row set messaging , can you please help me with the required XML , and if the third party is non PS then we always preferred to use Non Rowset messaging and create the required XML using code.

Please revert with the exact requirement.

Regards
Sharad Patel
14 Nikhil s February 7, 2011 at 5:31 pm: hi sharad,

So sorry for the late response i was down sick for the past 5 days. I want to use XML through integration broker. There will be a response but not immd so i can keep the messages async.

Do u have a personal email id where i can get in touch with you on, so i can send u the furthur details. thanks.

Regards,
nikhil S
nickel369@yahoo.com – my email.
15 Nikhil s February 7, 2011 at 5:32 pm: hi sharad,

So sorry for the late response i was down sick for the past 5 days. I want to use XML through integration broker. There will be a response but not immd so i can keep the messages async.

Do u have a personal email id where i can get in touch with you on, so i can send u the furthur details. thanks.

Regards,
nikhil S
nickel369@yahoo.com – my email.
Thanks.
16 Sharad Patel February 8, 2011 at 5:47 am: Hello NIkhil,

you can call me at 9819576325 any time,os just mail me at sharadp@hexaware.com

Reagrds
Sharad Patel
17 Praveen February 10, 2011 at 12:44 pm: Hi,

Is there a way to pass run control parameters to PSJos processes apart from scheduling Job component?

E.g. lets say PSJob has 3 SQR processes, i need to pass run control id A1 to SQR1, A2 to SQR2 and A3 to SQR3 at run time. I dont want the schedule Job component to be used.

Appreciate ur help.

Thanks,
18 Kiruthika February 16, 2011 at 4:42 pm: I have a requirement to change the way the lookup page appears.
When we click on a prompt table, the lookup appears where the search results are displayed. Along with the search results, the partial search feature is also present. Is there a way to customise the lookup appearance by only displaying the search results and hiding all the other contents of the page?
19 Akash February 17, 2011 at 5:25 am: Hi Kiruthika,
1) If there is no key in search record make all fields as list box item & Dont make any field as Search Key.
2) Make a secondary page & have a gird in it and display everything in it from Search Record.

I hope this resolves your requirement,
Thanks,
Akash Awadhiya
20 Aishwarya February 18, 2011 at 5:58 am: We have a hyperlink on a page which does not work as it references a component (HR_EMPLOYEE_INTRO)
which is not present in 9.1.Also when we click on the hyperlink,we need to transfer the page to the below link:
http://yangtze.kdc.capitalone.com:8601/psp/DHRDEVPIA/EMPLOYEE/HRMS/s/WEBLIB_PTPP_SC.HOMEPAGE.FieldFormula.IScript_AppHP?pt_fname=CO_EMPLOYEE_SELF_SERVICE&FolderPath=PORTAL_ROOT_OBJECT.CO_EMPLOYEE_SELF_SERVICE&IsFolder=true.
any ideas will be greatly appreciated.
21 Vineet February 22, 2011 at 11:58 am: Integration Synchronous handler: No destination node can be determined for the request on node PSFT_HR(158,963) PT_BPEL.BPELUTIL.OnExecuteName:LaunchSyncBPELProcess PCPC:1267
Called from ………..savepostchange of the component record level
After applying filters for sender specified routing, node transactions, relationship transactions and Peoplecode event OnRouteSend, a destination node can not be found.

I got this error while consuming a web service in peoplsoft Finance. After consumed a WS. I tried to test my app. then i found this.
Plz reply.
22 sagar March 22, 2011 at 9:00 pm: - i Have one CSV file placed in fle server.
- While opening file using view Attachement function it is getting opened in XLS format and not in CSV.
- Do we have any other function to open file in CSV format and not in XLS.
23 Akash Awadhiya March 23, 2011 at 4:39 am: Hi Sagar,
While installing the MS-office you give default application for CSV file to be MS Excel; so if you dont want your attachment to open in CSV,
1) you can do either give file extension as .txt & keep format of file as csv or
2) Don’t give any extension, whenever user clicks on attachment system will ask application in which it has to open file remember to keep file format as csv.

Thanks,
Akash
24 Shobhan April 27, 2011 at 10:19 am: We are upgrading the current FSCM 8.9 to FSCM9.1. As a part of upgrade we have to convert all the existing crystals to the new version Crystal 2008. After conversion one of my crystal is running for 5 hrs against 40 min in current version production environment. I could see one query running number of times. Any ideas of why this is happening.

Thanks in Advance
Shobhan
25 Manoharan May 19, 2011 at 8:31 am: How can i save a component interface without having SAVE() method that is normally attached to the Component Interface ?
26 Manoharan May 19, 2011 at 8:33 am: Is there any other limitation other than fetching a single row thru SQLExec function in peoplesoft ?
27 Shaik May 23, 2011 at 4:05 am: Hello Experts,

Is there a way to hide/unhide Peoplesoft Grid “Download to Excel” button, based on User Role. Please let me know, thanks in advance.

Shaik.
28 Vinay July 22, 2011 at 2:00 pm: Hi Experts,

Could you please send me the list of tables related to Integration Broker?

Thanks
Vinay