Cisco Cisco Workload Automation 6.3 User Guide

Appendix A—Custom APPS User SQL Commands

tidal_syn.sql Commands

GRANT "CONNECT" TO "TIDAL";

GRANT SELECT ON "APPS.FND_USER" TO "TIDAL"; 

GRANT SELECT ON "APPS.FND_APPLICATION" TO "TIDAL"";

tidal_syn.sql Commands

CREATE OR REPLACE SYNONYM APP_EXCEPTION FOR APPS.APP_EXCEPTION; 
CREATE OR REPLACE SYNONYM DBMS_OBFUSCATION_TOOLKIT FOR SYS.DBMS_OBFUSCATION_TOOLKIT; 
CREATE OR REPLACE SYNONYM FNDCP_CRM FOR APPS.FNDCP_CRM; 

CREATE OR REPLACE SYNONYM FND_AMP_PRIVATE FOR APPS.FND_AMP_PRIVATE; 

CREATE OR REPLACE SYNONYM FND_APPLICATION FOR APPS.FND_APPLICATION; 

CREATE OR REPLACE SYNONYM FND_APPLICATION_PKG FOR APPS.FND_APPLICATION_PKG; 

CREATE OR REPLACE SYNONYM FND_APPLICATION_S FOR APPS.FND_APPLICATION_S; 

CREATE OR REPLACE SYNONYM FND_APPLICATION_TL FOR APPS.FND_APPLICATION_TL; 

CREATE OR REPLACE SYNONYM FND_APPLICATION_VL FOR APPS.FND_APPLICATION_VL; 

CREATE OR REPLACE SYNONYM FND_APPL_TOPS FOR APPS.FND_APPL_TOPS; 

CREATE OR REPLACE SYNONYM FND_CACHE_VERSIONS FOR APPS.FND_CACHE_VERSIONS; 

CREATE OR REPLACE SYNONYM FND_CLIENT_INFO FOR APPS.FND_CLIENT_INFO; 

CREATE OR REPLACE SYNONYM FND_CODE_PKG FOR APPS.FND_CODE_PKG; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT FOR APPS.FND_CONCURRENT; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_BUSINESS_EVENT FOR APPS.FND_CONCURRENT_BUSINESS_EVENT; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_FILE FOR APPS.FND_CONCURRENT_FILE; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_PROCESSES FOR APPS.FND_CONCURRENT_PROCESSES; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_PROGRAMS FOR APPS.FND_CONCURRENT_PROGRAMS; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_PROGRAMS_TL FOR APPS.FND_CONCURRENT_PROGRAMS_TL; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_PROGRAMS_VL FOR APPS.FND_CONCURRENT_PROGRAMS_VL; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_QUEUES FOR APPS.FND_CONCURRENT_QUEUES; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_QUEUES_VL FOR APPS.FND_CONCURRENT_QUEUES_VL; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_REQUESTS FOR APPS.FND_CONCURRENT_REQUESTS; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_REQUESTS_S FOR APPS.FND_CONCURRENT_REQUESTS_S; 

CREATE OR REPLACE SYNONYM FND_CONCURRENT_WORKER_REQUESTS FOR APPS.FND_CONCURRENT_WORKER_REQUESTS;

CREATE OR REPLACE SYNONYM FND_CONC_DATE FOR APPS.FND_CONC_DATE; 

CREATE OR REPLACE SYNONYM FND_CONC_DEFERRED_ARGUMENTS FOR APPS.FND_CONC_DEFERRED_ARGUMENTS; 

CREATE OR REPLACE SYNONYM FND_CONC_GLOBAL FOR APPS.FND_CONC_GLOBAL; 

CREATE OR REPLACE SYNONYM FND_CONC_PP FOR APPS.FND_CONC_PP; 

CREATE OR REPLACE SYNONYM FND_CONC_PP_ACTIONS FOR APPS.FND_CONC_PP_ACTIONS; 

CREATE OR REPLACE SYNONYM FND_CONC_PROG_ONSITE_INFO FOR APPS.FND_CONC_PROG_ONSITE_INFO; 

CREATE OR REPLACE SYNONYM FND_CONC_RELEASE_CLASSES FOR APPS.FND_CONC_RELEASE_CLASSES; 

CREATE OR REPLACE SYNONYM FND_CONC_RELEASE_CLASSES_S FOR APPS.FND_CONC_RELEASE_CLASSES_S; 

CREATE OR REPLACE SYNONYM FND_CONC_RELEASE_CLASSES_TL FOR APPS.FND_CONC_RELEASE_CLASSES_TL;

CREATE OR REPLACE SYNONYM FND_CONC_RELEASE_CLASSES_VL FOR APPS.FND_CONC_RELEASE_CLASSES_VL; 

CREATE OR REPLACE SYNONYM FND_CONC_RELEASE_CLASS_UTILS FOR APPS.FND_CONC_RELEASE_CLASS_UTILS; 

CREATE OR REPLACE SYNONYM FND_CONC_REQUEST_ARGUMENTS FOR APPS.FND_CONC_REQUEST_ARGUMENTS;

CREATE OR REPLACE SYNONYM FND_CONC_REQ_OUTPUTS FOR APPS.FND_CONC_REQ_OUTPUTS; 

CREATE OR REPLACE SYNONYM FND_CONC_SSWA FOR APPS.FND_CONC_SSWA; 

CREATE OR REPLACE SYNONYM FND_CP_IPP_PRINTERS FOR APPS.FND_CP_IPP_PRINTERS; 

CREATE OR REPLACE SYNONYM FND_CP_SERVICES FOR APPS.FND_CP_SERVICES;

CREATE OR REPLACE SYNONYM FND_CRYPT_PKG FOR APPS.FND_CRYPT_PKG; 

CREATE OR REPLACE SYNONYM FND_DATA_GROUPS FOR APPS.FND_DATA_GROUPS; 

CREATE OR REPLACE SYNONYM FND_DATA_GROUP_UNITS FOR APPS.FND_DATA_GROUP_UNITS; 

CREATE OR REPLACE SYNONYM FND_DATE FOR APPS.FND_DATE; 

CREATE OR REPLACE SYNONYM FND_DEBUG_RULES FOR APPS.FND_DEBUG_RULES; 

CREATE OR REPLACE SYNONYM FND_DEBUG_RULES_S FOR APPS.FND_DEBUG_RULES_S; 

CREATE OR REPLACE SYNONYM FND_DEBUG_RULE_OPTIONS FOR APPS.FND_DEBUG_RULE_OPTIONS;

CREATE OR REPLACE SYNONYM FND_DESCRIPTIVE_FLEXS FOR APPS.FND_DESCRIPTIVE_FLEXS; 

CREATE OR REPLACE SYNONYM FND_DESCRIPTIVE_FLEXS_TL FOR APPS.FND_DESCRIPTIVE_FLEXS_TL; 

CREATE OR REPLACE SYNONYM FND_DESCR_FLEX_COLUMN_USAGES FOR APPS.FND_DESCR_FLEX_COLUMN_USAGES; 

CREATE OR REPLACE SYNONYM FND_DESCR_FLEX_COL_USAGE_TL FOR APPS.FND_DESCR_FLEX_COL_USAGE_TL; 

CREATE OR REPLACE SYNONYM FND_DESCR_FLEX_COL_USAGE_VL FOR APPS.FND_DESCR_FLEX_COL_USAGE_VL; 

CREATE OR REPLACE SYNONYM FND_DESCR_FLEX_CONTEXTS FOR APPS.FND_DESCR_FLEX_CONTEXTS; 

CREATE OR REPLACE SYNONYM FND_DESCR_FLEX_CONTEXTS_TL FOR APPS.FND_DESCR_FLEX_CONTEXTS_TL;

CREATE OR REPLACE SYNONYM FND_FILE_TEMP FOR APPS.FND_FILE_TEMP; 

CREATE OR REPLACE SYNONYM FND_FLEX_VALIDATION_TABLES FOR APPS.FND_FLEX_VALIDATION_TABLES;