You are browsing the archive for Oracle Service Contracts.

Service Contracts Usage Averaging

 

NAME: Service Contracts Usage Averaging
SHORT CODE: OKSBAVSE
MODULE: Oracle Service Contracts

Description: OKS Usage Averaging Program
Navigation: Oracle Service Contracts Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Contract_Number : Contract Number

 

Service Contracts AutoReminder Program

 

NAME: Service Contracts AutoReminder Program
SHORT CODE: OKSAUTOR
MODULE: Oracle Service Contracts

Description:
Navigation: Oracle Service Contracts Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_type : Process Type
  • p_k_status : Contract Status

 

Service Contracts Tables

Oracle Service Contracts Tables:

  • OKS_ACTION_TIMES
  • OKS_ACTION_TIME_TYPES
  • OKS_BCL_PR
  • OKS_BILLING_HIST_INT_ALL
  • OKS_BILLING_PROFILES_B
  • OKS_BILLING_PROFILES_TL
  • OKS_BILLRATE_SCHEDULES
  • OKS_BILL_CONT_LINES
  • OKS_BILL_SUB_LINES
  • OKS_BILL_SUB_LINE_DTLS
  • OKS_BILL_TRANSACTIONS
  • OKS_BILL_TXN_LINES
  • OKS_BSD_PR
  • OKS_BSL_PR
  • OKS_BTL_PR
  • OKS_BTN_PR
  • OKS_CON_COV_LEVELS_INT_ALL
  • OKS_CON_ERRORS_INT_ALL
  • OKS_CON_HEADERS_INT_ALL
  • OKS_CON_LINES_INT_ALL
  • OKS_COVERAGES_INT_ALL
  • OKS_COVERAGE_TIMES
  • OKS_COVERAGE_TIMEZONES
  • OKS_COV_BILL_RATES_INT_ALL
  • OKS_COV_BILL_TYPES_INT_ALL
  • OKS_COV_TXN_GROUPS_INT_ALL
  • OKS_COV_TYPES_B
  • OKS_COV_TYPES_TL
  • OKS_INSTANCE_CONTRACTS_TEMP
  • OKS_INSTANCE_HISTORY
  • OKS_INSTANCE_K_DTLS_TEMP
  • OKS_INST_HIST_DETAILS
  • OKS_INTERACTION_HISTORY
  • OKS_ITEM_SPLIT
  • OKS_JTF_RES_TEMP
  • OKS_K_DEFAULTS
  • OKS_K_HEADERS_B
  • OKS_K_HEADERS_BH
  • OKS_K_LINES_B
  • OKS_K_LINES_BH
  • OKS_K_LINES_TL
  • OKS_K_LINES_TLH
  • OKS_K_ORDER_CONTACTS
  • OKS_K_ORDER_DETAILS
  • OKS_K_RES_TEMP
  • OKS_K_SALES_CREDITS
  • OKS_LEVEL_ELEMENTS
  • OKS_MSCHG_OPERATIONS_DTLS
  • OKS_PM_ACTIVITIES
  • OKS_PM_SCHEDULES
  • OKS_PM_STREAM_LEVELS
  • OKS_PROCESS_CONTROL
  • OKS_QUALIFIERS
  • OKS_REPORT_TEMPLATES
  • OKS_REPROCESSING
  • OKS_REV_DISTRIBUTIONS
  • OKS_RULES_DFF
  • OKS_SERV_AVAILS
  • OKS_SERV_AVAIL_EXCEPTS
  • OKS_STATUS_FORECAST
  • OKS_STREAM_LEVELS_B
  • OKS_STRM_TYPE
  • OKS_SUBSCR_ELEMENTS
  • OKS_SUBSCR_HEADER_B
  • OKS_SUBSCR_HEADER_TL
  • OKS_SUBSCR_PATTERNS
  • OKS_TEMPLATE_SET