«

»

Feb 24

Print this Post

Process Definition

When a process definition has been created, there are three main tables where it makes an entry and store definition of the . Those are:

PS_PRCSDEFN — The main page where you start creating “Process Definition”.
PS_PRCSDEFNPNL — “Process Definition Options” page where you define components, process group, recurrence etc…
PS_PRCSDEFNGRP — “Process Definition Options” page where you define components, process group, recurrence etc…

Apart from that, there are some more tables which get affects depends on options you have choosen while creating a process definition. Below are the same with description…

PS_PRCSDEFNCNTDIST — If you have specified “Output Destination Options” for some process, enteries goes to this table.
PS_PRCSDEFNXFER — If you have specified “Page Transfer Information” for some process, enteries goes to this table.
PS_PRCSDEFNNOTIFY — If you have specified ” Notifications” for some process, enteries goes to this table.
PS_PRCSDEFNMETA — If you have specified some value in “OS390 Option”, enteries goes to this table.
PS_PRCSDEFNMESSAGE — If you have specified some value for message from page “Schedule Message Information”, enteries goes to this table.

So there are two query sets here to delete any process definition…

First case in which you just have created a wrong process definition:

DELETE FROM PS_PRCSDEFN where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNPNL where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNGRP where PRCSNAME = ‘process name’

Second case in which you have created a wrong process definition with the options like Output destination, Page transfer etc…:

DELETE FROM PS_PRCSDEFN where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNPNL where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNGRP where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNCNTDIST where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNXFER where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNNOTIFY where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNMETA where PRCSNAME = ‘process name’
DELETE FROM PS_PRCSDEFNMESSAGE where PRCSNAME = ‘process name’

Its good to run second query set to eliminate any chances for any reference of Process Definition. Hope this will help sometime…

Permanent link to this article: http://alokbhardwaj.com/oracle-peoplesoft/2009/02/24/process-definition/

1 comment

  1. rakesh.parwal

    nice info shared. Thnx

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>