Categories
Cloud

Using Terraform Cloud for Oracle Cloud Infrastructure

This is the hands-on examples i have created in GitHub – How to use Terraform Cloud.

https://github.com/oraclecloud/tfocilab

Categories
Cloud

Using Terraform Cloud for Azure

https://github.com/oraclecloud/tfazurelab

Categories
PeopleCode XML Publisher

Create a Report Using XML Publisher – PeopleSoft

To create a PS Query Based XML Publisher Report we have to do the below steps:

Create a PS Query:

Navigation : Reporting Tool > Query > Query Manager.

PS-Query1

 

 

 

 

 

 

 

 

 

PS-Query2

 

 

 

 

 

Create Data Source:

Navigation: Reporting Tools > XML Publisher > Data Source.

Choose Data Source type as PS-Query and choose Data Source ID from the prompt.

datasource_1

 

 

 

 

 

 

datasource_2

 

 

 

 

 

 

 

 

 

 

Generate XML and XSD files, and save the page.

Create RTF Template:

  • Download the XML file from the newly created data source.
  • Open Microsoft Word, go to Add-Ins > Data > Load XML Data.

word1

 

 

 

 

Go to Add-Ins > Insert > Table Wizard . Perform the below steps.

word2

 

 

 

 

 

 

word3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

word4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click Finish. Below is the template snap.

rtf_temp

 

 

 

 

Create Report Definition:

Navigation: Reporting Tools > XML Publisher > Report Definition. Perform the following steps.

rpt_defn1

 

 

 

 

 

 

 

 

rpt_defn2

 

 

 

 

 

 

rpt_defn3

 

 

 

 

 

 

 

Create Component, Page, Menu:

Create Page, Component, Menu and Register it from Online.

page1

 

 

 

 

 

 

comp1

 

 

 

menu

 

 

 

 

 

Write PeopleCode to Component Record field Field Change event.

pc

 

 

 

 

 

/*===================================
Description:
———————————————————-
Sample XML Publisher Report Where DataSource is a PS-Query.
=====================================*/

import PSXP_RPTDEFNMANAGER:*;

Local string &reportDefnId;
Local string &languageCode, &outputFormat, &templateName, &reportName;
Local date &AsOfDate;

&reportDefnId = “UD_XMLP_DMO1”;
&languageCode = “ENG”;
&outputFormat = “PDF”;
&reportName = “UD_XMLP_DMO1”;
&templateName = “UD_XMLP_DMO1_1”;
&AsOfDate = %Date;

/* Initializing Report Def class Object */
Local PSXP_RPTDEFNMANAGER:ReportDefn &rptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&reportDefnId);
&rptDefn.Get();
&rptDefn.ProcessReport(&templateName, &languageCode, &AsOfDate, &outputFormat);
CommitWork();
&rptDefn.DisplayOutput();

Run The Report:

r1

 

 

 

 

 

 

R2

 

 

 

 

 

 

R3

 

 

 

 

 

 

 

 

 

Thanks

Milan Bhattacharjee

Categories
Integration Broker PeopleTools

PeopleSoft Integration Broker

This blog post we will look every aspect of PeopleSoft Integration Broker

PeopleSoft Integration Broker 8.53
Guide to PeopleSoft Integration Broker 8.53

This Article Contains 6 Part

  1. Part 1 – Before Integration Broker Setup Modify the Application Server Configuration , Enable Pub / Sub Server ( This One )
  2. Part 2 – Fresh PIA Deploy via Command Line With Authentication Token Domain Options ( PeopleSoft Integration Broker Part – 2 )
  3. Part 2.1 – PIA Redeploy for Authentication Token Domain ( PeopleSoft Integration Broker Part – 2.1 )
  4. Part 3 – Integration Broker Setup through PeopleSoft Portal ( PeopleSoft Integration Broker Part – 3 )
  5. Part 4 – Third party software SoapUI Setup for Microsoft Windows ( PeopleSoft Integration Broker Part – 4 )
  6. Part 5 – Inbound Component Interface Based Web Services – Using PeopleSoft Message Catalog Component.( PeopleSoft Integration Broker Part – 5 )
  7. Part 5.1 – Inbound Component Interface Based Web Services – Using Using Delivered Component Interface. ( PeopleSoft Integration Broker Part – 5.1 )
  8. Part 6 – Consuming third Party Web service into PeopleSoft Systems. ( PeopleSoft Integration Broker Part 6 )

So Lets go.

Before Installing Integration Broker I have shown How to use Static IP address on Loopback Adapter. As below screen shoots show if you have DHCP ( Dynamic Host / IP Address ) then you should follow the below step.In Most i am using internet dongle like, MTS , Vodafone this service provider always give you dynamic ip address , it may create problems on application server bootup.
If you are using Static IP then skip the Loopback adapter Installation & Configuration  steps.

 

 

 

 

 

 

Host File Setup for static IP

Ping test check.

 

Now Application Server Modification for Integration Broker Setup

 

 

 

 

 

 

 

 

 

 

 

 

 

This Article Contains 6 Part

  1. Part 1 – Before Integration Broker Setup Modify the Application Server Configuration , Enable Pub / Sub Server ( This One )
  2. Part 2 – Fresh PIA Deploy via Command Line With Authentication Token Domain Options ( PeopleSoft Integration Broker Part – 2 )
  3. Part 2.1 – PIA Redeploy for Authentication Token Domain ( PeopleSoft Integration Broker Part – 2.1 )
  4. Part 3 – Integration Broker Setup through PeopleSoft Portal ( PeopleSoft Integration Broker Part – 3 )
  5. Part 4 – Third party software SoapUI Setup for Microsoft Windows ( PeopleSoft Integration Broker Part – 4 )
  6. Part 5 – Inbound Component Interface Based Web Services – Using PeopleSoft Message Catalog Component.( PeopleSoft Integration Broker Part – 5 )
  7. Part 5.1 – Inbound Component Interface Based Web Services – Using Using Delivered Component Interface. ( PeopleSoft Integration Broker Part – 5.1 )
  8. Part 6 – Consuming third Party Web service into PeopleSoft Systems. ( PeopleSoft Integration Broker Part 6 )

Hope this helps 🙂

Categories
Integration Broker PeopleTools

PeopleSoft Integration Broker Part – 2.1

This section will discuss about

PIA Redeploy for Authentication Token Domain (Before IB Setup)

If you already have Web (PIA) Server but not Configured Authentication Token Domain then following step you can redeploy PIA & configured Authentication Token Domain.

So Lets Start.

This Article Contains 6 Part

  1. Part 1 – Before Integration Broker Setup Modify the Application Server Configuration , Enable Pub / Sub Server ( )
  2. Part 2 – Fresh PIA Deploy via Command Line With Authentication Token Domain Options ( PeopleSoft Integration Broker Part – 2 )
  3. Part 2.1 – PIA Redeploy for Authentication Token Domain ( This One )
  4. Part 3 – Integration Broker Setup through PeopleSoft Portal ( PeopleSoft Integration Broker Part – 3 )
  5. Part 4 – Third party software SoapUI Setup for Microsoft Windows ( PeopleSoft Integration Broker Part – 4 )
  6. Part 5 – Inbound Component Interface Based Web Services – Using PeopleSoft Message Catalog Component.( PeopleSoft Integration Broker Part – 5 )
  7. Part 5.1 – Inbound Component Interface Based Web Services – Using Using Delivered Component Interface. ( PeopleSoft Integration Broker Part – 5.1 )
  8. Part 6 – Consuming third Party Web service into PeopleSoft Systems. ( PeopleSoft Integration Broker Part 6 )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This Article Contains 6 Part

  1. Part 1 – Before Integration Broker Setup Modify the Application Server Configuration , Enable Pub / Sub Server ( )
  2. Part 2 – Fresh PIA Deploy via Command Line With Authentication Token Domain Options ( PeopleSoft Integration Broker Part – 2 )
  3. Part 2.1 – PIA Redeploy for Authentication Token Domain ( This One )
  4. Part 3 – Integration Broker Setup through PeopleSoft Portal ( PeopleSoft Integration Broker Part – 3 )
  5. Part 4 – Third party software SoapUI Setup for Microsoft Windows ( PeopleSoft Integration Broker Part – 4 )
  6. Part 5 – Inbound Component Interface Based Web Services – Using PeopleSoft Message Catalog Component.( PeopleSoft Integration Broker Part – 5 )
  7. Part 5.1 – Inbound Component Interface Based Web Services – Using Using Delivered Component Interface. ( PeopleSoft Integration Broker Part – 5.1 )
  8. Part 6 – Consuming third Party Web service into PeopleSoft Systems. ( PeopleSoft Integration Broker Part 6 )