Skip to main content

PSFT FSCM Define User Preference Tables

            Let us look in to underlying base tables for User Preference page. Understanding the base tables will come handy when we migrate user setup from one instance to different instance. Also when we need to setup test users for any load or performance testing. Below is the list of few important tables:

Overall Preference: PS_OPR_DEF_TBL_FS

OLE Information: PS_OPR_DEF_TBL_OLE

Process Group:  PS_RTM_OPR_SOURCE; PS_RTM_OPR_GROUP 

Asset Management: PS_OPR_DEF_TBL_AM

IT Asset Management: PS_OPR_DEF_TBL_IT

Billing: PS_OPR_DEF_TBL_BI

Contracts: PS_OPR_DEF_TBL_CA

Contract Status Authorization: PS_CA_OPRID_CASTAT 

General Ledger: PS_OPR_DEF_TBL_FS

Journal Entry Options:  PS_OPR_DEF_TBL_GL

Inventory:  PS_OPR_DEF_TBL_IN

Procurement: PS_OPR_DEF_TBL_PM

Payables Online Vouchering:  PS_OPR_DEF_TBL_AP

Requisition Authorizations: PS_OPR_PO_RQSTR

PO Authorizations -  Buyer User Authorization: PS_OPR_PO_BUYER

Supplier Processing Authority:  PS_OPR_DEF_TBL_VND

Document Tolerance Authorization:  PS_OPR_DEF_TBL_PM 

Supplier Onboarding: PS_OPR_DEF_TBL_OB;  PS_OPR_DEF_TBL_OBT

Project Costing: PS_OPR_DEF_TBL_PC

Receivables Data Entry: PS_OPR_DEF_TBL_AR

 


Labels:

Comments

Post a Comment

Popular posts from this blog

Making PS Query into Tile in PeopleSoft

MAKING A QUERY INTO A TILE Refer to Oracle documentation for creating  PeopleSoft fluid tile using PS query. Link:  Link to "Query to Tile" Documentation   Since many of you not able to access the document, I have listed the ontent of the document below for making a query into a tile.   1.      1. Create Query (or reuse an available query)   Pillar(HCM, FSCM, ELM, etc) > Reporting Tools > Query > Query Manager       The above query is just a list of employees and their health benefit plans.   Very simple query, but I wanted it to be simple to show how easy the process is to create a tile from a query.   2.  Create Pivot Grid (or reuse an available pivot grid) Pillar > Reporting Tools > Pivot Grid > Pivot Grid Wizard   Enter the name and the Title of the Pivot Grid. Grid Types: Private models are only available to the users who created the model and the users who have ...
Post a Comment
Read more

PeopleSoft Asset Management Tables

Below is the list of main tables being used in PeopleSoft Asset Management PS_ASSET PS_BOOK PS_COST PS_DEPRECIATION PS_DIST_LN PS_OPEN_TRANS PS_ASSET_ACQ_DETAILS PS_RETIREMENT When new asset has been created then it inserts asset details into PS_ASSET, PS_BOOK,PS_ASSET_ACQ_DETAILS & PS_OPEN_TRANS tables. If the asset has cost then there will be entry in PS_COST table. Once asset has been added, we need to run Depreciation calculation process. System will calculate the depreciation based on details in book and cost details, depreciation entries will be inserted into PS_DEPRECIATION table. Create Accounting entries or closure process will insert accounting entries into PS_DIST_LN table. In case if an asset is retired then an entry will be inserted into PS_RETIREMENT table. Apart from these base tables, there are two main reporting tables being used across AM reports. PS_DEPR_RPT  - This table holds cost and depreciation details break down to individual acc...
3 comments
Read more

PeopleSoft Test Framework - Execution tracking

Let us say we need to get all the PTF test scripts and needs to find out which has been and what is the status, instead of going over each and every script (or) asking each tester for the status, better way is to get it from the database. Using PeopleSoft meta table  to get those details will reduce the test leads effort in consolidate the execution status. Below SQL, which I have prepared will get the last execution status for a test script. This query consider only main test scripts, let us say if there is a shell test script A, which calls two other test script. Below SQL will consider only the main shell script test case only, because as part of testing a requirement, one test script will be used. Also to avoid duplicate count. SELECT a.PTTST_PARENTFOLDER, a.PTTST_NAME, a.DESCR,a.PTTST_TYPE, a.PTTST_USE_ERROR,  a.LASTUPDDTTM, b.pttst_log_id, b.PTTST_LOG_CAPTION, b.pttst_log_result, case b.pttst_log_result  when 100 then 'None' when 110 then 'Pass' whe...
Post a Comment
Read more