To run the Workflow Resource Generator:
For the standalone version of Oracle Workflow:
1. The Workflow Resource Generator program is located in the bin subdirectory of the Oracle Workflow directory structure.
2. Run the program from your operating system prompt as follows:
- To generate a binary resource file from a source file (.msg), type:
wfresgen [-v] -f <resourcefile> <source_file>
Replace <resourcefile> with the full path and name of the resource file you want to generate, and <source_file> with the full path and name of your source file. The optional -v flag causes the program to validate the source file against the binary resource file.
- To upload seed data from a source file (.msg) to the database table WF_RESOURCES, type:
wfresgen [-v] -d <username/password@database>
<source_file>
Replace <username/password@database> with the username, password and SQL*Net connect string or alias to your database and <source_file> with the full path and name of the source file you want to upload. The optional -v flag causes the program to validate the source file against the database.
For Oracle Workflow embedded in Oracle Applications:
2. To run the concurrent program from the Submit Requests form, navigate to the Submit Requests form.
Note: Your system administrator needs to add this concurrent program to a request security group for the responsibility that you want to run this program from. See: Overview of Concurrent Programs and Requests
3. Submit the Workflow Resource Generator concurrent program as a request. See: Submitting a Request.
4. In the Parameters window, enter values for the following parameters:
Destination Type
| Specify "Database", to upload seed data to the database table WF_RESOURCES from a source file (.msg), or "File", to generate a resource file from a source file.
|
Destination
| If you specify "File" for Destination Type, then enter the full path and name of the resource file you wish to generate. If you specify "Database" for Destination Type, then the program automatically uses the current database account as its destination.
|
Source
| Specify the full path and name of your source file.
|
5. Choose OK to close the Parameters window.
6. When you finish modifying the print and run options for this request, choose Submit to submit the request.
7. Rather than use the Submit Requests form, you can also run the Workflow Resource Generator concurrent program from the command line using one of two commands. To generate a resource file from a source file, type:
WFRESGEN apps/pwd 0 Y FILE res_file source_file
To upload seed data to the database table WF_RESOURCES from a source file, type:
WFRESGEN apps/pwd 0 Y DATABASE source_file
Replace apps/pwd with the username and password to the APPS schema, replace res_file with the file specification of a resource file, and replace source_file with the file specification of a source file (.msg). A file specification is specified as:
@<application_short_name>:[<dir>/.../]file.ext
or
<native path>