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.

Posted by Hexaware
Comments (327)
April 2nd, 2008

Comments (327)

Shaik - May 23rd, 2011

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.

Manoharan - May 19th, 2011

Is there any other limitation other than fetching a single row thru SQLExec function in peoplesoft ?

Manoharan - May 19th, 2011

How can i save a component interface without having SAVE() method that is normally attached to the Component Interface ?

Shobhan - April 27th, 2011

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

Akash Awadhiya - March 23rd, 2011

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

sagar - March 22nd, 2011

- 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.

Vineet - February 22nd, 2011

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.

Aishwarya - February 18th, 2011

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.

Akash - February 17th, 2011

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

Kiruthika - February 16th, 2011

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?

Praveen - February 10th, 2011

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,

Sharad Patel - February 8th, 2011

Hello NIkhil, you can call me at 9819576325 any time,os just mail me at sharadp@hexaware.com Reagrds Sharad Patel

Nikhil s - February 7th, 2011

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.

Nikhil s - February 7th, 2011

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.

Sharad Patel - February 2nd, 2011

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

Nikhil S - February 1st, 2011

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

nikhil - February 1st, 2011

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

vijay - January 27th, 2011

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

Shanmugavel.K - November 26th, 2010

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.

Partha - November 26th, 2010

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?

Testing - October 15th, 2010

testing

Shobhan - October 11th, 2010

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

satish - September 24th, 2010

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

Dhana - September 23rd, 2010

Hi, I need to suppress the Search page when a component is opened, what are the various ways to do this. Thanks in advance.

Ranjith - September 15th, 2010

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.

Ravi krishna - September 9th, 2010

Hi.. Do any one have query to find whether a peoplesoft record is physical record or derived record through query only...thank you all

Preethi - August 24th, 2010

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.

Anil Kumar Reddy - August 13th, 2010

Hi, How can we use group by clause in sub select or in sub query, when we are developing query in PSQuery.Is it posssible to use Group by clause effectivley,,in PSquery.If yes..Plz let me know.. Thanks in advance. Thanks & Regards, Y.Anil Kumar Reddy.

Srikrishna - July 15th, 2010

Under Setup Financials Supply Chain-->Instal-->Installation Options-->Overall We have Interunit Summarization Option set to No Summariaztion. However, all of our interunit journals are being summarized to one line Ex: The following journal…. BU Account Affiliate Amt 00100 600000 500.00 00100 690340 750.00 00410 600000 -500.00 00410 690340 -750.00 Results in the following Intercompany lines 00100 195000 00410 -1250.00 00410 195000 00100 1250.00 With the setting above, we'd expect to see 00100 195000 00410 500.00 00100 195000 00410 750.00 00410 195000 00100 -500.00 00410 195000 00100 -750.00 Peoplebooks states that "No Summarization: Select if you do not wish to summarize system-generated inter/intraunit offset lines or if you are using affiliate ChartFields. " We are using affiliate chartfields so I'd expect summarization to NOT occur.

George - July 2nd, 2010

i want to a barcode printed vertically on a report using SQR. I used PRINT-BAR-CODE function which wil help me to print only horizontally, Any help on this would be greatly appreciated. Thanks, George

Priya - July 1st, 2010

Hello, i am trying to open a secondary page from the main page using the DEMODAL function in the fieldchange event .I have clicked the default OK and CANCEL buttons in the secondary page. The issue is, the secondary page opens up , and the CANCEL button is working returning back to the main page.But, the OK button doesnt seem to be working and the control remains in the main page itself. Suggestions are appreciated. Thanks & Regards Priya

Aarti Balasubramanian - June 24th, 2010

Hi, Please explain the significance of the "set control field" on the edit tab of record field properties (set control field gets enabled when prompt table edit is chosen) and also in the record properties. Would be helpful if you can explain with an example. Thanks. Aarti

RevathyP - June 16th, 2010

Hi i have doubt in application engine section . how can we create sections that are platform-independent or platform-specific, experts could you please explain this with an example ..? Thanks in advance.

WS - June 14th, 2010

Each scroll level can have only one primary scroll record.But if there are more than one scroll in a level, then what records will be used in these scroll/grid?

Hakkim - June 14th, 2010

Hi, I am getting accounting entries in incomplete status when AR Update is run for a maintenance worksheet. I am trying to offset an item, using maintenance worksheet but this goes into incomeplete status and not to posted status. When I try creating the accounting entries manually, via online panel, they are getting generated, but they couldnt be saved and pops up a an accounting entry out of balance error. What could be possible reason how to trouble shoot this. Seems more of a set up related issue, but I am not sure where to look up, plz advise.

ram - March 25th, 2010

can please let me the peoplesoft project life cycle and what does Fit gap means.

Sugantharaj - March 8th, 2010

I want to display an image as the background for a mail notification, triggered using SendMail sendmail function in peoplecode..Please help me out

Kiran Vaddin - February 18th, 2010

We have a requirement where we need to implement single sign on for Peoplesoft - OBIEE(The user need to login in PeopleSoft and then from there he must be able to navigate in OBIEE without singing again in OBIEE). Below are the components installed. PeopleSoft: PS Portal 9 Weblogic 9.2 Tuxedo 9.1 Database Oracle 10.2.0.4 on Windows OBIEE: OBIEE 10.1.0.4 on Windows Kindly let me know that with the above components, is it possible to configure SSO. Regards, Kiran Vaddin

sirihem - February 9th, 2010

Hi, Application version is 8.4 and tools version 8.46. In customer 360 degree view page, customer hierarchy, contact name is displayed. how to bring Title (field captured at contact page)beside contact name. In 360 degree view, customer hierarchy, contact name should be displayed as Contact name - Title

PS_Help - January 24th, 2010

Hi Bhaskar For your issue create a view using a) Source b) year(part of run date) (Select distinct Source, year(run_date) from Mark year as the search key and both source and year as the list, Use this view as search record. Hope this solves the issue.

Bhaskar - January 23rd, 2010

Hi Experts, I have a small design issue.i need to buid a page using a existing record with out adding any fields and not to change any existing key structure. **we can use any newly created records,views**** existing Record fields :- 1)source -- Key 2)Run_dt -- Key (MM-DD-YYYY) 3)Descr design should be user can search based on the year(YYYY). Add mode user should see two fileds (source,year) and in the below grid he can enter run_dt for that year and can save/update/inser

mano - January 21st, 2010

Do any of you guys know where can I get complete flows of all the modules in HCM 9.0. I'm interested to know how the data flows from one point to another, the important tables, the processes, integration among the modules, and integration with other application like PS FSCM.

Praveen - January 1st, 2010

Hi, I've created an online voucher and then i've posted it. After that i ran the pre interface process to get the asset details in the pre interface loader table. Then i ran the payables interface process AMPS1000 to get the asset details in the INTFC_PHY_A and INTFC_FIN tables. When i reviewed the INTFC_PHY_A tables, i could not get the location field populated. Please let me know if anyone of you have faced the similar kind of issue. Thanks in advance

Rahul Bagade - December 29th, 2009

Hi, I am using rowset.flush method to clear all data from the scroll and Using rowset.select("Some Condition") to populate the same scroll with additional criteria. Whenever I try to Save the component with some data changes, I am getting error message "Page Data Inconsistent with Database". If I remove rowset.flush, rowset.select("Some Condition") statements Save is happening normally. Can you please tell me why I am getting above error? Regards, Rahul Bagade

Rahul Bagade - December 23rd, 2009

Hi, I’m facing a problem with the worklist. When I enter a particular component through the menu navigation, the component launches. But when I try to enter to the component thro’ a worklist entry, it shows “you are not authorized for this page”. And this occurs only for a particular UserId. What might be the problem?? Regards, Rahul Bagade

K. S. Rama Naidu - December 17th, 2009

Hi, I want to display an image as the background for a mail notification, triggered using SendMail through an Application Engine. The below method works, but with a problem. Any employee who receives this should be granted access to the image folder on the server, which is impossible (or else he will not be able to see the background image) &MAIL_TEXT = "{html}{body background='" | GetURL(URL.ANNIVERSARY_MAIL_IMAGE) | "'} - - - - - where, URL.ANNIVERSARY_MAIL_IMAGE = \\a.b.c.d\foldername\imagename.extension Then I tried the following 2 ways, which i had earlier succesfully used in iScript peoplecode. Now in AE, I get the error: First Operand of . is NULL #1) &MAIL_TEXT = "{html}{body background='" | %Response.GetImageURL(Image.ANN_MAIL_BG) | "'} - - - - - #2) &Image_Rec = CreateRecord(Record.ANN_MAIL_IMG); /* Image had been stored in this database table */ &Image_Rec.YEARS_OF_EXP.Value = &YEARS_COMPLETED; &Image_Rec.EFFDT.Value = &EFF_DATE; &Image_Rec.EFF_STATUS.Value = "A"; &Image_Rec.ANNV_MAIL_IMG.Value = &IMAGE_DATA; &MAIL_TEXT = "{html}{body background='" | %Response.GetImageURL(&Image_Rec) | "'} - - - - - Please suggest a solution. Thanks, Rama Naidu.

Praveen Daniel - December 16th, 2009

Hi, Peopletools 8.50/PIA 9.1 Integration broker concept. Invoke CI as a Web Service 1. Providing a Component Interface(Create Method) as a web service in the target instance and stored the generated WSDL file and WSDL URL (done) 2. In the source instance, we are trying to consume the generated WSDL file and pass parameters to invoke the CI(Create Method). But we are facing an issue while parsing the WSDL file in the source instance After loading the WSDL file, it throwed error as "Failed to parse WSDL document,first operand of . is null, so cannot access member name" We faced an issue if we pass the WSDL file as URL too. It throwed error as "HttpTargetConnector:PSHTTPFactory init or SetCertificate Fails" Kindly let me know if you get any solution. Thank you.

Praveen Daniel - December 16th, 2009

Hi, Iam working in Peopletools 8.50/PIA 9.1 Iam working in Integration broker concept. Iam facing an issue which has been mentioned below. Invoke CI Using Messages: 1.Publishing a message from Source instance and subscribing it in target instance.(done) 2. In the target instance, we are trying to read the message in the Service Operation and pass it to Component Interface (Create Method) which will create an Employee. We have added the CI name and method in Handler part of Service Operation. But we are facing a problem in the place of how the value gets passed from the Service operation to CI. Kindly let me know if you find any solution. Thank you

Vaibhav Ashtekar - December 14th, 2009

Hi, I am working on delivered CI_JOB_DATA in HRMS 8.8. When I dragged the delivered CI in to an App Eng and tried to validate, it gives an error for "End-For". On further investigation, I found that "End-For" is not generated in the peoplecode for JOB_JR and COMPENSATION collection which is expected. After adding the "End-For" peoplecode work fine for this CI code. I tried the same in HRMS 8.9,9.0 instances and got the same error. Is this the PeopleSoft bug? Thanks in advance.

Aries - November 25th, 2009

Hello, In PS HRMS Job Data page, when we add a new row(correct history mode), we can see that the values are copied from the previous row to the current row except the EFFDT field. I have checked the RowInsert peoplecode and was not able to find the code that exactly does this. Can you please help me where this code is written and how it is done? Thanks, Aries

Mohul - November 25th, 2009

How to execute an external software(exe) from peoplesoft.The s/w is intalled on anothe system which is in network (but not on PS server).It is able to run from Command Prompt but not with PS Exec function.

PS Help - November 25th, 2009

Hi Sharad You are correct. Thats why in a restartable AE if you need the next section to refer parameters you will need them saved in AET and hence AET needs to be an SQL table. Else if parameters are not refered to then you can use a derived record as AET.

Sharad Soni - November 24th, 2009

Hi Thanks a lot for reply.. Still does this mean state record are only used to pass values from one section/step to other(off course there are other uses as well but my concern is only passing variables) Ex. AE having section A and B, completes section A successfully and updated some values to state record. When we restart AE.. it will start from section B and picks up values from state record if required this is how state record is used in restartable logic ? Regards, Sharad S.

PS Help - November 23rd, 2009

Hi Sharad You are correct no need of an state record for restartable AE. only care you will have to take is that the AE will start at section before which last commit was fired. So, in case in the section you are doing any row-by-row processing then you will need to internally manage a logic so that you dont process the processed rows again.

Shard Soni - November 23rd, 2009

Hi, Is it possible AE to be restartable without State Record ? I know St. Record are used to pass variables betn diff. sections, action of AE But in case AE do not need to pass variables to different section or action so no need of state record, but if such AE fail in betn and is restartable then it will took next step/sectio execution from AERUNCONTROL. So there is no need of state record in this scenario for AE to be restartable ? Correct me if wrong. So state record are not must for AE to restartable ? Thanks for your guidance in advance. Regards, Sharad S

Aries - November 22nd, 2009

Thanks a lot Vimal. It answered my question the best way. Regards, Kishore M

Vimal - November 22nd, 2009

Hi Aries ...you can use %select(StateRec1.field1,StateRec1.field2)select field1,field2 from table where condition. StateRec1 = Non default State record.

Aries - November 22nd, 2009

THanks Vimal, Insertion into default state record is normally done by %select(field1,field2)select field1,field2 from table where condition. But how to insert values into non-default state record. u mentioned in the previous reply saying that we can use RECORD.FIELD. But how can we achieve in Do Select? Can we use Sqlexec("Insert into RECORD.FIELD ")

Vimal - November 21st, 2009

Hi Aries.....You can use RECORD.FIELD syntax to use non default state record fields. For default only FIELD reference is required. Regards, Vimal

Aries - November 21st, 2009

Hello, I have a question on inserting values into PeopleSoft state records. Suppose there are two state records used in an Application engine and one being the default. How can we insert in to the state record which is the non-default one? Thanks, Aries

Rahul - November 10th, 2009

What is the difference between the Functionality of People Soft CRM 8.9 to Peoplesoft CRM 9.0.

Rahul - November 10th, 2009

Hi,this is really a good site. I want to know what is the major difference in the functionality of People soft CRM 8.9 and Peoplesoft CRM 9.0.

Mohammed - November 10th, 2009

Hi, Can you please tell me the steps for Application upgrade. Also please share any document for the same. Regards, Mohammed

vinn - November 2nd, 2009

I have a xml file with parent child rows - 1 10 - 2 5 The keyNo in the parent is the key field and I put the Field inheritance on the child table. On using file layout and creating AE from it..it doesn't load the keyNo field data to child table even though the Field inheritance is set. (same field name in parent and child) The CopyFieldsTo is not copying the like fields. Should the XML child data have the key fields repeated.? Any help is appreciated. Thanks

Vimal - October 26th, 2009

Hi Priti....did you check the RC_CASE_CI Component Interface as all case information is stored by invoking this CI.

Vimal - October 26th, 2009

Hi Ramanaidu....in the workflow event if a worklist is triggered and an error occurs in the Savepostchange then the worklist is rolled back. However this does not happens if a mail is triggered in the workflow. In such cases the alternative way is to trigger the mail after all the code in savepostchange completes.

PS Help - October 25th, 2009

Hi Booshan As per Peoplebooks %UpdateStats is used to "generate a platform-dependent SQL statement that updates the system catalog tables used by the database optimizer in choosing optimal query plans". Refer peoplebooks for respective peoplecode construct. For eg in SQL Server(MSS) you can use SQLexe("UPDATE STATISTICS tablename") or SQLexe("UPDATE STATISTICS tablename WITH FULLSCAN"). Please refer Peoplebooks for other database specific SQLs.Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: PeopleSoft Application Engine > Using Meta-SQL and PeopleCode (%UpdateStats)

anu radha - October 23rd, 2009

can anyone plz help with of how to,Created a process to load one time deductions for payroll using Application engine and component interface

Peter Vincent - October 22nd, 2009

has annyone implemented a customized "post approval" time reporting

Booshan - October 22nd, 2009

Can Anyone let me know the equivalent of %UpdateStats in peoplecode. I know %UpdateStats can be used for object type SQL.

PS Help - October 20th, 2009

Hi K. S. Rama Naidu The events fire in the order a) SavePrechange b) Workflow d) SavePostChange Reason being that system assumes all the validation have been done till Saveprechange and it is the last point where developer has the ability to stop saving.After that PS assumes all is OK and it should not face problem while saving.So after that PS has provided Workflow event for triggering of workflow. SAvepost changes even has been provided to update the system post all the previous events fire ok. If any issues is faced in savepostchange the system rolls back all the changes but the workflow cannot be rolled back.

PS Help - October 20th, 2009

How to Incorporated workflow notifications in Application Engine programs? Hi Yashovardhan You can do this by following below steps a) Creat a dummy component using a work and Physical record(Where yu would like to store workflow info). b) Then create a CI based on the above component. c) In the workflow event of the derived record write a workflow code. d) Call the CI in select fetch of the Application Engine and save the CI. This will help you maintain the Workflow fired during processing of Application Engine.

yashoovardhan - October 20th, 2009

Can any one help me How to Incorporated workflow notifications in Application Engine programs

yashoovardhan - October 20th, 2009

I need to Developed a process to load the elections data to Health, Life, FSA/FSD Benefits tables using Application Engine, File Layout , component Interface. Can U please at least out line the process of how to do Thanks in advance

yashoovardhan - October 20th, 2009

Can u please help me ,,,How to Created a process to load one time deductions for payroll using Application engine and component interface thanks in advance

Gautam Agawari - October 18th, 2009

Dear members, My client is looking for training in the area of "ESP Scheduler". Please let me know incase you find any trainer who could do this training program. The training would be held in India.Indian trainer preferred. Incase you are not a trainer by profesion, but strongly feel that you can run training, please feel free to revert. Please feel free to write me at gautam@pyramid-hr.com or call me at 9212300906. Regards, Gautam Agawari

Srini A - October 16th, 2009

Hi, Is it possible to redirect the user to an external website on clicking a hyperlink on a PeopleSoft page? Also this redirect has to happen as a http form post while passing some parameters. I'm trying to use an IScript for this purpose and here's the code for it. But the onload function is not working and control remains in PeopleSoft. Can an expert help? function firstrun() { document.forms[0].submit(); return false; }

Chhavi - October 16th, 2009

Hi I am working on applying bundles and patches in peoplesoft 9.0 we have already compared our demo ((Vanila 9.0) db on which we have already applied patches) with dev (copy of production) we have done few customizations in our peoplesoft system but when i look at compare reports it doesnt show me all of customised code however when i go and check peoplecode in app designer the customized code is there. what could be the possible reason that it is not coming up in compare reports? Also I need to know that when we are applying patches do we need to have base 9.0 version + the patches on it in demo database is this correct?

Kanchana - October 12th, 2009

Is it possible to use "In List" in the Query using Query Viewer Dynamically. If Not, Kindly suggest if there is any other alternative to achieve the "In List" Criteria in the Query Dynamically

Rama Krishna - September 21st, 2009

I am looking for Archiving of old data in peoplesoft. Did Peoplesoft Data Archive Manage is good or not? Which is the best way to Archive and how to use? I am very new to Archiving. Any inputs regarding the same will be appreciated.

K. S. Rama Naidu - September 10th, 2009

Hi, I want to know why the events are ordered in this way: 1. SavePreChange 2. Workflow { Database Update } 3. SavePostChange { Database Commit } My SavePostChange Code is resulting in error. The Data is getting rolled-back. But, my Workflow code triggers the mail ! which should not happen when transaction fails, right? Thanks, Naidu.

K. S. Rama Naidu - September 10th, 2009

Hi, I want to know why the events are ordered in this way: 1. SavePreChange 2. Workflow <> 3. SavePostChange <> My SavePostChange Code is resulting in error. The Data is getting rolled-back. But, my Workflow code triggers the mail ! which should not happen when transaction fails, right? Thanks, Naidu.

srikanth - September 9th, 2009

hi, i am srikanth..i want to install pT8.48 on solaris 10 with oracle as my database.how can i do this??is there any website available for this with screen shots explain of this procedure.i want to use vm ware to install solaris 10 and and use my pc as a client.please reply me. thank you...

Victory - September 7th, 2009

how can we retrive a particular data from dropdown field values by peoplecode?do we have any functions like for it like we have AddDropDownItem ?

p.vijayan - September 1st, 2009

hi, I am vijayan from salem, tamilnadu. i want to know about the peoplesoft details. How this is use and where.. How I learn this... I want to know the training centres and fees details also. Kindly do the needful. And i am waiting for your reply. Thanks & regards, P.Vijayan, Salem0-9842737201.

PS_Help - August 27th, 2009

Victory selectbykey() means the following You provide the key values of a record object and execute this method it will return you the values from other field in the record object.Following are points to be noted a) In a record in PS you define the Key values. b) This method has input parameters (Key values of a record) and output as record object (Returning all values of the fields) c) If you don’t specify all the key fields for a record, those you exclude are added to the Where clause with the condition equal to a blank value. If not all keys are set and more than one row is retrieved, you won't receive an error and SelectByKey won’t fetch any data. eg. In MYRECORD i have two key fields KEYF1, KEYF2 then Local record &REC; &REC = CreateRecord(RECORD.MYRECORD); &REC.KEYF1.Value = "A"; &REC.KEYF2.Value = "X"; &REC.SelectByKey(); will return me the whole record.

Victory - August 24th, 2009

Please explain selectbykey().

xyz - August 20th, 2009

How to display the date in the peticyular format in the CSV file. Because user want date in 'YYYY-MM-DD' format but once i will generate the CSV using AE then it will be displayed as default excel format please hepl on the same.

Akash Awadhiya - August 20th, 2009

Hi Victory, To have operator of the serach critrea field displayonly, following ways you can do it: I hope its through configurable search setup: 1) Have only 1 search criteria and make it default 2) In RB_FILTER application package you can disable this field through peoplecode. Thanks,

Victory - August 19th, 2009

How can I make the operator of the serach critrea field displayonly?

Arun - August 7th, 2009

Hi, In CRM 8.99 (PT 8.48), we are required to develop a page to capture the History of Changes in a Customized page very similar to that for Lead / Opportunity in Sales.Can any one pls help me on this?

LearnPS HRMS - July 29th, 2009

To learn Peoplesoft Functional modules Especially for core HR, Benefits, Payroll and Time and Labour. check here : http://www.learn-peoplesoft.blogspot.com

Lynn Cermak - July 28th, 2009

Tune_ae_data_conversion question for Nitin Pai: I am going through an 8.4 to 9.0mp5 conversion and encountering the same problem. I am interested to see what tuning changes you did and what specific statements where changed. What index was dropped on which table and which insert had the hint added and which index was re-created.

RS - July 28th, 2009

This is about accessing one of the customized peoplesoft component by external User. I’m generating the URL using the following code &str = “&CASE_ID=” | &nCaseID; &str = &str | “&COMPANYID=” | &sCompID; &strSP_URL = “” | GenerateComponentContentRelURL(”CUSTOMER”, “CRM”, MenuName.XX_MNU, “GBL”, Component.XX_CMP, Page.XX_PG, “U”); &strSP_URL = &strSP_URL | &str; and it generates the following URL, and would be sent to the external user via an email. http://servername/psp/crmdev/CUSTOMER/CRM/c/XX_MNU.XX_CMP.GBL?Page=XX_PG&Action=U&CASE_ID=255988&COMPANYID=1209680 Now what i want is, when user click the above URL he should be shown the page. but the problem is, when I click the above generated link the following message appears on the explorer. “You are not authorized for this page. http://server/psc/crmdev/CUSTOMER/CRM/c/XX_MNU.XX_CMP.GBL?Page=XX_PG&Action=U&CASE_ID=255988&COMPANYID=1209680” But if I paste the above link in address bar, after logging into the application, then the componenet is displayed. I’m on CRM 8.80 & PT 8.45 Thanks!

RS - July 28th, 2009

This is about accessing one of the customized peoplesoft component by external User. I'm generating the URL using the following code &str = "&CASE_ID=" | &nCaseID; &str = &str | "&COMPANYID=" | &sCompID; &strSP_URL = "" | GenerateComponentContentRelURL("CUSTOMER", "CRM", MenuName.XX_MNU, "GBL", Component.XX_CMP, Page.XX_PG, "U"); &strSP_URL = &strSP_URL | &str; and it generates the following URL, and would be sent to the external user via an email. http:///psp/crmdev/CUSTOMER/CRM/c/XX_MNU.XX_CMP.GBL?Page=XX_PG&Action=U&CASE_ID=255988&COMPANYID=1209680 Now what i want is, when user click the above URL he should be shown the page. but the problem is, when I click the above generated link the following message appears on the explorer. "You are not authorized for this page. http:///psp/crmdev/CUSTOMER/CRM/c/XX_MNU.XX_CMP.GBL?Page=XX_PG&Action=U&CASE_ID=255988&COMPANYID=1209680" I'm on CRM 8.80 & PT 8.45 Thanks!

Akash Awadhiya - July 24th, 2009

Hi Vini, Answer to your below question is "Yes". To be on safer side; please verify Page in Application designer where all this sub page is present and then migrate all those pages. Akash Vini Says: July 24th, 2009 at 1:05 am I have modified the subpage.Should i include both the subpage and the parent page in upgrade tab of project for the proper migration of the project?

Vini - July 24th, 2009

I have modified the subpage.Should i include both the subpage and the parent page in upgrade tab of project for the proper migration of the project?

Luke - June 12th, 2009

How do I find a consultant in the Fort Worth Texas area who has experience with Resource Management Module.

Srini - June 5th, 2009

Hi, Leave request email is firing with person email instead of system email id. where I need to check. I have changed user to system in generic template. -Regards Srini

Srini - June 4th, 2009

Hi, Leave request email is firing with person email instead of system email id. where I need to check. I have changed user to system in heneric template. -Regards Srini

Rajan Rikame - May 20th, 2009

Hi, Tools: 8.47 (Oracle 10g) 1. Is there a way to have DDL model to create Bitmap index using App Designer? 2. Is there a way to have DDL model to use DBMS_STATS instead of ANALYZE. 3. Is there a way to check using AE to check the TEMP Tables stats stale or no?

Rahyul Bagade - May 15th, 2009

Hi, I am configuring E-Learning module in Peoplesoft HRMS production (Tools Version 8.42 & App version 8.8). While employee Submit his request/nominate himself for perticular course I am getting error "Invalid Row No -1 for class rowset method getrow at FUNCLIB_CO.REPORTS_TO.FieldFormula ReportsToByAccessType PCPC 7979" Can you please tell me what thing I am missing in setup?

Sathish - April 24th, 2009

Hi, In our current system there are lots of custom peoplesoft roles referred in peoplecode as well as SQR. I would like to know if there is a way we can identify all roles referred in peoplecode. Though it’s a rare scenario, it’s a pain for us when it comes to managing security of peoplesoft system. Thanks in Advance ! Regards, Sathish

krishna - April 17th, 2009

Hi Experts, I came across this statement when working on delivered FIN2002.SQR. Could you explain how this works? Begin-Select ... ... . . ... FROM [PS_JRNL_HEADER_FS A, PS_JRNL_LN_FS B,:$HEADER_AND_LINE_REC] [$Rec_Alt_Account] WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT Thanks, Krishna

krishna - April 17th, 2009

Hi Experts, I have a requirement where in I have to display the users the details of 3 invoices(Searched Invoice, Credit Invoice and Rebill Invoice) on a page.The page functionality is such that the user searches for a particular invoice and create the Credit Invoice and Rebill Invoice based on the Searched Invoice. The click of Save button populates all the invoice related tables and generate a Credit Invoice ID and Rebill Invoice Id. Here I am referring to the Adjust Entire Billing page in the Billing Module. Is it possible to show the details of 3 invoices(Searched Invoice, Credit Invoice & Rebill Invoice) within a single page as the invoice is being referred to in the same table. Also the user should have the ability to edit the details of the Rebill Invoice.Could any one throw some light on this?

Gaurav - April 8th, 2009

Hi, I am looking a way by which we can send SMS(Short message) via Peoplesoft like how we trigger mails from PeopleSoft. What are the infrastructure and configration needed for the same. Thanks in advance.

Piyush Kotpalliwar - April 8th, 2009

I have created a view for Role Query . The view is running properly in Toad but when i try to run it via PS Query it is taking time . If i build the View then it is working properly in PS Query for certain period but after certain time the performance again degrades.

pathak - April 7th, 2009

(SQR 2515) INPUT required user interaction but user interaction was disabled by the -XI command line flag. I'm facing the above issue while running a sqr report....if anybody has a clue please reply thanks in advance

Adeeb - April 2nd, 2009

Can we call a datamover script from SQR or an App Engine? If yes, How? Thanks. Adeeb

Akshata - April 1st, 2009

I get this SMTP error on using the sendMail function Failed to connect to the SMTP server at :25 (80,1) but when I use the Notify delivered button, there is no error but the mail is also not delivered

Phani - March 30th, 2009

I need some info..reg how to insert or update .csv /excel file values(Fields) e into a peoplesoft table...for eg..PS_JOB any kind of process is ok..(APP Eng / SQR /or any method) send me the source code if possible

jazi - March 24th, 2009

Hi Experts, I have data in a rowset within peoplecode. I would like to display data on a page in html. how would I do that? For example, I have an html area object called (a_html) on the page and &aRowSet is the data rowset. Thanks in advance

Radha - March 20th, 2009

Hi, Is it possible to display more than 30 character for the page tab? The Item Label in the Component allows up to 30 characters only. But I want a label which is more than that. How to achieve it. Please help.

Radha - March 18th, 2009

Hi, I have 5 fields in the grid. Is it possible to add a common header label for only 3 fields? (i.e Grouped label for 3 fields and separate labels for other 2 fields). Please provide some suggestions.

Radha - March 18th, 2009

Hi, Is it possible to add a static text in the Grid? I have to place some check boxes in the grid. Next to the Check box, the description has to be entered. But inside the grid, check box description/static text is not allowed. Please provide some suggestions.

Radha - March 6th, 2009

Hi, I would like to design a page with 2 languages. i.e In the grid, one description field will be in English and the next field will be in German. Is it possible in Peoplesoft? Please update.

JG - March 3rd, 2009

I've a search record on a component, and in this search record I've couple of fields which are having translate values. Now during search, when the values of this record are displayed. The shown values in fields with XLAT value, are small descr value. I want to see the long descr value of the translate value. Please tell me how this can be done? Thanks !

Nithin Chowdary - March 2nd, 2009

Hi Experts, We are facing a strange situation with Viewing Reports/Logs. On opening View log/trace, and clicking the corresponding filename,a warning message "Your User ID and/or Password are invalid."pops up. On entering the UserID and password, "An error has occurred." message is displayed. Now, if we try to open the file it automatically opens. Can you throw some light on this strange problem?? Thanks in Advance, Nithin

radha - February 25th, 2009

hi can guide with We need to see if an employee has any pending transactions from a manager of his (like an approval or something, the manger can be direct/ indirect reports)...and show this on a portal page...the transaction can be a promotion, transfer or any other self service transaction. However, i am not sure if there is any table which stores all pending transactions for employees in peoplesoft. i did some research on this and found SS_STAT_INDICAtor flag which has this info for at employee level..

Vijay - February 21st, 2009

Hi, we are running EPM 8.9 & tools 8.47 We need to lock the users from editing PS trees on a monthly basis for 1 week. Is there are way to lock the PeopleSoft trees without having to change the Perm lists everytime (Users ~20). Did some research and found that PS usually locks the trees(during a tree copy or tree moving) through PSLOCK & PSVERSION, I don't want to mess with Lock and Version by a custom process, thought of checking it here if there is any other way. Any Help is highly appreciated. ~Thanks Vj

Rahul - February 20th, 2009

Hi, I have a variable length problem in SQR. My SQL fetches the value 789,644,254,825 from the database as part of our test cases. But, my variable is unable to hold it and shows the following error: SQR 5528) ODBC SQL dbftch error 8115 in cursor 24: [Microsoft][ODBC SQL Server Driver][SQL Server] Error on line 742: (SQR 3725) Bad return fetching row from database. SQR for PeopleSoft: Program Aborting.

Wayne Simpson - February 17th, 2009

I am very new to PeopleSoft but it has been running for about two years in my company. I have the task of loading new employee information. I have the information in a database and currently people are re-entering all the information into PeopleSoft. I understand there are some API's that I could use to load this information. I do not know where to start. HELP!!

JG - February 17th, 2009

Hi, This is regarding IB (Application: 8.80, Tools: 8.45). I've an InSync transaction defined on a PIA Node. In this transaction I'm posting a xml message. Now if I put password on this PIA node, what changes do I need to do in xml message or in URL on which the message is being post. the structure of which is like: {?xml version="1.0"?} {EL_PT_REQ_MSG} {FieldTypes} {EL_PT_REQ_WRK class="R"} {CASE_ID type="NUMBER"/} {/EL_PT_REQ_WRK} {PSCAMA class="R"} {LANGUAGE_CD type="CHAR"/} {AUDIT_ACTN type="CHAR"/} {BASE_LANGUAGE_CD type="CHAR"/} {MSG_SEQ_FLG type="CHAR"/} {PROCESS_INSTANCE type="NUMBER"/} {/PSCAMA} {/FieldTypes} {MsgData} {Transaction} {EL_PT_REQ_WRK class="R"} {CASE_ID}255935{/CASE_ID} {/EL_PT_REQ_WRK} {PSCAMA class="R"} {LANGUAGE_CD}ENG{/LANGUAGE_CD} {AUDIT_ACTN IsChanged="Y"}A{/AUDIT_ACTN} {BASE_LANGUAGE_CD}ENG{/BASE_LANGUAGE_CD} {MSG_SEQ_FLG/} {PROCESS_INSTANCE}0{/PROCESS_INSTANCE} {/PSCAMA} {/Transaction} {/MsgData} {/EL_PT_REQ_MSG} I'm posting this message on following URL http://SERVER_Name/PSIGW/HttpListeningConnector?From=XML_NODE&To=PSFT_CR&MessageName =EL_PT_REQ_MSG&MessageVersion=VERSION_1 thanks !

Raam Naidu - February 17th, 2009

Hi, Can I handle the Database Level Delivered Error Messages? I have to show the user a user-friendly message instead of : "Duplicate Key Value -- not allowed. (15,7)" - - - - - - - - - - - - (which comes when user adds a new row with same keys in the scroll area; where user cannot see the old row and the new row at the same time) Thanks, Rama Naidu.

Madan - February 16th, 2009

Hi My client is upgrading from FO 8.4 FS 8.4 HRMS 8.3 to FS 8.9 HRMS 8.9. Current FO 8.4 is going to be part of FS & HRMS 8.9. How do I get a list of current FO 8.4 tables and its equivalent FS or HRMS 8.9 tables? Appreciate your help. Thanks Madan

Rama Naidu - February 13th, 2009

Hi, Can we create a View in App Designer, which accesses tables from another link server? eg: select EMPLID from [psserv6].[HRUAT].dbo.PS_JOB Also I have an uppercase problem with the following View. %NoUppercase SELECT EMPLID , GRADE FROM [HRSTAG].dbo.PS_JOB the owner "dbo" should be in lowercase only. I get the following SQL error on build: SQL error. Stmt #: 2675 Error Position: 0 Return: 8601 - [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'NOUPPERCASE'. [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180 CREATE VIEW PS_Q_DB_TEST (EMPLID, GRADE) AS NOUPPERCASE SELECT EMPLID , GRADE FROM [HRSTAG].dbo.PS_JOB When I dont use %NoUpperCase, it automatically casts as ".DBO."(so gives an invalid object error) I am using PT 8.42 version. Please suggest a solution. Thanks, Rama Naidu.

Denny - February 12th, 2009

Hi Expert, I need to do HRCS9.0 MP5 Upgrade. Here is my environment: PT8.49.11, HRCS9.0 and I need to configgure it with ZAF localizations. PLease I need some help. I havn't done any upgrade before besides, this is on my DEMO workstation. Just want to understand how to get this upgrade thing done. Thanks in good anticipation. Texas!

abby - February 12th, 2009

hi, we've been experiencing problem in Absence Approve/Deny Process. we're encountering the error message "1 No Rows exist for specified keys. {GP_ABSENCE_EVENT} (91,50) No rows exist on the database with the specified keys. (0,0)". we cant find a permanent solution on this, the temporary solution we have is to add the dept id of the employee to Security by Dept Tree of the supervisor, but we cant do this all the time especially when in a big company. the error occurred after applying a patch to the existing system. please help. this is a very tedious process and the clients are beginning to get irritated due to this error. thanks.

Rahul Bagade - February 10th, 2009

Hi, I have created a permission list and included 4 components from the Menu into it. After assigning role to user, user can access all 4 components and its pages. After sometime I marked one more component as "Authorized" in the "Edit Pages" link (has only one page) in the same permission list. But user is getting error like "You are not authorized for this page. http://175.26.29.80:8080/psc/YSHRSTAG/EMPLOYEE/ HRMS/c/ADMINISTER_TRAINING_(GBL).COURSE_ENROLLMENT1.GBL" Can you please explain me why this error message is coming??

Rajan Rikame - February 9th, 2009

Hi, I need some help from anyone who has faced/resolve the issue: We had an AE (EPM 8.9)which runs in DEV & UAT in less than 30 min. But we ran the same AE in PROD it gets hanged forever. Its at particular Steps where a one of the insert (into one PS temp table) SQL fails due to PSTEMP unable to extend. Initially we thought its a PSTEMP space issue. We had increased by 45GB of Space in PSTEMP totalling 130GB. But still the SQL keep on piling up the PSTEMP and at the end it failed with same error(unable to extend). The select sql behind the insert return the 19 rows in just 2 seconds in PROD. The explain plan for the SQL was not costly just 4 figure. I am now feeling that its due to PS and not database issue. Can Someone help me out to get the direction fo r troublshooting this or any resolution other than what I mentioned above. Thanks in Advance.

Rama Naidu - February 7th, 2009

Hi, I have a strange situation in our TEST environment. In HRMS - Workforce Administration > Job Information > Job Data. We are terminating some IDs. But, the SAVE is NOT happening. Its page shows the message "Saved". But the 'TER' action row does not get saved in the data base. When I return to search and come back to the page, I do not find the 'TER' row either. One thing I have observed is that it happens for all those who have a User Profile. If i hire a new guy without creating a user profile, i am able to terminate him. Thanks, Rama Naidu

Krishna - February 6th, 2009

Hi, We are working on the Billing -> Maintain Bills -> Adjust Entire Bill Page. The page is designed in such a way that once the user selects the credit & rebill option and clicks save both credit and rebill invoices will be generated. We are planning to display the details of the Rebill invoice generated after clicking the save when this option is selected. This will help the user to make any changes that may be required. Kindly let us know how this can be achieved. We are on FSCM 8.4 and PeopleTools 8.46.05 Also please let us know if there are any pages that has similar functionality. Please help.

Rama Naidu - February 5th, 2009

Hi, I have a Field "Country" on a page, actually on a subpage. Main Table: A, Subrecord: CM_ADDRESS_SBR, Subrecord: ADDRESS_SBR -> A contains CM_ADDRESS_SBR -> CM_ADDRESS_SBR contains ADDRESS_SBR It has COUNTRY_TBL as the prompt table in the subrecord. It gives the entire 200+ countries. Our users want only the frequently used 10-15 countries to be shown in the list. I have to clear the dropdown of this country field to add a few frequently used countries. I tried the 3 ways of below code with the 3 tablenames: (at ADDRESS_SBR.COUNTRY.RowInit)(Have tried at Field Formula also, but no use) ############# Local Field &FLD_ADDR; &FLD_ADDR = GetRecord(Record.ADDRESS_SBR).GetField(Field.ADDRESS_DROPDOWN); &FLD_ADDR.ClearDropDownList(); ############## None of them worked. I get the error with the 3 tablenames respectively: "GetRecord: Record 'ADDRESS_SBR' not found in scroll level 0" So how can I get the field object to clear the dropdown list? Thanks, Rama Naidu

Krishna - February 5th, 2009

I am trying to add translate values(using radio buttons) of derived work record field onto a page.The field has 5 translate values. The default value is NO. I would like to use only two translate values of the field on my page. These two fields doesnt contain my default value.When I am trying to save the page it throws me a warning "The following record field occurs more than once on this page(number of times)". When i am trying to access this field from PIA i am able to select both the values. Please let me know what am I missing here? I would like to have one of these values used to be defaulted. Please help.

Hex wisher - February 5th, 2009

HTML page is showing the banner of "Pit Stop" instead of "PeopleSoft Fieldbook". Pls look into it.

Altab khan - February 3rd, 2009

Hi PeopleSoft Teams, To let us know the feasibility of invoking a CI present in X instance from another instance Y either with or without any links. Also how to pass the parameters for the same.

Rama Naidu - January 30th, 2009

Hi, PS does not recommend the usage of SQLExec(). > What are the reasons for it? > Please suggest how we can avoid its usage, with the alternatives. Thanks, Rama Naidu.

Asad Hamdare - January 29th, 2009

Hi Murali, Please include setup32.sqc(for landscape) in your sqr report to print the report in landscape format. Thanks, Asad PS : setup31.sqc for portrait

Murali - January 29th, 2009

Hi, The default report orientation in sqr is portrait. If I have to change the default to landscape, where should I do that.Do we need any set up or modify any configuration file. Please advise

Asad Hamdare - January 29th, 2009

Hi Murali, Please include setup32.sqc(for landscape) in your sqr report to print the report in landscape format. Thanks, Asad PS : setup31.sqc for portrait

Murali - January 29th, 2009

Hi, The default report orientation in sqr is portrait. If I have to change the default to landscape, where should I do that.Do we need any set up or modify any configuration file. Please advise

Francis T. - January 29th, 2009

Hi, I'm having trouble with my PS Process Scheduler in Version 7.5. Sometimes it starts without any problems but sometimes it goes a little something like this: STARTTING PROCESS SCHEDULER PSNT ON DATABASE XXXXXXX. PROCESS SCHEDULER WILL BE RESTARTED UP TO 50 TIMES. OPERATOR_BOOT WILL BE SENT NOTIFICAITON. Could not find the file. Sleeping for 5 minutes." Please advise. Thank you!

Francis T. - January 28th, 2009

Hi, I'm having trouble with my PS Process Scheduler in Version 7.5. Sometimes it starts without any problems but sometimes it goes a little something like this: STARTTING PROCESS SCHEDULER PSNT ON DATABASE XXXXXXX. PROCESS SCHEDULER WILL BE RESTARTED UP TO 50 TIMES. OPERATOR_BOOT WILL BE SENT NOTIFICAITON. Could not find the file. Sleeping for 5 minutes." Please advise. Thank you!

Pradeep K - January 27th, 2009

We have a PRD1 PS enviroment and PRD2(copy of PRD1) PS environment.PRD2 gets refreshed every month from PRD1. I would like to create a userid(like PS) in PRD1 with Display Only access to everything and when the PRD2 gets refreshed with PRD1, this ID should have access to everything in Display/update/Correction in PRD2. How do I do that and where do I need write peoplecode to identify the database name? Thanks for your help. Pradeep

Rama Naidu - January 27th, 2009

Hi, PeopleBook says: "The only mutually exclusive actions within a single step are Call Section and SQL Statement; you cannot add a Call Section action to a step that already contains a SQL Statement action and visa versa. You can include only one of each action type within a single step." But I couldn't find any reason/explanation for it. Can anybody tell why it is so? Thanks, Rama Naidu.

Rama Naidu - January 27th, 2009

Hi, PeopleBook says: "The only mutually exclusive actions within a single step are Call Section and SQL Statement; you cannot add a Call Section action to a step that already contains a SQL Statement action and visa versa. You can include only one of each action type within a single step." But I couldn't find any reason/explanation for it. Can anybody tell why it is so? Thanks, Rama Naidu.

Rama Naidu - January 27th, 2009

Hi, Is it possible to write Images along with HTML text into a file created in an App Engine ? I have to generate Appraisal Letters in Bulk. I am generating .doc files in an App Engine and writing the Appraisal Letter content into them with bind parameters using fileobject.writeline(htmlcontent). ####################### Code: (with output results in comments) &file_APPL_STATUS = "C:\temp\Letter_" | DateTimeToLocalizedString(%Date, "dd-MM-yyyy") | ".doc"; &APPL_STATUS_REPORT = GetFile(&file_APPL_STATUS, "w", %FilePath_Absolute); &APPL_STATUS_REPORT.Open(&file_APPL_STATUS, "w", %FilePath_Absolute); &EMPLID = "15257"; &EFFDT = "2007-04-01"; SQLExec("SELECT .. FROM PS_NAMES A, PS_JOB B, PS_SAL_GRADE_TBL C, PS_JOBCODE_TBL D WHERE A.EMPLID = :1 and B.EFFDT = :2 AND B.ACTION IN ('PRO', 'PAY') ..", &EMPLID, &EFFDT, &NAME_PREFIX, &FIRST_NAME, &LAST_NAME, &ACTION, &BAND, &GRADE, &DESIGNATION, &CTC); SQLExec("SELECT B.SY_SIG_NAME, B.SY_DESIGNATION50, B.SY_DIGITAL_SIGN FROM PS_SY_STEP_SIGN A, PS_SY_STEP_DIG_SIG B WHERE A.EMPLID = :1 AND B.EMPLID = A.SY_SIGNATRY_EMPLID AND A.EFFDT=B.EFFDT AND B.EFFDT = :2 AND A.COMPANY='001' AND A.COMPANY=B.COMPANY", &EMPLID, &EFFDT, &SIGNATORY_NAME, &SIGNATORY_DESG, &DIGITAL_SIGN); SQLExec("SELECT SY_SIG_NAME, SY_DESIGNATION50, SY_DIGITAL_SIGN FROM PS_SY_STEP_DIG_SIG WHERE EMPLID = :1 AND EFFDT = :2 AND COMPANY = '001'", "11132", &EFFDT, &STATIC_SIGNATORY_NAME, &STATIC_SIGNATORY_DESG, &STATIC_DIGITAL_SIGN); SQLExec("INSERT INTO PS_SY_IMG_1 VALUES(:1,:2)", Image.SY_SYNTEL_LOGO, Image.SY_SYNTEL_LOGO); SQLExec("SELECT * FROM PS_SY_IMG_1", &IMG_1, &IMG_2); &str1 = " %BIND(:18)%BIND(:19)%BIND(:20)%BIND(:21)Tel : %BIND(:22)Fax : %BIND(:23)www.syntelinc.com STEP Review 2007-08"; &str2 = "Date: 28 June, 2008.Employee ID : " | &EMPLID | "Name : " | &FIRST_NAME | " " | &LAST_NAME | ""; &str3 = "Grade : " | &GRADE | "Designation : %BIND(:13)-->Dear" | &FIRST_NAME | "Having reviewed your performance for the year 2007, we would regret to inform you that that your contributions Did not meet Expectations. You are rated as Less Effective 10."; &str4 = "With effect from " | &EFFDT | " your total compensation has been revised. Your revised Compensation is "; &str5 = "Rs." | &CTC | "/- per annum. A detailed break-up of your revised compensation structure has been attached herewith. All other terms & conditions remain unchanged. Yours Sincerely,"; &str6 = " " | "FIELD 1" | &IMG_1 | " " | "FIELD 2" | &IMG_2 | " " | "HAI:" | "" | " " | &img | " "; &str7 = "Enclosed:a) Salary Annexure-->"; &html_content_1 = &str1 | &str2 | &str3 | &str4 | &str5 | &str6 | &str7 ; REM &APPL_STATUS_REPORT.WriteLine(&STATIC_DIGITAL_SIGN); /* output: the word 'Image' */ rem &APPL_STATUS_REPORT.WriteRaw(&IMG_1); /* output: blank page */ rem &APPL_STATUS_REPORT.WriteRaw(&IMG_2); /* output: SY_SYNTEL_LOGO */ rem &APPL_STATUS_REPORT.WriteRaw(Image.SY_SYNTEL_LOGO); /* output: blank page */ REM &APPL_STATUS_REPORT.WriteRaw(&STATIC_DIGITAL_SIGN); /* output: Image */ &APPL_STATUS_REPORT.WriteLine(&html_content_1); &APPL_STATUS_REPORT.Close(); ################ My HTML tags in above code are being executed in this website - so u find no tags in above code. &IMG1 is from a ImageReferance Type Field &IMG2 and &STATIC_DIGITAL_SIGN are from Image Type Fields ################ in the output i see a small box with a red 'x' mark, wherever an amage is expected. WriteRaw() works, but not along with Writeline. I need to print both the HTML text and the Images together, into the file. Please suggest a solution. Thanks, Rama Naidu.

Rama Naidu - January 27th, 2009

Hi, Is it possible to write Images along with HTML text into a file created in an App Engine ? I have to generate Appraisal Letters in Bulk. I am generating .doc files in an App Engine and writing the Appraisal Letter content into them with bind parameters using fileobject.writeline(htmlcontent). ####################### Code: (with output results in comments) &file_APPL_STATUS = "C:\temp\Letter_" | DateTimeToLocalizedString(%Date, "dd-MM-yyyy") | ".doc"; &APPL_STATUS_REPORT = GetFile(&file_APPL_STATUS, "w", %FilePath_Absolute); &APPL_STATUS_REPORT.Open(&file_APPL_STATUS, "w", %FilePath_Absolute); &EMPLID = "15257"; &EFFDT = "2007-04-01"; SQLExec("SELECT .. FROM PS_NAMES A, PS_JOB B, PS_SAL_GRADE_TBL C, PS_JOBCODE_TBL D WHERE A.EMPLID = :1 and B.EFFDT = :2 AND B.ACTION IN ('PRO', 'PAY') ..", &EMPLID, &EFFDT, &NAME_PREFIX, &FIRST_NAME, &LAST_NAME, &ACTION, &BAND, &GRADE, &DESIGNATION, &CTC); SQLExec("SELECT B.SY_SIG_NAME, B.SY_DESIGNATION50, B.SY_DIGITAL_SIGN FROM PS_SY_STEP_SIGN A, PS_SY_STEP_DIG_SIG B WHERE A.EMPLID = :1 AND B.EMPLID = A.SY_SIGNATRY_EMPLID AND A.EFFDT=B.EFFDT AND B.EFFDT = :2 AND A.COMPANY='001' AND A.COMPANY=B.COMPANY", &EMPLID, &EFFDT, &SIGNATORY_NAME, &SIGNATORY_DESG, &DIGITAL_SIGN); SQLExec("SELECT SY_SIG_NAME, SY_DESIGNATION50, SY_DIGITAL_SIGN FROM PS_SY_STEP_DIG_SIG WHERE EMPLID = :1 AND EFFDT = :2 AND COMPANY = '001'", "11132", &EFFDT, &STATIC_SIGNATORY_NAME, &STATIC_SIGNATORY_DESG, &STATIC_DIGITAL_SIGN); SQLExec("INSERT INTO PS_SY_IMG_1 VALUES(:1,:2)", Image.SY_SYNTEL_LOGO, Image.SY_SYNTEL_LOGO); SQLExec("SELECT * FROM PS_SY_IMG_1", &IMG_1, &IMG_2); &str1 = " %BIND(:18)%BIND(:19)%BIND(:20)%BIND(:21)Tel : %BIND(:22)Fax : %BIND(:23)www.syntelinc.com STEP Review 2007-08"; &str2 = "Date: 28 June, 2008.Employee ID : " | &EMPLID | "Name : " | &FIRST_NAME | " " | &LAST_NAME | ""; &str3 = "Grade : " | &GRADE | "Designation : %BIND(:13)-->Dear" | &FIRST_NAME | "Having reviewed your performance for the year 2007, we would regret to inform you that that your contributions Did not meet Expectations. You are rated as Less Effective 10."; &str4 = "With effect from " | &EFFDT | " your total compensation has been revised. Your revised Compensation is "; &str5 = "Rs." | &CTC | "/- per annum. A detailed break-up of your revised compensation structure has been attached herewith. All other terms & conditions remain unchanged. Yours Sincerely,"; &str6 = " " | "FIELD 1" | &IMG_1 | " " | "FIELD 2" | &IMG_2 | " " | "HAI:" | "" | " " | &img | " "; &str7 = "Enclosed:a) Salary Annexure-->"; &html_content_1 = &str1 | &str2 | &str3 | &str4 | &str5 | &str6 | &str7 ; REM &APPL_STATUS_REPORT.WriteLine(&STATIC_DIGITAL_SIGN); /* output: the word 'Image' */ rem &APPL_STATUS_REPORT.WriteRaw(&IMG_1); /* output: blank page */ rem &APPL_STATUS_REPORT.WriteRaw(&IMG_2); /* output: SY_SYNTEL_LOGO */ rem &APPL_STATUS_REPORT.WriteRaw(Image.SY_SYNTEL_LOGO); /* output: blank page */ REM &APPL_STATUS_REPORT.WriteRaw(&STATIC_DIGITAL_SIGN); /* output: Image */ &APPL_STATUS_REPORT.WriteLine(&html_content_1); &APPL_STATUS_REPORT.Close(); ################ My HTML tags in above code are being executed in this website - so u find no tags in above code. &IMG1 is from a ImageReferance Type Field &IMG2 and &STATIC_DIGITAL_SIGN are from Image Type Fields ################ in the output i see a small box with a red 'x' mark, wherever an amage is expected. WriteRaw() works, but not along with Writeline. I need to print both the HTML text and the Images together, into the file. Please suggest a solution. Thanks, Rama Naidu.

Dave Espenson - January 24th, 2009

How do I search for information in your blog. Collaborate had an article about determining user access to pages and there is SQL. I would rather copy/paste than to have to retype.

Dave Espenson - January 24th, 2009

How do I search for information in your blog. Collaborate had an article about determining user access to pages and there is SQL. I would rather copy/paste than to have to retype. Thanks.

beginner - January 23rd, 2009

Hi I have a requirement as a database cleanup to delete non required Workers from Database. Can you please advice on Worker related data and which peoplesoft tables should be hit. CRM 8.9

beginner - January 23rd, 2009

Hi I have a requirement as a database cleanup to delete non required Workers from Database. Can you please advice on Worker related data and which peoplesoft tables should be hit. CRM 8.9

Rama Naidu - January 23rd, 2009

Hi, My User has a question: "Why should I run the Report(AE/SQR) using process monitor. Why doesn't it give the excel file just like that!" What is the best solution fot it? Especially when the output data is very huge.. I have a few ideas: 1. On First Button PeopleCode: CallAppEngine() On Second Button PeopleCode: ViewAttachment() 2. On First Button PeopleCode: [ Paste the AppEngine Code, with SendMail to current user with excel attachment ] 3. On a Button: ScrollSelect() Result data would be populated in a Grid(with "No Auto Select") based on a view. Then, "Download to Excel". Thanks, Rama Naidu.

Rama Naidu - January 23rd, 2009

Hi, My User has a question: "Why should I run the Report(AE/SQR) using process monitor. Why doesn't it give the excel file just like that!" What is the best solution fot it? Especially when the output data is very huge.. I have a few ideas: 1. On First Button PeopleCode: CallAppEngine() On Second Button PeopleCode: ViewAttachment() 2. On First Button PeopleCode: 3. On a Button: ScrollSelect() Result data would be populated in a Grid(with "No Auto Select") based on a view. Then, "Download to Excel". Thanks, Rama Naidu.

Rama Naidu - January 23rd, 2009

Hi, My User has a question: "Why should I run the Report(AE/SQR) using process monitor. Why doesn't it give the excel file just like that!" What is the best solution fot it? Especially when the output data is very huge.. I have a few ideas: 1. On First Button PeopleCode: CallAppEngine() On Second Button PeopleCode: ViewAttachment() 2. On First Button PeopleCode: 3. On a Button: ScrollSelect() Result data would be populated in a Grid(with "No Auto Select") based on a view. Then, "Download to Excel". Thanks, Rama Naidu.

Larry Decker - January 22nd, 2009

I am looking to find a tracing tool that will show me inserts into tables when executing application packages. I have tried many different ways to setup the Peoplesoft delivered traces but don't seem to get the insert statements I am looking for. I am working on version 9 of PeopleSoft and trying to trace the Expenses workflow process. I know tables that this code inserts into but do not see these table insert references in the trace. Any help would be greatly appreciated lardecker@hotmail.com

vamsi - January 22nd, 2009

Hi, I have a user from Japan complaining about the alignment of two fields on a page. I have checked the same in English and its absolutely fine. So i adjusted the fields in Japaneese language portal so that the fields are correctly aligned. Could you please let me know how should i reflect these changes in the production system? I am not sure whether I can carry forward the changes with out any effect to the other langauage users? Thanks

Rama Naidu - January 20th, 2009

Hi, Is there any way to copy the list of objects from App Designer (Upgrade View) into an Excel or Word Document? Making the Object Migration Forms and Technical Specification Forms, is a huge mechanical work, when the project is huge. The huge list of objects (Pages,Components,Records,PeopleCode with Event types etc.) has to be manually typed into an Excel/Word Doc & consumes a lot of time. Please suggest a solution. Thanks, Rama Naidu.

Andi - January 19th, 2009

Our client is trying to implement ESP Scheduler and migrate from Peoplesoft Process scheduler.Ant help on the ESP Scheduler wld be appreciated.

Ravi - January 19th, 2009

Hi, We are implementing CRM for a Bank. For that we are importing all the Customers, account details and different relationships between them through various AE's. The AE programs are required to be executed in following sequence; 1. Import Personal Customer Details. 2. Import Non-Personal Customer Details. 3. Import Financial Details. 4. Import Relationship Details. 5. Archive all the Input Files to Backup Folders. Every AE should start on successful completion of the prior one. How do we make sure this happens automatically starting 1 AM every night and should complete without human intervention. A user has been created who just have the access to run these programs. How do we make sure, different Run Control ID's are created for this user before execution of above mentioned AE's start using these Run Control ID's ? Thanks in Advance.

Frank Young - January 16th, 2009

We are running 8.9 JDE One World with tools release 8.96.3.1 on an iSeries 520. What is best practices for deleting E1 SQL Packages?

Jim Terlizzi - January 13th, 2009

Has anyone experienced any issues in Talent Acquisition Management in Peoplesoft HCM 9.0 where applicants are being dropped from the system? We did have this problem in version 8.8 where applicants think they applied successfully online but none of their data was saved. One of the signs of this was skipped applicant ID's. We are noticing skipped applicant ID's in 9.0 but it does not appear to be due to missing applicant information. In 8.8 we set up custom tables to catch applicant data before the submit button was pressed. Is this necessary in 9.0? Any insight on this would be greatly appreciated.

Rahul Bagade - January 12th, 2009

Can I Use Digital Signature in SQR report? Thanks in advance, Rahul

Rahul Bagade - January 12th, 2009

Hi, I am doing an SQR to generate offer letter. I am fetching Designation field from the databse that needs to be printed in bold. I am printing Desg line like this : #row_no = 5 print 'Some Text' (#row_no,1) print $Designation (#row_no,15) Bold print 'More Text on the same line' (#row_no,35) The problem that I have faced is when the size of $Designation field is too small there will be big gap after designation & if the size of $Designation field is big then it overlaps with next text. I can not concatenate the above 3 lines text as I want to print Designation in Bold. Like Designation there are many fields that i am fetching from the database & needs to be printed in Bold. Can you please suggest me how should I handle this case or any other logic that can be used.

Nishant Kumar - January 12th, 2009

Hi, On press of prompt we get a search page. On this search page we have one dropdown field with NAME and PERSON_ID as values. Whenever we try to do a search with name field the system logs out. Through trace file we got the SQL being used to retrieve the value on this search page. Now we need to change this SQL to tune it. I even tried to capture the adapters being used to create this SQL but whenever i try to generate the trace file with peoplecode properties the trace file does not generate. It generates only if i select SQL properties on tace. Do we have any configurations for this? Please help!!!

cahkri - January 9th, 2009

If we have a client who is multi-companies and each company have different standard hours, how can we achieve this since 1 user profile can only be tied to only 1 Primary permission list? (in Peoplesoft HCM 9.0 & Tools 8.49) Thanks in advance Chakri

JG - January 8th, 2009

I've Application ver: CRM 8.80.01.000 & Tools ver: 8.45.08 I'm using Sendmail function to send an email, through an application engine. But it is not working. When I run it in debug mode, the Sendmail function's return value is 3. Then I tried this function on a button click. I wrote the following code to run it SendMail (0, "jg@yahoo.com", "", "", "subject", "text"); But it shows me the following error: Failed to connect to the SMTP server at 10.20.105.241:25 (80,1) A connection with the specified SMTP server was not established. The SMTP service on the specified host may not be available. However, if I use the Notification component to send an email, the email is fired without showing me any error. Please help!

Praveen - January 8th, 2009

Hi, I want to implement a discussion page as we use in ICE. Please provide me an info on that. Thanks in advance.

Rama Naidu K S - January 7th, 2009

Hi, I need to pick all the files(.pdf) which are generated by an SQR into a particular Folder, AND store them into a database record. I have done it in App Engine, Using PutAttachment() and a Record URL (record://PSFILE_ATTDET). Is it possible to do the same in SQR? (So that I can directly write the pdf files generated by the SQR into the database) Thanks, Rama Naidu.

Naveen Paulraj - January 6th, 2009

Hi, We are in the process of implementing the Journal upload using the Peoplesoft delivered excel spreadsheet. I went through the peoplesoft document and it gives the steps how to upload the spreadsheets. But I am looking for something how to setup the XML LINK url. If you have any documents or any sugestions,which will be of great help. Thanks in advance.

Rama Naidu K S - January 6th, 2009

Hi, Do we need to fetch data using code to populate the grid in a secondary page? Or can it be done by mapping keys from parent page to secondary page? What is the difference between using domodal and using the Destination = Secondary page on button properties? Thanks, Rama Naidu.

Rama Naidu K S - January 6th, 2009

Hi, Is it possible to generate a PDF file from an App Engine? If so, is it possible to write HTML content into it (using file.writeline or any other way) Thanks, Rama Naidu.

Sri - December 30th, 2008

Hello All, I have to write a SQR in such a way that it needs to execut either in report mode or in process mode. I have to put a process flag on runcontrol page to choose the mode. If it is Process Mode it just needs to insert a row in JOB, BAS_ACTIVITY table based on some logic. If it is report mode it needs to generate CSV file. Please let me know is there any delivered sqr to look into or guide me how to achieve this task. Thanks in Advance!

Sri - December 30th, 2008

Hello All, I have to write a SQR in such a way that it needs to execut either in report mode or in process mode. I have to put a process flag on runcontrol page to choose the mode. If it is Process Mode it just needs to insert a row in JOB, BAS_ACTIVITY table based on some logic. If it is report mode it needs to generate CSV file. Please let me know is there any delivered sqr to look into or guide me how to achieve this task. Thanks in Advance!

Sri - December 30th, 2008

Hello, I have to write a SQR in such a way that it needs to execut either in report mode or in process mode. I have to put a process flag on runcontrol page to choose the mode. If it is Process Mode it just needs to insert a row in JOB, BAS_ACTIVITY table based on some logic. If it is report mode it needs to generate CSV file. Please let me know is there any delivered sqr to look into or guide me how to achieve this task. Thanks in Advance!

Priya - December 29th, 2008

Hai, how to hire an employee using component interface and application engine, the employee details being given in a csv file

Priya - December 29th, 2008

Hai, how to hire an employee using component interface and application engine, the employee details being given in a csv file

Radha - December 21st, 2008

I would like to use NEWGRAPHICS functionality in SQR. I have added the NEWGRAPHICS=TRUE command in the SQR.INI file in the [Default-Settings] section. But the SQR is not accepting the functionality. Even though there are no errors, it produces blank page instead of the chart. If I removed the command from SQR.INI file, it works fine and produces the chart. Do we need to have some advanced setups? (Like Windows XP, JRE versions etc.). Is it compatible to only few versions of SQR? Please clarify. I need to have combination chart and some other advanced functionalities (like color etc.,) in Charts. Is there any other ways to do that? Please intimate. Thanks.

Radha - December 21st, 2008

I would like to use NEWGRAPHICS functionality in SQR. I have added the NEWGRAPHICS=TRUE command in the SQR.INI file in the [Default-Settings] section. But the SQR is not accepting the functionality. Even though there are no errors, it produces blank page instead of the chart. If I removed the command from SQR.INI file, it works fine and produces the chart. Do we need to have some advanced setups? (Like Windows XP, JRE versions etc.). Is it compatible to only few versions of SQR? Please clarify. I need to have combination chart and some other advanced functionalities (like color etc.,) in Charts. Is there any other ways to do that? Please intimate. Thanks.

PS - December 19th, 2008

I am unable to view My Favorites in my portal sidebar. Also, this is not present in the PeopleTools > Portal > Structure and Content. Please help.

PS - December 19th, 2008

I am unable to view My Favorites in my portal sidebar. Also, this is not present in the PeopleTools > Portal > Structure and Content. Please help.

jg - December 18th, 2008

Hi, I've PT v 8.45 & CRM application v 8.80. I want to fire an email using application engine. And this email should be generated using Template I define (Setup CRM-> Common Definitions-> Correspondence). In this template I've an e-mail template & some Tokens, which get data from PS Query. The app engine would pick the template name from the setup table, which I'll define. Now my problem is, how can I generate the email text using these templates & tokens? As I'm not sure how the data would be passed to the tokens from the PSQuery, and how I'll pass the data to binding variables of the PSQuery. For your information, the app engine would be scheduled to run during particular time of the day. Thanks!

jg - December 18th, 2008

Hi, I've PT v 8.45 & CRM application v 8.80. I want to fire an email using application engine. And this email should be generated using Template I define (Setup CRM-> Common Definitions-> Correspondence). In this template I've an e-mail template & some Tokens, which get data from PS Query. The app engine would pick the template name from the setup table, which I'll define. Now my problem is, how can I generate the email text using these templates & tokens? As I'm not sure how the data would be passed to the tokens from the PSQuery, and how I'll pass the data to binding variables of the PSQuery. For your information, the app engine would be scheduled to run during particular time of the day. Thanks!

Camille - December 18th, 2008

I am doing a mass data upload. I read a csv file and use CI for the upload. Each row in the CSV file is one row of data to be uploaded. If one of the rows has a validation error (for example, incorrect translate value being entered) the whole program fails and the succeeding rows are no longer processed. What I would like to do is trap this error and let the program continue processing the other rows in the CSV file. I am using PeopleTools 8.21.10 and I believe there is still no Try-Catch functionality that I could use in this version. How can I then implement error handling? I also tried to set the Step and Action properties of the App Engine but they seem to be not working.

Camille - December 18th, 2008

I am doing a mass data upload. I read a csv file and use CI for the upload. Each row in the CSV file is one row of data to be uploaded. If one of the rows has a validation error (for example, incorrect translate value being entered) the whole program fails and the succeeding rows are no longer processed. What I would like to do is trap this error and let the program continue processing the other rows in the CSV file. I am using PeopleTools 8.21.10 and I believe there is still no Try-Catch functionality that I could use in this version. How can I then implement error handling? I also tried to set the Step and Action properties of the App Engine but they seem to be not working.

NP - December 16th, 2008

How can I find all the roles and the records that the roles can access using Query Manager? Thanks!

NP - December 16th, 2008

How can I find all the roles and the records that the roles can access using Query Manager? Thanks!

Ganesh Hegde - December 12th, 2008

Hi, I have a security related issue. When the user run a (any type)process, process is showing success. But for some processes (All type of processes SQR, AE, Scheduled Jobs etc) process log displaying a message "You are not authorized to run process type SQR Report and process name XXXXX.” I analyzed the process for 30 days. Problem was not there at initial stages. Also, I analyzed the SQR process ‘XXXXX’ for last 30 days. I observed that SQR process ‘XXXXX’ went to error first time around 15 days back for a user ‘AAAAA’ and the error was "You are not authorized to run process type SQR Report and process name XXXXX” which is same as above log message. From this point other process also getting above log message. What is the reason for this problem and what’s the solution?

jg - December 12th, 2008

Hi, This is a very basic question, but I'm not 100% sure about it. Which code should be written in SavePreChange & which in SavePostChange event? I'm not able to fully differentiate between these two events. Thanks

jg - December 12th, 2008

Hi, This is a very basic question, but I'm not 100% sure about it. Which code should be written in SavePreChange & which in SavePostChange event? I'm not able to fully differentiate between these two events. Thanks

Ganesh Hegde - December 12th, 2008

Hi, I have a security related issue. When the user run a (any type)process, process is showing success. But for some processes (All type of processes SQR, AE, Scheduled Jobs etc) process log displaying a message "You are not authorized to run process type SQR Report and process name XXXXX.” I analyzed the process for 30 days. Problem was not there at initial stages. Also, I analyzed the SQR process ‘XXXXX’ for last 30 days. I observed that SQR process ‘XXXXX’ went to error first time around 15 days back for a user ‘AAAAA’ and the error was "You are not authorized to run process type SQR Report and process name XXXXX” which is same as above log message. From this point other process also getting above log message. What is the reason for this problem and what’s the solution?

shailendra - December 11th, 2008

Hi, I am working on a macro to run query in People soft ps query from excel and save the output at given path. Here are steps that I exactly want to do 1. Put all query name (not entire query) under column a in excel Sheet. 2. Run macro to open PS Query. 3. Run query (only private) in PS Query. 4. Output should be saving at given path in given format. Primarily I am looking for some code to invoke ps query from excel macro. Please suggest me on this. Thanks in advance Regards Shailendra

shailendra - December 11th, 2008

Hi, I am working on a macro to run query in People soft ps query from excel and save the output at given path. Here are steps that I exactly want to do 1. Put all query name (not entire query) under column a in excel Sheet. 2. Run macro to open PS Query. 3. Run query (only private) in PS Query. 4. Output should be saving at given path in given format. Primarily I am looking for some code to invoke ps query from excel macro. Please suggest me on this. Thanks in advance Regards Shailendra

Carl Williams - December 10th, 2008

Dear Nitin Pai, I was looking at your blog, Hexaware and I thought our Q3, 2008 Job Market Statistics, providing a comprehensive picture of the Oracle BI job market including historical comparison of the demand trends, median salary and salary distribution would be of interest to you. Please take a look at Oracle Apps Market Statistics ( http://www.odinjobs.com/Odin/marketstatcompare?id=6246&q=Oracle+Apps ). Better yet, you can compare Oracle Apps to another skill of your choice. You can also add variables such as location, role, and industry. Here is an example of Oracle Apps versus SAP ( http://www.odinjobs.com/Odin/marketstatcompare?id=6247&q=Oracle+Apps+vs+SAP ). Here is another example of how Vincent McBurney analyzed the data and created "How to kick start your Datastage career" (http://it.toolbox.com/blogs/infosphere/how-to-kick-start-your-datastage-career-27481). You can post a widget of the stats comparison on your blog or site or post any of the individual charts comparing Oracle Apps to another skill to support any blog entry or article concerning the statistics. If you have any questions, feel free to contact me. Thanks. Carl Williams OdinJobs Oakbrook Terrace, IL 866-889-7823 P.S: If you choose to use the data, apply your knowledge, analyze and create an exciting post, let me know about your blog entry and I can provide exposure to your entry from our site.

Nilesh Chhajed - December 10th, 2008

Hi. I recently saw a PSOPRDEFN table of a client where there were couple of users whose ACCTLOCK was 1 but their values in FAILEDLOGINS was less than what is defined as the maximum login attempts(PSSECOPTIONS.LOGINATTEMPTS)in the system. In what scenarios, can a user's account be locked even if number of unsuccesful logins is less than max defined? If you need more information, please let me know. Thanks in advance.

Nilesh Chhajed - December 10th, 2008

Hi. I recently saw a PSOPRDEFN table of a client where there were couple of users whose ACCTLOCK was 1 but their values in FAILEDLOGINS was less than what is defined as the maximum login attempts(PSSECOPTIONS.LOGINATTEMPTS)in the system. In what scenarios, can a user's account be locked even if number of unsuccesful logins is less than max defined? If you need more information, please let me know. Thanks in advance.

Carl Williams - December 10th, 2008

Dear Nitin Pai, I was looking at your blog, Hexaware and I thought our Q3, 2008 Job Market Statistics, providing a comprehensive picture of the Oracle BI job market including historical comparison of the demand trends, median salary and salary distribution would be of interest to you. Please take a look at Oracle Apps Market Statistics ( http://www.odinjobs.com/Odin/marketstatcompare?id=6246&q=Oracle+Apps ). Better yet, you can compare Oracle Apps to another skill of your choice. You can also add variables such as location, role, and industry. Here is an example of Oracle Apps versus SAP ( http://www.odinjobs.com/Odin/marketstatcompare?id=6247&q=Oracle+Apps+vs+SAP ). Here is another example of how Vincent McBurney analyzed the data and created "How to kick start your Datastage career" (http://it.toolbox.com/blogs/infosphere/how-to-kick-start-your-datastage-career-27481). You can post a widget of the stats comparison on your blog or site or post any of the individual charts comparing Oracle Apps to another skill to support any blog entry or article concerning the statistics. If you have any questions, feel free to contact me. Thanks. Carl Williams OdinJobs Oakbrook Terrace, IL 866-889-7823 P.S: If you choose to use the data, apply your knowledge, analyze and create an exciting post, let me know about your blog entry and I can provide exposure to your entry from our site.

Deepa - December 9th, 2008

Hi, I have created an app engine program for multi rowset data. Till data source registration everything is working fine but I am getting an error while registering my xml report as "XSD is invalid". If anybody have tried this please guide me.

Deepa - December 9th, 2008

Hi, I have created an app engine program for multi rowset data. Till data source registration everything is working fine but I am getting an error while registering my xml report as "XSD is invalid". If anybody have tried this please guide me.

Radha - December 8th, 2008

I would like to use NEWGRAPHICS functionality in SQR. I have added the NEWGRAPHICS=TRUE command in the SQR.INI file in the [Default-Settings] section. But the SQR is not accepting the functionality. Even though there are no errors, it produces blank page instead of the chart. If I removed the command from SQR.INI file, it works fine and produces the chart. Do we need to have some advanced setups? (Like Windows XP, JRE versions etc.). Is it compatible to only few versions of SQR? Please clarify. I need to have combination chart and some other advanced functionalities (like color etc.,) in Charts. Is there any other ways to do that? Please intimate. Thanks.

Radha - December 8th, 2008

Hi, I would like to use NEWGRAPHICS functionality in SQR. I have added the NEWGRAPHICS=TRUE command in the SQR.INI file in the [Default-Settings] section. But the SQR is not accepting the functionality. Even though there are no errors, it produces blank page instead of the chart. If I removed the command from SQR.INI file, it works fine and produces the chart. Do we need to have some advanced setups? (Like Windows XP, JRE versions etc.). Is it compatible to only few versions of SQR? Please clarify. I need to have combination chart and some other advanced functionalities (like color etc.,) in Charts. Is there any other ways to do that? Please intimate. Thanks.

Radha - December 8th, 2008

Hi, I would like to use NEWGRAPHICS functionality in SQR. I have added the NEWGRAPHICS=TRUE command in the SQR.INI file in the [Default-Settings] section. But the SQR is not accepting the functionality. Even though there are no errors, it produces blank page instead of the chart. If I removed the command from SQR.INI file, it works fine and produces the chart. Do we need to have some advanced setups? (Like Windows XP, JRE versions etc.). Is it compatible to only few versions of SQR? Please clarify. I need to have combination chart and some other advanced functionalities (like color etc.,) in Charts. Is there any other ways to do that? Please intimate. Thanks.

LavanyaRaghuram - December 8th, 2008

thanks for replying to the writing rowset buffer to XML. I have Levl0,Level1 and Level2 records to be populated by this code. it populates but I have an issue with the following code. Local XmlDoc &inXMLDoc; Local Rowset &rs_Hdr, &rs_Dtl, &rs_LDtl; &rs_Hdr = GetLevel0(); &inXMLDoc = CreateXmlDoc(""); &ret = &inXMLDoc.CopyRowset(&rs_Hdr); &str = &inXMLDoc.GenXmlString(); &MYFILE = GetFile("C:\temp\Test.xml", "W", %FilePath_Absolute); &MYFILE.WriteLine(&str); &MYFILE.Close(); Thanks in Advance, LavanyaRaghuram

LavanyaRaghuram - December 8th, 2008

thanks for replying to the writing rowset buffer to XML. I have Levl0,Level1 and Level2 records to be populated by this code. it populates but I have an issue with the following code. Local XmlDoc &inXMLDoc; Local Rowset &rs_Hdr, &rs_Dtl, &rs_LDtl; &rs_Hdr = GetLevel0(); &inXMLDoc = CreateXmlDoc(""); &ret = &inXMLDoc.CopyRowset(&rs_Hdr); &str = &inXMLDoc.GenXmlString(); &MYFILE = GetFile("C:\temp\Test.xml", "W", %FilePath_Absolute); &MYFILE.WriteLine(&str); &MYFILE.Close(); Thanks in Advance, LavanyaRaghuram

Radha - November 27th, 2008

Hi, I am writing an interface SQR to connect 2 databases. We have created ODBC connection, and using the -db connection string variable for select/sql statements. The program runs correctly with SQRW. While running in Porcess Scheduler, I am getting the error message as "Could not connect to datasource specified in -db variable: 'DSN =; UID=;PWD=". It picks up the DSN connection string perfectly. Is there any security related things blocking the SQR to run in Process Scheduler? I suppose the DB LINK has to be mentioned somewhere in App Server. It runs perfectly with SQRW. What settings needed to run in 3-tier? Please update. Thanks.

Radha - November 27th, 2008

Hi, I am writing an interface SQR to connect 2 databases. We have created ODBC connection, and using the -db connection string variable for select/sql statements. The program runs correctly with SQRW. While running in Porcess Scheduler, I am getting the error message as "Could not connect to datasource specified in -db variable: 'DSN =; UID=;PWD=". It picks up the DSN connection string perfectly. Is there any security related things blocking the SQR to run in Process Scheduler? I suppose the DB LINK has to be mentioned somewhere in App Server. It runs perfectly with SQRW. What settings needed to run in 3-tier? Please update. Thanks.

Mohammed Hussain - November 26th, 2008

The peoplesoft delivered process duplicant applicant ID application engine is not returning the non duplicate applicants also (when used first name,last name and email address as search process criteria). it returs the applicants who are having same first name , last name but different email also. AE name: DUP_APP_SRCH please give me your suggestions to rectify this error Navigation: Recruitng->Identify/ProcessApplicants->Duplicate applicant search. and -> duplicate applicant results.

Mohammed Hussain - November 26th, 2008

The peoplesoft delivered process duplicant applicant ID application engine is not returning the non duplicate applicants also (when used first name,last name and email address as search process criteria). it returs the applicants who are having same first name , last name but different email also. AE name: DUP_APP_SRCH please give me your suggestions to rectify this error Navigation: Recruitng->Identify/ProcessApplicants->Duplicate applicant search. and -> duplicate applicant results.

SD - November 26th, 2008

Hi, What are the options provided by PeopleSoft for Item Security ? Is it possible to restrict a list of items to a group of users ? Example : Only IT dept users should be able to place a Requisition / PO for "Mainframe Server" .. Appreciate your answers.

SD - November 26th, 2008

Hi, What are the options provided by PeopleSoft for Item Security ? Is it possible to restrict a list of items to a group of users ? Example : Only IT dept users should be able to place a Requisition / PO for "Mainframe Server" .. Appreciate your answers.

Ravi - November 25th, 2008

Hi, In CRM 9 (PT 8.49), we are required to develop a page to capture the History of Changes in Status of a Campaign ([root]Marketing > Marketing Programs), very similar to that for Lead / Opportunity in Sales. To start, we had to Change the Operator Set in the Term (part of Active Analytics Framework) and create a new Action and Policy (Application Package) to record the changes in History Record. But, after doing all that, we found the Policy is not getting fired. Pls provide some inputs on this. Thanks in advance.

Vicky - November 25th, 2008

Hi, The SQR Reports that have Chart Data fail to run in the Process Scheduler. The reason is shows is that " a creating function called in 'GRAFCAP' doesn't exist. The same report when run on a Win System using SQRW runs fine. Can you please identify the issue? Note: Ive searched the net, all i could find was a reference to a file called LIBSTI.INI file. They have specified where to place it on a Win System. but i require the location for it on a UNIX.

Ravi - November 25th, 2008

Hi, In CRM 9 (PT 8.49), we are required to develop a page to capture the History of Changes in Status of a Campaign ([root]Marketing > Marketing Programs), very similar to that for Lead / Opportunity in Sales. To start, we had to Change the Operator Set in the Term (part of Active Analytics Framework) and create a new Action and Policy (Application Package) to record the changes in History Record. But, after doing all that, we found the Policy is not getting fired. Pls provide some inputs on this. Thanks in advance.

LavanyaRaghuram - November 25th, 2008

Hi, How do I read data from XML file into rowset buffer and vice versa. Please do provide me the pseudo code for this. How do I maitain Level's in the XML file? Thanks in advance.

LavanyaRaghuram - November 25th, 2008

Hi, How do I read data from XML file into rowset buffer and vice versa. Please do provide me the pseudo code for this. How do I maitain Level's in the XML file? Thanks in advance.

VICKY - November 25th, 2008

Hi, The SQR Reports that have Chart Data fail to run in the Process Scheduler. The reason is shows is that " a creating function called in 'GRAFCAP' doesn't exist. The same report when run on a Win System using SQRW runs fine. Can you please identify the issue? Note: Ive searched the net, all i could find was a reference to a file called LIBSTI.INI file. They have specified where to place it on a Win System. but i require the location for it on a UNIX.

jujhar - November 24th, 2008

I've a application class, & in one of it's methods I'm using SQLExec function. This application class method is being called from mobile page on a button click. But when I click the button on mobile page, I get the following error: "Internal error. Unimplemented function. (180,120) " "The PeopleCode language evaluator detected an internal error in calling a built-in function that is not implemented." When I comment the SQLExec function, it works fine. please help.

jujhar - November 24th, 2008

I've a application class, & in one of it's methods I'm using SQLExec function. This application class method is being called from mobile page on a button click. But when I click the button on mobile page, I get the following error: "Internal error. Unimplemented function. (180,120) " "The PeopleCode language evaluator detected an internal error in calling a built-in function that is not implemented." When I comment the SQLExec function, it works fine. please help.

Sandeep S - November 23rd, 2008

Hi, Can you tell me the steps followed for integrating a message sent by a third party system to PeopleSoft System. Can you please explain this in detail like usage of IB associated to CI/AE to integrate to PeopleSOft Tables. Thanks Sandeep

Sandeep S - November 22nd, 2008

Hi, Can you tell me the steps followed for integrating a message sent by a third party system to PeopleSoft System. Can you please explain this in detail like usage of IB associated to CI/AE to integrate to PeopleSOft Tables. Thanks Sandeep

Jujhar - November 21st, 2008

Hi, This is about Component Interface. I've CI with one key field... when I run this CI in test mode this runs fine, that is it gives me the desired result. But when I'm calling it through peoplecode, then it is not returning any value. Below is the code being used.. Local ApiObject &oWrkrCI = %Session.GetCompIntfc(CompIntfc.RFM_WORKER); If &oWrkrCI <> Null Then &oWrkrCI.PERSON_ID = &sPERSON_ID; If &oWrkrCI.get() Then &sGoodsRecvNo = &oWrkrCI.PHYSICAL_LOCATION; Else &sGoodsRecvNo = "could not get"; End-If; Else &sGoodsRecvNo = ""; End-If; everytime the value 'could not get' is being returned. please help.

Jujhar - November 21st, 2008

This is about Component Interface. I've CI with one key field... when I run this CI in test mode this runs fine, that is it gives me the desired result. But when I'm calling it through peoplecode, then it is not returning any value. Below is the code being used.. Local ApiObject &oWrkrCI = %Session.GetCompIntfc(CompIntfc.RFM_WORKER); If &oWrkrCI Null Then &oWrkrCI.PERSON_ID = &sPERSON_ID; If &oWrkrCI.get() Then &sGoodsRecvNo = &oWrkrCI.PHYSICAL_LOCATION; Else &sGoodsRecvNo = "could not get"; End-If; Else &sGoodsRecvNo = ""; End-If; everytime the value 'could not get' is being returned. please help.

Rohit Shah - November 21st, 2008

how to pair effective sequence field to effective date in peoplesoft application designer 8.48

Radha - November 20th, 2008

Hi, This is related to data conversion. I want to convert a string to a number. The string contains zero at the first position. while conversion, other values get converted except the zero. During print, we can print the zero using edit mask. But I want the number to be stroed with Zero at the first position. Is there any ways to achieve it? Please explain. Thanks Radha.

Asha Rao - November 19th, 2008

Hi, I wanted to know how can one give 'display only' permission list to Administer workforce module. Thanks in Advance. - Asha

Siva - November 19th, 2008

Hi Can we call Unix commands through peoplecode? Thanks

ram - November 16th, 2008

Hi, i have couple of doubts in 1099 reporting. i am genrating 1099 report through peoplesoft. 1) while doing so, i am not getting the exact amount in the report of how much the vendor is liable for the IRS. what would be the reason for this. 2) i am getting 1099 copy b report and i am asked to get 1099 copy2 report. is it availbale in peoplesoft. if it not there what could i do?... 3) there is an option which will help to generate test report for 1099. but if i ran the app.engine(withholding 1099 reort) program for test report i am not getting any output in the crystal report. awaiting for your advice thanks, ram.

Aswathy - November 14th, 2008

Hello I want to know if I can add a benefit "Plan type". If so how do I do that? and I want to know which PeopleSoft contains Plan type information including description etc. Also, can u explain what is meant by translate values?

Radha - November 12th, 2008

Hi, I need a help for SQR Charts. I would like to replicate a Chart which is of type xy-scatter in Microsoft Excel. SQR also supports the same type. But, my X-axis data is Date type. xy-scatter-plot in SQR accepts only numeric values. What kind of Chart we can use instead? (to replicate some numbers in Y-axis for the dates in X-axis)What are all the parameters available for Charts? If known, Please reply. Thanks.

Ankit Shah - November 10th, 2008

Hi While using my test system mistakenly i deleted the Time and Labour link from the Structure and content page , (navigation: Main menu > peopletools > portal > structure and content ) is there any way to restore the link. I am working in Employee portal and using local node. Please help thank u. Ankit Shah

Atul Sirmour - November 8th, 2008

Hi, I'm working on uploading vouchers into PS System from spreadsheet using the delivered ExcelUploadforVoucher.xls functionality which uploads the data into the staging tables PS_VCHR_HDR_STG, PS_VCHR_LINE_STG, and PS_VCHR_DIST_STG using the IB Message VOUCHER_BUILD and then into the original tables PS_VOUCHER, PS_VOUCHER_LINE, and PS_DISTRIB_LINE using the AE process AP_VCHRBLD. Now the requirement is to restrict the voucher to upload if the PS_VCHR_HDR_STG.GRP_AP_ID (Control Group Id) value is not preapproved.Its required to compare PS_VCHR_HDR_STG.GRP_AP_ID value with the PS_GRP_AP.GRP_AP_ID value . I am not able to figure out where to write code for this.And how to maintain the error log if control group id is not pre-approved so that user can correct it using link: Account Payable-->Vouchers-->Maintain-->Voucher Build Error Detail Please help me. Thanks & Regards Atul

Sue Xu - November 6th, 2008

Hi, I am working on PT846 on XP system and want to call OS command in the SQR program. For example: call system 'CMD.EXE /c mountvol|find ":\" > D:\temp\driver.txt' #sts WAIT The #sts always returned as 1. If I remove the WAIT option, For example: call system 'CMD.EXE /c mountvol|find ":\" > D:\temp\driver.txt' #sts #sts returned as zero, but the following process will find that the driver.txt is created without any word. It seems that the call system command can not use WAIT option on NT server. Why this happened? Do I use the command correctly? Any help is highly appreciated.

Giridhar M - November 5th, 2008

Hi Experts, iam working on CRM 90 and PT848,when ia trying to add a page(RD_PERSON) to a permission list,my session expires . However iam able to another page of Add Company to the same permission list. Suggest me what could be the possibel reasons?

kash - November 4th, 2008

Hi, Can u pls guide me how to write a AE program which loads data into the component. This AE should load data into the time entry component. The pages contains the fields LOCATION,PAYGROUP and PAY_END_DT and all hours and amounts fields. These LOCATION,PAYGROUP and PAY_END_DT three fields should be populated by the AE Program from the LOCATION_TBL,PAYGROUP_TBL,PAY_CALENDER. Following is the logic that we need to follow for the interface to load data to the Bolt-on page. 1. Loop through all ACTIVE locations in the location table. 2. For each location, loop through the 3 paygroups - Weekly, Biweekly and RSR 3. for the combination derived select the min of pay-end-dt where paygroup obtained from above and pay_sheets_run = 'Y' and Pay_confirm_start = 'n' 4. For the combination derived in the above steps, loop through the Employees (PS_EMPLOYEES) table and validate if the employee is present in the PS_PAY_EARNINGS table. If it's present, enter data for the Employee into the Bolt-on table. If not, write it out to the log output. please guide thorugh the AE Program. I have problem with the implementation.

Kumar - November 1st, 2008

Hi. I am currently working on the peopletools version 8.22 and application version 8.43.489. I have one requirement for the prompt on the Bankcode field. Currently, the bank code field is prompted based on the company of the employee. It needs to be changed as per below requirements. Bank code should be prompted based on the current location of the employee.Also Prompt should also display the list of bank codes which are associated to the company of the employee and which doesn

sitapati - October 30th, 2008

Hi In PS 9.0 NA Payroll there is an error message appearing when i run the PAYGL01A process. Tax ChartField not found for - Company ABC Business Unit PQRST Pay End Date 11-OCT-2008 Dept MO146 JobCode 000401 Position Nbr 104530 EmplID 0701274 Empl Rcd 0.000000000000000000000000 Province BC Wage Loss Plan W43 Tax Class QIR. There is an incorrect entry for a province BC as QIR. I want to how to remove the entry and how it came into the pay chek summary of an employee as it had appeared. Thanks Sitapati

CLH - October 29th, 2008

What are best business practices for auditing transaction data within PS? What type of reports are typically used to accomplish this?

ssk - October 28th, 2008

What is the best way of identifying UNUSED panels /Pages in the Application / Database. Currently , Present scenario at my end I am filtering the pages which are created But Not used in Components . Still is there best way of identifying unused pages from PeopleTools Tables .

Srivatsa - October 27th, 2008

Hi, I am working on quick invoice extract in SCM 8.9. The condition is I am extracting the values from VCHR_HDR_QV,VCHR_LINE_QV,VCHR_DIST_QV.After this extraction I am running the voucher build process,according to peoplebooks the VCHR_MSCH_QV and VCHR_MSCL_QV(MIscellaneous header and line) tables have to be populated.But only VCHR_MSCH_QV is getting populated and VCHR_MSCL_QV is not getting loaded.So can anyone suggest what to do for this? Thanks in advance. Srivatsa

Ed Johnson - October 21st, 2008

Which V$ views should I use to monitor PSTEMP and catch the SQL consuming large amount of PSTEMP space? Hi Natin, Thanks for a detail explaination last time. I can see you are a solid knowledgable PS apps DBA mainly in Oracle, so I want to ask you again the question in that field for getting the standard or best practice from you. Actually I submitted the question in some major PS or Oracle web forum, I didn't get any response. Someone said it's the lower level question, but it is bothering me for a while. Recently I was confused by monitoring PSTEMP (as you know, it's the default temp tablespace for sysadm user). It's a RAC environment with multiple instances for a database. I tried to run SQLs to how many percentage used in PSTEMP, not TEMP as usual. And which SQL executed is using PSTEMP in excessive percentage so that I can catch it for tuning. The following are my confusion: 1. GV$ or V$? and which V$? We know normally v$sort_segment,v$sort_usage, and v$temp_space_header are providing TEMP or PSTEMP info. But I found the result they provided are different, so I go through them all, and found: select * from gv$sort_usage; -- no pstemp info select * from v$sort_usage; -- no pstemp info select * from gv$sort_segment; -- has pstemp info select * from v$sort_segment; -- no pstemp info select * from gv$temp_space_header; -- has pstemp info, by each temp files on all instances select * from v$temp_space_header; -- has pstemp info, by each temp files I like to know which GV$ or V$ you are using to monitor PSTEMP? We should not use v$sort_usage as it only gives TEMP, no PSTEMP? Please tell your experiences about them? 2. Oppsite info: a) SELECT tablespace_name, SUM(bytes_used+bytes_free)/1024/1024 Tot_MB,SUM(bytes_used)/1024/1024 Used_MB, SUM(bytes_free)/1024/1024 Free_MB FROM v$temp_space_header GROUP BY tablespace_name; TABLESPACE_NAME TOT_MB USED_MB FREE_MB TEMP 5000 4907 93 PSTEMP 10000 10000 0 As the result above, PSTEMP was used out all. But at the same time, I ran the following SQL and got totally oppsite result: b) SELECT tablespace_name, SUM(total_blocks)*8192/1024/1024 Tot_MB,SUM(used_blocks)*8192/1024/1024 Used_MB, SUM(free_blocks)*8192/1024/1024 Free_MB FROM gv$sort_segment GROUP BY tablespace_name; TABLESPACE_NAME TOT_MB USED_MB FREE_MB TEMP 4906 0 4906 PSTEMP 9999.75 0 9999.75 So which one, v$temp_space_header or gv$sort_segment, should I trust to know the usage in PSTEMP and TEMP? Thanks a lot in advance.

Jason - October 20th, 2008

Hi, I would like to know if there's a kind of functionality in PSGL where we can run allocation ONLY if the balance of the pool is negative. If the balance of the pool is positive, then no additional journals will be created. I am looking for this info as I cannot find any related materials, hence I'm thinking that this is not possible. But someone said it is possible in V9. Appreciate your help. Thanks.

Peoplesoft User - October 18th, 2008

Hi, My requirement is to do cloning for Events ans Steps Associated with Activity. I can do Save As for Activity in Application Designer but not for Events and Steps. I want to write Peoplecode method to achieve this. Anybody has idea how can I do cloning of these objects ? Is there any peoplecode method I can use. Thanks in Advance.

Caron - October 17th, 2008

I would like to know if the current PeopleSoft GL Version 8.8 provides an audit trail of the userid who posted a journal.

Uday - October 14th, 2008

Hi, We have upgraded our Financials system from 8.8 to 9.0. I'm working on uploading vouchers into PS System from spreadsheet using the delivered ExcelUploadforVoucher.xls functionality which uploads the data into the staging tables PS_VCHR_HDR_STG, PS_VCHR_LINE_STG, and PS_VCHR_DIST_STG using the IB Message VOUCHER_BUILD and then into the original tables PS_VOUCHER, PS_VOUCHER_LINE, and PS_DISTRIB_LINE using the AE process AP_VCHRBLD. Now the requirement is to add more fields to the Excel sheet and upload them into some other tables like Vendor, Bank, Payment_tbl etc. Can you please help me to acheive this functionality? Regards, Uday.

Sameer - October 13th, 2008

Hi, We are implementing PS Financials 9.0. I want to secure certain pages (make them display only) of a component based on a value in a field on the main page of the component along with the users' role. How can I do so via PeopleCode. Thanks, Sameer

Alan - October 8th, 2008

I can not get the worklist to populate in Peoplesoft financials. Version 8.48 Any installation guide for setup. Wanted to get the delivered approval process working for a demo.

Dhananjay - October 8th, 2008

Hi, I am working on PS 9.0 version. I have created a department tree and also a security set for business unit with respective access types. I just wanted to know if we can combine security by department tree and security by permission list( for business unit or location)?

vinod - October 6th, 2008

Is there a standard questionnaire (subprocess wise - Building Recruitment templates, job opening, applicant data, screening & Routing and so on..) that you would recommend for eRecruitment 9.0 implementation to gather requirements? What is the best practice that one should adopt for requirement analysis phase which would be an input to fit-gap phase?

Nishant - October 4th, 2008

I want to load non person profiles in peoplesoft HR 9.0(PT8.48.17)through excel to ci but unable to do so.The profile gets added but wen i try to add competencies and profile identities i get errors.

Neel - October 3rd, 2008

Hi, Please tell me how i would go about implementing DoModalComponent for MAINT_PAYROLL_INTERFACE--> ADDITIONAL_PAY component from any custom page Thanks.

venki - September 30th, 2008

I am trying Derived Work Record's Field value change at the end of one application engine program. Is it possible? Thanks in advance

Rahul - September 29th, 2008

Hi, In the field mapping can we have associate record field from sub page ? Just adding the Record.Field in Sub Page, does not make it show up in the field Mapping. Thanks Rahul

Raman - September 26th, 2008

Hello, Can someone help in the performance of my sqr program. ++++++ Query 1 : Select AA, BB, CC From Table 1 From the result of query 1, need to selecting : Query 2 : Select AA, BB, CC, DD, EE From Table 1 where AA = AA and DD = CC From the result of Query 2 : Select XX from Table3 where AA=AA BB=EE The result from Table 2 and Table 3 i insert into table and commit on each row. The result of the sqr is then extracted from this table onto an array to print onto Xl sheet in column wise. Any help please ? Thank you Raman

Ravij Looma - September 26th, 2008

my code didnt appear on last post. below is the code: if@column:/AX_TRS_WRK/KEY3!=""?>

Ravij Looma - September 26th, 2008

I am working on peoplesoft HCM9,peopletools 8.49. working with XML publisher,RTF template. I have the req that i need to hide a complete column in table if its blank. this is the code which i wrote: However it always hides the column irrespective of the condition given in IF statement. Any help is highly appreciable.

suresh reddy - September 26th, 2008

Hi gurus, i am new to Application engine and component interface. i need to learn it in a real time scenario. please help me

Sachin - September 25th, 2008

I have a Worklist question.We have the complete and Delete buttons.We are looking to find who deleted/completed items in their worklist. Is there a way of finding out? This is in regards to a call center Worklist.

bhaskar - September 25th, 2008

Hi Experts, I just want a clarification regarding the ROWSELECT peoplecode event. What i believe is ROWSELECT event is used to filter the rows in search page,but it is not working like that. i have two field in a record(emp_rec) 1)EMP_NO -- search key 2)EMP_NAME it consits of following data. 1)101 bhaskar 2)102 sunil 3)103 raju 4)104 ramesh when i press the search key it will displays 101 102 103 104 but i am trying to hide emp_no 101 from the search page. if EMP_REC.EMP_NO = 101 then discardrow() end-if but it is not working.what to complete this task by using only ROWSELECT not by VIEWS. Thanks & Regards Bhaskar Rao

Durga - September 22nd, 2008

Hi, I have a query on Scrolls.can a scroll contain more than one grid? what objects can't be placed inside a scroll.

Sandy - September 20th, 2008

Ftping files using FTPTARGET Hi, I am trying to ftp files using the ftptarget as opposed to using a ftp process. I am using addattachment to ftp the file. When I fire the code thru a button on a page, the file is sent to the destination. But contains special characters and garbled. If I use the same code on a AE and lauch it thru process scheduler, it remains in NEW status and thye file never makes it. Can you provide an example of how to accomplish this ?

Sandy - September 20th, 2008

Hi, When are the cirmstances under which one would 1. Uncheck the add check box on a component. 2. Add the same page to 2 separate components and -- have just update display check on one component -- and update display all/correction checked on the other. What design considerations would go into doing this as opposed to having jsut one component with update display/ update display all and correction check on all. Thanks for your time!

Santosh Thapliyal - September 19th, 2008

I have to set Advance Search as the default search option for a look up field/prompt table. When I set the default search option in the component property, all the look up field/prompt tables used in the component follows the same. How do I set the Advance Search as default option for just one look up field?

Sun - September 18th, 2008

Hi, Subject:Excel to CI Utility. Please tell how we can show the customised error after validating the input for the 1)Signed Number fields and 2)Length of a field in the Excel when the data is submitted to CI. I tried to do using the base component Record Field Peoplecode but it shows delivered error only.

phillip langley - September 17th, 2008

Our company is planning to upgrade from JDE ENTERPRISE 1 Release 8.0 to 9.0 as it become available (hopefully October 2008). Just trying to get an idea on what problems (horror stories) someone else may have experienced when going to 8.12 (latest release which is web based). One question.. will existing inhouse written programs (UBE, Table conversions, etc)still work the same?

Bob - September 15th, 2008

Hi... I need sql to help identify all users that have access to a specific page. Thanks

Sandesh - September 15th, 2008

I am trying to add a row in job-data via comp. interface. I am changing the action/action-reason jobcode and compensation. The app. engine that runs the CI gives warnings and ends successfully. but I dont see any row getting added on the page for that employee. Can you plase elp me in this. Thanks, Sandesh

Sun - September 12th, 2008

Hi Hexaware Gurus, I have a requirement in Excel to CI utility. In case of error in uploading any of the record to staging table,no record should get updated to staging table and error row should get highlited in excel. Please tell how this can be done and in what ways is this possible??

Prashant - September 9th, 2008

Hi Somehow colour background of PIA is changed. i want to reset it to default. How and hwere to do it?

Rajan - September 6th, 2008

Dear Guru's, Please clarify the following queries 1. I like to know the default noticifcation mails can be changed 2. Leave Travel Allowance module is available in Peoplsoft (India), if so how to use the same.

Glenn Perkins - September 5th, 2008

A customer on PSFT 8.4 has an AP question regarding monthly 1099 Reporting of contractor data to the Govt EDD. Is there functionality deleivered in 8.4 or have other 8.4 customers created a capability to accomplish this?

gnanadhas - September 2nd, 2008

Hi,can u explain how to read multiple data's from a flat file(csv) to database using component interface.

Chandar - September 2nd, 2008

Hi, Please,Could u tell me the Uselinks of PeopleSoft Function Parts. Thanks Chandar

Chandar - September 2nd, 2008

Hi, Could you please tell me some links to learn Peoplesoft Functional modules (Apart from Peoplebooks). Especially for core HR, Benefits, Payroll and Time and Labour.

Ranjan - August 31st, 2008

Hi,I have to write an inbound program to read multiple files and processing them in PeopleSoft. After processing I have to move them to different folder. 1)How to handle multiple file in peoplecode (first I have to search for files In particular place then I have to process one by one ) 2)How to move processed files to dump folder. We are using Peoplesoft Finance 9.0 and Tools 8.48 , NT server, SQL server 2005 data base. Any help in this regard is appreciated. Thanks in Advance.

CLF - August 29th, 2008

Does PeopleSoft have a taxable gross component id (or some other way) to handle same sex marriages that are recognized in the state of NY, but not for Federal taxes? Where can I find this update and if it is a taxable gross component, what is the id?

Siri - August 29th, 2008

Hi, I have a query regarding SMTP server for PeopleSoft CRM9.0 tools 8.48.08.SMTP is configured for dev instance.SMTP sender email id is test@bol.net.in.when I try to test email from peopleTools--> workflow->Defaults & Messages->worklist/Email message, it is giving error like invalid email ID. I have given email ID for that user but the email ID is @yahoo.com . what could be the reason. Appreciate your help

Jayanth - August 29th, 2008

Can we have dynamic search records for a component? If so then how can we achieve it??

Krishna - August 28th, 2008

Hi, I need help in crystal reports Check printing. In check while printing number in words it is printing 3,365,900.00 like

Asha Rao - August 27th, 2008

Hi, I wanted to know when any employee undergoes the hiring process in peoplesoft, is there any way that his user profile gets automatically generated? If there is any way, would appreciate if you could mail me the navigation for the same. Thanks in advance Asha Rao

Ravishankeran Ramaraj - August 27th, 2008

Hi, How to proactively monitor peoplesoft environments before the process goes down? Thanks & Regards, Ravi

Isha Chawla - August 26th, 2008

Hi, I am currently working on retrofitting for patch implementation on 8.47 tools version for a client on PS HRMS 8.9. We have implemented 16 patches on 8.47. Now while testing the instance after implementing all the patches, I am stuck with an error on 'Add a Person' page. After keying in all the required information for the employee when I click on the 'Add relationship' button on Organizational relationship page, then an error message is displayed for the Message 'DSPERSON_BASIC_SYNC'. For the message 'DSPERSON_BASIC_SYNC', in the properties dialogue box, under the tab 'Use', there is a box for 'Validate Structure'. Here there is a check box for 'Schema'. This check box is somehow checked in the instance where we have applied patches and are doing testing. In other instances this check box is unchecked. Please suggest how can I uncheck this check box as it's appearing greyed (display only) for me. Navigation : Application Designer --> Open definition --> Message --> DSPERSON_BASIC_SYNC(Message Name) --> Properties --> Use --> Validate Structure --> Schema Thanks!

wish - August 20th, 2008

I have a scroll in a page , and i need to hide the field plan type (Edit push button) on a page if its 10(medical Plan type) , how do i do that.

Parag - August 19th, 2008

Hi, I am working on Peoplesoft and Identity Manager(Sun/Oracle) integration. 1. Can you please provide me with some pointers to work on?? 2. Generally, what points should be considered while going for third party integration?

Siva - August 18th, 2008

Hello, I have been following your blog & I find it very useful. I appreciate your efforts. Now coming to my question: Is there a way to defualt Advance lookup when the prompt button is clicked ? Normal behaviour is to display the page with basic lookup. Thank you, Siva

Darmadi - August 15th, 2008

Hi All, Could you help me how to setup routing approval in MSS. for example i want to transfer an employee and this request must go through 3 level approval like below: Level 1 --> ROLE_VERIFIER Level 2 --> ROLE_MOR Level 3 --> ROLE_ADMINISTRATOR Can PeopleSoft vanilla setting routing approval like that? if yes please you guidance. Thanks a bunch in advance. Best Regards, Darmadi

Kalpana - August 14th, 2008

Currently we are working in peoplesoft finance 9.0 ver. We have an issue in few pages for only one user. The exact issue is - the radio button labels are displaying twice in the group box only for first time to that user. Successive attempts does not have this issue. We have tried refresh option,added some more radio buttons, did research on peoplecode for that specific user,checked properties for [field,page,rec],cloned the affected user but the cloned user does not have that issue, cleared the cache, did the trace file for the affected user and the non-affected user,checked the view source file. Kindly let us know your valuable suggestions to resolve this issue.

samir - August 12th, 2008

I am trying to run sftp script to transfer a file between servers. The command I am using for sftp is /usr/local/bin/sftp -B parfile I have sftp script in batchdir and file to be transferred is in rptdir. sftp in turn calls ssh2. I am having issue authenticating id when ssh2 is called. Any help will be appreciated.

gently_g - August 9th, 2008

Hello, I am new to peoplesoft and would like to seek your help. I am having problems using OPRID as a required key fields in my parent and child records. I am using OPRID and RUN_CNTL_ID as required keys in both of my parent and child records. As i go into my run control page. The child RUN_CONTROL_ID is performing normally by having the same value as the parent RUN_CONTROL_ID. The problem is at OPRID, It wont load the content to my child record where it's at only level1. I have already set the configurations of child/parent-OPRID with the configurations of child/parent-RUN_CONTROL_ID so that both would run normally the same as RUN_CNTL_ID does. but it wont!!! I know OPRID is a system function that returns a value. how will I be able to get the same value as my parent record had in my child record for OPRID.

Rama Krishna - August 7th, 2008

Hi Sachin, Thanks for the reply. Actually I already created the CI but the problem is I don

Sachin Deshmukh - August 6th, 2008

This is for Rama Krishna. Please see the comments below Here are our comments

Rama Krishna - August 6th, 2008

I have to run a daily process where Appengine pick some data from PeopleSoft and put it in some staging table from there I have to put in Psoft again in an another module using CI. Table will be like below Bunit Row ID Item ID Quantity ABC 1 00012 10 ABC 2 00014 10 ABc 3 00015 20 Xyz 1 00015 20 Xyz 2 00015 10 Here situation is Bunit will go to Zero level record and remaining filed values will come to 1 level In above example first 3 rows come in to first level scroll with ABC as parent in first level For first three rows ..I will assign BUNIT value

Siree - August 6th, 2008

Hi, I have a requirement in PeopleSoft CRM. there will be some VIP customers,only a particular user can search for those VIP customers during transactions like OC,Sales and other users can't. Is there any way to achieve this.

Bradley Westvig - August 5th, 2008

I'm looking into creating a custom connector for Integration Broker that uses sftp to transfer files to a remote server. The remote server is not able to handle the XML wrapper, they want just a plain text file. Has anyone used the ability to create custom connectors in IB? Do you think that this would be a possibility?

suresh - August 4th, 2008

hi gurus, my problem is on sqr. i don't know how to test dynamic where clause in sqr. can you please help me.

Darmadi - August 3rd, 2008

Hi, I'm planning to use PeopleSoft eprofile manager desktop, but when i try to use vanilla page to transfer employee the direct report data was not show (it happen also in other page such as promote, change report to, etc) I already include supervisor ID in the user ID and also give the manager self service role. when i check in direct report manager module by putting the supervisor ID as parameter then executing drill down function (API), the result is show and correct. Is there some setup that i must do first? please your advice and guidance the first step to use self service module Thanks Before

Hi, - August 1st, 2008

Hi , i have requirement like, user's able to select the language from signon page and based on his preferred language texonomy (Menu navigation)will be appear. Can you please suggest me. Thanks, VJ.

Rakesh Mohan - July 31st, 2008

I am still wondering as why we can't have SQL and CALL Action in a single STEP in an Application Engine. Also can I know about any site/repository which decribes PeopleSoft GL Set Up.

Rakesh Mohan - July 31st, 2008

I am still wondering as why we can't have SQL and CALL Action in a single STEP in an Application Engine. Also can I know about any site/repository which decribes PeopleSoft GL Set Up.

balaji - July 30th, 2008

Hi Anyone knows how to call a COBOL program from SQR or Application Engine? Thanks, balaji

Heather Truong - July 28th, 2008

Hi, I would like to find out what tables that needed to be converted over for activity and history Absence Management. Also I'd like to know if there is feature for EE can perfrom a cancelation action on his/her request, instead of manager has to do it. Thank you

Jugal Kishore - July 27th, 2008

Hello PS Gurus, Can you please tell me the delivered process (in PS 8.8) to interface the Garnishments to AP? Thanks, Jugal.

xx - July 24th, 2008

Posted as part of portal web testing Just to check if this process is working fine

Sani - July 23rd, 2008

Hi, I have a simple sql which selects few fields from a table for each country. i.e. select emplid,name,businee_unit from ps_employees where reg_region = 'USA' I want to put all those fields in a csv file and schedule that sql on a daily basis.Also,i want to pass reg_region (i.e AUS,USA etc)as a parameter to this sql.As this is very simple sql I dont want to write any AE or sqr for this.Is there any simple way to do this? Thanks, Sani.

Sundeep - July 22nd, 2008

Can some one help me out how to implement ADP Connection. Any link to materials would be appreciated

M - July 15th, 2008

Hello, I am trying to figure out how to get the process scheduler to restart / reprocess all of the 'no success' app engine programs. Has anyone ever had to run a batch job to restart app engines that were once 'no success'? Any help would be greatly appreciated. Thanks!

Jim Ogletree - July 15th, 2008

I am running some PL/SQL in an app engine to generate web page files. I'm having great difficulty with the slashes (/). The first line of the file is the typical %execute(/) that lets a series of commands run in one section. But every time I have a slash, even in a quoted string, it ends input and complains of a syntax error, e.g. ...href ='htt p://...' (spaces put in so it doesn't look like html to your form). If I try another character in the %execute() directive, I get an error about illegal character "at or about position 10" which is exactly the spot where I have tried something other than a slash. I got around the problem in a very ugly way by substituting "chr(47)" with appropriate concatenates for each slash, but there are many of them in the code, and now it is both unreadable and unmaintainable. Any help on changing the character from slash to something else or escaping the slashes in the strings would be greatly appreciated.

Chandra - July 14th, 2008

Hi In HRMS 8.9 whenever a new person (employee) hired an email is sent to the list people providing information about it.I wanted to know where can i find the list of email so that i can modify the list, so that right people can get an email from Hiring is done. I really apprciate your help.

vineet kumar - July 2nd, 2008

I need to track whether a new record has been added to personal data or any modification has been made. Could you please let me know on this

shyam - July 2nd, 2008

Hi i have a requirement where i need to generate multiple excel sheets in one excel using sqr. Any suggestions how to code?

sneha - July 1st, 2008

Dear Gurus, I am facing a problem in one of the COF sqr program I need to generate the change only file, because if any changes in the active employee case, i already sent the full information about an employee to vendor. Please help me in this problem. Any help would be appreciated. -sneha

Vatsa - July 1st, 2008

Hi, I am working on a CI currently and I am facing a problem. I have 2 records at the same level,when I run the App engine the process runs to success but in the log file I am geting an error stating the rec.field is not defined.But the issue is the CI is treating the 2nd record as the field of the 1st record. How to resolve this issue. Any help would be appreciated. Thanks in advance

sneha - June 28th, 2008

Hi I need a help in SQR. I would like to make a change of file program in sqr to send to third party. Is any one can tell me the logic of this program? I will be appreciate those who has generous mind. Thank you in advance -sneha

sneha - June 28th, 2008

Hi I need a help in SQR. I would like to make a change of file program in sqr to send to third party. Is any one can tell me the logic of this program? I will be appreciate those who has generous mind. Thank you in advance -sneha

MSR - June 25th, 2008

Hi, We are upgrading from HRMS 8.8 to 9.0. After completing Initial Move, when I run the final Alter Audit, alter script got generated for "Change". I ran this script during Alters With Deletes, but still Alter Audit is generating same script for "Change". Here is the comments section that got generated *************************************** -- -- Alters for record PS_AE_STMT_TBL -- AE_STMT - change **************************************** Do you have any idea why is this alter script generated eventhough I ran this script before?? How to suppress alters for "Change"??? We are on SQL Server 2005 and here is the alter script that got generated for above table, please look at the data type of AE_STMT field. Interestingly all the alter scripts that got generated, are for the fields with datatype NVARCHAR(MAX) at DB Level. But in application designer, this field is defined as Long Character of Length 8192 ************************************************** -- -- Alters for record PS_AE_STMT_TBL -- AE_STMT - change -- Start the Transaction -- Data Conversion -- Create temporary table CREATE TABLE PSYAE_STMT_TBL (AE_PRODUCT NVARCHAR(2) NOT NULL, AE_APPL_ID NVARCHAR(8) NOT NULL, AE_SECTION NVARCHAR(8) NOT NULL, DB_PLATFORM NVARCHAR(1) NOT NULL, EFFDT PSDATE NULL, AE_STEP NVARCHAR(8) NOT NULL, AE_STMT_TYPE NVARCHAR(1) NOT NULL, AE_REUSE_STMT NVARCHAR(1) NOT NULL, AE_USE_CURSOR SMALLINT NOT NULL, AE_ADJUST_STATUS NVARCHAR(1) NOT NULL, AE_STMT NVARCHAR(MAX) NOT NULL) go -- Copy from source to temp table INSERT INTO PSYAE_STMT_TBL ( AE_PRODUCT, AE_APPL_ID, AE_SECTION, DB_PLATFORM, EFFDT, AE_STEP, AE_STMT_TYPE, AE_REUSE_STMT, AE_USE_CURSOR, AE_ADJUST_STATUS, AE_STMT) SELECT AE_PRODUCT, AE_APPL_ID, AE_SECTION, DB_PLATFORM, EFFDT, AE_STEP, AE_STMT_TYPE, AE_REUSE_STMT, AE_USE_CURSOR, AE_ADJUST_STATUS, AE_STMT FROM PS_AE_STMT_TBL go -- CAUTION: Drop Original Table IF EXISTS (SELECT 'X' FROM SYSOBJECTS WHERE TYPE = 'U' AND NAME = 'PS_AE_STMT_TBL') DROP TABLE PS_AE_STMT_TBL go -- Rename Table sp_rename PSYAE_STMT_TBL, PS_AE_STMT_TBL go COMMIT go -- Done *************************************************** Thanks, MSR.

Carol Mitchell - June 23rd, 2008

Hi; We have just stood up a sandbox for PSoft 8.9 and I see the standard user menus do not display in 2-tier (Compensate Employees, AdminWorkforce) etc. Is there a method to "switch" these on? 3 tier is fine, so I know security access is not an issue. I'm anticipating you will tell me they are gone forever......... Thanks

Sandeep S - June 19th, 2008

Hi,This is really a very good blog for peoplesoft information. I have a question on integration with ariba and peoplesoft.Is it possible to integrate peoplesoft and ariba in terms of page related integration like when i click a link on ariba a PeopleSoft page should be opened and on selecting data on peoplesoft integrates back to ariba. Example :- If i click a requisitions link in Ariba,To select the items for the requisition i need to move to peoplesoft and selecting the items move back to Ariba for creating Requisitions. Can you tell me is this possible in any way or there is any other peoplesoft delievered tool.

MM - May 22nd, 2008

This Means that just applying MP6-ML and selecting ENG,GER,FRA and COMMON will solve my purpose.I need to go and apply English update id seperately.Am i correct?

Ramesh - May 21st, 2008

Why PeopleSoft roles can not be compared using Compare & Report option available in Applicaiton Designer when permission lists can be?

MM - May 12th, 2008

Hi I have a multilingual Database(GER,FRA) and have to apply Maintenance Packs on it.Will just applying Multilingual packs include English also.? Thanks MM

MM - May 12th, 2008

Hi I have a multilingual Database(GER,FRA) and have to apply Maintenance Packs on it.Will just applying Multilingual packs include English also.? Thanks MM

Nirmalkumar - May 8th, 2008

Useful Queries for process monitoring. 1.The following query's used to find process output file path, this query will work based on the process instance number. If suppose process failed due to someother reason, then use the following query to get the log files in this path. SELECT C.WINNETWORKPATH || '\'|| NAME || '\'|| to_char(DTTM_CREATED,'YYYYMMDD')|| '\' || A.CONTENTID || '\'|| A.FILENAME ,A.CDM_FILE_TYPE, A.FILE_SIZE , A.DTTM_CREATED , B.CDM_ADMIN , B.CDM_BINARY_FILE , B.DESCR50 ,B.FLDNOTUSED FROM PS_CDM_FILE_LIST A , PS_CDM_FILE_EXT B ,PS_CDM_DIST_NODE C,V$DATABASE d WHERE A.CDM_FILE_TYPE = B.CDM_FILE_TYPE AND B.DISPLAY_OPTION = '1' AND PRCSINSTANCE='PROCESS INSTANCE' AND C.DISTNODENAME =NAME 2.Use the following query to get the processing time SELECT PRCSINSTANCE , floor(TO_CHAR((enddttm-begindttm)*24*60)) AS MINUTES, lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))-floor(TO_CHAR((enddttm-begindttm)*24*60)))*60) ,2,0) AS SECONDS , decode (FLOOR(TO_CHAR((enddttm-begindttm)*24*60))||':'||lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))- floor(TO_CHAR((enddttm-begindttm)*24*60)))*60) ,2,0), ':',' ',FLOOR(TO_CHAR((enddttm- begindttm)*24*60))||':'||lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))-floor(TO_CHAR((enddttm-begindttm)*24*60)))*60) ,2,0)) AS MINSEC , PRCSNAME, OPRID, RUNCNTLID, SERVERNAMERUN, RQSTDTTM, RUNDTTM, BEGINDTTM, ENDDTTM , RUNSTATUSDESCR FROM PS_PMN_PRCSLIST where runstatusdescr ='Success'

Arun - April 28th, 2008

Peoplesoft Directory configuration: 1.would like to know more about the 'default connect DN' of the ldp.exe 'Microsoft Active Directory'. 2. Creating an ldap administrator account with browse rights to objectclass=person 3. Establish single sign on

mamoni - April 28th, 2008

hi i have my component in development but it is not reflecting in portal , i ve checked everything from portal registry to permissions and every thing is correct but stil that component is not reflecting in portal at all. any one can help me plz

Mahesh Kundu - April 23rd, 2008

How can I remove the description of a parameter and the horizontal line from a value prompt (drop-down box)?

bhargavi - April 16th, 2008

hi all,iam a frsher working a peoplesoft QA-trainee.I am doing with the project. There is an error poping up, when i save the data at portal.After i enter the data in the page, when i click SAVE then an error pops up "Data being added conflicts with existing data (18,2)". i have checkout with the KKeys, field length and also the existing data in the record from backend. I have cleared the cache. I have also created the new record,changed the page and registered the component with another menu. But still the error remains the same. please help me out with this.

Christina Long - April 15th, 2008

I am looking to Hire a Peoplesoft Programmer Analyst in Austin Texas that is strong with both technical and functional aspects...Any ideas where I can find someone? Any interested in the role?

abc - April 14th, 2008

Hi, Could you please tell me some links to learn Peoplesoft Functional modules (Apart from Peoplebooks). Especially for core HR, Benefits, Payroll and Time and Labour.

Comments are closed.