Recent Forum Posts

From categories:
page »

You can use the following to get the "hour", in 24 hour format from a timestamp field in Oracle (as well as the minute and second):

  extract(hour from(localtimestamp)),
  extract(minute from(localtimestamp)),
  extract(second from(localtimestamp))
 from dual;
PrajPraj 27 Mar 2015 19:58
in discussion Forum / Help » Web Service Help

Sounds like you've hit the limit for the number of requests you can make to that web service - as suggested you need to register to use it more. This isn't related to PeopleSoft it is related to the site you are consuming the web service/WSDL from.

by PrajPraj, 27 Mar 2015 19:58
srajan (guest) 27 Mar 2015 10:42
in discussion Forum / Help » Web Service Help

I am getting below error when trying to load data from WSDL..
XigniteCurrencies: Maximum number of unregistered requests exceeded. Consider registering or subscribing to expand usage. Can anyone please confirm how do we resolve this

by srajan (guest), 27 Mar 2015 10:42

You can use the Char function to find and replace the line feed character (ASCII Code 10) with an appropriate HTML equivalent such as a break or <br/> tag. Here's an example of how to do it with Substitute:

&formatted_html = Substitute(&input_data, char(10), '<br/>');

Where &input_data might be the data from the database (e.g. in a DESCRLONG field) and &formatted_html will replace all line feeds with the <br/> tag and therefore render line breaks in your output HTML.

Display line feeds in HTML by PrajPraj, 26 Mar 2015 11:04
Bob (guest) 25 Mar 2015 22:26
in discussion Forum / Help » Problems in consuming a peoplesoft webservice

Do you have a more detailed error message or lot. SOAP versions might be important e.g. v1.1 vs v1.2 for compatibility.

by Bob (guest), 25 Mar 2015 22:26

I observe there is a difference in the way we test or consume webservices exposed by Peoplesoft. Through SOAPUI everything works fine. But when i try to use an ESB and send the same webservice request i end up with a lot of errors like "ExternalOperationName is a required field".

Could you please let me know how do i proceed with this. I have seen a lot of forums asking this question but none have been able to provide suitable answers.

Problems in consuming a peoplesoft webservice by Suns_Rays (guest), 25 Mar 2015 14:48

Two types of 1099 income example Royalties and nonconpensation. Royalties $12, Non Comp $150. Only $12 printing on form.

Our tax professional says that once one item becomes reportable all items become reportable. So the normal $600 cap on non-compensation would not apply because the Royalties are reportable and the $150 should be reported to IRS.

I could not find a delivered solution for this exception. Is there one? Has anyone used a work around?

1099 multiple reporting Items (boxes) by Hector (guest), 24 Mar 2015 15:34

I'm looking to find any names changed within the last 365 days but am having an issue with defining the expression.

Expression 1 Type = Field
Expression 1 = A.EFFDT

Condition Type = between

Epression 2 Type = Const - Expr
Expression 2 Constant = Current Date
Expression 2 = ???

PeopleSoft 9.2 Search Framework
Marvin (guest) 04 Mar 2015 17:06
in discussion Forum / Help » PeopleSoft 9.2 Search Framework

I am trying to unmap a component from its Search Definition. The final result is to keep the Keyword Search Page from showing for the component. I have read what I could find on PeopleBooks and performed the steps below:

1. Select PeopleTools, Search Framework, Designer, Search Definition, and open
the desired search definition.

2. Select the Component Mapping tab.

3. Delete the desired component from the grid.

4. Cleared Cache

However, the Keyword Search page is still showing. Is there any other step that needs to be take deactivate the Keyword Search Page for a particular component?

PeopleSoft 9.2 Search Framework by Marvin (guest), 04 Mar 2015 17:06
Satish (guest) 04 Mar 2015 09:51
in discussion Forum / Help » Writing a Date expression in PS Query

How to use Curent_Date - 1 in PS Query.
Please Help.

by Satish (guest), 04 Mar 2015 09:51
drubek (guest) 02 Mar 2015 22:17
in discussion Forum / Help » PSPBARUN finalization process failing in vs 8.9

This is COBOL, not app engine.

by drubek (guest), 02 Mar 2015 22:17

greetings for the day

we are happy to inform you all that we are providing peoplesoft fscm online training classes

the below is the course content we fallow:
PeopleSoft Financials
Course Content
Introduction to PeopleSoft 9.1 - Duaration = 4 days
• Navigating PeopleSoft Applications
• Signing into PeopleSoft Applications
• Identifying PeopleSoft Internet Application (PIA) components
• Identifying Shortcut Keys
• Personalizing Content and Layout
• Adding Favorites
• Retrieving Data
• Using PeopleBooks
• Understanding System Structure
• Explaining the PeopleSoft Internet Architecture
• Discussing the Structure of PeopleSoft Tables and Relational Databases
• Illustrating Effective Dating Defining Business Units and Set IDs
• Identifying Types of PeopleSoft Tables
• Describing Business Units
• Explaining the Relationships of Business Units and Set IDs
• Using PeopleSoft Process Scheduler and Reporting Tools
• Describing PeopleSoft Process Scheduler
• Using the Process Monitor
• Identifying Reporting Tools
• Running Reports
• Performing Queries
• Submitting Reports Using PS/nVision
• Utilizing ChartFields
• Explaining ChartFields
• Identifying Delivered ChartFields
• Configuring ChartFields
General Ledger 9.1 -
Duaration = 10 days
• Creating the General Ledger Structure
• Basic Elements of PeopleSoft General Ledger
• Implementation Steps for PeopleSoft General Ledger
• PeopleSoft General Ledger Table Structure
• Establishing General Ledger Business Units
• Applying General Ledger Tableset Sharing
• Setting Installation Options and Common Definitions
• Setting Up Installation Options
• Establishing User Preferences
• Establishing Account Types Creating Detail Calendars
• Defining Business Calendars
• Defining ChartFields and ChartField Values
• Planning and Creating PeopleSoft Trees
• Defining the Significance of PeopleSoft Trees
• Defining Tree Manager Terminology
• Creating PeopleSoft Trees
• Modifying Trees Using Tree Manager
• Preparing for Journal Processing
• Defining Ledger Templates
• Defining Ledgers and Ledger Groups
• Associating Ledgers with a Business Unit
• Maintaining Accounting Periods
• Defining Journal Entry Templates
• Defining Journal Sources, Classes and Speed Types
• Implementing ChartField Combination Editing
• Defining ChartField Combination Edits
• Link Combination Edits to Business Units
• Building the Combination Edit Data Tables
• Maintaining Combination Edits
• Inquiring on Combination Edit Data
• Describing the Journal Process Flow
• Processing PeopleSoft General Ledger Data
• Reviewing Journals and Determining their Status
• Editing and Posting Journals
• Maximizing PeopleSoft General Ledger Processing
• Automating Journals Selecting a Statistical Method
• Setting Up Suspense Error Handling
• Analyzing Financial Information
• Processing General Ledger Data Importing Spreadsheet Journals
• Preparing the Workbook for Journal Upload
• Configuring the Spreadsheet
• Creating the Workbook
• Importing Spreadsheet Journals
• Performing Year End Close
• Defining PeopleSoft Year End Close
• Defining ChartField Value Sets
• Defining Closing Rules
• Processing PeopleSoft Year End Close
• Running the Closing Trial Balance Report
• Describing the Archiving Process
• Implementing Interunit and Intraunit Accounting
• Selecting an Appropriate Interunit Approach
• Defining Interunit and Intraunit Transactions
• Performing Required Interunit and Intraunit Setup
• Reconciling Interunit Activity
• Unposting Interunit Journals
• Reporting Results with PS/nVision
• Defining the PS/nVision Elements
• Creating PS/nVision Layouts
• Running PS/nVision Reports
• Implementing Documenting Sequencing for General Ledger Defining Document Sequencing
• Preparing for Document Sequencing
• Processing Document Sequencing

Purchasing 9.1 —- Duaration = 8 days

• Business Process Overview
o Understanding the PeopleSoft Purchasing Business Process Flow and Functionality
o Understanding the Integration Points between PeopleSoft Purchasing and other PeopleSoft Applications
o Understanding the Default Hierarchy
o Finding Information About PeopleSoft Purchasing in Peoplebooks
• Establishing Business Units and Processing Options
o Defining Installation Parameters
o Creating PeopleSoft Purchasing Business Units
o Creating PeopleSoft Purchasing Processing Options
• Setting Up Required Table Information
o Creating Locations
o Adding Ship To Locations
o Setting Up User Preferences
o Setting Up Requesters
o Setting Up Buyers
• Determining Vendor Basics
o Configuring the Vendor Set Control Page
o Searching for a Vendor
o Adding a New Vendor
• Setting Up Purchasing Items
o Creating Item Categories
o Creating Purchasing Items
o Copying and Loading Items
o Approving Items
o Creating Units of Measure
o Setting Up a Purchasing Kit
• Creating Requisitions
o Explaining the Requisition Business Process Flow
o Describing Requisitions
o Creating Requisitions Online
o Managing the Requisition Reconciliation Workbench
o Describing the Process to Load Requisitions from other PeopleSoft Applications
• Sourcing Requisitions and Creating Purchase Orders
o Describing Sourcing
o Sourcing Requisitions Online
o Sourcing Requisitions by Using the Auto-select Requisitions Process
o Building Inventory Demand
o Using the Sourcing Workbench Component
o Identifying Sourcing Methods
o Configuring the PO Calculations Process
o Configuring the Create PO Process
• Managing Purchase Orders
o Explaining the Purchase Order Business Process and Structure
o Creating and Updating Purchase Orders
o Creating a Purchase Order by Copying from Another Document
o Using the Purchase Order Reconciliation Workbench
o Evaluating Options to Dispatch Purchase Orders
• Demonstrating Receiving
o Describing the Receiving Business Process
o Identifying Receiving Setup Information
o Defining Receipt Statuses
o Creating a Receipt with a Purchase Order
o Creating a Receipt Without a Purchase Order
o Describing How Purchasing Receipts Interface with Other PeopleSoft Applications
• Demonstrating the Change Order and Delete Functionality
o Describing the Change Order Template
o Creating Change Orders for Purchase Orders
o Viewing Purchase Order Change Order History
o Deleting a Purchase Order
o Distinguishing Between Purchase Order Cancellations and Deletions
o Describing the Change Order Request Process
o Describing Requisition Change Order Tracking
o Describing Requisition Deletion
• Configuring Additional Procurement Options
o Describing Distribution Networks
o Setting Up Miscellaneous Charges/Landed Cost Templates
o Combining Miscellaneous Charges with Items on Purchase Orders
o Describing Procurement Cards
• Setting Up Sales and Use Tax
• Maintaining Price Adjustments
o Setting Up Vendor Price Adjustment Rules
o Setting Up Purchase Order Schedule Price Adjustments
• Creating and Using Purchasing Contracts
o Defining Contract Set Controls
o Explaining Master Contracts
o Creating Purchasing Contracts
o Generating Contract Purchase Orders
o Explaining Blanket Purchase Orders
• Using Commitment Control in PeopleSoft Purchasing
o Enabling Commitment Control in PeopleSoft Purchasing
o Demonstrating Document Tolerance Checking
o Demonstrating the Budget Checking Process
Account Payables 9.1 —- Duaration = 6 days
• Defining Core Tables
• Setting Installation Options
• Utilizing TableSets
• Establishing User Preferences
• Creating Locations
• Identifying Currency Options
• Defining ChartFields
• Creating Accounting Entry Templates
• Setting Up Sales and Use Tax Options
• Setting Up Payables Business Units
• Identifying General Ledger Business Units
• Viewing Commitment Control Options
• Creating a Payables Definition
• Modifying Payables Options
• Defining Banks
• Identifying Common Banking Terms
• Identifying the Basic Steps of Bank Setup
• Defining Banks
• Setting up Bank Branches
• Defining External Accounts
• Setting up Payment Data
• Entering Payment Terms Setting up Additional Payment Data
• Adding Vendors
• Explaining Vendors
• Establishing Vendor Information
• Adding Vendors
• Explaining Vendor Conversations
• Deactivating Vendors
• Entering Miscellaneous Data
• Enabling Entry Events
• Defining Landed Costs
• Processing Vouchers
• Identifying Voucher Basics
• Identifying Voucher Types
• Manually Uploading Vouchers
• Creating Quick Invoice Entries
• Closing, Unposting and Deleting Vouchers
• Updating Open Items
• Correcting Voucher Errors
• Approving Vouchers
• Utilizing Control Groups
• Creating Control Groups
• Deleting a Control Group
• Running the Control Group Register
• Creating Voucher Contracts
• Describing Voucher Contracts
• Establishing Contract Set Controls Defining Voucher Contracts
• Closing Voucher Contracts
• Processing Batch Vouchers
• Creating a Pay Cycle
• Identifying Payment Creation Steps
• Running the Pay Cycle
• Viewing Payment References
• Creating a Manual Positive Payment
• Managing Trouble Shooting
• Posting Payments
• Matching
• Explaining Matching
• Entering Match Rules and Tolerances
• Creating Debit Memos
• Viewing Matching Reports
• Creating and Managing Payments
• Using Express Checks
• Creating Manual Payments
• Canceling Payments
• Processing Escheated Payments
• Processing Rescheduled Payments
• Creating Drafts
• Running Batch Processes
• Running Journal Generator
• Viewing Open Liabilities Running Inquiries and Reports
• Viewing PeopleSoft Payables Inquiries
• Viewing Payables Metrics
• Running Payables Reports

Receivables 9.1 - Duaration = 6 days
• Describe PeopleSoft Enterprise Receivables 8.9
• Implementing Receivables
• Integrating with Other PeopleSoft Enterprise Products
• Establishing PeopleSoft Receivables Business Units
• Establishing a PeopleSoft Receivables Business Unit
• Defining SetIDs
• Using Record Groups
• Defining Receivables Tables
• Establishing Installation Options and User Preferences
• Setting up Core Credit and Collection Options
• Setting up Action Owners and Audit History
• Setting Up Payment Terms
• Establishing Reference Qualifier Codes
• Setting Up Detail Calendars
• Setting Up Receivables Options
• Setting Up Customers
• Entering and Maintaining Customer Information
• Modifying Customer Credit Profiles
• Establishing Customer Contacts Defining Item Processing Tables
• Setting Up Origin IDs
• Setting Up Distribution Codes
• Identifying System Functions
• Identifying Entry Types and Entry Reasons
• Establishing Item Entry Types
• Entering Items
• Entering Items Online
• Receiving External Pending Items
• Performing the Receivable Update Process
• Managing Item and Customer Inquiries and Maintenance
• Reviewing Item Information
• Updating Item Details
• Using Conversations
• Researching Customer Accounts
• Defining Payment Processing
• Setting Up Deposit Types
• Defining Bank Account Information
• Establishing Automatic Entry System Functions
• Entering Payments
• Entering Regular Deposits
• Entering Express Deposits
• Processing Cash Drawer Receipts
• Receiving Electronic Payments
• Correcting Errors in Deposits
• Journaling Payments Directly Managing Payment Worksheets
• Building Payment Worksheets
• Applying Payments Across Business Units
• Analyzing Overpayments
• Applying Underpayments
• Inquiring on Payments Set to Post
• Applying Payments to Items Using Multiple Currencies
• Running the Journal Generator Process
• Performing Payment Inquiries
• Using Payment Predictor
• Constructing Payment Predictor Methods
• Using the Payment Predictor Process
• Analyzing Payment Predictor Reports
• Managing Item Maintenance
• Using Maintenance Worksheets
• Unposting a Payment
• Using Transfer Worksheets
• Using the Automatic Maintenance Process
• Setting Up Automatic Maintenance
• Aging Receivables
• Defining History Elements
• Setting Up Aging Control Tables
• Creating History Inquiries and Aging Requests
• Generate Aging Reports Setting Up Exception and Collection Processing
• Describing Exception and Collection Processing
• Setting Up Actions and Action Templates
• Setting Up Collection and Assessment Rules
• Using Credit, Collections, and Exceptions
• Working with Actions
• Obtaining D&B Information
• Generating Statements
• Reviewing Customer and Item Information
• Explaining the Correspondence Process
• Creating Statements
Expenses 9.1 -
Duaration = 5 days
• Defining General Options
• Defining Installation Options for Expenses
• Setting Up Expenses Options
• Setting Up Expenses Business Units
• Defining DCAA Requirements (USA)
• Identifying Common Data and Global Features
• Setting up Security and Approvals
• Setting Up Expense Users and Permission Lists
• Defining Approval and Audit Rules
• Defining Approval Options
• Setting Up Expenses Structure
• Defining Business Rules for Expenses Setting Up Expense Management Functions
• Setting Up Locations and Rates
• Creating Expense Templates
• Setting Up Employee Data
• Loading Employee Data
• Maintaining Employee Profiles
• Processing Travel Authorizations
• Creating Travel Authorization Templates
• Creating Travel Authorizations
• Processing Expense Transactions
• Modifying User Defaults
• Processing Cash Advances
• Preparing Cash Advances
• Creating Time Reports
• Approving Expense Transactions
• Describing Summary Approval Options
• Performing Approvals and Audits
• Modifying Approved Transactions
• Processing Payments
• Describing the Expenses Payment Process
• Staging Payments for Processing
• Processing Payments in PeopleSoft Payables
• Sending Payments to Payroll
• Reviewing Payments
• Integrating with PeopleSoft Project Costing Processing Project-related Expense Transactions
• Sending Transactions to Project Costing
• Integrating with PeopleSoft General Ledger
• Posting Liabilities and Payments
• Examining Accounting Entries
• Establishing Links with the General Ledger
• Using the Journal Generator
• Rolling Over Travel Authorization Encumbrances
• Managing Expense Transaction Exceptions
• Canceling Expense Payments in Payables
• Unposting Expense Reports
• Modifying and Closing Cash Advances and Expense Reports
• Creating Accounting Adjustments for Expense Reports
• Reconciling Cash Advances
• Processing External Data
• Describing External Expense Data
• Reconciling Airline Tickets
• Processing Imported Credit Card Data
• Using Automated Teller Machine Data
• Using Benchmark Data
• Examining and Archiving Expense Information
• Running Expenses Queries
• Running Reports
• Archiving Expense Transactions
Asset Management 9.1 - Duaration = 7 days
• Business Process Overview
• Defining the Asset Lifecycle Management (ALM) Solution
• Describing the Asset Transaction Flow
• Describing Asset Management System Integration
• Describing the Implementation of Asset Management
• Describing the Conversion Process for Asset Management
• Navigating through Asset Management
• Defining General Options
• Setting Up Installation Options
• Defining User Preferences
• Defining Locations, Calendars and ChartField Values
• Setting Up Asset Management
• Creating Asset Books
• Creating Business Units
• Defining Open Periods
• Setting Up Value Added Tax (VAT) Defaults
• Adding Assets
• Describing the Methods for Adding Assets Online
• Describing the Tables Used for Asset Management
• Adding Assets Using Express Add
• Adding Assets Using Basic Add
• Identifying Hazardous Assets
• Managing Asset Insurance, Maintenance, Warranties and Repair
• Tracking Asset Insurance
• Defining and Tracking Asset Maintenance Tracking Asset Maintenance Contracts
• Creating and Applying Warranties
• Reviewing Maintenance History
• Maintaining Leased Assets
• Desribing Lease Types
• Defining Lease Payment Schedules
• Creating Leased Assets
• Defining Step Leases
• Generating Lease Reports
• Adjusting, Recategorizing and Transferring Assets
• Adjusting Asset Information
• Reviewing Asset Cost History
• Recategorizing Assets
• Transferring Assets Within and Between Business Units
• Summarizing Cost Rows
• Retiring and Reinstating Assets
• Retiring Assets Manually
• Retiring Fully Depreciated Assets Automatically
• Using the Disposal Worksheet to Retire Assets
• Describing Retirement Integration with Other PeopleSoft Applications
• Reinstating Assets
• Maintaining Parent and Child Assets
• Adding Parent and Child Assets
• Adjusting Parent and Child Assets
• Recategorizing Parent and Child Assets
• Performing Transfers of Parent and Child Assets
• Retiring of Parent and Child Assets Reviewing the Net Book Value of Parent-Child Assets
• Depreciating Assets
• Describing How Asset Management Calculates Depreciation
• Reviewing and Modifying Open Transactions
• Performing the Depreciation Calculation Process
• Recalculating Depreciation and Performing What-If Calculations
• Depreciating Assets – France
• Configuring and Depreciating Assets Using the Derogatory Method
• Creating Accounting Entries for Derogatory Depreciation
• Configuring and Reporting Business Tax
• Revaluing Assets
• Running Statutory Reports
• Depreciating Assets – India
• Describing Depreciation Processing for India
• Processing Tax Depreciation for India
• Depreciating Assets – Japan
• Using Special and Increased Depreciation Methods
• Using Advanced and Composite Depreciation
• Setting Up Currency Rounding Options
• Generating Local Tax Reports
• Calculating Consumption Tax When Selling Retired Assets
• Maintaining Asset Book Information
• Describing Asset Books and Required Information for Calculating Depreciation
• Describing Remaining Value and Life-to-Date Depreciation Methods
• Reviewing Changes Made to Asset Books Reporting and Charting Asset Information
• Describing Asset Management Reporting Options
• Generating Asset Management Reports
• Generating Asset Charts
• Generating Asset Accounting Entries
• Creating and Reviewing Accounting Entries
• Closing Depreciation
• Closing Asset Accounting Periods
• Listing Common Month-End Processes
• Allocating Depreciation Expense
• Describing Depreciation Allocation
• Defining Transaction Groups
• Creating Allocation Entries
• Integrating with PeopleSoft General Ledger
• Defining the General Ledger to Accept Journal Entries
• Defining the Link Between Asset Management and General Ledger
• Running the Journal Generator Process
• Integrating Asset Management with Other Products
• Integrating with PeopleSoft Purchasing and Payables
• Using On-Demand Processing
• Consolidating and Unitizing Assets
• Integrating with PeopleSoft Project Costing
• Planning for Capital Asset Acquisitions
• Describing Asset Budgeting and Capital Acquisition Planning
• Defining Capital Acquisition Plans (CAP) Link Assets to a CAP
• Review and Adjust CAP information
• Performing Mass Changes to Assets
• Defining and Running the Mass Change Process
• Reviewing the Results of Mass Change
• Running the Transaction Loader Process
• Final Course Activity
• Defining the Various Control Tables Required to Perform Transactions
• Calculating Depreciation on Open Transaction
• Creating Accounting Entries and Running Depreciation Close
• Running the Journal Generator Process
• Reviewing Results
Billing 9.1 -
Duaration = 5 days
• Overview of the Billing Process
• Entering a one line Bill (invoice)
• Doing a search for a customer in the master file
• Cancelling a Bill (invoice) in progress
• Accounting using chartfields
• Printing a proforma Bill (invoice)
• Printing a final Bill (invoice)
• Entering a multiple line Bill (invoice)
• Tax handling - using tax codes
• Generating a courtesy copy
• Using Revenue Distribution codes for accounting
• Review of proforma and final Bills

contact :
Email id : moc.liamg|snoitulostimbI#moc.liamg|snoitulostimbI
website :
Phone no. : Usa:+1-845-915-8712
India : +91-9642373173 ,+91-9505533825
Skype id : provides the best Software’s training for various
Computer IT courses through Webex, Gotomeeting. Learners can grasp the
technology-subject from our highly experienced & certified trainers
which will be helping the students to work in real time projects.
Learners can choose either regular course or fast track classes or
weekend Training classes. It’s proud to be we are one of the top
leading online training provider from India. We are into this field
with passion and dedication we are in to online trainings from many
years. Our team of well experienced trainers with vast real time IT
experience in online trainings is dedicated towards providing quality
training. ibmitsolutions has taken great steps in providing best
quality Online Classes. We provide the training classes in INDIA,USA,
Provide Job support & Interview Support.

Email id : moc.liamg|snoitulostimbI#moc.liamg|snoitulostimbI
website :
Phone no. : Usa:+1-845-915-8712
India : +91-9642373173 ,+91-9505533825
Skype id :


Topics Sub topics
PeopleSoft Architecture introduction of ERP system
Application Designer
Create Fields,Translates values,Records
Properties and differeces between 7 types of records
Parent Child relationship
Create types of Pages and its usage
Create Components, Menus and register components
Record and Field Level Audits
Event execution flow and importance of events
Traversing and getting values form 0-level to 3rd level and variable declarations
and its usage
Understanding Objects and Classes in PeopleCode
PeopleSoft Built-in Functions and user defined functions
Error Validations and User Access for DEL/ADD rows and Message catalogs
Component and Data buffer classes
Application Engine
Advantages of Application Engine and structure
AE program elements properties and AE properties
State record and Temp tables advantages
Different types of actions and usage
Meta SQLs advatages in AE
Debugging and Tracing
Paralell processing
Topics Sub topics
Reporting Tools
Types of SQR reports and generate all type reports
Performance tuning using with Array and Load Lookup
Debugging SQR reports
Creation of SQCs and its advantages
Inbound and Outbound file interface
Generate standard reports
Integration Tools
File Layout inbound and Outbound
Data Conversion using Component Interface
Data Conversion using XL to CI utility
Data mover
Import and export data from one instance to another instance
PS Security
Understanding PeopleSoft Security
Create Roles and permission lists and assign roles to Users
Create User profiles
Role level security

AWE Basics**

jyothi (guest) 18 Feb 2015 13:38
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute


I am looking for peoplesoft finance training Fast track only,Please give details of class room Training. AP/PO/GL/Billing/AR/Asset Management

Thanks & Regard

by jyothi (guest), 18 Feb 2015 13:38

Just a general tip, perhaps you find it useful, perhaps not, but a good way to distinguish self-service users from regular users (e.g. staff vs students in Campus Solutions) might be to look at their OPRCLASS (primary permission list) in PSOPRDEFN?

Webservice Issue
Josh ReyJosh Rey 30 Jan 2015 20:54
in discussion Forum / Help » Webservice Issue

Hi guys,

I'm consuming a webservice in IBM Maximo from a webservice client in Peoplesoft, but when I send the request (SOAP xml) I retrieve a "OK" response from Maximo, but Maximo doesn't do anything. When I consume the same webservice from a client in Java or SOAPUI, I retrieve the same response "OK", but Maximo works well. I review the XML request message and this is formed correctly but I suspect maybe the Integration Broker sends the XML incomplete without <body> to Maximo, and Maximo just is returning an Echo. Somebody has had this kind of problem with some webservice or an incomplete XML request from Peoplesoft?


Josh Rey

Webservice Issue by Josh ReyJosh Rey, 30 Jan 2015 20:54

I searched the forum and didn't find anything under recycle or services. I want to use PowerShell to issue PS commands to stop and start services. But I also want to be able to verify/test that the service has successfully restarted. Also I'm looking for a way to test logging into PS from the command-line. I want to be able to mimic the manual process we are currently using.

Can anyone help?

Automate recycle of services by JonPQJonPQ, 28 Jan 2015 15:39
Local string &current_date = NumberToString("002", Day(%Date)) | "/" | NumberToString("002", Month(%Date)) | "/" | Year(%Date);
9.2 Query Manager
Thaman GuruThaman Guru 02 Jan 2015 19:48
in discussion Forum / General » 9.2 Query Manager

I am building a new query in query manager, table has a emplid and a completion date field. I am wanting pull all emplid with criteria where completion date in today's date. How do I define this criteria in PS query?

Please assist.

9.2 Query Manager by Thaman GuruThaman Guru, 02 Jan 2015 19:48
page »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License