select 'create public synonym ' || table_name || ' for SYSADM.' || table_name || ';' from ALL_TABLES where owner = 'SYSADM';

by Praj

Specifically you can use a query like this to check the first process that was run:

select * from PSPRCSRQST where DBNAME = '{your database}' order by RUNDTTM asc;

It may only be an approximation as it relies on at least one process running after the refresh (typically a system process) which may or may not have happened on the same day as the refresh. Even so it, gives you a timeframe to work with.

by Praj

Process Profile defined for user ID %2 is invalid (65,111) The process profile assigned to the user ID is either not valid or blank. Update the User Profile for the user ID in the Maintain Security component with a valid process profile.

PeopleTools > Security > User Profiles
Enter user's ID

Check the Process Profile permission list. It is most likely blank or invalid. Set to something valid like PTPT1000 for example.

by Praj

You can test Business Interlinks from PeopleTools > Utilities > Debug > PeopleTools Test Utilities

PeopleTools > Utilities > Administration > XML Link Function Registry

For PeopleSoft Finance Journal Upload Process:

• Service = Excel_Journal_Import
• WEBLIB_GL.JOURNAL_ID

Check users have access to WEBLIB_XMLLINK (PSAUTHWEBLIBVW) and WEBLIB_GL

by Praj

Error: Process aborted. Possibly due to JVM is not available or missing java class or empty password.

Per the notes on The Smart Panda site, PeopleTools 8.53+ has a new salt component and this uses Java for encryption.

To fix you need to add %PS_HOME%\jre\bin\ to Windows your path:

Control Panel > System > Advanced > Environment Variables (or search settings for Edit the System Environment Variables).
Scroll through System Variables and find PATH, and append the location of %PS_HOME%\jre\bin\ to the end e.g.

Note once you do this, you need to close and re-open data mover for it pick up the new path.

by Praj

by Praj

PeopleTools > Integration Broker > Configuration > Service Configuration

Click on the "Setup Target Locations" hyperlink:

On the target locations page, set the relevant values as suggested e.g.

SOAP/XML web services
http://<machine>:<port>/PSIGW/PeopleSoftServiceListeningConnector

REST web services
http://<machine>:<port>/PSIGW/RESTListeningConnector

by Praj

UserName not defined in database. (158,55)

Then check the Default User ID set for the ANONYMOUS Node (used by IB for web services) and make sure that it is a valid username and that the user account is active (e.g. not locked out).

by Praj

by Praj

Fortunately there is a way to specify the order in which to build views: Build Sequence No which you can find in the Record Type tab of a view definition.

By default the value of this field is 1. You could specify a sequence for every view, but all you really need to do is increase the build sequence number of any views to be greater than the view they rely on (i.e greater than 1).

For example:

• BUILD_1ST_VW build sequence no = 1 (default)
• BUILD_2ND_VW build sequence no = 2 (or greater)

That way, BUILD_1ST_VW will always be built before BUILD_2ND_VW. Test by building all views and checking the build script to make sure BUILD_2ND_VW is further down in the script than BUILD_1ST_VW.

Repeat until you have a build script that is in the correct order for any build dependencies.

by Praj

PeopleBooks gives an example of how to sort by a single field. To sort by multiple fields, add each record.field and order to the parameter list. For example:

&rs.Sort(RECORD.FIELD1, "A", RECORD.FIELD2, "D", RECORD.FIELD3, "A");

So this example will sort by FIELD1 (asecending) then FIELD2 (descending) and then FIELD3 (ascending). Pretty much the same as an order by syntax but you do need to be explicit about the sort format (A=ascending, D=descending).

by Praj

function RemoveHTMLTags(&sInputHTML as String) Returns String Local JavaObject &jRemoveHTMLRegex = CreateJavaObject("java.lang.String", "<[^>]*>"); Local JavaObject &jInputHTML = CreateJavaObject("java.lang.String", &sInputHTML); Local string &sPlainText = &jInputHTML.replaceAll(&jRemoveHTMLRegex, ""); Return &sPlainText; end-function;

Place this function (or turn it into an App class method) and use it as required. Useful for cases where the PeopleSoft rich-text editor has saved HTML in a DESCRLONG type field in the database.

by Praj

This code utilises the WriteToLog function to output the snapshot to the Application Server log directory as a tracesql file.

Local Record &rec_Snapshot = &rs(1).EXAMPLE_RECORD; Local number &i; Local number &fieldCount = &rec_Snapshot.FieldCount; Local string &log = ""; WriteToLog(%ApplicationLogFence_Error, "--- BEGIN Record Snapshot for Record: " | &rec_Snapshot.Name | " ---"); For &i = 1 to &fieldCount &log = "... "; If &rec_Snapshot.GetField(&i).IsInBuf Then &log = &log | &rec_Snapshot.GetField(&i).Name | '=' | &rec_Snapshot.GetField(&i).Value; Else &log = &log | &rec_Snapshot.GetField(&i).Name | '=' | '(Not in Buffer)'; End-If; WriteToLog(%ApplicationLogFence_Error, &log); End-For; WriteToLog(%ApplicationLogFence_Error, "--- END Record Snapshot for Record: " | &rec_Snapshot.Name | " ---");

Also you'll notice that it uses the Field class IsInBuf method to check if the field is actually in the buffer (i.e. has some data ) and only report the value of the record's field if it has data in the buffer. If not it will report it as (Not In Buffer).

Comments

by Praj

To summarise, the WriteToLog function consists of two parameters:

• Log fence setting, I usually use %ApplicationLogFence_Error (1) to ensure it will write a log file
• The relevant text string to be written to the log file

When called, it will write to a file called something like <OPRID>_<IP>.tracesql in the application server logs folder (where you would typically find other trace files).

The thing I like best about this is that it is unobtrusive. It doesn't impact other users and it doesn't stop execution flow (nothing worse than a MessageBox in a loop that you have to click through 50 times!).

by Praj

For example, take the PeopleSoft home page, this is how it looks once you press "f" with Vimium:

All those yellow labels with letters are the keys to press to take you to that particular link. For example, pressing "md" takes you to PeopleTools.

From there, press "f" again to bring up the letters.
You can then press "la" to browse to the process monitor:

Press "f" again and you can press "pk" to refresh the monitor or "pc" to change the run status filter.

Probably not for everyone, but I find this extremely useful when you are repeatedly browsing to the same places (e.g. testing).

by Praj

Here are the steps:

• In the source environment, copy just the project definition (no objects) to the target environment from the source. To do this, in the copy project dialog, deselect all definitions but ensure that Copy Project Definition is checked.

• In the target environment, you will now have a project with the same name and will include any definitions that already exist. Any new definitions will show up in the project but will be invalid. This is fine.

• In the target environment, export the project to a file. This will be your pre-migration backup.

• Finally back in your source environment, you can perform a full migration (all definition).

Now, if, unluckily you have clobbered a definition, and need it back, you can get it back from the backup file. It's not all that intuitive but it does give you a way to go back if required.

by Praj

My suggestion for doing this is to put it into component PeopleCode for the relevant run control component in either FieldEdit or FieldChange event of the Run button.

Specifically, the location for this code would be component-record-field PeopleCode at:

YOUR_COMPONENT.PRCSRQSTDLG_WRK.LOADPRCSRQSTDLGPB.FieldChange or FieldEdit

This is assuming that you have added the PRCSRUNCNTL_SBP to your run control page. The PeopleCode location will vary if you are using a different run control subpage.

The nice thing about using component-record-field PeopleCode here is that the validation is just for your component (and does not get called in other components that use the same shared sub-page).

Remember to use the PeopleCode Error command if you need to stop processing and prevent the run control being scheduled if you are using FieldChange. Alternatively use the FieldEdit event.

by Praj

Something as simple as this can be a valuable debugging tool at times:

Error "The value of variable x=" | &x;

Most people use message box (or the now very deprecated WinMessage), but at times this may not appear depending on the context of the PeopleCode you are executing. Error stops processing (a poor man's breakpoint) so you can find out what's going on at that exact point in the code.

by Praj

Our site is highly focused and founded by veteran PeopleSoft professionals. Every website that we operate has focused on the careers of ERP professionals, especially the PeopleSoft Pro.

by Praj