Loading ...
Sorry, an error occurred while loading the content.

Re: Software Inventory of Installed PeopleSoft Applications

Expand Messages
  • James Blanding
    PS_INSTALLATION is the big one...
    Message 1 of 8 , Jan 31, 2008
    • 0 Attachment
      PS_INSTALLATION is the big one...

      --- In psftdba@yahoogroups.com, "rkothari22" <rkothari22@...> wrote:
      >
      > Is there a table(s) in the PeopleSoft database that can queried to
      > determine what Applications (ie, HR, FCSM, Campus, etc) are
      > installed/implemented within a particular PeopleSoft domain?
      >
    • Manoj Kumar
      PSRELEASE & PS_INSTALLTION ... From: rkothari22 To: psftdba@yahoogroups.com Sent: Friday, 1 February, 2008 2:13:43 AM Subject:
      Message 2 of 8 , Feb 2, 2008
      • 0 Attachment
        PSRELEASE & PS_INSTALLTION

        ----- Original Message ----
        From: rkothari22 <rkothari22@...>
        To: psftdba@yahoogroups.com
        Sent: Friday, 1 February, 2008 2:13:43 AM
        Subject: PeopleSoft DBA Forum Software Inventory of Installed PeopleSoft Applications

        Is there a table(s) in the PeopleSoft database that can queried to
        determine what Applications (ie, HR, FCSM, Campus, etc) are
        installed/implement ed within a particular PeopleSoft domain?




        Save all your chat conversations. Find them online.
      • Bhimsingh Wadhwa
        We are trying to use Application Message (EOP_PUBLISHF) to import data to PS_TL_RPTD_ELPTIME in Peopletools 8.48.13 We re using the ELAPSED_TIME channel and
        Message 3 of 8 , Feb 4, 2008
        • 0 Attachment
          We are trying to use Application Message
          (EOP_PUBLISHF) to import data to
          PS_TL_RPTD_ELPTIME in Peopletools 8.48.13 We're using
          the ELAPSED_TIME channel and the ELAPSED_TIME_ADD
          message. It stops in the Subscribe Contract stage; all
          messages are status "New" and There is no "error"
          status messages.



          ____________________________________________________________________________________
          Looking for last minute shopping deals?
          Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
        • saravanan g
          Hi, Kindly check the following things 1.Make sure that your PUB/SUB servers are up 2.Check whether channel(Ie Queue in PT 8.48) is in Run status 3.If PUB/SUB
          Message 4 of 8 , Feb 5, 2008
          • 0 Attachment
            Hi,
            Kindly check the following things
             
            1.Make sure that your PUB/SUB servers are up
            2.Check whether channel(Ie Queue in PT 8.48) is in 'Run' status
            3.If PUB/SUB is already up, then restart PUB/SUB and again try.
             
            Thanks,
            Saravanan.
             

            Bhimsingh Wadhwa <ph55856@...> wrote:
            We are trying to use Application Message
            (EOP_PUBLISHF) to import data to
            PS_TL_RPTD_ELPTIME in Peopletools 8.48.13 We're using
            the ELAPSED_TIME channel and the ELAPSED_TIME_ ADD
            message. It stops in the Subscribe Contract stage; all
            messages are status "New" and There is no "error"
            status messages.

            ____________ _________ _________ _________ _________ _________ _
            Looking for last minute shopping deals?
            Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping


            Chat on a cool, new interface. No download required. Click here.

          • Bhimsingh Wadhwa
            We are looking into option to partition HR tables for performance and archiving reasons. If anybody has used partition in HRMS peoplesoft , I will be
            Message 5 of 8 , Feb 6, 2008
            • 0 Attachment
              We are looking into option to partition HR tables for
              performance and archiving reasons.
              If anybody has used partition in HRMS peoplesoft , I
              will be interested to know partitioning scheme( which
              tables partition on which columns and if any
              additional indexes were created). Please share if any
              negative impacts/ concerns on this objective.
              We are using PT 8.48 and Application Release HRMS
              8.80.01.000

              Thanks,
              Bhimsingh.



              ____________________________________________________________________________________
              Looking for last minute shopping deals?
              Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
            • Montgomerie, Steve (SSL US)
              We partition the following in HR 8 SP1. We are in the process of upgrading to HCMP 8.9 so I ll let you know how that goes -). We did it to speed up calcs which
              Message 6 of 8 , Feb 8, 2008
              • 0 Attachment
                We partition the following in HR 8 SP1. We are in the process of
                upgrading to HCMP 8.9 so I'll let you know how that goes -).

                We did it to speed up calcs which it did by at least 60%. I believe they
                were all partitioned by years execept for pay check which was partioned
                by quarter (every 3 months).

                I'd be happy to send you the ddl if you like.

                SQL> select distinct table_name from DBA_TAB_PARTITIONS where
                table_owner='SYSADM';

                TABLE_NAME
                ------------------------------
                PS_DEDUCTION_BAL
                PS_EARNINGS_BAL
                PS_PAY_CHECK
                PS_PAY_EARNINGS


                Steve Montgomerie
                PeopleSoft/Oracle Administrator


                No great thing is created suddenly. -Epictetus (A.D.200)
              • Bhimsingh Wadhwa
                Steve Montgomerie, Thank you very much. Can you send me DDL for these tables. This will be good starting pont for me. Thanks, Bhimsingh, Bay Area Rapid
                Message 7 of 8 , Feb 10, 2008
                • 0 Attachment
                  Steve Montgomerie,
                  Thank you very much. Can you send me DDL for these
                  tables. This will be good starting pont for me.

                  Thanks,
                  Bhimsingh,
                  Bay Area Rapid Transit, SFO.
                  --- "Montgomerie, Steve (SSL US)"
                  <steve.montgomerie@...> wrote:

                  > We partition the following in HR 8 SP1. We are in
                  > the process of
                  > upgrading to HCMP 8.9 so I'll let you know how that
                  > goes -).
                  >
                  > We did it to speed up calcs which it did by at least
                  > 60%. I believe they
                  > were all partitioned by years execept for pay check
                  > which was partioned
                  > by quarter (every 3 months).
                  >
                  > I'd be happy to send you the ddl if you like.
                  >
                  > SQL> select distinct table_name from
                  > DBA_TAB_PARTITIONS where
                  > table_owner='SYSADM';
                  >
                  > TABLE_NAME
                  > ------------------------------
                  > PS_DEDUCTION_BAL
                  > PS_EARNINGS_BAL
                  > PS_PAY_CHECK
                  > PS_PAY_EARNINGS
                  >
                  >
                  > Steve Montgomerie
                  > PeopleSoft/Oracle Administrator
                  >
                  >
                  > No great thing is created suddenly. -Epictetus
                  > (A.D.200)
                  >



                  ____________________________________________________________________________________
                  Looking for last minute shopping deals?
                  Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
                Your message has been successfully submitted and would be delivered to recipients shortly.