Third-party integration in PeopleSoft

-
Third-party integration in PeopleSoft refers to the process of connecting PeopleSoft applications (like HR, Finance, or Supply Chain) with external systems or services, such as payroll vendors, banks, tax authorities, or custom web applications. PeopleSoft offers several built-in tools and technologies to facilitate this kind of integration, depending on the use case, data format, and real-time vs batch requirements. Here’s a breakdown of how third-party integration typically works in PeopleSoft: 🔧 Common Integration Methods 1. Integration Broker (IB) Purpose: Real-time or near real-time integrations using messages and services. Technologies Used: SOAP, REST, HTTP, XML, JSON. Components: Service operations (define messages and routing) Nodes (represent external systems) Queues (manage message delivery) Example: Sending employee data to a benefits provider in real time. 2. Component Interfaces (CI) Purpose: Provide programmatic access to PeopleSoft...
Post a Comment

Peoplecode to print a BI Publisher report on the click of a push button

-
Here, I am sharing peoplecode which is to be used for printing report using a push button from the page. All you need to do is to give the following constraints like-
&MyReportName="Name from Report Definition in PIA"
&MyTemplate="Template name from Report definition/template tab" 

 e.g., REPORT_NAME_1

and query prompts to filter the data in the report-

 &rcdQryPrompts
e.g.,&rcdQryPrompts.PO_DT.Value = PO_HDR.PO_DT.Value;


---------------------------------------------------------------------------------------------------------------------

 import PSXP_RPTDEFNMANAGER:*;

 &LanguageCd = "ENG";
&AsOfDate = %Date;
&OutFormat = "PDF";
&MyReportName = "REPORT_NAME";
&MyTemplate = "REPORT_TEMPLATE_NAME";

 Local PSXP_RPTDEFNMANAGER:ReportDefn &oReportDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&MyReportName);

 &oReportDefn.Get();
Local Record &rcdQryPrompts, &RC1;

 &rcdQryPrompts = &oReportDefn.GetPSQueryPromptRecord();
If Not &rcdQryPrompts = Null Then
   
   &oReportDefn.SetPSQueryPromptRecord(&rcdQryPrompts);
   &rcdQryPrompts.FIELD_NAME.Value = RECORD_NAME.FIELD_NAME.Value;
   
End-If;
&oReportDefn.ProcessReport(&MyTemplate, &LanguageCd, &AsOfDate, &OutFormat);

 CommitWork();

&oReportDefn.DisplayOutput();

 -----------------------------------------------------------------------------------------------------------------------

Visit and comment for new updates- Thanks

Comments

  1. Unknown22 June 2016 at 08:41

    Thanx Shashank
    I got the prompt solution.
    Good work keep it up.

    ReplyDelete
  2. Unknown10 September 2016 at 00:12

    Great Blog...
    It helped a lot!

    ReplyDelete
  3. Unknown31 May 2018 at 12:49

    Thanks so much for this code. It works great!

    ReplyDelete
  4. Astiginlio-su-Columbia24 April 2022 at 11:41

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. Wpipueod_e26 August 2022 at 06:31

    This comment has been removed by a blog administrator.

    ReplyDelete
  6. UmofiPrec-go30 November 2022 at 23:48

    UmofiPrec-go Tonya Brown Click
    click
    seturedro

    ReplyDelete

Post a Comment

Popular posts from this blog

PeopleSoft Meta Tables

-
Application Engine Meta Data PSAEAPPLDEFN AE header record; 1 row per app engine PSAEAPPLSTATE AE state records (shows which one is the default) PSAEAPPLTEMPTBL AE temp tables assigned PSAESECTDEFN AE sections: public or private PSAESECTDTLDEFN AE section: descriptions, market, DB Type, EFFDT, EFF_STATUS, and auto commit PSAESTEPDEFN AE steps within section: description, market, DB Type, EFFDT, EFF_STATUS PSAESTMTDEFN AE actions within AE step: Step type (SQL, Do Select, etc.) with SQLID. PSAESTEPMSGDEFN AE message (parameters in each step) AEREQUESTPARM AE request parameters table behind the AE run control page. Find All Records Referenced in App Engine 1. Find the Temp Records (TAO) that are used: SELECT RECNAME FROM PSAEAPPLTEMPTBL WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME' 2. If there are records, find the number of instances: SELECT TEMPTBLINSTANCES FROM PSAEAPPLDEFN WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME...
Read more

Peoplesoft Application Package, Application Class and Application Method Implementation

-
Application Classes in PeopleSoft Defining and Importing packages or classes in PeopleCode <Pacakge name>:<Subpacakge name>:<…>:<Class name or wild card> Class Extensions represents the “is-a” relationship.   When a class extends another class, it’s called a subclass of that class. No Multiple inheritances or Concept of interface in Application classes. Instance variables in the class are accessible in all the objects of that class. Application programs generally pass parameters by value, which is not the same as for existing functions. Parameter passing with object data types is by reference. When the objects are passed to method and it reassign the object with new object it will not reflected in the calling method. Application Programs use the out specifier to pass a parameter by reference. Method increment (&Value as number out); rem passed by reference.   Create is the key word used to create the class object.  ...
Read more

Peoplesoft Application Package - Application Class/Application Package peoplecode and Calling them anywhere

-
Peoplesoft Application Package - Define Application Class and Calling Application class and Application Class Method from any Peoplecode event:  Step 1: Create New Application Package - MYPACKAGE Step2: Add a new application class in it. - MyClass Step 3: Defining Class and methods inside (Public or Private) 1. We can define classes here 2. We can define methods here 3. We can define Class Property Code to write inside a class to define class and its method: class MyClass method MyMethod (&smyInput as String, &nmyInput as Number) returns string; private method MyPrivateMethod (&sInput as String) returns boolean; property string &sVar; property number &nVar; end-class; method MyMethod /*+Method Body+*/ returns &sVar; end-method; method MyPrivateMethod  /*+Method Body+*/ returns &bVar; end-method; Code to write call a class and run its method: import MYPACKAGE:MyClass; Local string &sGetMethodData; Local MYPACKAGE:MyClass &oClassObjectVar...
Read more