Script to update the Tablespace for all the records in the Project.
Script to update the Tablespace for all the records in the Project. when we import Project in the client instance, we can use this SQL to change the tablespace for all the records at time, rather changing it one by one.
Update PSRECTBLSPC
SET DDLSPACENAME = {NEW TABLESPACE}
WHERE DDLSPACENAME = {OLD TABLESPACE};
and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B
Where A.PROJECTNAME = {PROJECTNAME} and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0)
Test third Party webservices integration with PeopleSoft
Test third Party
intergration w/ sample Peoplecode
Consume third Party web services.
Download the document for all the steps.
Creating PeopleSoft Mockup Pages Made Easy
Creating a PeopleSoft Mockup page while creating the Functional Design document and Requirement collection process is very important in the PeopleSoft Consulting Projects.
Usually Paint and screen captures are used to create the mock-ups.
Here find the the link to excel document, which has the collection of all the possible images/icons that you need to create easy mock-up pages quickly.
PeopleSoft Mockup Template
Download the file to view it in the Microsoft Excel.
Usually Paint and screen captures are used to create the mock-ups.
Here find the the link to excel document, which has the collection of all the possible images/icons that you need to create easy mock-up pages quickly.
PeopleSoft Mockup Template
Download the file to view it in the Microsoft Excel.
Subscribe to:
Posts (Atom)
Posts
