You are browsing the archive for CN.

Oracle Incentive Compensation Tables

Database tables for Oracle Incentive Compensation Module.

  • CN_ATTAIN_SCHEDULES
  • CN_ATTAIN_TIERS
  • CN_ATTRIBUTE_RULES_ALL
  • CN_CALC_EDGES_ALL
  • CN_CALC_EXT_TABLES_ALL
  • CN_CALC_EXT_TBL_DTLS_ALL
  • CN_CALC_FORMULAS_ALL
  • CN_CALC_SQL_EXPS_ALL
  • CN_CALC_SUBMISSION_BATCHES_ALL
  • CN_CALC_SUBMISSION_ENTRIES_ALL
  • CN_CALC_SUB_QUOTAS_ALL
  • CN_CALC_SUB_VALIDATIONS_ALL
  • CN_CAL_PER_INT_TYPES_ALL
  • CN_CLRL_API_ALL
  • CN_COLUMN_IND_MAPS
  • CN_COLUMN_MAPS_ALL
  • CN_COLUMN_TRG_MAPS
  • CN_COMMISSION_HEADERS_ALL
  • CN_COMMISSION_LINES_ALL
  • CN_COMM_LINES_API_ALL
  • CN_COMP_ANCHORS
  • CN_COMP_PLANS_ALL
  • CN_CREDIT_CONV_FCTS_ALL
  • CN_CREDIT_TYPES_ALL_B
  • CN_CREDIT_TYPES_ALL_TL
  • CN_CW_SETUP_TASKS_ALL_B
  • CN_CW_SETUP_TASKS_ALL_TL
  • CN_CW_WORKBENCH_ITEMS_ALL_B
  • CN_CW_WORKBENCH_ITEMS_ALL_TL
  • CN_DIMENSIONS_ALL_B
  • CN_DIMENSIONS_ALL_TL
  • CN_DIM_EXPLOSION_ALL
  • CN_DIM_HIERARCHIES_ALL
  • CN_EVENTS_ALL_B
  • CN_EVENTS_ALL_TL
  • CN_EVENT_LOG_ALL
  • CN_FORMULA_INPUTS_ALL
  • CN_HEAD_HIERARCHIES_ALL_B
  • CN_HEAD_HIERARCHIES_ALL_TL
  • CN_HIERARCHIES_API_ALL
  • CN_HIERARCHY_EDGES_ALL
  • CN_HIERARCHY_NODES_ALL
  • CN_IMPORT_TYPES
  • CN_IMP_HEADERS
  • CN_IMP_LINES
  • CN_IMP_MAPS
  • CN_IMP_MAP_FIELDS
  • CN_INTERVAL_TYPES_ALL_B
  • CN_INTERVAL_TYPES_ALL_TL
  • CN_INVOICE_CHANGES_ALL
  • CN_JOB_ROLES
  • CN_LEDGER_BAL_TYPES_ALL_B
  • CN_LEDGER_BAL_TYPES_ALL_TL
  • CN_LEDGER_JE_BATCHES_ALL
  • CN_LEDGER_JOURNAL_ENTRIES_ALL
  • CN_LINE_ROLLUP_PATHS_ALL
  • CN_MODEL_RESOURCES_ALL
  • CN_MODULES_ALL_B
  • CN_MODULES_ALL_TL
  • CN_MOD_OBJ_DEPENDS_ALL
  • CN_NOTIFY_LOG_ALL
  • CN_NOT_TRX_ALL
  • CN_OBJECTS_ALL
  • CN_PAYMENT_API_ALL
  • CN_PAYMENT_TRANSACTIONS_ALL
  • CN_PAYMENT_WORKSHEETS_ALL
  • CN_PAYRUNS_ALL
  • CN_PAY_APPROVAL_FLOW_ALL
  • CN_PAY_ELEMENT_INPUTS_ALL
  • CN_PAY_GROUPS_ALL
  • CN_PERF_MEASURES_ALL
  • CN_PERIOD_QUOTAS_ALL
  • CN_PERIOD_SETS_ALL
  • CN_PERIOD_STATUSES_ALL
  • CN_PERIOD_TYPES_ALL
  • CN_PLAN_TEXTS
  • CN_PMT_PLANS_ALL
  • CN_POSTING_BATCHES_ALL
  • CN_POSTING_DETAILS_ALL
  • CN_POSTING_DETAILS_SUM_ALL
  • CN_PROCESS_AUDITS_ALL
  • CN_PROCESS_AUDIT_LINES_ALL
  • CN_PROCESS_BATCHES_ALL
  • CN_QUARTER_BCK_ALL
  • CN_QUOTAS_ALL
  • CN_QUOTA_ASSIGNS_ALL
  • CN_QUOTA_CATEGORIES
  • CN_QUOTA_PAY_ELEMENTS_ALL
  • CN_QUOTA_RULES_ALL
  • CN_QUOTA_RULE_UPLIFTS_ALL
  • CN_RATE_DIMENSIONS_ALL
  • CN_RATE_DIM_TIERS_ALL
  • CN_RATE_SCHEDULES_ALL
  • CN_RATE_SCH_DIMS_ALL
  • CN_RATE_TIERS_ALL
  • CN_REASONS_ALL
  • CN_REASON_HISTORY_ALL
  • CN_REPOSITORIES_ALL
  • CN_REVENUE_CLASSES_ALL
  • CN_ROLE_DETAILS
  • CN_ROLE_MODELS_ALL
  • CN_ROLE_PAY_GROUPS_ALL
  • CN_ROLE_PLANS_ALL
  • CN_ROLE_PLAN_MAPS
  • CN_ROLE_PMT_PLANS_ALL
  • CN_ROLE_QUOTA_CATES
  • CN_ROLE_QUOTA_FORMULAS
  • CN_ROLE_QUOTA_RATES
  • CN_ROLLOVER_QUOTAS_ALL
  • CN_RT_FORMULA_ASGNS_ALL
  • CN_RT_QUOTA_ASGNS_ALL
  • CN_RULESETS_ALL_B
  • CN_RULESETS_ALL_TL
  • CN_RULES_ALL_B
  • CN_RULES_ALL_TL
  • CN_RULES_HIERARCHY_ALL
  • CN_RULE_ATTR_EXPRESSION_ALL
  • CN_SALESREPS_API_ALL
  • CN_SCA_ALLOCATIONS_ALL
  • CN_SCA_ALLOC_DETAILS_ALL
  • CN_SCA_COMBINATIONS_ALL
  • CN_SCA_CONDITIONS_ALL
  • CN_SCA_COND_DETAILS_ALL
  • CN_SCA_CREDIT_RULES_ALL
  • CN_SCA_DENORM_RULES_ALL
  • CN_SCA_HEADERS_INTERFACE_ALL
  • CN_SCA_LINES_INTERFACE_ALL
  • CN_SCA_LINES_OUTPUT_ALL
  • CN_SCA_MATCHES_ALL
  • CN_SCA_PROCESS_BATCHES_ALL
  • CN_SCA_RULE_ATTRIBUTES_ALL_B
  • CN_SCA_RULE_ATTRIBUTES_ALL_TL
  • CN_SCA_WINNERS_ALL
  • CN_SCH_DIM_TIERS_ALL
  • CN_SEASONALITIES_ALL
  • CN_SEAS_SCHEDULES_ALL
  • CN_SECURITY_PROFILES_ALL
  • CN_SEC_PROF_ASSIGNS_ALL
  • CN_SF_REPOSITORIES_ALL
  • CN_SOURCE_ALL
  • CN_SRP_CNRT_HISTORY_ALL
  • CN_SRP_COMP_ANCHORS_ALL
  • CN_SRP_CTXN_DATA_ALL
  • CN_SRP_DATA_SUMM_F
  • CN_SRP_DENORM_DATA_ALL
  • CN_SRP_DENORM_DATA_BCK_ALL
  • CN_SRP_INTEL_PERIODS_ALL
  • CN_SRP_PAYEE_ASSIGNS_ALL
  • CN_SRP_PAYOUT_DTLS_ALL
  • CN_SRP_PAY_GROUPS_ALL
  • CN_SRP_PERIODS_ALL
  • CN_SRP_PERIOD_PAYEES_ALL
  • CN_SRP_PERIOD_QUOTAS_ALL
  • CN_SRP_PERIOD_QUOTAS_EXT_ALL
  • CN_SRP_PER_QUOTA_RC_ALL
  • CN_SRP_PLAN_ASSIGNS_ALL
  • CN_SRP_PMT_PLANS_ALL
  • CN_SRP_QUOTA_ASSIGNS_ALL
  • CN_SRP_QUOTA_CATES_ALL
  • CN_SRP_QUOTA_RATES_ALL
  • CN_SRP_QUOTA_RULES_ALL
  • CN_SRP_RATE_ASSIGNS_ALL
  • CN_SRP_ROLE_DTLS_ALL
  • CN_SRP_ROLE_HISTORY_ALL
  • CN_SRP_ROLLOVER_QUOTAS_ALL
  • CN_SRP_RULE_UPLIFTS_ALL
  • CN_SRP_TOTAL_COMPS_ALL
  • CN_TABLE_MAPS_ALL
  • CN_TABLE_MAP_OBJECTS_ALL
  • CN_TRX_ALL
  • CN_TRX_BATCHES_ALL
  • CN_TRX_FACTORS_ALL
  • CN_TRX_LINES_ALL
  • CN_TRX_SALES_LINES_ALL
  • CN_USER_ACCESSES_ALL
  • CN_WORKSHEET_BONUSES_ALL
  • CN_WORKSHEET_QG_DTLS_ALL

Incentive Compensation Profile Options

Oracle Incentive Compensation Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
CN_SRP_ONLY_BATCH_SIZE OSC:Use number of salesreps as the only criteria for determining batch size
CN_USER_TYPE OIC: User’s Type
CN_PAYROLL_ACTION_IF_ENTRY_EXISTS OIC: Approve or Reject Duplicate Payment Transactions
CN_SP_PLANNING_FY OIC: Salesforce Planning FY
CN_CUSTOM_AGGR_TRX OIC: Customized Summarization
CN_PLAN_XML_RPT_QUOTA_ORD OIC:XML Document Quota Period Display Order
CN_PLAN_XML_RPT_QUOTAS OIC:XML Document Max Quota Periods
CN_PLAN_XML_MAX_RTIERS OIC:XML Document Max Rate Tiers Per Table
CN_PMT_SALESREP_BATCH_SIZE Payment Salesrep Batch Size(1)
CN_DB_PARALLEL_ENABLE CN_DB_PARALLEL_ENABLE
CN_CUSTOMER_MERGE_ONLINE OIC:CUST_MERGE_ONLINE
CN_REPORTING_HIERARCHY OIC: Reporting Hierarchy
CN_NUMBER_OF_WORKERS OIC: Number of Batch Workers for Credit Allocation
CN_SCA_REV_NOT_100 OIC: Allow split % less than 100%
CN_CHK_WKSHT_STATUS OIC: Enforce Payment Worksheet Approval
CN_UPGRADING_FROM_RELEASE OIC: Upgrading Incentive Compensation From Which Release
CN_NON_REVENUE_SPLIT OIC: Apply non-revenue split to quantity
CN_R2P_DAYS_PROFILE OIC: Number of skipped days
CN_PAY_BY_TRANSACTION OIC: Pay by Transaction
CN_R2P_ORG_PROFILE OIC: Organization for DBC
CN_RAM_NEGATE OIC: Negate during Revenue Adjustments Collection
CN_INVOICE_SPLIT_UPG_END_DATE OIC: Invoice Split Upgrade End Date
CN_INVOICE_SPLIT_UPG_START_DATE OIC: Invoice Split Upgrade Start Date
CN_ROLL_SUM_TRX OIC: Roll Summarized Transactions
CN_RESET_BALANCES_EACH_YEAR OIC: Reset Balances Each Year
CN_PMT_SRP_BATCH_SIZE Payment Salesrep Batch Size
CN_FFNAME_REV_TYPE OIC: Territory Manager Revenue Type Flex Field
CN_FFNAME_SPLIT_PCTG OIC: Territory Manager Split Percentage Flex Field
CN_SKIP_CREDIT_ALLOCATION OIC: Skip Credit Allocation
CN_PROFILE_NEWS_ITEMS OIC:New Items Profile
CN_PROFILE_DEFAULT_TICKERS OIC:Default Tickers Profile
CN_SCALING OIC: Scaling Factor
CN_SP_DEBUG OIC: Salesforce Planning Debug Mode
CN_MULTI_ROLLUP_PATH OIC: Multi Rollup Path
CN_SP_GL_RATE_DATE OIC: Currency Exchange Rate Date
CN_WF_INIT_WAIT_TIME OIC: Workflow Initial Wait Time in Hours
CN_WF_REMINDER_TIME OIC: Workflow Reminder Frequency in Hours
CN_SFP_RESP_GROUP OIC: SFP Responsibility Group
CN_IMP_SERVER_PATH OIC: SQL Loader Data File Directory
CN_CUST_DISCLAIMER OIC: Income Planner Disclaimer
CN_IMP_CONTROL_PATH OIC: SQL Loader Control File Directory
CN_TRACK_INVOICE OIC: Apply Invoice Splits to Credit Memos and Payments
CN_LOV_INPUT_LEN_PROFILE OIC: LOV Input Validation
CN_RESET_ERROR_TRX OIC: Reset Error Transactions
CN_DISPLAY_DRAW OIC: Display Draw
CN_SFP_USE_WRKDAY OIC: Use Work Day Calendar
CN_ORACLE OIC: Internal Oracle Contract Flag
CN_ENABLE_COMM_STMT_DRILLDOWN OIC: Enable Commission Statement Drilldowns
CN_SFP_DISABLE_WF OIC: SFP Disable Workflow Notifications
CN_R2P_SCALING_FACTOR OIC: DBC Scaling Factor
CN_CONVERSION_TYPE OIC: Default Conversion Type
CN_COLLECT_ON_ACCT_CREDITS OIC: Collect on Account Credits
CN_COMM_RATE_PRECISION OIC: Commission Rate Precision
CN_CUSTOM_FLAG OIC:Default Custom Flag
CN_DEBUG OIC: Enable Debug Mode
CN_LOG_FILE OIC: Enable Logging
CN_LOG_FILE_DIR OIC: Log File Directory
CN_MARK_EVENTS OIC: Enable Incremental Calculation
CN_PRIOR_ADJUSTMENT OIC: Prior Adjustment
CN_REPORT_SECURITY_LEVEL OIC:  Report Security Level
CN_SLEEP_TIME OIC: Frequency of Batch Runners Status Check
CN_USER_EMP_NUM OIC: User’s Employee Number
CN_INCR_CALC_ALL_RSRC OIC: Enable Incremental Calculation for All Resources

Incentive Compensation Forms

Oracle Incentive Compensation Forms:

FORM SHORT CODE ORACLE FORM NAME
CNUINAV OSC UI Navigator
CNPLDF Compensation Plans
CNFORMUL Formulas
CNMDRATE Multi-Dimension Rate Tables
CNPEDEF Plan Element
CNPERFFM Performance Measures
CNSRMT Salespeople
CNTRMA Transaction Maintenance
CNSBCS Calculation Submission
CNSBPS Payment Submission
CNROLE Sales Role Definition
CNSYPR Periods
CNSYEL User Notifications
CNSYPA Process Logs
CNPAYPR Pay Peroids
CNSYSP System Parameters
CNSYTC Tables and Columns
CNCLRL Classification Rules
CNDIHY Dimension Hierarchies
CNSYAM Collections Mapping
CNPGRP Pay Group
CNPMTPLN Payment Plans
CNCGFRM2 Define Compensation Groups
CNSPROF Security Profiles
CNEXTBLM External Table Mapping
CNINTTP Interval Types
CNCRCVFT Credit Type Conversions
CNSBLDGR Compensation Summary
CNSEARCH CN Search
CNREVCLS Revenue Classes
CNCRTPDN Credit Types
CNPOST Posting Details
CNRDIM Rate Dimensions
CNSYCP Collections Runtime Values