To delete the server cache, normally we bring down the application server services and deltete the contents under $PS_HOME/appserv/{domain}/cache folder. We can workaround this complicated process by invalidating the current cache. You can use the following command to invalidate the cache.

UPDATE PSSTATUS SET LASTREFRESHDTTM = SYSDATE

Hope this helps some of you guys.

I know this sounds little stupid for some people, but for some people this is helpful. I know one guy who gets confused all the time with these two terms and comes and asks me all the time. I thought I would list these here and ask him to remember PeopleSoftGuys.com, so that he can come here and read it..

Custom Objects in PeopleSoft: Custom objects are the objects built by a PeopleSoft client to accommodate their business needs.

Customized Objects in PeopleSoft: Customized objects are the delivered objects from PeopleSoft to which the client made some changes to accommodate their business requirements.

PeopleSoft Data Mover issues COMMIT statements after most successful SQL commands, except for EXPORT and IMPORT commands. But for EXPORT and IMPORT commands, PeopleSoft Data Mover issues a COMMIT after each record. With IMPORT commands you can associate a  SET COMMIT n command, which will perform a COMMIT after the system inserts every n rows.

Example:

SET INPUT C:\PS_CUSTOMER.dat;
SET COMMIT 5000;
IMPORT *;

The example shows that it will import all the data from PS_CUSTOMER.dat file and it will commit the data after every 5000 rows are inserted into PeopleSoft record.

ENCRYPT_PASSWORD
 Encrypt one or all user passwords defined in PSOPRDEFN table.
  Example: ENCRYPT_PASSWORD ROGERS;

EXPORT
 EXPORT command will be used to export the data from a table or a join of tables and store the result set in a file. You can use the generated export file as input for migrating data to any another platform.
Example:
SET OUTPUT C:\PS_CUSTOMER.dat
EXPORT PS_CUSTOMER;

IMPORT
IMPORT command will be used to Insert data into PeopleSoft tables using the data in an exported file. If a tablespace or table does not exist, this command creates tablespace, table, and indexes for the record, using the information in the exported file, and inserts the data.
Example
SET INPUT C:\PS_CUSTOMER.dat
IMPORT *;
 
REM, REMARK, and –
 These commands will be used to indicate comment statements in the data move scripts.

Example:
REM Example file;
 

You can connect to PeopleSoft data mover in two modes depending on the previlages that your user id has. The following two are the modes that you can connect to the data mover.

• Regular mode.

Most of the time you connect using this mode. To sign in to the data mover in regular mode, enter your PeopleSoft user ID and password during sign-in. In regular mode, all data mover commands are valid.

• Bootstrap mode.

In bootstrap mode, you use a database access ID and access password when signing in to data mover. Typically, we use bootstrap mode for database load. When we create a brand new PeopleSoft database we connect to the data mover in a bootstrap mode. We also use bootstrap mode for running some security commands, such as ENCRYPT_PASSWORD.

Objective:
Developer needs to include all his objects when they modified and saved into the project.Method:
The following method shows you how to insert an object automatically into a project when you modified and saved or deleted.