Archive for October, 2013


PeopleSoft Tip : Adding New Object OwnerId

The following steps is required to add new object ownerid.

Step1: open the field OBJECTOWNERID.
Step2: Add new translate value.
Step3: save the field.

We use MsgGetExplainText() to get the message from message catalog explain text part to display as an error or message or warning.

In PT8.49 onwards, the function is returning the text twice. for example if the text is “This is a Peoplesoft Message“, the output will be like

This is a Peoplesoft Message

This is a Peoplesoft Message

To get rid of this bug, we need to clear the second message which is in the buffer.
use it as below.

&error= MsgGetExplainText(28000,12,”Message not found”);
&novalue=MsgGetExplainText(99999,1,””);/* 99999,1 should not have any text*/
error (&error);

or this way.

&error= MsgGetExplainText(28000,12,”Message not found”);
&error=MsgGetExplainText(0,0,&error);/* 99999,1 should not have any text*/
error (&error);

I have a record with 2 keyfields and 4 required fields.
One keyfield is at level0 and all the other fields are at level 1. All the fields are editable.
When im trying to key in some information and save the component, i’m getting error which says “XXX field is required”.

This is even if the value is entered in the field.

When i made the level 0 keyfield as display only, then the error is solved.

After research i found that it is a peoplesoft delivered functionality.
We cannot have more than one record on the same level. But we can have same record on level 0 and level 1.
But the requirement to have the same record on level 1 and 0 is that ,level 0 fields should be display only.

when you have same record on level 0 and 1 then it tries to insert 2 rows in the database with same
value of level 0 fields and in level 1 for one row the values you have given. And in second row same level 0 field values but blank level 1
values.