Standard Request Submission

Standard Request Submission

Standard Request Submission

• Provides standard interface for running and monitoring reports.
• Single form to submit any request, concurrent program. Another form to see report's progress and to review report online.
• Submit Request form: easy-to-use interface.
• Automatic Resubmission.
• Request Sets: define sets of reports, Submit an entire set at same time.
• Request Set options: Run order, printer, no. of copies etc.
• Request Set Log File:Single log file containing the completion status of all reports in set.
• Viewing Requests: Monitor report's progress using View Request form.

• Child Request: or a sub-request submitted by any other concurrent request(Parent Request)

• Parameter: A value you specify when you run a request.

* A request set is parent request and all reports in set are child requests
Value Set: A set of values against which AOL validates values, the ned user enters when running a concurrent program.

Controlling Access to Reports:

• Create related group of reports and request sets.
• Define responsibility and assign a report security group to that responsibility.

Request Sets:

• A collection of reports/programs that are grouped together. Allow to submit reports or programs in a request set all at once using a single transaction.
• Request set can be defined to submit requests depending on the completion status of previously submitted requests in the set.

Stage:

• Component of a request set used to group requests within a set. All requests in a stage are executed in parallel. Request set executes one stage at a time., following links from stage to stage.
• Links that are followed depend on the completion status of the individual stages. A stage completes when all the requests contained in the stage have completed.
• PL/SQL functions calculate the completion status of a stage
• Three status of a stage:

1. Success
2. Warning
3. Error

Stage Evaluation function:

• Provided by AOL, computes the stage completion status from the completion statuses of the specified requests in set.
• Function returns a

1. Success: If all requests completed with a status of "Success".
2. Warning: If one or more requests in set completed with warning and no request completed with error.
3. Error: If any request in set completed with error.