I had a requirement to submit a AutoInvoice Master(related to AR Invoice) program using fnd_request.submit_request via back-end in custom schema.
For this we need to involves granting the specific user permissions to run a concurrent request. And also need to create Public synonyms.
Firstly give grants and try to execute fnd_request.submit_request via backed, if not succeed then create public synonyms.
Must run the following Grants for custom schema in APPS, once all granting and creating a synonyms done then try to use "fnd_request.submit_request" via custom schema.
1) GRANTS
GRANT ALL ON fnd_user to CUSTOM_USER_NAME;
GRANT ALL ON fnd_core_log to CUSTOM_USER_NAME;
GRANT ALL ON fnd_client_info to CUSTOM_USER_NAME;
GRANT ALL ON hr_signon to CUSTOM_USER_NAME;
GRANT ALL ON jg_context to CUSTOM_USER_NAME;
GRANT ALL ON fnd_global to CUSTOM_USER_NAME;
GRANT ALL ON fnd_profile to CUSTOM_USER_NAME;
GRANT ALL ON fnd_message to CUSTOM_USER_NAME;
GRANT ALL ON app_exception to CUSTOM_USER_NAME;
GRANT ALL ON fnd_log to CUSTOM_USER_NAME;
GRANT ALL ON fnd_request to CUSTOM_USER_NAME;
GRANT ALL ON fnd_concurrent_programs_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_responsibility_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_log_repository to CUSTOM_USER_NAME;
GRANT ALL ON fnd_application_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_languages to CUSTOM_USER_NAME;
GRANT ALL ON fnd_application to CUSTOM_USER_NAME;
GRANT ALL ON fnd_lookup_types to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_groups to CUSTOM_USER_NAME;
GRANT ALL ON fnd_profile_options_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_new_messages to CUSTOM_USER_NAME;
GRANT ALL ON fnd_data_group_units to CUSTOM_USER_NAME;
GRANT ALL ON fnd_oracle_userid to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_groups to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_initialization to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_init_condition to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_init_dependency to CUSTOM_USER_NAME;
GRANT ALL ON fnd_product_installations to CUSTOM_USER_NAME;
GRANT ALL ON fnd_profile_options to CUSTOM_USER_NAME;
GRANT ALL ON fnd_profile_option_values to CUSTOM_USER_NAME;
GRANT ALL ON fnd_security_groups_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_user_resp_groups to CUSTOM_USER_NAME;
GRANT ALL ON icx_parameters to CUSTOM_USER_NAME;
GRANT ALL ON fnd_cache_versions to CUSTOM_USER_NAME;
GRANT ALL ON fnd_log_messages to CUSTOM_USER_NAME;
GRANT ALL ON fnd_printer to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_date to CUSTOM_USER_NAME;
GRANT ALL ON fnd_printer_styles to CUSTOM_USER_NAME;
GRANT ALL ON fnd_printer_information to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_release_classes_s to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_request_arguments to CUSTOM_USER_NAME;
GRANT ALL ON fnd_concurrent_requests_s to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_deferred_arguments to CUSTOM_USER_NAME;
GRANT ALL ON fnd_concurrent_programs to CUSTOM_USER_NAME;
GRANT ALL ON fnd_logins to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_release_classes to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_release_class_utils to CUSTOM_USER_NAME;
GRANT ALL ON fnd_concurrent_requests to CUSTOM_USER_NAME;
GRANT ALL ON fnd_print to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_pp_actions to CUSTOM_USER_NAME;
GRANT ALL ON fnd_data_groups to CUSTOM_USER_NAME;
GRANT ALL ON fnd_responsibility to CUSTOM_USER_NAME;
GRANT ALL ON fnd_logins_s to CUSTOM_USER_NAME;
GRANT ALL ON fndcp_crm to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_pp to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_release_classes_tl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_rt_request to CUSTOM_USER_NAME;
GRANT ALL ON fnd_request_set_programs to CUSTOM_USER_NAME;
GRANT ALL ON fnd_rt_requests to CUSTOM_USER_NAME;
GRANT ALL ON nls_session_parameters to CUSTOM_USER_NAME;
GRANT ALL ON fnd_dflex to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conflicts_domain to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conflicts_domain_s to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_pp_actions to CUSTOM_USER_NAME;
GRANT ALL ON fnd_application_tl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_executables to CUSTOM_USER_NAME;
GRANT ALL ON fnd_descriptive_flexs_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_descr_flex_contexts_vl to CUSTOM_USER_NAME;
GRANT ALL ON fnd_conc_global to CUSTOM_USER_NAME;
2) Create Synonyms:
CREATE PUBLIC SYNONYM fnd_user FOR fnd_user;
CREATE PUBLIC SYNONYM fnd_core_log FOR fnd_core_log;
CREATE PUBLIC SYNONYM fnd_client_info FOR fnd_client_info;
CREATE PUBLIC SYNONYM hr_signon FOR hr_signon;
CREATE PUBLIC SYNONYM jg_context FOR jg_context;
CREATE PUBLIC SYNONYM fnd_global FOR fnd_global;
CREATE PUBLIC SYNONYM fnd_profile FOR fnd_profile;
CREATE PUBLIC SYNONYM fnd_message FOR fnd_message;
CREATE PUBLIC SYNONYM app_exception FOR app_exception;
CREATE PUBLIC SYNONYM fnd_log FOR fnd_log;
CREATE PUBLIC SYNONYM fnd_request FOR fnd_request;
CREATE PUBLIC SYNONYM fnd_concurrent_programs_vl FOR fnd_concurrent_programs_vl;
CREATE PUBLIC SYNONYM fnd_responsibility_vl FOR fnd_responsibility_vl;
CREATE PUBLIC SYNONYM fnd_log_repository FOR fnd_log_repository;
CREATE PUBLIC SYNONYM fnd_application_vl FOR fnd_application_vl;
CREATE PUBLIC SYNONYM fnd_languages FOR fnd_languages;
CREATE PUBLIC SYNONYM fnd_application FOR fnd_application;
CREATE PUBLIC SYNONYM fnd_lookup_types FOR fnd_lookup_types;
CREATE PUBLIC SYNONYM fnd_product_groups FOR fnd_product_groups;
CREATE PUBLIC SYNONYM fnd_profile_options_vl FOR fnd_profile_options_vl;
CREATE PUBLIC SYNONYM fnd_new_messages FOR fnd_new_messages;
CREATE PUBLIC SYNONYM fnd_data_group_units FOR fnd_data_group_units;
CREATE PUBLIC SYNONYM fnd_oracle_userid FOR fnd_oracle_userid;
CREATE PUBLIC SYNONYM fnd_product_groups FOR fnd_product_groups;
CREATE PUBLIC SYNONYM fnd_product_initialization FOR fnd_product_initialization;
CREATE PUBLIC SYNONYM fnd_product_init_condition FOR fnd_product_init_condition;
CREATE PUBLIC SYNONYM fnd_product_init_dependency FOR fnd_product_init_dependency;
CREATE PUBLIC SYNONYM fnd_product_installations FOR fnd_product_installations;
CREATE PUBLIC SYNONYM fnd_profile_option_values FOR fnd_profile_option_values;
CREATE PUBLIC SYNONYM fnd_security_groups_vl FOR fnd_security_groups_vl;
CREATE PUBLIC SYNONYM fnd_profile_options FOR fnd_profile_options;
CREATE PUBLIC SYNONYM fnd_user_resp_groups FOR fnd_user_resp_groups;
CREATE PUBLIC SYNONYM icx_parameters FOR icx_parameters;
CREATE PUBLIC SYNONYM fnd_cache_versions FOR fnd_cache_versions;
CREATE PUBLIC SYNONYM fnd_log_messages FOR fnd_log_messages;
CREATE PUBLIC SYNONYM fnd_printer FOR fnd_printer;
CREATE PUBLIC SYNONYM fnd_conc_date FOR fnd_conc_date;
CREATE PUBLIC SYNONYM fnd_printer_styles FOR fnd_printer_styles;
CREATE PUBLIC SYNONYM fnd_printer_information FOR fnd_printer_information;
CREATE PUBLIC SYNONYM fnd_conc_release_classes_s FOR fnd_conc_release_classes_s;
CREATE PUBLIC SYNONYM fnd_conc_request_arguments FOR fnd_conc_request_arguments;
CREATE PUBLIC SYNONYM fnd_concurrent_requests_s FOR fnd_concurrent_requests_s;
CREATE PUBLIC SYNONYM fnd_conc_deferred_arguments FOR fnd_conc_deferred_arguments;
CREATE PUBLIC SYNONYM fnd_concurrent_programs FOR fnd_concurrent_programs;
CREATE PUBLIC SYNONYM fnd_logins FOR fnd_logins;
CREATE PUBLIC SYNONYM fnd_conc_release_classes FOR fnd_conc_release_classes;
CREATE PUBLIC SYNONYM fnd_conc_release_class_utils FOR fnd_conc_release_class_utils;
CREATE PUBLIC SYNONYM fnd_concurrent_requests FOR fnd_concurrent_requests;
CREATE PUBLIC SYNONYM fnd_print FOR fnd_print;
CREATE PUBLIC SYNONYM fnd_conc_pp_actions FOR fnd_conc_pp_actions;
CREATE PUBLIC SYNONYM fnd_data_groups FOR fnd_data_groups;
CREATE PUBLIC SYNONYM fnd_responsibility FOR fnd_responsibility;
CREATE PUBLIC SYNONYM fnd_logins_s FOR fnd_logins_s;
CREATE PUBLIC SYNONYM fndcp_crm FOR fndcp_crm;
CREATE PUBLIC SYNONYM fnd_conc_pp FOR fnd_conc_pp;
CREATE PUBLIC SYNONYM fnd_conc_release_classes_tl FOR fnd_conc_release_classes_tl;
CREATE PUBLIC SYNONYM fnd_rt_request FOR fnd_rt_request;
CREATE PUBLIC SYNONYM fnd_request_set_programs FOR fnd_request_set_programs;
CREATE PUBLIC SYNONYM fnd_rt_requests FOR fnd_rt_requests;
CREATE PUBLIC SYNONYM nls_session_parameters FOR nls_session_parameters;
CREATE PUBLIC SYNONYM fnd_dflex FOR fnd_dflex;
CREATE PUBLIC SYNONYM fnd_conflicts_domain FOR fnd_conflicts_domain;
CREATE PUBLIC SYNONYM fnd_conflicts_domain_s FOR fnd_conflicts_domain_s;
CREATE PUBLIC SYNONYM fnd_conc_pp_actions FOR fnd_conc_pp_actions;
CREATE PUBLIC SYNONYM fnd_application_tl FOR fnd_application_tl;
CREATE PUBLIC SYNONYM fnd_executables FOR fnd_executables;
CREATE PUBLIC SYNONYM fnd_descriptive_flexs_vl FOR fnd_descriptive_flexs_vl;
CREATE PUBLIC SYNONYM fnd_descr_flex_contexts_vl FOR fnd_descr_flex_contexts_vl;
CREATE PUBLIC SYNONYM fnd_conc_global FOR fnd_conc_global;
No comments:
Post a Comment