Data Groups Window
Use this window to define data groups. A data group is a list of Oracle Applications and the ORACLE usernames assigned to each application.
- If a custom application is developed with Oracle Application Object Library, it may be assigned an ORACLE username, registered with Oracle Applications, and included in a data group.
An ORACLE username allows access to an application's tables in an ORACLE database. All data groups automatically include an entry for Application Object Library.
- A concurrent manager running reports or programs under Oracle Applications refers to a data group to identify the ORACLE username it uses to access an application's tables in the database.
- Transaction managers running synchrous programs can only run programs submitted from responsibilities assigned the same data group as the transaction manager. If you create custom data groups, you should create new transaction managers for the applications that use transaction managers. Consult your product documenation to determine if your application uses transaction managers.
Each responsibility within Oracle Applications is assigned a data group.
During installation or upgrading of Oracle Applications, a standard data group is defined, pairing each installed application with an ORACLE username (note: a standard data group is defined for each set of books). You cannot change or delete the predefined values for Application or ORACLE username in a Standard data group. However, you may:
- Modify the Tool ORACLE username and description associated with an Application-ORACLE username pair.
- Add new Application-ORACLE username pairs to the group.
Data Groups Block
Create a new data group, or modify an existing data group.
You cannot change or delete the predefined values for Application or ORACLE username in a Standard data group. However, you may modify the Tool ORACLE username and description, or add new Application-ORACLE username pairs to a Standard group.
Data Group
A data group is uniquely identified by its name. You cannot create a data group with a name already in use.
Once saved, data group names cannot be edited.
Application-ORACLE Username Pairs Block
Pair applications with ORACLE usernames.
When you copy a data group, each application, its assigned ORACLE username, and, if present, its Tool ORACLE username and description, appear in this zone automatically. All data groups automatically include an entry for Application Object Library.
Application
Within each data group, an application can be listed only one time.
Oracle User Name
Tool
A Tool ORACLE username can be added to each application-ORACLE username pair within a data group. A Tool ORACLE username identifies an ORACLE account that users can automatically connect to when using an Oracle Tool, for example, SQL*Plus. Users select the Oracle Tools window from the standard Oracle Applications menu.
Attention: The Oracle Tools window may not be available on your desktop platform. The Oracle Tools window is primary for the character mode environment.
When a responsibility is defined, a data group is chosen, and an application within the data group is selected for the responsibility's forms to connect to.
- When a Tool ORACLE username is associated with that application, users of an Oracle Tool can connect to that ORACLE account without entering a username and password.
- If a Tool ORACLE username is not associated with that application, then users of an Oracle Tool must enter a username and password to obtain access to an ORACLE account.
Attention: You cannot select a Tool ORACLE username to associate with Application Object Library. The Application Object Library-ORACLE username pair is inserted into each data group, and cannot be updated or deleted.
Suggestion: You should assign a Tool ORACLE username that is restricted (read-only).
Warning: Modifying data or table structures using an Oracle Tool, for example, SQL*Plus, may damage your data's integrity and is not supported by Oracle.
Copy Applications From...
Use this button to copy an existing data group, then add or delete application-ORACLE username pairs to create a new data group.
See Also
Overview of Concurrent Programs and Requests
Defining Data Groups
Using Data Groups
Modifying Data Groups
