skip to main | skip to sidebar

PeopleSoft Helper

Reference codes used in PeopleSoft Projects

Saturday, May 24, 2014

Script to ask email ids in PeopleSoft FSCM financials module, to be used in test regions

UPDATE PSOPRDEFN SET EMAILID='a@a.a'

UPDATE PSUSEREMAIL SET EMAILID='a@a.a'

UPDATE PS_ROLEXLATOPR SET EMAILID='a@a.a'

UPDATE  PS_SAC_EMC_PND_HDR SET SENT_TO='a@a.a'

UPDATE  PS_VENDOR_ADDR SET EMAILID='a@a.a'

UPDATE PS_VENDOR_CNTCT SET EMAILID='a@a.a'

TRUNCATE TABLE PS_PO_EMAIL_QUEUE
Posted by Arvin at 8:48 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Aravind's Blogs

  • ▼  2014 (12)
    • ▼  May (12)
      • Script for updating the vendor short name sequence...
      • Tree denoralization script for PeopleSoft trees --...
      • SQL to list out the records and fields in a People...
      • Multibyte characters related to peoplesoft in orac...
      • Oracle long running operations /sql in the database
      • Script to list out long running operations or sq...
      • Oracle PL/SQL script for reading a Long data colum...
      • PeopleSoft IB message transaction table names, /*...
      • Script to ask email ids in PeopleSoft FSCM financi...
      • Query to identify a table size in Oracle SELECT s...
      • -->provides navigation path of a componentSELECT a...
      • --provides PIA navigation path of a Component/fold...
  • ►  2013 (9)
    • ►  April (6)
    • ►  March (1)
    • ►  February (2)
  • ►  2012 (7)
    • ►  May (1)
    • ►  March (6)
  • ►  2011 (5)
    • ►  August (3)
    • ►  July (2)
  • ►  2008 (1)
    • ►  June (1)