PeopleSoft Wiki

What is the difference between Data Buffer and the Component Buffer?

Just to update… I found that the page had a secondary page which had a scroll area (instead of a group box). The scroll area property "No Auto Update" was NOT checked so the processor was doing an auto update in addition to my SQL Insert.

The solution was to check the "No Auto Update" on both the grid and the scroll area on the secondary page.

The following URL provides an example of how to achieve this, although additional work is required to make it suitable for releasing to production around who is emailed the query result.

How to email scheduled psquery results

As mentioned in the comments to the blog this functionality is available in Tools 8.5

My page has a level 1 grid whose primary record is a "top of stack" view. When the user modifies a "top of stack" row, upon the Save I do a CopyTo(&Rec), where &Rec is the underlying table, then I increment the effdt and effseq appropriately, then do a &Rec.Insert.

I am doing this for several grids on the page at the same level, and all grids work fine except this one grid. In all cases, the level 1 scrolls have one extra key than the parent. In this case, the trace shows the &Rec.Insert succeeding, then it attempts the "Select for Update" into the original view giving the original effdt. This doesn't happen for any other grid. All other grids stop after the insert.

TRACE FILE:

If GetRow().IsChanged Then
&Rec = GetRecord();
If &Rec.EFFDT.Value = %Date And
GetRow().IsNew = False Then
&Rec.EFFSEQ.Value = &Rec.EFFSEQ.Value + 1;
Else
&Rec.EFFDT.Value = %Date;
&Rec.EFFSEQ.Value = 0;
End-If;
…
&REC2 = CreateRecord(Record.ZG_ENT_KC);
&REC2.SetDefault();
&Rec.COPYFIELDSTO(&REC2);
&REC2.Insert();

Stmt=INSERT INTO PS_ZG_ENT_KC (ZG_ENTITY_ID,EMPLID,EFFDT,EFFSEQ,EFF_STATUS,PHONE, EMAIL_ADDR,LASTUPDOPRID,LASTUPDDTTM) VALUES (:1,:2,TO_DATE(:3,'YYYY-MM-DD'),:4,:5,:6,:7,:8,TO_TIMESTAMP(:9,'YYYY-MM-DD-HH24.MI.SS.FF'))
value=V0000001
value=7269 555
value
10-07-19
value=0
value=A
value=444/444-4444
value=
value=743156
value
10-07-19-19.36.34.000000
End-If;

Stmt=SELECT ZG_ENTITY_ID, EMPLID, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'), EFFSEQ, EFF_STATUS, PHONE, EMAIL_ADDR, LASTUPDOPRID, TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') FROM PS_ZG_ENT_KC_VW WHERE ZG_ENTITY_ID=:1 AND EMPLID=:2 AND EFFDT=TO_DATE(:3,'YYYY-MM-DD') AND EFFSEQ=:4 FOR UPDATE OF EFFDT, PHONE, LASTUPDOPRID, LASTUPDDTTM
value=V0000001
value=7269555value
10-07-15
value=0

Hi Melban - we found our issue to this, there is SMTP settings in the psprcs.cfg that had not been configured NOTE you have to set the SMTPSourceMachine to the machine name.
Hope this helps anyone that comes across this issue.

Did you get any further with this? we are trying to do the same thing, we have gone into distribution selected "Email Web Report" and entered in email address… process completes sucessfully but no email generated. If you have got any further than this please let me know.

Thanks

Does it work if you check for a value of OT_ESS.DATE before calling DoSaveNow() ? E.g.

If All(&LocalRowOT(&i).OT_ESS.DATE.Value) Then
   DoSaveNow();
End-If;

Why OT_ESS.DATE is stated empty while calling DoSaveNow() althought it already has a value?

Here is the code in the submit button

Local Rowset &LocalRowOT;
&LocalRowOT = GetLevel0()(1).GetRowset(Scroll.OT_ESS);

For &i = ActiveRowCount(Scroll.OT_ESS) To 1 Step - 1

   If All(&LocalRowOT(&i).OT_ESS.EMP_RMK.Value) Then
      &LocalRowOT(&i).OT_ESS.STATUS.Value = "SUB";
   End-If;
   If All(&LocalRowOT(&i).OT_ESS.CODE.Value, &LocalRowOT(&i).OT_ESS.DATE.Value, &LocalRowOT(&i).OT_ESS.EMP_RMK.Value) Then
      &LocalRowOT(&i).OT_ESS.DATE.Enabled = False;
      &LocalRowOT(&i).OT_ESS.EMP_RMK.Enabled = False;
   End-If;

   DoSaveNow();

End-For;

I got this error messsage after click the SUBMIT_BTN
Field Is Required: OT_ESS - DATE

I try to display the value so add the code with message boxes:

Local Rowset &LocalRowOT;
&LocalRowOT = GetLevel0()(1).GetRowset(Scroll.OT_ESS);

For &i = ActiveRowCount(Scroll.OT_ESS) To 1 Step - 1
   MessageBox(0, "", 0, 0, "&i is " | &i | " &LocalRowOT(&i).OT_ESS.DATE is " | &LocalRowOT(&i).OT_ESS.DATE | " &LocalRowOT(&i).OT_ESS.DATE.Value is " | &LocalRowOT(&i).OT_ESS.DATE.Value);
End-For;

For &i = ActiveRowCount(Scroll.OT_ESS) To 1 Step - 1

   If All(&LocalRowOT(&i).OT_ESS.EMP_RMK.Value) Then
      &LocalRowOT(&i).OT_ESS.STATUS.Value = "SUB";
   End-If;
   If All(&LocalRowOT(&i).OT_ESS.CODE.Value, &LocalRowOT(&i).OT_ESS.DATE.Value, &LocalRowOT(&i).OT_ESS.EMP_RMK.Value) Then
      &LocalRowOT(&i).OT_ESS.DATE.Enabled = False;
      &LocalRowOT(&i).OT_ESS.EMP_RMK.Enabled = False;
   End-If;

   MessageBox(0, "", 0, 0, "before save : OT_ESS.DATE is " | OT_ESS.DATE | " and OT_ESS.DATE.Value is " | OT_ESS.DATE.Value);

   DoSaveNow();

End-For;

The first Message box
i is 1 &LocalRowOT(&i).OT_ESS.DATE is Field &LocalRowOT(&i).OT_ESS.DATE.Value is 2010-06-10

The second Message box
before save : OT_ESS.DATE is and OT_ESS.DATE.Value is

the field DATE already has a value (displayed in the message box). But why it generates error while calling DoSaveNow() ?

If you are just after tables, start with the following query:

select RECNAME, RECDESCR
from PSRECDEFN
where RECTYPE = 0
and RECNAME not like 'PS%'
order by RECNAME;

A RECTYPE of 0 indicates a table. The condition RECNAME not like 'PS%' excludes the PeopleTools tables which (largely) start with PSabc (e.g. PSOPRDEFN).

Hi!

I'm looking to find someone who has good experience working with PeopleSoft Campus Solutions 9.0. If you do, please let me know as I'd like to speak to you about an excellent position in the NY area.

Shelly
646-247-0075

My name is Chandra Reddy working as an IT recruiter with Avance Consulting Services. I would like to share a job opportunity with one of our esteemed clients.
Please find the below job description and if you are interested, Please send me your updated CV and also suggest me the best time to discuss in detail.

Requirement:

Roles : PeopleSoft HRMS Consultant
Location : London

Job Description:

 Implement multiple Peoplesoft HRMS modules like HR, Benefits administration, Talent Acquisition & Candidate Gateway with expertise in one or more process areas
 Model business processes based on user requirements.
 Understand and advise client on best practices
 Implement technical and package configurations with setups
 Support and/or conduct requirements collation and analysis.
 Map package features to client requirements, suggest workarounds where necessary, conduct Fit- Gap analysis, define requirements for customizations and extensions.
 Conduct CRP, support UAT, user training and perform System testing, configuring in Development environments as part of implementation, support and other related activities.
 Provide guidance to the team, throughout the project life cycle for a successful completion of the project.
 Tailor methodologies and macro issues to customer’s needs
 Good knowledge of PeopleSoft Upgrade/Implementation methodologies
 Lead large teams at a module or functional process
 Pre-sales support activities.
 Contribute to thought-leadership and identification of pre-packaged solutions.

Mentor junior consultants.

Looking ahead to hear from you.

Best Regards,
Chandra Reddy
Avance Consulting(Europe)
Direct: +44 20 79935300
Fax : 08718130559
Email: moc.secivresecnava|ydder.ardnahc#moc.secivresecnava|ydder.ardnahc
www.avanceservices.com

We pay referral fee for all our positions. Please visit http://www.wisestep.com/ for details.

My name is Chandra Reddy working as an IT recruiter with Avance Consulting Services. I would like to share a job opportunity with one of our esteemed clients.
Please find the below job description and if you are interested, Please send me your updated CV and also suggest me the best time to discuss in detail.

Requirement:

Roles : PeopleSoft Financial Consultant
Location : London
Type : Permanent

Job Description:

 Implement multiple Peoplesoft Financial modules like finance, Benefits administration, Talent Acquisition & Candidate Gateway with experties in one or more process areas
 Model business processes based on user requirements.
 Understand and advise client on best practices
 Implement technical and package configurations with setups
 Support and/or conduct requirements collation and analysis.
 Map package features to client requirements, suggest workarounds where necessary, conduct Fit- Gap analysis, define requirements for customizations and extensions.
 Conduct CRP, support UAT, user training and perform System testing, configuring in Development environments as part of implementation, support and other related activities.
 Provide guidance to the team, throughout the project life cycle for a successful completion of the project.
 Tailor methodologies and macro issues to customer’s needs
 Good knowledge of PeopleSoft Upgrade/Implementation methodologies
 Lead large teams at a module or functional process
 Pre-sales support activities.
 Contribute to thought-leadership and identification of pre-packaged solutions.

Mentor junior consultants.

Looking ahead to hear from you.

Best Regards,
Chandra Reddy
Avance Consulting(Europe)
Direct: +44 20 79935300
Fax : 08718130559
Email: moc.secivresecnava|ydder.ardnahc#moc.secivresecnava|ydder.ardnahc
www.avanceservices.com

We pay referral fee for all our positions. Please visit http://www.wisestep.com/ for details.

I want to know all the hrms tables available in peoplesoft. can i find the list of all hrms table names in one table, if so please provide the name of that table.

This is the first time I have used information found on this site.

I have never created a trigger, nor an audit record.

Your instructions were perfect.
I followed them and had success the first time.

Thank you.

Thanks glad you like it. I've used it in numerous places which is why I packaged it up. Let me know if you have any enhancements to it you'd like to publish.

Nice pick up, really appreciate you pointing this out. I've updated the code and put up a new version of the project. Thanks!

Does anyone know what record/field would denote in peoplesoft if a purchase order is a regular order or a repair? I need to eliminate purchase orders in a query that I have developed for a user based on if it is a purchase order for a repair.

This is such a great idea. I've used the correspondence CRM piece before and it is just too bulking for some things. This allows for very simple emails to be sent very easily and I'll use this in the future. I've also been using the PT_MCF_MAIL App Package alot for projects and have had to develop a nice template engine to go along for generating complex HTML emails. Great start.

First off, this rocks!

While reading through this I noticed what I think is a small bug. Doubt it would ever show or cause issue, but thought I'd mention it.

method GetResultText   
 ...   
   When = %ObEmail_NotDelivered
      Return "Delivery not attempted";
      Break;
   When = %ObEmail_NotDelivered
      Return "Partially delivered";
      Break;
 ...
end-method;

I think this should actually be

 When = %ObEmail_NotDelivered
      Return "Delivery not attempted";
      Break;
 When = %ObEmail_PartiallyDelivered
      Return "Partially delivered";
      Break;

Thanks for posting
I've posted the same question Oracle SUport

from Metalink

In PT8.50 we have a new function called isdomainavailable to check if the email address's domain is valid or not. It pings DNS server to validate email addresses. Other than that, there is no other ways. Development has stated that Java mail on the outgoing server does not check for invalid address of TO address while sending an email. It just checks for the correct format of email address.
If you consider to upgrade to PT8.50, this issue can be resolved.

:-(
Thanks
Srinivas