Peoplesoft Queries Solutions

Integrating PeopleSoft applications using JSON Integrating PeopleSoft applications using JSON involves leveraging PeopleSoft Integration Broker's capabilities to handle JSON-formatted data, facilitating seamless communication with external systems through RESTful web services.  Key Steps for JSON Integration:- Document Object Creation: Utilize the Document Builder to define the structure of your JSON data. This involves creating a document object that maps to the desired JSON schema, ensuring proper alignment between PeopleSoft and external data formats.  Message Definition: Create messages based on the document object. Navigate to PeopleTools > Integration Broker > Integration Setup > Messages and define new messages of type 'Document'. Ensure that the message structure aligns with the JSON data you intend to process. Service and Service Operation Configuration:   Define a REST service and associate service operations corresponding to the HTTP methods (e.g., G...

Converting User Filenames If a user attaches a file through the browser dialog box generated by the AddAttachment function, the filename may be converted before that filename is returned to the AddAttachment call for storage. For example, the file My Resume.doc is returned through the AddAttachment parameter as My_Resume.doc, with the space changed to an underscore. No comparable mapping occurs for user filenames with the PutAttachment function, which requires the user filename as an input parameter rather than an output parameter that is returned to the user. Instead, before storing the ATTACHUSERFILE value, you should invoke code similar to this: &ATTACHUSERFILE = Substitute(&ATTACHUSERFILE, " ", "_"); &ATTACHUSERFILE = Substitute(&ATTACHUSERFILE, ";", "_"); &ATTACHUSERFILE = Substitute(&ATTACHUSERFILE, "+", "_");

If your data is hierarchical in nature, or based on existing PeopleSoft records or pages, you want to use a File Layout definition for reading and writing your data, rather than doing it line by line (or field by field.) For example, suppose you wanted to write all the information from a record to a file. You can use the WriteRecord method to write all the data from the record, instead of having to loop through every field, find the value, and write it to the file. In addition, you could write all the information from a transaction (or several transactions) from a page to a file. Each transaction can be considered a  rowset . A rowset can contain more than one record and is generally composed in a hierarchical structure. You could create a File Layout definition that has the same structure as the page (or component), and use the WriteRowset method. If you have a file that contains data in the correct format, you can use the ReadRowset method to read the data from the file to the pa...

A. The Basic Version The ‘MessageBox’ function is such a handy piece of code for troubleshooting that you often find yourself using the ‘basic version’ without giving much thought to how the statement really works: MessageBox(0, "", 0, 0, "Display message here"); This post will take a closer look at some of the additional features of ‘MessageBox’, beyond its basic usage above. In particular, we consider each of the parameters in more detail. B. Parameter 1: Message Type The first parameter specifies the type of message you wish to display. In most cases, the parameter is set to a value of ‘0’, which displays a message with an ‘OK’ button only. However, the function comes with a number of other options for setting the message type. These can be entered as either a numeric value (‘0’) or a constant (‘%MsgStyle_OK’): 0 – %MsgStyle_OK 1 – %MsgStyle_OKCancel 2 – %MsgStyle_AbortRetryIgnore 3 – %MsgStyle_YesNoCancel 4 – %MsgStyle_YesNo 5 – %MsgStyle_RetryCancel This means ...

Best PeopleCode Examples | PeopleCode Hacks | Learn PeopleSoft Coding | How to PeopleCode | PeopleSoft Appdesigner Coding Creating MSExcel with new sheets through peoplecode: Local object &oWorkApp, &oWorkBook; &sFilePath = "C:\temp\TEST_FL.xlsx"; &sFileDestPath = "C:\temp\Test.xlsx"; &oWorkApp = CreateObject("COM", "Excel.Application"); &oWorkApp.DisplayAlerts = "False"; ObjectSetProperty(&oWorkApp, "Visible", True); &oWorkBook = ObjectGetProperty(&oWorkApp, "Workbooks"); &oWorkBook.Open(&sFilePath); &oWorkSheet = &oWorkApp.Worksheets("Sheet1"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkApp.WorkSheets.Add().Name = "Test"; &oWorkSheet = &oWorkApp.Worksheets("Test"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkSheet.Cells(1, 1).Value = "I'm a...

PeopleSoft : Phone Number Validation Using Regular Expressions in Peoplecode Local String &str = "\+{0,1}[0-9\s\-\(\)]+" ; Local JavaObject &oPhoneNumExpression = CreateJavaObject("java.lang.String", ); Local JavaObject &oPhoneNum = CreateJavaObject("java.lang.String", Record.Field.Value );   If &oPhoneNum.matches(&oPhoneNumExpression) = False Then  MessageBox(0, "", 0, 0, "Enter valid phone number"); End-If;  Regular Expression "\+{0,1}[0-9\s\-\(\)]+"    : It allows a number + in starting and - in the middle of the number. Record.Field.Value : Contains the entered phone number value. Keep Learning, Keep sharing. Thank you for visiting by blog, If you like it please share and check out more content.

List of Tables in PeopleSoft Financials Below are the list of tables used in PeopleSoft Financial modules 1. Accounts Payable PS_VOUCHER PS_VOUCHER_LINE PS_DISTRIB_LINE PS_PYMNT_VCHR_XREF PS_PAYMENT_TBL PS_VCHR_ACCTG_LINE PS_PYMNT_ADVICE PS_VCHR_PPAY_XREF 2. Asset Management PS_INTFC_FIN PS_INTFC_PHY_A PS_ASSET PS_BOOK PS_COST PS_DEPRECIATION PS_BOOK_HIST PS_DIST_LN PS_ASSET_ACQ_DETAIL PS_ASSET_LOCATION PS_OPEN_TRANS PS_DEPR_RPT PS_ASSET_NBV_TBL PS_RETIREMENT 3. General Ledger PS_JRNL_LN PS_JRNL_HEADER PS_LEDGER 4. Purchase Order PS_PO_HDR PS_PO_LINE PS_PO_LINE_DISTRIB PS_PO_LINE_SHIP 5.Purchase Order Staging Tables: PS_PO_HDR_STG PS_PO_ITM_STG PS_PO_DISTRIB_STG 6. Receipts PS_RECV_HDR PS_RECV_LN_SHIP PS_RECV_LN_ACCTG 7. Vendors PS_VENDOR PS_VENDOR_ADDR PS_VENDOR_LOC PS_VENDOR_PAY PS_VENDOR_INVOICE PS_VENDOR_CNTCT PS_VNDR_BANK_ACCT PS_VNDR_IBANK_ACCT PS_VNDR_WTHD_JUR 8. Accounts Rec...

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.  ...

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...

PeopleSoft Integration Broker Tables | IB Tables | PeopleSoft IB Meta Tables — Message Nodes PSMSGNODEDEFN; PSNODEDEFNLANG; PSCONNECTSTRING; PSNODEURITEXT; PSNODECONPROP; PSNODCONPRPLANG; PSNODELOCKDOWN; PSNODEPROP; PSNODEPROPLANG; PSNODESDOWN; PSTRUSTNODES; — Message Channels PSCHNLDEFN; PSCHNLDEFNLANG; PSCHNLNODE; PSSUBCHNL; — Message Definitions PSMSGATTR; PSMSGDEFN; PSMSGDEFNLANG; PSMSGFLDOVR; PSMSGPARTS; PSMSGREC; PSMSGVER; — App Messaging PSAPMSGARCHPC; PSAPMSGARCHPD; PSAPMSGARCHPH; PSAPMSGARCHSC; PSAPMSGARCHTMP; PSAPMSGPUBATTR; PSAPMSGPUBCERR; PSAPMSGPUBCERRP; PSAPMSGPUBCLOCK; PSAPMSGPUBCON; PSAPMSGPUBCSYNC; PSAPMSGPUBDATA; PSAPMSGPUBERR; PSAPMSGPUBERRP; PSAPMSGPUBHDR; PSAPMSGPUBINST; PSAPMSGPUBLOCK; PSAPMSGPUBSYNC; PSAPMSGSUBCERR; PSAPMSGSUBCERRP; PSAPMSGSUBCLOCK; PSAPMSGSUBCON; PSAPMSGSUBCSYNC; PSAPMSGSUBPRCID; PSAPMSGXTB; — Services PSSERVICE; PSSERVICELANG; PSSERVICEO...