PeopleSoft FSCM

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

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