FSCM functional Interview questions

PeopleSoft functional Interview questions :

Accounts Payables:

1) What are the Important tables in AP and Vendors ?

Vouchers
Voucher Header	PS_VOUCHER
Voucher Line	PS_VOUCHER_LINE
Voucher line distribution	PS_DISTRIB_LINE
Payment Voucher cross reference	PS_PYMNT_VCHR_XREF
Voucher Posting	PS_VCHR_ACCTG_LINE
Payment	PS_PAYMENT_TBL
Paycycle Manager
Quick Invoice tables Summary Invoice tables	VCHR_HDR_QV VCHR_LINE_QV VCHR_DIST_QV VCHR_PYMT_QV VCHR_MSCH_QV
Vendors
Vendor Header table	PS_VENDOR
Vendor address and phone numbers:	PS_VNDR_ADDR_SCROL PS_VENDOR_ADDR PS_VENDOR_ADDR_PHN
Vendor Contacts and phone numbers:	PS_VNDR_CNTCT_SCR PS_VENDOR_CNTCT        PS_VENDOR_CNTCT_PHN
Vendor location:	PS_VENDOR_LOC
Vendor Payment:	PS_VENDOR_PAY

2) AP data flow 

1. Vouche enty into Payables system 

2. Voucher Maintenance
3. Voucher matching
4. Voucher Posting
5. Payment processing

6. Payment Posting.

3) What is the difference between Quick Invoice entry and Regular Invoice entry and Summary Invoice entry ?

        Quick Invoice entry : (Component VCHR_QUICK_PNL)

• When we use Quick invoice entry component for invoice load , The data will be stored into the following QV   tables

1. PS_VCHR_HDR_QV                
2. PS_VCHR_LINE_QV 
3. PS_VCHR_DIST_QV
4. PS_VCHR_PYMT_QV 
5. PS_VCHR_MSCH_QV

•  We need to run the voucher build process (AP_VCHRBLD) to bring the data from QV tables to main Voucher  tables . 
• This component has less fields when compared to Regular  invoice entry component and most of the values will be defaulted from set up's 
• Quick Invoice entry will also have an option to copy the Voucher information directly from PO , Based on Quick Invoice template options. If the value is Complete it enables PO selection options directly in the component 

                           

       Summary Invoice entry: (Component - VCHR_SUMM_PNL)

• Summary Invoice entry component allows us to enter data completely based on Invoice and PO . This component does not allow to enter Invoice line information.
• Data will be stored in QV tables instead Voucher main tables , Needs to run Voucher build process for populating main Voucher tables 

        Regular Invoice entry:   (Component - VCHR_EXPRESS)

• When we use Regular invoice entry component data will be stored directly into Voucher master tables and no need to run voucher build process. 

4) What is Pay-cycle manager ?

Paycycle manager is a delivered utility which can be used to select eligible vouchers and apply payment against them.

5) What are the different ways to bring invoice data into payable s system ?

• We can use Regular entry component for manual data load
• We can use Summary Invoice / Quick invoice components by populating QV , STG tables and run voucher build program to load data into AP main tables.
• Create custom interfaces that loads data directly into voucher tables. 

6) What are the different ways to bring Vendor information into PeopleSoft payables systems ?

 1)  Vendors can be entered through online by using following navigation  

• Main menu - Vendors - Vendor Information - Add/Update - Vendor 
  
  
     2) Using VNDR_IMPORT application engine 
  
  
  VNDR_IMPORT is having some of the limitations and can be used only within the following situations 
  
  
  -> VNDR_IMPORT process takes the information from flat files, so we need to create so many flat files matching the record structures that we want to populate. This process internally uses File Layouts for data insertion ,  If we are getting all the Vendor data in a single file and wants to use this process then we needs to extract the data into different files by developing an another custom program before getting started.
  
  
  -> This program does not do any business validations except field edit validations (prompt table edit/no edit). Needs to apply all the validations prior using this AE.
  
  
  -> Before getting started with this program , We need to do data mapping and store each file with record name . Suppose we are generating a file for Vendor record we need to store the file in App Server as Vendor.txt 
  
  
   - > Run Vendor detail listing report , Vendor summary listing report to validate the data
  
  
     3)  Using Delivered Component Interface (VNDR_ID_EXCEL) which is created on the top of VNDR_ID component. Loading data through this CI is common as any other data load by using AE+CI combination.
  
  
     4) By using IB messaging
  We can leverage delivered IB messages, Web services to subscribe and publish data between PeopleSoft modules and third party systems. Delivered messages are
  
  
  
  

  Message Name	Function
  VENDOR_SYNC	Incremental publish and subscribe.
  VENDOR_FULLSYNC	Full-table publishes and subscribe.
  VENDOR_SYNC_EFF	Incremental publish of current effective-dated data.
  VENDOR_FULLSYNC_EFF	Full-table publish of current effective-dated data.