PeopleSoft Posting issues

 

Please find the SQL for bulk reposting content.

 

BEGIN

FOR x in  (

       SELECT prcsinstance

       FROM   psprcsrqst

       WHERE  diststatus = 4 -- Those are not posted

       AND    runstatus in (9,10,17)  -- 9 successful processes,17 FOR WARNING,10 FOR NO SUCCESS

       )

LOOP

UPDATE PSPRCSRQST

SET    DISTSTATUS = '7'

WHERE  PRCSINSTANCE = x.prcsinstance;

 

UPDATE PSPRCSQUE

SET    DISTSTATUS = '7'

WHERE  PRCSINSTANCE = x.prcsinstance;

 

UPDATE PS_CDM_LIST

SET    DISTSTATUS   = '8'

,      TRANSFERINSTANCE = 0

WHERE  PRCSINSTANCE = x.prcsinstance

AND    DISTSTATUS   <> '5'; --posted

END LOOP;

END;

/

COMMIT

/