You are browsing the archive for Oracle Sales Foundation.

Assign Territory Access for New Mode

 

NAME: Assign Territory Access for New Mode
SHORT CODE: ASNATA
MODULE: Oracle Sales Foundation

Description: Assign Territory Access for New Mode
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Account Type : Account Type
  • Account Addl. where clause : Account Addl. where clause
  • Lead Status : Lead Status
  • Lead Addl. where clause : Lead Addl. where clause
  • Opportunity Status : Opportunity Status
  • Opportunity Addl. where clause : Opportunity Addl. where clause
  • Exclude Ordered Quotes : Exclude Ordered Quotes
  • Exclude Expired Quotes : Exclude Expired Quotes
  • Quotes Addl. where clause : Quotes Addl. where clause
  • Proposal Addl. where clause : Proposal Addl. where clause
  • % Analyzed for Trans Table : % Analyzed for Trans Table
  • Debug : Debug
  • Trace : Trace

 

Product Catalog Migration for Leads

 

NAME: Product Catalog Migration for Leads
SHORT CODE: AMLPRCAT
MODULE: Oracle Sales Foundation

Description: Product Catalog Migration for Leads
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • SQL Trace : SQL Trace

 

Oracle Sales Foundation Tables

Data base table information for Oracle Sales Foundation module:

  • AS_ACCESSES_ALL_ALL
  • AS_ACCESSES_PURGE_TEMP
  • AS_ACCOUNT_QUAL_VALUES_ALL
  • AS_ACC_USR_RANKS_ALL
  • AS_AP_ACCOUNT_PLANS
  • AS_AP_BUSINESS_DRIVERS
  • AS_AP_STRTGC_OBJECTIVES
  • AS_AP_TRACKING_OBJECTIVES
  • AS_CARD_RULE_QUAL_VALUES
  • AS_CATEGORIES_ALL
  • AS_CHANGED_ACCOUNTS_ALL
  • AS_CHANGED_TERRITORIES_ALL
  • AS_COLLATERAL_CAT_ALL
  • AS_COLLATERAL_KITS_ALL
  • AS_COLLATERAL_REQ_ALL
  • AS_COLLATERAL_REQ_ITEMS
  • AS_CONC_REQUEST_MESSAGES
  • AS_CONTACT_EDUCATION
  • AS_CONTACT_ENTER
  • AS_CONTACT_FAMILY
  • AS_CONTACT_HOBBIES
  • AS_CONTACT_JOB_HISTORY
  • AS_CONTACT_MILITARY
  • AS_CONTACT_PREFERENCES
  • AS_CONTACT_SPORTS
  • AS_CONTACT_TRAITS
  • AS_COUNTRY_PHONES
  • AS_CURRENT_ENVIRONMENT
  • AS_CUST_ACCESSES
  • AS_CUST_PROFILES
  • AS_DEDUPE_RULES_QUALIFIERS
  • AS_DEFAULT_PURCHASES_ALL
  • AS_EVENT_DATA
  • AS_EVENT_ENROLLMENTS_ALL
  • AS_EVENT_FACILITIES_ALL
  • AS_EVENT_FAC_ROOMS
  • AS_EVENT_FAC_STAFF
  • AS_EVENT_LETTERS_ALL
  • AS_EVENT_NAMES_ALL
  • AS_EVENT_NAME_REQUIREMENTS
  • AS_EVENT_PERSONNEL
  • AS_EXCHANGES_B
  • AS_EXCHANGES_TL
  • AS_FIELD_MAP
  • AS_FND_PROF_OPT_VALUES
  • AS_FND_SEG_ATTR_VAL
  • AS_FORECASTS
  • AS_FORECAST_ACTUALS
  • AS_FORECAST_CATEGORIES
  • AS_FORECAST_CATEGORIES_B
  • AS_FORECAST_CATEGORIES_TL
  • AS_FORECAST_CAT_DEN
  • AS_FORECAST_PROB_ALL_B
  • AS_FORECAST_PROB_ALL_TL
  • AS_FORECAST_WORKSHEETS
  • AS_FRAMEWORK_PROFILE
  • AS_FRAMEWORK_RULES
  • AS_FST_SALES_CATEGORIES
  • AS_FUNDS_B
  • AS_FUNDS_TL
  • AS_FUND_CONTACTS
  • AS_GROUP_ISSUE_MAP
  • AS_GROUP_PARTY_MAP
  • AS_HR_ORG_UNITS
  • AS_HZ_CLASS_CODE_DENORM
  • AS_IMPORT_INTERFACE
  • AS_IMP_CNT_PNT_INTERFACE
  • AS_IMP_CNT_ROL_INTERFACE
  • AS_IMP_LINES_INTERFACE
  • AS_IMP_SL_FLEX
  • AS_INTERESTS_ALL
  • AS_INTEREST_CATEGORY_SETS_ALL
  • AS_INTEREST_CODES_ALL
  • AS_INTEREST_CODES_B
  • AS_INTEREST_CODES_MC
  • AS_INTEREST_CODES_TL
  • AS_INTEREST_STATUSES
  • AS_INTEREST_TYPES_ALL
  • AS_INTEREST_TYPES_B
  • AS_INTEREST_TYPES_TL
  • AS_INTERNAL_FORECASTS
  • AS_INVALID_ADDR
  • AS_ISSUER
  • AS_ISSUES_B
  • AS_ISSUES_TL
  • AS_ISSUE_GROUPS_B
  • AS_ISSUE_GROUPS_TL
  • AS_ISSUE_GROUP_IDFR
  • AS_ISSUE_GROUP_TYPES
  • AS_ISSUE_LISTING_B
  • AS_ISSUE_LISTING_IDFR
  • AS_ISSUE_LISTING_TL
  • AS_ISSUE_RELATIONSHIPS
  • AS_LAST_RUN_DATES
  • AS_LEADS_ALL
  • AS_LEADS_LOG
  • AS_LEAD_ADJS
  • AS_LEAD_COMPETITORS
  • AS_LEAD_COMPETITOR_PRODS
  • AS_LEAD_COMP_PRODUCTS
  • AS_LEAD_CONTACTS_ALL
  • AS_LEAD_DECISION_FACTORS
  • AS_LEAD_IMPORT_ERRORS
  • AS_LEAD_LINES_ALL
  • AS_LEAD_LINES_LOG
  • AS_LEAD_LINE_ADJS
  • AS_LEAD_LOG
  • AS_LEAD_OBSTACLES
  • AS_LEAD_ORDERS
  • AS_LETS_PARTNER_MAP
  • AS_LISTS_ALL
  • AS_LISTS_TO_PRINT
  • AS_LIST_ENTRIES
  • AS_LIST_ENTRY_USAGES
  • AS_LIST_QUERIES
  • AS_LIST_RULES
  • AS_LIST_RULE_ENTRIES
  • AS_LIST_RULE_FIELDS
  • AS_LIST_RULE_FIELDS_TL
  • AS_LLOG_STATUS_SUMMARY
  • AS_LS_ERRS
  • AS_MC_REPORTING_CURR
  • AS_MC_SALES_CREDITS_DEN
  • AS_MC_TYPE_MAPPINGS
  • AS_MERGE_FILES_ALL
  • AS_METH_STAGE_INSTANCES
  • AS_METH_STEP_INSTANCES
  • AS_MOBILE_ACCESSES
  • AS_MOBILE_CUSTOMERS
  • AS_MOBILE_DEVICE_USERS
  • AS_MOBILE_NOTIFICATION
  • AS_MRP_FCT_DETAIL
  • AS_MRP_FCT_REPORT
  • AS_MRP_INTERFACE
  • AS_MRP_INTERFACE_LINES
  • AS_MRP_OPP_REPORT
  • AS_MTL_UOM_CLA_CON
  • AS_OBJECT_ATTRIBUTES
  • AS_OPP_COMPETING_PRODS
  • AS_OPP_COMP_PROD_STRNTHS
  • AS_OPP_WORKSHEET_LINES
  • AS_OSI_CONS_CCS_BASE
  • AS_OSI_CONTR_NAMES_BASE
  • AS_OSI_CONTR_VHCL_BASE
  • AS_OSI_LEADS_ALL
  • AS_OSI_LEADS_DENORM
  • AS_OSI_LEAD_OVL_ALL
  • AS_OSI_LOOKUP
  • AS_OSI_OVERLAY_BASE
  • AS_PARAMETERS_DATA
  • AS_PARTNER_ACCESSES
  • AS_PARTNER_LEAD_CONTACTS
  • AS_PARTNER_LEAD_LINES
  • AS_PARTNER_LEAD_NOTES
  • AS_PARTNER_MAP
  • AS_PERIOD_DAYS
  • AS_PERIOD_RATES
  • AS_PE_INT_CATEGORIES
  • AS_PHONE_FORMATS
  • AS_PIPELINE_AMOUNTS
  • AS_PRICE_LISTS
  • AS_PRICE_LIST_GROUPS
  • AS_PRODUCT_FILTERS
  • AS_PROD_WORKSHEET_LINES
  • AS_PROFILE_ATTRIBUTE
  • AS_PROMOTIONS_ALL
  • AS_PROMOTION_RELATIONSHIPS
  • AS_PROMOTION_SCRIPTS
  • AS_QTE_STATUS_TRANSITIONS
  • AS_QUOTA_PROFILES
  • AS_QUOTES_ALL
  • AS_QUOTE_LINES_ALL
  • AS_QUOTE_STATUS_LOG
  • AS_REF_ACT_ATTENDEES
  • AS_REF_ACT_LOCATIONS
  • AS_REF_ACT_SCHEDULES
  • AS_REF_ACT_SCH_REL_TO
  • AS_REF_ASSETS
  • AS_REF_ASSET_REL_TO
  • AS_REF_ASSET_USAGES
  • AS_REF_AUDITS
  • AS_REF_CONTACTS
  • AS_REF_CUST_PRODUCTS
  • AS_REF_DELIVERABLES
  • AS_REF_DEL_PRODUCTS
  • AS_REF_OBJECTIVES
  • AS_REF_REQSTD_ACTIVITIES
  • AS_REF_REQSTD_PROFILES
  • AS_REF_RESTRICTIONS
  • AS_REF_RSTRCTN_MAP_B
  • AS_REF_RSTRCTN_MAP_TL
  • AS_REF_SHORT_NOTES
  • AS_REF_SITES
  • AS_RELATIONSHIPS
  • AS_REPORTING_MANAGERS
  • AS_ROLLING_CALENDARS
  • AS_ROLLING_PERIODS
  • AS_SALESFORCE
  • AS_SALESREP_JOBS
  • AS_SALES_CREDITS
  • AS_SALES_CREDITS_DENORM
  • AS_SALES_CREDITS_LOG
  • AS_SALES_CREDIT_ADJS
  • AS_SALES_GROUPS
  • AS_SALES_GROUPS_DENORM
  • AS_SALES_GRP_ADMIN
  • AS_SALES_LEADS
  • AS_SALES_LEADS_LOG
  • AS_SALES_LEAD_CARD_RULES
  • AS_SALES_LEAD_CONTACTS
  • AS_SALES_LEAD_DEDUPE_RULES
  • AS_SALES_LEAD_LINES
  • AS_SALES_LEAD_OPPORTUNITY
  • AS_SALES_LEAD_OPP_LINES
  • AS_SALES_LEAD_OWNERS
  • AS_SALES_LEAD_QUALS_B
  • AS_SALES_LEAD_QUALS_TL
  • AS_SALES_LEAD_RANKS_B
  • AS_SALES_LEAD_RANKS_TL
  • AS_SALES_LEAD_SCORECARDS
  • AS_SALES_LEAD_SEED_QUAL_B
  • AS_SALES_LEAD_SEED_QUAL_TL
  • AS_SALES_METHODOLOGY_B
  • AS_SALES_METHODOLOGY_TL
  • AS_SALES_METH_STAGE_MAP
  • AS_SALES_METH_TASK_MAP
  • AS_SALES_QUOTAS
  • AS_SALES_STAGES_ALL_B
  • AS_SALES_STAGES_ALL_TL
  • AS_SCRIPT_ACTUAL_ANSWERS
  • AS_SCRIPT_ANSWER_ACTIONS_ALL
  • AS_SCRIPT_PRE_DEFINED_ANSWERS
  • AS_SCRIPT_QUESTIONS
  • AS_SERVERS
  • AS_SNAPSHOT_LOGS
  • AS_STATUSES_B
  • AS_STATUSES_TL
  • AS_SYNCH_SERVER
  • AS_TAP_PURGE_WORKING
  • AS_TERRITORIES_ALL
  • AS_TERRITORY_ACCESSES
  • AS_TERRITORY_ACC_PURGE_TEMP
  • AS_TERRITORY_GROUPS_ALL
  • AS_TERRITORY_ROLLUPS
  • AS_TERRITORY_TYPES_ALL
  • AS_TERRITORY_VALUES_ALL
  • AS_TERR_RESOURCES_TMP
  • AS_TERR_ROLLUPS_IMMEDIATE_TMP
  • AS_TERR_SEEDED_QUALIFIERS_ALL
  • AS_TERR_TYPE_QUALIFIERS
  • AS_TODO_LISTS_ALL
  • AS_TRANSFER_DETAILS
  • AS_TRANSFER_QUES
  • AS_WORD_REPLACEMENTS
  • HR_ALL_ORGANIZATION_UNITS