Ask the Hexaware Expert

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

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

Tagged as: PeopleSoft, peoplesoft upgrades

You might want to read these awesome related posts

{ 328 comments }

← Previous Comments

1 Srini A October 16, 2009 at 8:07 am: 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;
}
2 Gautam Agawari October 18, 2009 at 10:34 pm: 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
3 yashoovardhan October 20, 2009 at 3:53 am: 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
4 yashoovardhan October 20, 2009 at 4:16 am: 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
5 yashoovardhan October 20, 2009 at 4:21 am: Can any one help me
How to Incorporated workflow notifications in Application Engine programs
6 PS Help October 20, 2009 at 9:26 pm: 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.
7 PS Help October 20, 2009 at 9:39 pm: 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.
8 Booshan October 22, 2009 at 3:08 am: Can Anyone let me know the equivalent of %UpdateStats in peoplecode. I know %UpdateStats can be used for object type SQL.
9 Peter Vincent October 22, 2009 at 12:08 pm: has annyone implemented a customized “post approval” time reporting
10 anu radha October 23, 2009 at 7:06 pm: can anyone plz help with of how to,Created a process to load one time deductions for payroll using Application engine and component interface
11 PS Help October 25, 2009 at 8:29 pm: 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)
12 Vimal October 26, 2009 at 6:27 am: 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.
13 Vimal October 26, 2009 at 6:30 am: Hi Priti….did you check the RC_CASE_CI Component Interface as all case information is stored by invoking this CI.
14 vinn November 2, 2009 at 7:32 pm: 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
15 Mohammed November 10, 2009 at 4:44 am: Hi,

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

Regards,
Mohammed
16 Rahul November 10, 2009 at 10:22 pm: 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.
17 Rahul November 10, 2009 at 10:24 pm: What is the difference between the Functionality of People Soft CRM 8.9 to Peoplesoft CRM 9.0.
18 Aries November 21, 2009 at 6:12 am: 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
19 Vimal November 21, 2009 at 8:50 pm: Hi Aries…..You can use RECORD.FIELD syntax to use non default state record fields. For default only FIELD reference is required.

Regards,
Vimal
20 Aries November 22, 2009 at 1:20 am: 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 “)
21 Vimal November 22, 2009 at 2:36 am: Hi Aries …you can use

%select(StateRec1.field1,StateRec1.field2)select field1,field2 from table where condition.

StateRec1 = Non default State record.
22 Aries November 22, 2009 at 5:25 am: Thanks a lot Vimal. It answered my question the best way.

Regards,
Kishore M
23 Shard Soni November 23, 2009 at 9:06 pm: 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
24 PS Help November 23, 2009 at 9:32 pm: 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.
25 Sharad Soni November 24, 2009 at 11:38 am: 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.
26 PS Help November 25, 2009 at 12:13 am: 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.
27 Mohul November 25, 2009 at 5:13 am: 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.
28 Aries November 25, 2009 at 9:17 am: 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
29 Vaibhav Ashtekar December 14, 2009 at 6:27 am: 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.
30 Praveen Daniel December 16, 2009 at 6:18 am: 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
31 Praveen Daniel December 16, 2009 at 6:31 am: 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.
32 K. S. Rama Naidu December 17, 2009 at 5:03 am: 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.
33 Rahul Bagade December 23, 2009 at 11:08 pm: 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
34 Rahul Bagade December 29, 2009 at 5:09 am: 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
35 Praveen January 1, 2010 at 9:03 am: 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
36 mano January 21, 2010 at 11:36 pm: 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.
37 Bhaskar January 23, 2010 at 9:48 pm: 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
38 PS_Help January 24, 2010 at 8:40 pm: 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.
39 sirihem February 9, 2010 at 12:24 am: 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
40 Kiran Vaddin February 18, 2010 at 11:48 pm: 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
41 Sugantharaj March 8, 2010 at 12:50 am: I want to display an image as the background for a mail notification, triggered using SendMail sendmail function in peoplecode..Please help me out
42 ram March 25, 2010 at 9:11 pm: can please let me the peoplesoft project life cycle and what does Fit gap means.
43 Hakkim June 14, 2010 at 6:36 am: 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.
44 WS June 14, 2010 at 10:34 am: 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?
45 RevathyP June 16, 2010 at 12:46 pm: 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.
46 Aarti Balasubramanian June 24, 2010 at 6:33 am: 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
47 Priya July 1, 2010 at 4:58 am: 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
48 George July 2, 2010 at 5:03 pm: 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
49 Srikrishna July 15, 2010 at 2:24 pm: 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.
50 Anil Kumar Reddy August 13, 2010 at 4:22 am: 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.