1 Reply Latest reply: Apr 22, 2012 8:45 PM by 849992 RSS

    PeopleSoft Version Table

    804179
      Hi,

      Can anyone provide me the datbase table which shows the version of PeopleSoft that is installed? Similiar to v$instance for the database.

      Seems easy but I am new to PS.

      Thanks
        • 1. Re: PeopleSoft Version Table
          849992
          Hi ,

          I always use the below sql to check what the update exists in our system. You can check the most recent update id and see which MP or bundle exist.

          SELECT * FROM PS_MAINTENANCE_LOG WHERE DTTM_IMPORTED IS NOT NULL ORDER BY PS_MAINTENANCE_LOG.DTTM_IMPORTED DESC

          Dennis