Peoplesoft Queries Solutions

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