Blogs

How can we call Dynamic Calling section in Peoplesoft Application Engine program?

Hi Friends,

Calling Dynamic Sction Dynamically:

Open Application engine program and insert the section with action(action like call section).Here select the Dynamic Calling check box,then open Peoplecode action with OnExecute event and write the Dynamic calling section Peoplecode like....

Evaluate Recrod.Field ----- Evaluate PS_JOB.EMPLID
WHEN "N"
PS_JOB.AE_SECTION.Value="VALIDALL" /*Call here which sction is required to retrieve the data*/
Break;
WHEN = "Y"
PS_JOB.AE_SECTION.Value = 'LOADDATA' /*Call here loading data sction*/
Break;
End-Evaluate;

Regards,
Mahendra

How can we write multiple SQL Commands/Statements under one Action by using one function?

Hi Friends,

Yes,we can write multiple SQL Statements by using %Execute Function.(Pls refer in Peoplbooks if required).

Example: Scenario1:
Open one SQL Action.............
%EXECUTE (/)
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
/
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
/
DELETE PS_JOB WHERE ROWNUM=10;
Note: Here forwardslash is optional to commit the statment.

Scenario2:
%EXECUTE()
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
COMMIT;
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
COMMIT;

Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?

Hi All,

The below are the some of collection for common Peoplesoft Terminology.

Business Unit: A business unit is an organizational entity which maintains its own transaction data.
Transaction Tables: Transaction tables store data about day-to-day business activities. Transaction tables in PeopleSoft are keyed in by Business Unit.

Difference between Custom and Customised objects in Peoplesoft?

Hi All,
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.

If am wrong please correct me.

Regards,
Mahendra

Creating an entirely read-only user in PeopleSoft

On big projects it is quite likely that large numbers of developers have access to a many environments. Occasionally they can have access to environment which is quite important, for instance one that the customer is using for training or testing.

Why COBOL and SQR processes are made API aware ?

An API aware process is able to update its process status.

COBOL and SQR processes API aware, use the standard API code provided by PeopleSoft.
Crystal processes have API built into PSCRRUN.EXE.

The API code updates the Process Scheduler the process’ runstatus, completion code, message set, and message number.

The API call is given just before it COMMITs processing.

If an error is encountered in the process, the code performs the rollback and updates the runstatus to “unsuccessful,” COMMITs this update and then terminates.

Why COBOL and SQR processes are made API aware ?

An API aware process is able to update its process status.

COBOL and SQR processes API aware, use the standard API code provided by PeopleSoft. Crystal processes have API built into PSCRRUN.EXE.

The API code updates the Process Scheduler the process’ runstatus, completion code, message set, and message number.

The API call is given just before it COMMITs processing.

If an error is encountered in the process, the code performs the rollback and updates the runstatus to “unsuccessful,” COMMITs this update and then terminates.

Working with crystal report

1)Create a Page with run control parameters and place this page in the component.
2)Navigate to Peopletools-->Process Scheduler-->processes-->Add new value
Mention Process type as Crystal.
Give a name.
In the process definition options tab give the Component name and give the process group.
in the override options tab select the
parameter list append and give the valueS ORIENTL:RECORD.FIELD:RECORD.FIELD
3)Go to all programs-->open the Crystal reports tool-->add new crystalreport-->Connect

Compare Report Query for PeopleTools 8.12 or 8.19

In older version of PeopleTools like 8.12, there is only option to save the Compare Report file and i.e. '.prt' format.
For viewing '.prt' files, it needs separate viewer or editor.
Inorder to save the Compare Reports run in PT 8.12 in .xls or .csv format, follow below steps

1> Run Compare Reports normally from App Desinger by Navigating to Tools --> Upgrade --> Compare/Report. Enter the Target environment Name and Password.

Unsupported Grafcap device - SQR 6458

When I try to run a custom developed SQR program, which has a bar chart, the error ”Unsupported Grafcap device –SQR 6458” was reported by the SQR engine.. Even when I tried with bar100.sqr program, which is a delivered SQR, the same error exists. Later I found the solution. There are three things to be considered while running any program with bar/pie/histogram etc.
a).stimages.dll
b).Libsti.ini
c).SQR File Path

a).Stimages.dll