You are browsing the archive for Oracle Marketing.

AMS : Import New Schedules

 

NAME: AMS : Import New Schedules
SHORT CODE: AMSADIIS
MODULE: Oracle Marketing

Description: AMS Web ADI New Schedules Import From Spreadsheet
Navigation: Oracle Marketing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_upload_batch_id : Upload Batch Id
  • p_ui_instance_id : UI Instance id

 

AMS – Team Access Refresh Program

 

NAME: AMS – Team Access Refresh Program
SHORT CODE: AMSADENO
MODULE: Oracle Marketing

Description: This is to refresh access denorm table for the access changes done in OMO
Navigation: Oracle Marketing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_full_mode : Distinguishes whether to run in full mode or incremental mode.

 

Oracle Marketing Tables

Oracle Marketing module important tables

  • AML_BUSINESS_EVENT_TYPES_B
  • AML_BUSINESS_EVENT_TYPES_TL
  • AML_DATA_MIGRATION
  • AML_INTERACTION_LEADS
  • AML_MONITOR_CONDITIONS
  • AML_MONITOR_LOG
  • AML_RULE_APPLIED_ATTRS
  • AML_SALES_LEAD_TIMEFRAMES
  • AMS_ACT_ACCESS
  • AMS_ACT_ACCESS_DENORM
  • AMS_ACT_BUDGETS
  • AMS_ACT_CATEGORIES
  • AMS_ACT_CHANGE_REQ_ITEMS
  • AMS_ACT_COMMUNICATIONS
  • AMS_ACT_CONTACT_POINTS
  • AMS_ACT_DELIVERY_METHODS
  • AMS_ACT_DISCOVERER_ALL
  • AMS_ACT_FORECASTS_ALL
  • AMS_ACT_GEO_AREAS
  • AMS_ACT_LISTS
  • AMS_ACT_LIST_GROUPS
  • AMS_ACT_LOGS
  • AMS_ACT_MARKET_SEGMENTS
  • AMS_ACT_MESSAGES
  • AMS_ACT_METRICS_ALL
  • AMS_ACT_METRICS_ALL_DENORM
  • AMS_ACT_METRIC_FACTS_ALL
  • AMS_ACT_METRIC_FORMULAS
  • AMS_ACT_METRIC_FORM_ENT
  • AMS_ACT_METRIC_HST
  • AMS_ACT_OBJECTIVES
  • AMS_ACT_OBJ_METRICS
  • AMS_ACT_OFFERS
  • AMS_ACT_PARTNERS
  • AMS_ACT_PERSONS
  • AMS_ACT_PRODUCTS
  • AMS_ACT_PROGRAMS
  • AMS_ACT_QA_CHECKS
  • AMS_ACT_RESOURCES
  • AMS_ACT_SCRIPTS
  • AMS_ACT_SIZES
  • AMS_ACT_SKILLS
  • AMS_ACT_TYPE_TASK_TPLS
  • AMS_ACT_WEB_RULE_TYPES
  • AMS_ACT_WF_REQUESTS
  • AMS_ADI_CAMPAIGNS_INTERFACE
  • AMS_ADI_MEDIA_PLANNER
  • AMS_ADI_OBJECTS_EXPORT_LIST
  • AMS_AGENDAS_B
  • AMS_AGENDAS_TL
  • AMS_APPROVAL_DETAILS
  • AMS_APPROVAL_DETAILS_TL
  • AMS_APPROVAL_HISTORY
  • AMS_APPROVAL_RULES
  • AMS_APPROVERS
  • AMS_ATTACHMENT_PROPERTIES
  • AMS_ATTB_LOV_B
  • AMS_ATTB_LOV_TL
  • AMS_ATTB_LOV_VALUES_B
  • AMS_ATTB_LOV_VALUES_TL
  • AMS_BASE_SALES_VOL_ALL
  • AMS_CALENDAR_CRITERIA
  • AMS_CAMPAIGNS_ALL_B
  • AMS_CAMPAIGNS_ALL_TL
  • AMS_CAMPAIGN_RELATIONS
  • AMS_CAMPAIGN_SCHEDULES
  • AMS_CAMPAIGN_SCHEDULES_B
  • AMS_CAMPAIGN_SCHEDULES_TL
  • AMS_CATEGORIES_B
  • AMS_CATEGORIES_TL
  • AMS_CAT_ACTIVITIES
  • AMS_CELLS_ALL_B
  • AMS_CELLS_ALL_TL
  • AMS_CHANNELS_B
  • AMS_CHANNELS_TL
  • AMS_CLIK_THRU_ACTIONS_B
  • AMS_CLIK_THRU_ACTIONS_TL
  • AMS_CLIK_THRU_ACT_PARAMS_B
  • AMS_CLIK_THRU_ACT_PARAMS_TL
  • AMS_CLIK_THRU_USAGES
  • AMS_COLUMNS_METADATA
  • AMS_COLUMN_RULES
  • AMS_COMPETITOR_PRODUCTS_B
  • AMS_COMPETITOR_PRODUCTS_TL
  • AMS_COND_STRUCT_RESTRICT_VALUE
  • AMS_CONTENT_RULES_B
  • AMS_CONTENT_RULES_TL
  • AMS_CPAG_ANSWERS_B
  • AMS_CPAG_ANSWERS_TL
  • AMS_CPAG_DLG_RESPONS_B
  • AMS_CPAG_DLG_RESPONS_TL
  • AMS_CPAG_DLG_WGHT_TOTL
  • AMS_CPAG_QUERIES
  • AMS_CPAG_QUERY_USAGES
  • AMS_CPAG_QUESTIONS_B
  • AMS_CPAG_QUESTIONS_TL
  • AMS_CTDS
  • AMS_CTD_ADHOC_PARAM_VALUES
  • AMS_CTD_ASSOCIATIONS
  • AMS_CTD_PARAM_VALUES
  • AMS_CUSTOM_SETUPS_B
  • AMS_CUSTOM_SETUPS_BK
  • AMS_CUSTOM_SETUPS_TL
  • AMS_CUSTOM_SETUP_ATTR
  • AMS_CUSTOM_SETUP_ATTR_BK
  • AMS_CUSTOM_SETUP_PURPOSE
  • AMS_DELIVERABLES_ALL_B
  • AMS_DELIVERABLES_ALL_TL
  • AMS_DELIV_KIT_ITEMS
  • AMS_DELIV_PRODUCTS
  • AMS_DENORM_QUERIES
  • AMS_DIALOGS_ALL_B
  • AMS_DIALOGS_ALL_TL
  • AMS_DISCOVERER_SQL
  • AMS_DLG_BRANCHES_B
  • AMS_DLG_BRANCHES_TL
  • AMS_DLG_BRANCH_VALUES
  • AMS_DLG_COMP_TYPES_B
  • AMS_DLG_COMP_TYPES_TL
  • AMS_DLG_COMP_TYPE_OUTCOME_B
  • AMS_DLG_COMP_TYPE_OUTCOME_TL
  • AMS_DLG_COMP_TYPE_PARAMS_B
  • AMS_DLG_COMP_TYPE_PARAMS_TL
  • AMS_DLG_CONTEXT_FIELDS
  • AMS_DLG_CTX_FIELD_USES
  • AMS_DLG_FLOW_COMPS_B
  • AMS_DLG_FLOW_COMPS_TL
  • AMS_DLG_FLOW_COMP_PARAM_MAP
  • AMS_DLG_FLOW_COMP_REL
  • AMS_DLG_IDENTIFY_ITEMS
  • AMS_DLG_IDENTIFY_RULES_B
  • AMS_DLG_IDENTIFY_RULES_TL
  • AMS_DLG_INTERACTIONS
  • AMS_DLG_REGISTERED_INTERESTS
  • AMS_DLG_RUN_CONTEXTS
  • AMS_DLG_RUN_STEP_DETAILS
  • AMS_DLG_URL_PARAMS_B
  • AMS_DLG_URL_PARAMS_TL
  • AMS_DLG_URL_PARAM_ASSOCIATIONS
  • AMS_DM_AGG_STG
  • AMS_DM_APPLY_STG
  • AMS_DM_BIC_STG
  • AMS_DM_BIN_VALUES
  • AMS_DM_CATEGORICAL_BB
  • AMS_DM_DRV_STG
  • AMS_DM_FINNUM_STG
  • AMS_DM_GEN_STG
  • AMS_DM_IMP_ATTRIBUTES
  • AMS_DM_INTER_SOURCE_STG
  • AMS_DM_LIFT
  • AMS_DM_MODELS_ALL_B
  • AMS_DM_MODELS_ALL_TL
  • AMS_DM_NUMERICAL_BB
  • AMS_DM_OPT_TGT_METRICS
  • AMS_DM_ORG_CONTACTS
  • AMS_DM_PARTY_DETAILS
  • AMS_DM_PARTY_DETAILS_TIME
  • AMS_DM_PARTY_PROFILE_STG
  • AMS_DM_PERFORMANCE
  • AMS_DM_PERINT_STG
  • AMS_DM_SCORES_ALL_B
  • AMS_DM_SCORES_ALL_TL
  • AMS_DM_SCORE_LISTS
  • AMS_DM_SCORE_PCT_RESULTS
  • AMS_DM_SCORE_RESULTS
  • AMS_DM_SOURCE
  • AMS_DM_TARGETS_B
  • AMS_DM_TARGETS_TL
  • AMS_DM_TARGET_SOURCES
  • AMS_DM_TARGET_STG
  • AMS_DM_TARGET_VALUES_B
  • AMS_DM_TARGET_VALUES_TL
  • AMS_DS_TCA_ENTITY
  • AMS_DS_TCA_ENTITY_COLS
  • AMS_DS_TCA_ENTITY_COLS_TL
  • AMS_DS_TCA_ENTITY_TL
  • AMS_EVENT_HEADERS_ALL_B
  • AMS_EVENT_HEADERS_ALL_TL
  • AMS_EVENT_OFFERS_ALL_B
  • AMS_EVENT_OFFERS_ALL_TL
  • AMS_EVENT_REGISTRATIONS
  • AMS_EXP_LIST_HEADERS_ALL
  • AMS_EXP_LIST_HEADERS_ALL_TL
  • AMS_EXP_MODIFIED_TEMPLATE
  • AMS_EXP_TEMPLATE
  • AMS_FORECAST_CUSTOMERS
  • AMS_FORECAST_DIMENTIONS
  • AMS_FORECAST_PERIODS
  • AMS_FORECAST_PRODUCTS
  • AMS_FORECAST_PROD_EXCLUSIONS
  • AMS_GENERATED_CODES
  • AMS_HIERARCHIES_ALL_B
  • AMS_HIERARCHIES_ALL_TL
  • AMS_IBA_CAMPAIGN_RULES
  • AMS_IBA_CAMP_POSTINGS
  • AMS_IBA_CPN_ITEMS_DENORM
  • AMS_IBA_DISPLAY_RULES
  • AMS_IBA_MS_ITEMS_DENORM
  • AMS_IBA_OP_PROMPT_B
  • AMS_IBA_OP_PROMPT_TL
  • AMS_IBA_OP_RECO_SETTING
  • AMS_IBA_OP_RE_SETUP
  • AMS_IBA_OP_SETUP
  • AMS_IBA_PAGE_LOCATION
  • AMS_IBA_PL_PAGES_B
  • AMS_IBA_PL_PAGES_TL
  • AMS_IBA_PL_PARAMETERS_B
  • AMS_IBA_PL_PARAMETERS_TL
  • AMS_IBA_PL_PARAM_VALS
  • AMS_IBA_PL_PG_PARAMS
  • AMS_IBA_PL_PLACEMENTS_B
  • AMS_IBA_PL_PLACEMENTS_TL
  • AMS_IBA_PL_SITES_B
  • AMS_IBA_PL_SITES_TL
  • AMS_IBA_PL_STYLESHTS_B
  • AMS_IBA_PL_STYLESHTS_TL
  • AMS_IBA_POSTINGS_B
  • AMS_IBA_POSTINGS_TL
  • AMS_IBA_POST_SUM_ALL
  • AMS_IBA_PS_CNDCLSES_B
  • AMS_IBA_PS_CNDCLSES_TL
  • AMS_IBA_PS_FILTERS_B
  • AMS_IBA_PS_FILTERS_TL
  • AMS_IBA_PS_POSTINGS_B
  • AMS_IBA_PS_POSTINGS_TL
  • AMS_IBA_PS_RL_ST_FLTRS
  • AMS_IBA_PS_RL_ST_PARAMS
  • AMS_IBA_PS_RULEGRPS_B
  • AMS_IBA_PS_RULEGRPS_TL
  • AMS_IBA_PS_RULES
  • AMS_IBA_PS_STRATS_B
  • AMS_IBA_PS_STRATS_TL
  • AMS_IBA_TRACKING_ALL
  • AMS_IMP_COL_MAPPING
  • AMS_IMP_CONFIG_COMPONENTS
  • AMS_IMP_CONFIG_IMPORT_TYPES
  • AMS_IMP_DEFAULT_MAPPING
  • AMS_IMP_DOCUMENTS
  • AMS_IMP_DOC_CONTENT
  • AMS_IMP_LIST_HEADERS_ALL
  • AMS_IMP_LIST_HEADERS_ALL_TL
  • AMS_IMP_LIST_IMPORT_TYPES
  • AMS_IMP_SOURCE_LINES
  • AMS_IMP_XML_ATTRIBUTES
  • AMS_IMP_XML_ELEMENTS
  • AMS_INTL_DATES
  • AMS_ITEM_ATTRIBUTES
  • AMS_LIST_CONT_RESTRICTIONS
  • AMS_LIST_DELETE_TMP_ENTRIES
  • AMS_LIST_ENTRIES
  • AMS_LIST_ENTRY_USAGES
  • AMS_LIST_FIELDS_B
  • AMS_LIST_FIELDS_TL
  • AMS_LIST_HEADERS_ALL
  • AMS_LIST_HEADERS_ALL_TL
  • AMS_LIST_IMPORT_ERRORS
  • AMS_LIST_QUERIES_ALL
  • AMS_LIST_QUERIES_PARAM
  • AMS_LIST_QUERIES_PARAM_TL
  • AMS_LIST_QUERIES_TL
  • AMS_LIST_RULES_ALL
  • AMS_LIST_RULES_ALL_TL
  • AMS_LIST_RULE_FIELDS
  • AMS_LIST_RULE_USAGES
  • AMS_LIST_SELECT_ACTIONS
  • AMS_LIST_SRC_FIELDS
  • AMS_LIST_SRC_FIELDS_TL
  • AMS_LIST_SRC_TYPES
  • AMS_LIST_SRC_TYPES_TL
  • AMS_LIST_SRC_TYPE_ASSOCS
  • AMS_LIST_SRC_TYPE_USAGES
  • AMS_LIST_TMP_ENTRIES
  • AMS_LIST_WORD_FIELDS
  • AMS_LIST_WORD_REPLACES
  • AMS_MEDIA_B
  • AMS_MEDIA_CHANNELS
  • AMS_MEDIA_TL
  • AMS_MESSAGES_B
  • AMS_MESSAGES_TL
  • AMS_METRICS_ALL_B
  • AMS_METRICS_ALL_TL
  • AMS_METRIC_ACCRUALS
  • AMS_METRIC_FORMULAS
  • AMS_MET_SCENARIOS
  • AMS_MET_TPL_ASSOCS
  • AMS_MET_TPL_DETAILS
  • AMS_MET_TPL_HEADERS
  • AMS_MET_TPL_HEADERS_B
  • AMS_MET_TPL_HEADERS_TL
  • AMS_MISC_COST_DIS_ALL_B
  • AMS_MISC_COST_DIS_ALL_TL
  • AMS_MTL_CATEGORIES_DENORM_B
  • AMS_MTL_CATEGORIES_DENORM_TL
  • AMS_OBJECT_ASSOCIATIONS
  • AMS_OBJECT_ATTRIBUTES
  • AMS_OBJECT_RULES_B
  • AMS_OBJECT_RULES_TL
  • AMS_OFFERS
  • AMS_OFFER_ADJUSTMENTS_B
  • AMS_OFFER_ADJUSTMENTS_TL
  • AMS_OFFER_ADJUSTMENT_LINES
  • AMS_OFFER_ADJUSTMENT_TIERS
  • AMS_OFFER_PARTIES
  • AMS_OFFER_PARTIES_TEMP
  • AMS_OFFER_PERFORMANCES
  • AMS_OFFER_PRODUCTS
  • AMS_OFFER_PRODUCTS_TEMP
  • AMS_PARTY_DEDUPE
  • AMS_PARTY_MARKET_SEGMENTS
  • AMS_PARTY_SOURCES
  • AMS_PORTAL_CACHE
  • AMS_PRETTY_URL
  • AMS_PRETTY_URL_ASSOC
  • AMS_PRICE_LIST_ATTRIBUTES
  • AMS_PROD_TEMPLATES_B
  • AMS_PROD_TEMPLATES_TL
  • AMS_PROD_TEMPLATE_ATTR
  • AMS_PROGRAMS_ALL_B
  • AMS_PROGRAMS_ALL_TL
  • AMS_QUERY_ALIAS
  • AMS_QUERY_CONDITION
  • AMS_QUERY_CONDITION_VALUE
  • AMS_QUERY_COND_DISP_STRUCT_ALL
  • AMS_QUERY_COND_DISP_STRUCT_TL
  • AMS_QUERY_TEMPLATE_ALL
  • AMS_QUERY_TEMPLATE_INSTANCE
  • AMS_QUERY_TEMPLATE_TL
  • AMS_QUERY_TEMP_INST_COND_ASSOC
  • AMS_QUERY_TEMP_PURPOSE_ASSOC
  • AMS_RELATED_DEAL_LINES
  • AMS_REP_HISTORY
  • AMS_REQUEST_HISTORY
  • AMS_RULE_MEDIA_ASSOC
  • AMS_R_CAMP_DAILY_FACTS
  • AMS_R_CAMP_WEEKLY_FACTS
  • AMS_R_EVEN_DAILY_FACTS
  • AMS_R_EVEN_WEEKLY_FACTS
  • AMS_R_FDSP_DAILY_FACTS
  • AMS_R_FDSP_WEEKLY_FACTS
  • AMS_R_FUND_DAILY_FACTS
  • AMS_R_FUND_WEEKLY_FACTS
  • AMS_SCHEDULER
  • AMS_SEARCH_IDS
  • AMS_SETUP_TYPES
  • AMS_SOURCE_CODES
  • AMS_STATUS_ORDER_RULES
  • AMS_SYSTEM_PRETTY_URL
  • AMS_TCOP_CHANNEL_SUMMARY
  • AMS_TCOP_CHANNEL_SUM_DTL
  • AMS_TCOP_CONTACTS
  • AMS_TCOP_CONTACT_SUMMARY
  • AMS_TCOP_CONTACT_SUM_DTL
  • AMS_TCOP_FATIGUED_BY
  • AMS_TCOP_FR_PERIODS_B
  • AMS_TCOP_FR_PERIODS_TL
  • AMS_TCOP_FR_RULES_SETUP
  • AMS_TCOP_PRVW_CONTACTS
  • AMS_TCOP_PRVW_FATIGUE
  • AMS_TCOP_PRVW_FTG_BY
  • AMS_TCOP_PRVW_FTG_DTLS
  • AMS_TCOP_PRVW_REQUESTS
  • AMS_TCOP_REQUESTS
  • AMS_TEMPL_RESPONSIBILITY
  • AMS_TEMP_MAPPING
  • AMS_TEMP_MAPPING_SEQ
  • AMS_TERR_LEVELS_ALL
  • AMS_TRIGGERS
  • AMS_TRIGGERS_TL
  • AMS_TRIGGER_ACTIONS
  • AMS_TRIGGER_CHECKS
  • AMS_TRIGGER_RESULTS
  • AMS_UPGRADE
  • AMS_UPGRADE_ENTRIES
  • AMS_UPGRADE_TRACK_ERROR
  • AMS_USER_STATUSES_B
  • AMS_USER_STATUSES_TL
  • AMS_VENUES_B
  • AMS_VENUES_TL
  • AMS_VENUE_RATES_B
  • AMS_VENUE_RATES_TL
  • AMS_VOLUME_OFFER_TIERS
  • AMS_WEB_PLACEMENTS_B
  • AMS_WEB_PLACEMENTS_TL
  • AMS_WEB_PLCE_CITEM_ASSOC
  • AMS_WEB_PLCE_CTYPE_ASSOC
  • AMS_WEB_PLCE_MP_B
  • AMS_WEB_PLCE_MP_TL
  • AMS_WEB_RECOMMS
  • AMS_WEB_RULES_B
  • AMS_WEB_RULES_TL
  • AMS_WEB_TRACKING