About “Integration Broker Case Study”

Thanks to the working environment, I have published this article in Infosys K-shop these days.

According to the suggestion, it will a kind of IP of the company ^_^

Integration Broker Case Study (Fileoutput) II

In this case, we are going to configure the intergration broker for the file output of the new/updated data in PeopleSoft, which means the system will give a file out when we enter a new record or update a record.

We use an available service DEPT_SYNC for department record updated or added. The following are main steps in the process:

• Start up Sub/Pub in PSadmin
• Configure PeopleSoft Listenning Connectors
• Configure PeopleSoft Traget Connectors
• Create the Nodes
• Create the Routing
• Put the Routing in a Queue
• Activate the service

1. Start up Sub/Pub in PSadmin

Open your PSadmin console to admin the app server and select your domain to configure. Put Pub/Sub Servers on in your configuration file and reboot the domain. We will be able to find the below info.

2. Configure PeopleSoft Listenning Connectors

In PIA, Main Menu > PeopleTools > Integration Broker > Quick Configuration, choose your local gateway, put your local gateway URL, like http://yourserver:yourport/PSIGW/PeopleSoftListeningConnector. If it is the correct address, you will ping the gateway successfully. In addition, you will also find your domain is in the intergration broker domains’ list, which is in active status.

Il y a longtemps

I am not sure why I can not visit my blog in last few days. Is it blocked or banned? Any ways, it is reachable now. Let’s keep on moving^o^

Integration Broker Case Study (Fileoutput)

Perface

It is from PeopleBooks that PeopleSoft Integration Borker facilitates exposing PeopleSoft business logic as services for PeopleSoft Applications to invoke, which means that IB (Integration Broker) helps PeopleSoft to work with other systems. The overview of the architecture is follow:

The integration process include configuring messaging systems as well as managing integration gateways, while we have the following items in the integration gateways:

• Nodes
• Messages
• Queues (“Queue” is once called “Message Channel” in pervious PeopleSoft version.)
• Services
• Service Operations
• Routings

I am able to give a general picture about the above items according to my understanding:

A service operation can develiery messages though a routing, while service operation is working in a queue. That’s it. Of course, there are also some pictures from PeopleBooks, which make out the mechanism.

These days, I was working on some IB in action to have a better understanding of it. There is an article,Using PeopleSoft Integration Broker, about how to get a fileoutput by using IB, but the tutorial is a little bit out of date. Now let us see how to make it work in our system.

PeopleCode Debug

Sometime, we will need to investigate in PeopleCode for debug. Here is a short introduction for doing so.

1. Use Getfile to debug PeopleCode

We simply use a file to log the data and variables.  Here is a similar article about this (http://peoplesoftexperts.blogspot.com/2005/12/debug-peoplecode-using-getfile.html ), I am also writing the PeopleCode as the following:

/* Debug Part*/

SQLExec(“select sysdate from dual”, &ddate);

&DFILE = GetFile(“\\machine_name\Output\dfile.txt“, “A”, %FilePath_Absolute);

If &DFILE.IsOpen Then

&DFILE.WriteLine(&ddate | “Your Data”);

&DFILE.Close();

End-If;

/* Debug Part End*/

What we do is to put the code in the place,  we are going to debug.

2. Debug Mode in Application Desinger

It would be better to have an IDE to debug the application and code, which is provided by Application Designer. We can use its debug mode to do the job. Here is way to enable the debug mode for 3-tier (PIA). There is a detail How-to in PeopleBook System and Server Administration, Chapter 12, Chapter 12 Configuring Trace and Debug Settings: http://download.oracle.com/docs/cd/E05317_01/psft/acrobat/pt849svt-b0307.pdf

While the following is a brief:

1. Enable PC Debugger in PSADMIN

2. Set the PSDBGSRV Listener Port in PSADMIN and Enable the log.  Normally, it is 9500, for example in .cfg file:

• Values for config section – PeopleCode Debugger
  PSDBGSRV Listener Port=9500
  DebuggerMsgLogEnable=1

3. Set Multiple PSAPPSRV Server Processes and Timeout to 0.  For example:

• Values for config section – PSAPPSRV
  Min Instances=2
  Max Instances=2
  Service Timeout=0
  Recycle Count=0
  Allowed Consec Service Failures=0
  Max Fetch Size=5000
  Auto Select Prompts=1
  Tuxedo Queue Size=65535

4. Open the Configuration Manager to ensure the PSDBGSRV Listener Port is 9500 on the same machine of Application Server

5. Login to Browser (PIA) and Application designer in three tier (App Server) with same and unique UserId.

6. In application designer, start debugger. Enable “break at Start” or set “break points” and access Page / Component to be debug in browser.

PeopleSoft Record Notes I

PeopleSoft is a database oriented application, which puts almost everything in the database.  We develop and update the metadata in database for the development. The following is the data structure as far as I know:

• Field->Record->Page->Component->Menu

Let’s Start:

1. Field:

Fields are the lowest-level definition in PeopleSoft, in general we can think of them as the column definiation in a database. Namely, we can find the definition in a table called PSDBFIELD in PeopleSoft Database. And we have a PSRECFILED, which keeps the relationship information of Records and Fields.

Related Tables: PSDBFIELD, PSRECFILED

2. Record:

A collection of fields is a record, while the core in peoplesoft definitions is “Record”. Their definitions are stored in the table named PSRECDEFN. And we now have the following record types:

• SQL Table
• SQL View
• A Derived Work Record (To store totals or buttons, messages or temp fields, only available during the session. No real table)
• Sub Record (For SubPages and the one-to-many relationship)
• Dynamic View
• Query View
• Temp Table

In order to create a standard record, such as SQL table, we will have to have the following operations:

1. In PIA, PeopleTools->Utilities->Administration->Tablespace Utilities to define the tablespace
2. Check PSTBLSPCCAT table for the new tablespace
3. Define the tablespace in Database
4. Create the record metadate in PSRECDEFN with Application Desinger
5. Build record with SQL generated by Application Desinger

Install PeopleSoft Step By Step Part III

5. PIA Setup:
• Use PIA Setup Wizard Program (PS_HOME\setup\PsMpPIAInstall\setup.exe) to create a PIA site
1. Setup your PIA site

2. Input your PS_HOME folder

3. Use WebLogic as the web server

4. Input WebLogic Application Home

5. Create a new domain with a domain name

6. The web server is for single server domain.

7. Specify a name for the web site.

8. Give the application server name and assign the port. (JSL Port should be the same as the one used in application server.)

9. Use the default User ID and Password for web profile. (The account is build in DB PSOPRDEFN)

10. Select your report repository location

11. Confirm your setting and parameters for PIA setup

6. PIA Service Startup:
• Find the web server startup file in PS_HOME\webserv\MyPeople\bin\startPIA.cmd
• Start your web server and be sure that Web Logic can connect your application server with JSL port
• Boot Your Application server with psadmin.exe (PS_HOME\appserv\psadmin.exe)

• 1. Start PSADMIN
• 2. Specify 1 for Application Server and press ENTER.
• 3. Specify 1 for Administer a domain and press ENTER.
• 4. Select the domain to administer and press ENTER.
• 5. Specify 1 to boot this domain and press ENTER.
• 6. Specify 1 to boot in serial mood and press ENTER

7. Testing:
• Open your web browser and input the local host IP address and HTTP port (http://127.0.0.1:80)

• Choose “default PeopleSoft logon page”

• Use PS/PS to log in

Install PeopleSoft Step By Step Part II

3. 2-tiers Connection Configuration:
• Connect to testing DB with Oracle Client 10g Enterprise Manager (If the connection has been create with configuration Assistant when installing the Client, you can skip the step. Otherwise, you will need to setup a connection.)

• Use sysadm/sysadm to connect with data mover to the DB. (Choose the connection type as “Oracle” and database name is the connection name you have created in the above step.)

• Use the script to reset the password (PS_Home\scripts\resetpswd.dms)
The script will have the following commands:
UPDATE PSOPRDEFN SET OPERPSWD = OPRID, ENCRYPTED = 0;
UPDATE PSACCESSPRFL SET ACCESSID = ‘SYSADM’, ACCESSPSWD = ‘SYSADM’, ENCRYPTED = 0;
ENCRYPT_PASSWORD *;

• Check the internal parameter in DB (PSOPRDEFN; PSLOCK; PSDBOWNER; PSSTATUS PSACCESSPRFL), which should be the same as the one as your connection. Otherwise, you will have to setup a new Connection according to the parameter in DB or modify your DB’s parameter.

• Use People Tools Configuration Manager and setup connection:

• Database Type: Oracle
• Database Name: (Your Connection Name)
• User ID: PS (for HRMS)
• Connect ID: people
• Connect Password: peop1e

• Use 2-tiers connection in Application Designer (PS/PS)

4. Application Server Setup:
• Use psadmin.exe (PS_HOME\appserv\psadmin.exe) to create a domain
1. Start PSADMIN
2. Specify 1 for Application Server and press ENTER.
3. Specify 2 to create a domain and press ENTER.
4. Input the name of the domain and press ENTER.
5. Select the template to use, choose 1 as developer and press ENTER.
6. Start to Configure the domain

• Select the number before the item you want to modify and press ENTER. Specify 13 to load the configuration. Configure the domain as the followings:

• DBNAME: (Your Connection Name)
• DBTYPE: ORACLE
• UserId: PS
• UserPswd: PS
• ConnectID: people
• ConnectPswd: peop1e
• Jolt: Yes
• JSL Port: 9000 (use an available port)

• Boot the Application Server.
1. Select 13 to load the configuration and press ENTER.
2. Specify q and press ENTER to exit to the top menu
3. Specify 1 to boot the domain and press ENTER
4. Specify 1 to boot in serial mood and press ENTER
5. The message will be shown after starting the server successfully. (Please be noted that JSL is available on it’s port.)

• Shutdown Application Server
1. Specify 2 and press ENTER to shutdown the server
2. Select 1 and press ENTER for normal shutdown

Install PeopleSoft Step By Step Part I

It is a basic article about PS installation based on Oracle 10g in Win XP/2003. Let’s go though the process step by step:

1. Platform and Software Package:
• OS: Windows XP/2003
• PeopleSoft Package (download from http://edelivery.oracle.com): People Tools 8.49 (B42585-01 … B42581-01); WebLogic Server 9.2; BEA Tuxedo 9.1 for Windows
• Miscellaneous Software: Oracle Client 10g; Secure CRT 5.0.4

2. Software Installation:
• Oracle Client 10g Installation
1. Run “setup.exe”

2. Select Installation Type as “Administrator”

3. Choose the home folder for the software

4. Start to install the software

5. Use the configuration Assistant

6. Select Naming Methods as Local Naming

7. Input the SID in the remote Database

8. Select TCP to connect to the remote server

9. Input the name or IP of the remote server and port number of the database

10. Test the connection with sysadm/sysadm (be sure the connection works successfully)

11. Give a name of your net service and complete the installation

• Tuxedo 9.1 Installation
1. Use pstuxinstall.exe to start the install program

2. Set the parameters for Tuxedo 9.1    ——- BEA Home/The folder to install in/TListen Port (default is 3050)

3. Start to install and to complete the installation according to the message

• PeopleTools Installation
1. Unzip the package and run setup.exe

2. With Oracle Database using the code.

3. Select your programs to be installed

4. Choose the folder to install in

5. Select the 3rd party ERP connector, if there is no connector. Choose “No”

6. Set the connectivity Program Directory (Your Oracle Connector program in bin)

7. Enter the configuration for environment management

8. Confirm the above setting and parameters and finish the installation

PeopleSoft Module and Menu Query

As it is known that PeopleSoft PIA pages and Menus’ definiation are stored in PSPRSMDEFN. We can also use some Hierarchical Queries in Oralce DB to trace a page with Portal_objname, Portal_prntobjname. Here is the example:
http://www.compshack.com/peoplesoft/queries/query-component-path-within-peoplesoft-portal

However, if we are going to reverse or iterate all the menus in PIA, we will properly meet the problems. There are some records in PSPRSMDEFN, which have the same Portal_objname and Portal_prntobjname. And your query will come down. Therefore, I use a level control for the query, here it is:

create table t1 as select PORTAL_OBJNAME, PORTAL_LABEL, portal_uri_seg1 || ‘.’ || portal_uri_seg2 || ‘.’ || portal_uri_seg3 as ps_module
from PSPRSMDEFN where portal_name=’EMPLOYEE’ and length(trim(portal_uri_seg3))>0;

alter table t1 modify portal_label varchar2(500);

declare
varlable PSPRSMDEFN.portal_objname%type;
varprntlable PSPRSMDEFN.portal_prntobjname%type;
varll varchar2(50);
varchane varchar2(500);
varint int;

CURSOR mycur is
select portal_objname from t1;

begin
if mycur%isopen = false then
open mycur;
end if;
fetch mycur into varlable;
varint :=1;
varchane := ”;
varprntlable :=varlable;
while mycur%found
loop
while varprntlable’PORTAL_ROOT_OBJECT’ and varint’ || varchane;
varint := varint +1;
end loop;
select portal_label into varll from PSPRSMDEFN
where portal_name=’EMPLOYEE’ and portal_objname=varprntlable and rownum=1;
varchane := varll || ‘>’ || varchane;
update t1 set portal_label=varchane where portal_objname=varlable;
fetch mycur into varlable;
varint :=1;
varchane := ”;
varprntlable :=varlable;
end loop;

close mycur;

end;

select * from t1;