Using an Alternative Database User

As an alternative to the standard APPS user, Tidal Automation supports the use of a custom database user to access Oracle EBS. This user's security profile would be limited to the minimal set of objects required to perform Concurrent Manager scheduling functions. This database account should be granted privileges to access the objects below. Tidal Automation can provide assistance in assigning the correct permissions.

Packages

• dbms_obfuscation_toolkit

• fnd_amp_private.

• fnd_application_pkg.

• fnd_global

• fnd_message

• Fnd_profile

• fnd_request

• fnd_submit

• fnd_web_sec.

• fnd_webfile

• Htp

• Utl raw

Forms and Associated Libraries

• FNDRSRUN

• FNDRSRUN

• FNDSCSGN

Sequences

• fnd application s

Tables and Views

• fnd_application

• fnd_application_tl

• Fnd_application_vl

• fnd_conc_request_arguments

• fnd_concurrent_processes

• fnd_concurrent_programs

• FND_CONCURRENT_PROGRAMS_TL

• fnd_concurrent_programs_vl

• FND_CONCURRENT_REQUESTS

• fnd descr flex col usage vl

• fnd_descr_flex_column_usages

• fnd_languages_vl

• fnd_menu_entries_vl

Tables and Views

• fnd_menus_vl

• FND_PRINTER

• FND_PRINTER_INFORMATION

• fnd_printer_styles

• fnd_product_groups

• fnd_product_installations

• fnd_profile_option_values

• fnd_profile_options

• fnd_req_set_run_form_v

• fnd_request_group_units

• fnd_request_set_programs

• fnd_request_set_stages

• fnd_request_sets

• fnd_request_sets_tl

• fnd_request_sets_vl

• fnd_resp_functions

• FND_RESPONSIBILITY_TL

• fnd_responsibility_vl

• FND_USER

• fnd_user_resp_groups

• wf_roles