Previous | Next | Contents | Index | Navigation | Glossary | Library |
If one user submits a large number of concurrent requests on a daily basis, for example, an Oracle Bill of Materials or Oracle Purchasing supervisor, you can create a streamlined purge program that only purges that user's concurrent processing records.
You can run this program as System Administrator and have it automatically resubmitted on a specific time interval.
You could also create a request set containing this one program and define the user as the owner of the request set. Then, if you do not assign the request set to any report security group, only the user (owner) can run the program. This way, the user can be responsible for purging their own records.
The System Administrator's Purge Concurrent Request and/or Manager Data program contains twelve parameters. You can copy, rename, and modify the program so it displays only three parameters, with only one parameter requiring user entry. See: Purge Concurrent Request and/or Manager Data.
The table below summarizes the steps to follow in our example.
Example - Modifying a Program's Parameters
Form Used | Task |
---|---|
Concurrent Programs (Concurrent Programs Define) | Query the Application Object Library program named "Purge Concurrent Request and/or Manager Data" and press Copy. Select both Copy Arguments and Copy Incompatible Programs. |
Enter a new name for the program you are going to copy, for example, enter JSMITH PURGE. | |
Concurrent Programs | To modify the JSMITH PURGE program's parameters, select the Parameters button. |
Parameter Window | Modify the following seven parameters so they do not display (user JSMITH cannot see nor change the program's default values). - Oracle ID - Program Application - Program - Manager Application - Manager - Responsibility Application - Responsibility |
Modify the following three parameters so they do not display (user JSMITH cannot see nor change the default values you set). Set the parameters to the following (Type=Constant) defaults: - Entity = Request - Mode = Age - User Name = JSMITH | |
Leave the following two parameters unchanged so they display. Mode Value will require JSMITH to enter a value, and Report is set to a default value of "Yes". - Mode Value - Report | |
Request Set (Reports Set) | Create a request set with one program in it, the JSMITH PURGE program. Enter JSMITH in the Owner field. If this request set is not assigned to any report security group, only JSMITH will be able to run the JSMITH PURGE program. |
Standard Request Submission program form. For example, the Run Reports form (Reports Run) | When first submitting the JSMITH PURGE program to run, navigate to the Resubmission Options region and enter, for example, "5" and "Days" in the Interval field. |
Table 1 - 9. (Page 2 of 2) |
Control the Behavior of Request Parameters
Concurrent Program Details Report
Previous | Next | Contents | Index | Navigation | Glossary | Library |