OKS Tables (80)

OKS - Service Contracts — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
OKS_ACTION_TIMES	23	This table is suggested to store Reaction/Resolution times.
OKS_ACTION_TIME_TYPES	18	This table is suggested keeping in view the proposed feature to enable user defined time types in future. Action_type_code can be user defin
OKS_BCL_PR	35	Records which are sent to AR.
OKS_BILLING_HIST_INT_ALL	34	This Interface table is used to import Billing History Information for the Contract lines and covered level lines.
OKS_BILLING_PROFILES_B	54	Contains profile information for a customer.
OKS_BILLING_PROFILES_TL	13	Translation Table for table OKS_BILLING_PROFILES
OKS_BILLRATE_SCHEDULES	34	This table stores the bill rate and it's schedules for a service activity billing type defined in Coverage.
OKS_BILL_CONT_LINES	35	Records which are sent to AR.
OKS_BILL_SUB_LINES	32	Related to a lower level contract line eg. coverage level or product.
OKS_BILL_SUB_LINE_DTLS	43	The detail of quantities and monetary amounts either regular or adjustment.
OKS_BILL_TRANSACTIONS	13	The transaction (invoice, credit etc.) which is eventually received from AR.
OKS_BILL_TXN_LINES	37	Holds the actual transaction amount and tax returned from AR.
OKS_BSD_PR	43	The detail of quantities and monetary amounts either regular or adjustment.
OKS_BSL_PR	32	Related to a lower level contract line eg. coverage level or product.
OKS_BTL_PR	31	Holds the actual transaction amount and tax returned from AR.
OKS_BTN_PR	13	The transaction (invoice, credit etc.) which is eventually received from AR.
OKS_CON_COV_LEVELS_INT_ALL	62	This Interface table is used to import covered levels information from legacy/source system to Oracle Contracts for Service applications.
OKS_CON_ERRORS_INT_ALL	16	This table would be using in logging errors during Service Contracts Import.
OKS_CON_HEADERS_INT_ALL	86	This is the interface table for importing Service Contracts Header information.
OKS_CON_LINES_INT_ALL	67	This Interface table is used to import contract lines information to Oracle Contracts for Service application (OKS) as Contract Lines.
OKS_COVERAGES_INT_ALL	35	This interface table is meant to import all the Coverage information to Oracle Contracts for Service module.
OKS_COVERAGE_TIMES	25	This table is suggested to store coverage times for a specific coverage time zone which reference a business process line
OKS_COVERAGE_TIMEZONES	19	This table is suggested to store coverage time zones for a business process line
OKS_COVERED_ACCOUNT_STG_TEMP	5
OKS_COVERED_INSTANCE_STG_TEMP	7
OKS_COVERED_ITEM_STG_TEMP	6
OKS_COVERED_PARTY_STG_TEMP	6
OKS_COVERED_SITE_STG_TEMP	5
OKS_COVERED_SYSTEM_STG_TEMP	4
OKS_COV_BILL_RATES_INT_ALL	29	This Interface table would be used to import Coverage Billing rates (Labor) information to OKS.
OKS_COV_BILL_TYPES_INT_ALL	28	This Interface table would be used to import Coverage Billing types for each business process to OKS.
OKS_COV_TXN_GROUPS_INT_ALL	69	This Interface table would be used to import Business processes , their coverage times, reaction times and resolution times attached to the
OKS_COV_TYPES_B	26	Contains the coverage type code and importance of each coverage type.
OKS_COV_TYPES_TL	11	Translatable columns from OKS_COV_TYPES_B, as per MLS standards.
OKS_DA_INTERFACE_B	9
OKS_INSTANCE_CONTRACTS_TEMP	16
OKS_INSTANCE_HISTORY	14
OKS_INSTANCE_K_DTLS_TEMP	19
OKS_INST_HIST_DETAILS	42
OKS_INTERACTION_HISTORY	17	Interaction history table for auto renewal.
OKS_INT_COVERED_LEVEL_STG_TEMP	9
OKS_INT_ERROR_STG_TEMP	6
OKS_INT_HEADER_STG_TEMP	80
OKS_INT_LINE_STG_TEMP	54
OKS_INT_SALES_CREDIT_STG_TEMP	7
OKS_INT_USAGE_COUNTER_STG_TEMP	24
OKS_JTF_RES_TEMP	8
OKS_K_DEFAULTS	58	This table is used to hold default values used when renewing a service contract or when creating a service contract from an order.The defaul
OKS_K_HEADERS_B	88	Service Contracts Header Attributes
OKS_K_HEADERS_BH	89	Service Contracts Header Attributes History
OKS_K_LINES_B	101	Service Contracts Line Attributes
OKS_K_LINES_BH	99	Service Contracts Line Attributes History
OKS_K_LINES_TL	14	Service Contracts Line Text Attributes
OKS_K_LINES_TLH	15	Service Contracts Line Text Attributes History
OKS_K_ORDER_CONTACTS	12	table for Order Contacts
OKS_K_ORDER_DETAILS	34	This table captures service contract details when a service is ordered in Order Management.
OKS_K_RES_TEMP	17
OKS_K_SALES_CREDITS	14	Records sales credits for the sale of services in a service contract.
OKS_LEVEL_ELEMENTS	22	each individual period within a level
OKS_MSCHG_OPERATIONS_DTLS	29	This table stores masschage related information.
OKS_PM_ACTIVITIES	21	Preventive Maintenance Activities
OKS_PM_SCHEDULES	23	This table will store the schedule details of PM program attached to a coverage.
OKS_PM_STREAM_LEVELS	27	PM Stream Levels
OKS_PROCESS_CONTROL	3	This table is used to store the statistics of a sql file. ie, If a sql file need to be run only once when applying the patch then it will c
OKS_QUALIFIERS	46	Used for Pricing Qualifier setup for Service Authoring
OKS_REPORT_TEMPLATES	19	Stores the reports for each template set.
OKS_REPROCESSING	19
OKS_REV_DISTRIBUTIONS	13	Database table used for storing revenue distribution information for service contract lines.
OKS_RULES_DFF	59	Contracts Rule Definitions table- rules striped
OKS_SERV_AVAILS	31	Stores availability information for a service.
OKS_SERV_AVAIL_EXCEPTS	33	Exception information for a service availabilities.
OKS_STATUS_FORECAST	12	For storing service forecast details
OKS_STREAM_LEVELS_B	29	Service Contracts Billing Stream Levels
OKS_STRM_TYPE	14	Specifies what the stream is for A stream may be a + or - cashflow
OKS_SUBSCR_ELEMENTS	21	Used for Subcription Elements Information
OKS_SUBSCR_HEADER_B	23	Used for Subcription Header Information
OKS_SUBSCR_HEADER_TL	13	Translatable columns from OKS_SUBSCR_HEADER_B, as per MLS standards.
OKS_SUBSCR_PATTERNS	17	Used for Subcription PatternsInformation
OKS_TEMPLATE_SET	16	Stores the template set information.
OKS_USG_QP_CALL_TBL	29