Recent Forum Posts

From categories:
page 1123...next »

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

Difference Between Data Buffer and Component Buffer by DURGAVAJHULADURGAVAJHULA, 1280389156|%e %b %Y, %H:%M %Z|agohover
Re: Data Being Added Conflicts error on Save.
MeridianGuy (guest) 1280176902|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Data Being Added Conflicts error on Save.

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.

Re: Data Being Added Conflicts error on Save. by MeridianGuy (guest), 1280176902|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Matt (guest) 1279766787|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » PSQUERY App Engine email query results

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

Re: PSQUERY App Engine email query results by Matt (guest), 1279766787|%e %b %Y, %H:%M %Z|agohover
Data Being Added Conflicts error on Save.
MeridianGuy (guest) 1279584920|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Data Being Added Conflicts error on Save.

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

Data Being Added Conflicts error on Save. by MeridianGuy (guest), 1279584920|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Kathy (guest) 1278296995|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » PSQUERY App Engine email query results

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.

Re: PSQUERY App Engine email query results by Kathy (guest), 1278296995|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Kathy (guest) 1277783667|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » PSQUERY App Engine email query results

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

Re: PSQUERY App Engine email query results by Kathy (guest), 1277783667|%e %b %Y, %H:%M %Z|agohover
Re: Field Is Required while calling DoSaveNow()
Anonymous (guest) 1277632212|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Field Is Required while calling DoSaveNow()

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;
Re: Field Is Required while calling DoSaveNow() by Anonymous (guest), 1277632212|%e %b %Y, %H:%M %Z|agohover
Field Is Required while calling DoSaveNow()
mi jo (guest) 1276778170|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Field Is Required while calling DoSaveNow()

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() ?

Field Is Required while calling DoSaveNow() by mi jo (guest), 1276778170|%e %b %Y, %H:%M %Z|agohover
Re: HRMS TABLES
PrajPraj 1276750413|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » HRMS TABLES

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

Re: HRMS TABLES by PrajPraj, 1276750413|%e %b %Y, %H:%M %Z|agohover
PeopleSoft Campus Solutions 9.0
Shelly (guest) 1276722059|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Opportunities » PeopleSoft Campus Solutions 9.0

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

PeopleSoft Campus Solutions 9.0 by Shelly (guest), 1276722059|%e %b %Y, %H:%M %Z|agohover

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.

PeopleSoft HRMS Principal Consultant by Chandra ReddyChandra Reddy, 1276692064|%e %b %Y, %H:%M %Z|agohover

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.

PeopleSoft Finance Principal Consultant by Chandra ReddyChandra Reddy, 1276691985|%e %b %Y, %H:%M %Z|agohover
HRMS TABLES
DURGAVAJHULADURGAVAJHULA 1276577874|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » HRMS TABLES

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.

HRMS TABLES by DURGAVAJHULADURGAVAJHULA, 1276577874|%e %b %Y, %H:%M %Z|agohover
Thank you
Yvonne (guest) 1276546636|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Auditing User Profiles

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.

Thank you by Yvonne (guest), 1276546636|%e %b %Y, %H:%M %Z|agohover
Re: Great idea
PrajPraj 1275810084|%e %b %Y, %H:%M %Z|agohover
in discussion Projects / Email Message Catalog » Great idea

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.

Re: Great idea by PrajPraj, 1275810084|%e %b %Y, %H:%M %Z|agohover
Re: Small Bug, I think...
PrajPraj 1275809731|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Email Message Catalog

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

Re: Small Bug, I think... by PrajPraj, 1275809731|%e %b %Y, %H:%M %Z|agohover
Need to find field in peoplesoft
KHurley (guest) 1275661092|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Need to find field in peoplesoft

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.

Need to find field in peoplesoft by KHurley (guest), 1275661092|%e %b %Y, %H:%M %Z|agohover
Great idea
melbanmelban 1275576174|%e %b %Y, %H:%M %Z|agohover
in discussion Projects / Email Message Catalog » Great idea

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.

Great idea by melbanmelban, 1275576174|%e %b %Y, %H:%M %Z|agohover
Small Bug, I think...
bensonkybensonky 1275575079|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Existing Content » Email Message Catalog

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;
Small Bug, I think... by bensonkybensonky, 1275575079|%e %b %Y, %H:%M %Z|agohover
Re: Sending mail using PT_MCF_MAIL
srinivas (guest) 1275533483|%e %b %Y, %H:%M %Z|agohover
in discussion Forum / Help » Sending mail using PT_MCF_MAIL

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

Re: Sending mail using PT_MCF_MAIL by srinivas (guest), 1275533483|%e %b %Y, %H:%M %Z|agohover
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License