OKC Tables (303)

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

TableColumnsDescription
OKC_11510MIGRATION_T 4 Temp table
OKC_2318603_H_TEMP 3
OKC_2318603_TEMP 2
OKC_ACTIONS_B 33 This table stores information about Actions
OKC_ACTIONS_TL 16 Stores the translatable attributes for actions.
OKC_ACTION_ATTRIBUTES_B 42 Stores attributes that describe the Action.
OKC_ACTION_ATTRIBUTES_TL 13 Translatable columns from OKC_ACTION_ATTRIBUTES_B, as per MLS standards.
OKC_ACTION_ATT_LOOKUPS 11 Defines table/column lookup for an Action Attribute
OKC_ACTION_ATT_VALS 10 Stores value of an instance of Action Attribute for every occurrence of an Action
OKC_ALLOWED_TMPL_USAGES 26 Table that contains document types that are allowed to use a given contract template.
OKC_ANCESTRYS 10 Holds ancestor Contract Lines for a Contract Line.
OKC_APP_FUNCTION_ACCESSES 14 Development-seeded table which is used to control access of objects based on their owning application and the application of the user
OKC_AQERRORS 13 This holds a list of Advanced Queuing (AQ) errors reported by the process(es) subscribing to the Actions AQ.
OKC_AQMSGSTACKS 11 This holds details of the message stack for errors reported from process(es) subscribing to an AQ.
OKC_ARTICLES_ALL 38 This table stores all the clauses that are used for an organization. This includes the standard clauses that exist in the clause library as
OKC_ARTICLE_ADOPTIONS 11 This table stores the adoption details of a global clause version in any given local operating unit. This table has rows for local operatin
OKC_ARTICLE_RELATNS_ALL 10 This table stores the relationship between clauses in an operating unit. e.g. INCOMPATIBLE or ALTERNATE. This table replaces OKC_STD_ART_INC
OKC_ARTICLE_TRANS 12 Relationship between an Article and the Rules or Lines created from it.
OKC_ARTICLE_TRANS_H 13 History Table for table OKC_ARTICLE_TRANSLATIONS
OKC_ARTICLE_VARIABLES 8 This table stores the variables associated with a clause version. The rows in this table are created by the system by extracting the embedd
OKC_ARTICLE_VERSIONS 57 This table stores all the versions of a standard clause and non-standard clause created on a business document. Standard Clauses have multip
OKC_ART_INTERFACE_ALL 61 This is the interface table for import of standard clauses from external systems. All valid data in this table will be imported to OKC_ARTI
OKC_ART_INT_BATPROCS_ALL 25 An internal system table that stores the batch process parameters and statistics for each import run.
OKC_ART_INT_ERRORS 16 This table stores all the errors encountered during the clause import process.
OKC_ART_RELS_INTERFACE 18 This is the interface table for import of relationships between standard clauses from external systems. All valid data in this table will b
OKC_ART_VAR_SECTIONS 11
OKC_ASSENTS 30 Indicates if an Operation is to be performed for a Subclass of Contract while in a Status.
OKC_BUS_DOC_EVENTS_B 12 OKC_BUS_DOC_EVENTS stores valid business document events. These events are seeded per business document type.
OKC_BUS_DOC_EVENTS_TL 10 Stores translatable information for a Business Document Event.
OKC_BUS_DOC_TYPES_B 47 Stores all business document types and preferences related to those documents. This information is seeded by each product team that integrat
OKC_BUS_DOC_TYPES_TL 11 This table stores the translatable attributes of the Business Document Types.
OKC_BUS_VARIABLES_B 49 This table stores all the business variables that can be used in clauses. This table contains variables of all type - System-defined, User-d
OKC_BUS_VARIABLES_TL 11 This table stores the translatable attributes of business variables that can be used in clauses.
OKC_CHANGES_B 27 Documents a change to a Contract as a result of a Change Request.
OKC_CHANGES_TL 12 Translatable columns from OKC_CHANGES_B, as per MLS standards.
OKC_CHANGE_PARTY_ROLE 10 Relates a Contract Party to a Change Request.
OKC_CHANGE_REQUESTS_B 39 A request to make one or more changes to a Contract.
OKC_CHANGE_REQUESTS_TL 12 Translatable columns from OKC_CHANGE_REQUESTS_B, as per MLS standards.
OKC_CLASSES_B 12 The highest level categorization of a Contract.
OKC_CLASSES_TL 13 Translatable columns from OKC_CLASSES_B, as per MLS standards.
OKC_CLASS_OPERATIONS 16 Holds seeded data with allowed operations for various classes
OKC_CLS_CLAUSE_BUFFER_T 36
OKC_CLS_CONFIG_DATA 9
OKC_CLS_REST_CALLS_LOGS 21
OKC_CLS_TOKENS 11
OKC_CONC_REQUESTS 21 Table to launch copy concurrent requests
OKC_CONDITION_HEADERS_B 44 Stores Condition definition.
OKC_CONDITION_HEADERS_BH 44 History table for OKC_CONDITION_HEADERS_B.
OKC_CONDITION_HEADERS_TL 15 Translatable columns from OKC_CONDITION_HEADERS_B, as per MLS standards
OKC_CONDITION_HEADERS_TLH 15 History table for OKC_CONDITION_HEADERS_TL.
OKC_CONDITION_LINES_B 44 Stores boolean expressions which further qualify a Condition Header
OKC_CONDITION_LINES_BH 44 History table for OKC_CONDITION_LINES_B.
OKC_CONDITION_LINES_TL 12 Translatable columns from OKC_CONDITION_LINES_B, as per MLS standards.
OKC_CONDITION_LINES_TLH 12 History table for OKC_CONDITION_LINES_TL.
OKC_CONDITION_OCCURS 10 An occurrence of a Condition defined in OKC_CONDITION_HEADERS_B.
OKC_CONTACTS 37 An individual acting as a contact point or otherwise named in a Contract.
OKC_CONTACTS_H 37 This is a mirror image of base table OKC_CONTACTS, please refer to the base table for detailed column level information.
OKC_CONTACT_SOURCES 16 A valid data source used to define a Contract Contact in a certain role.
OKC_CONTRACT_DOCS 24 This intermediate table is used by Contract Documents to store Business Document attachments entries.
OKC_CONTRACT_RISKS 20 Stores the risks associated with a contract. The Risks are not version-specific.
OKC_COVER_TIMES 10 Associates time components to time values.
OKC_COVER_TIMES_H 11 History Table for OKC_COVER_TIMES
OKC_CR_K_ACCESSES 10 An intersection which associates a contract, change request, process, or user for a change request on a contract.
OKC_DELIVERABLES 99 This table stores Deliverables and amendments to deliverables.
OKC_DELIVERABLES_EXT_B 105
OKC_DELIVERABLES_EXT_TL 52
OKC_DELIVERABLE_TYPES_B 9 Lookup table for all the deliverable types.
OKC_DELIVERABLE_TYPES_TL 11 Stores translatable information for a Deliverable Type
OKC_DEL_BUS_DOC_COMBXNS 8 Contains valid combinations of Business Document Classes and Deliverable Types
OKC_DEL_MESSAGES 15 OKC_DEL_MESSAGES stores the metadata for building various combinations of due date messages for deliverables.
OKC_DEL_STATUS_COMBXNS 9 Contains valid combinations of statuses
OKC_DEL_STATUS_HISTORY 11 Stores deliverable's status change history
OKC_DOC_QA_LISTS 11 This table will store list of all QA checks to be performed for a given business document type, and the severity of the checks.
OKC_EXPRT_IMPORT_REFS 17 This table will store all the references of the Library data imported into Contract Expert
OKC_EXPRT_TEST_T 10 Temporary Table to store all the test data for testing Contract Expert
OKC_FOLDERS_ALL_B 25 This table stores the folders created for an organization. Prior to 11.5.10, folders were stored in FND_LOOKUP_VALUES and were referred to a
OKC_FOLDERS_ALL_TL 10 This table stores the translatable attributes of the folders created for an organization.
OKC_FOLDER_CONTENTS 8 This table stores the clauses associated to a folder. This replaces the table OKC_STD_ART_SET_MEMS used in releases prior to 11.5.10.
OKC_FUNCTION_EXPR_PARAMS 16 The parameter values to be supplied for the function in a CONDITION LINE.
OKC_FUNCTION_EXPR_PARAMS_H 16 The parameters to be supplied to a FUNCTION EXPRESSION.
OKC_GOVERNANCES 15 Intersection entity.
OKC_GOVERNANCES_H 16 History Table for table OKC_GOVERNANCES
OKC_INCLUDED_OPERATIONS 10 Indicates which OPERATIONS are to be allowed for a given status type.
OKC_ITEM_PARTYS_B 27 This table is obsolete
OKC_ITEM_PARTYS_BH 28 This table is obsolete
OKC_ITEM_PARTYS_TL 14 This table is obsolete
OKC_ITEM_PARTYS_TLH 15 This table is obsolete
OKC_KEXP_REPORT 3 This is a temporary table to store the contract search results initiated from contract search screen. These results are later used by dis
OKC_K_ACCESSES 12 Level of access granted to a resource or resource group for a contract.
OKC_K_ACCESSES_H 13 History Table for table OKC_ACCESS_SECURITYS
OKC_K_ARTICLES_B 56 OKC_K_ARTICLES holds the use of standard and non-standard ("custom", one-time use) clauses in business documents.When associated with a docu
OKC_K_ARTICLES_BH 57 History table for OKC_K_ARTICLES_B.
OKC_K_ARTICLES_TL 16 Translatable columns from OKC_K_ARTICLES_B, as per MLS standards.Obsolete table - obsoleted in 11.5.10.
OKC_K_ARTICLES_TLH 17 History table for OKC_K_ARTICLES_TL.Obsolete table - obsoleted in 11.5.10.
OKC_K_ART_VARIABLES 18 Document clause variable table. This will store clause variables used in a document through contract terms
OKC_K_ART_VARIABLES_H 17 Document clause variable history table. This will store clause variables used in a document through contract terms
OKC_K_ART_VAR_EXT_B 105
OKC_K_ART_VAR_EXT_BH 106
OKC_K_ART_VAR_EXT_TL 52
OKC_K_ART_VAR_EXT_TLH 53
OKC_K_ENTITY_LOCKS 16
OKC_K_GROUPS_B 27 A user defined "bucket" for contracts.
OKC_K_GROUPS_TL 13 Translatable columns from OKC_K_GROUPS_B, as per MLS standards.
OKC_K_GRPINGS 12 This table holds the membership of a contract group for both contracts and other contract groups.
OKC_K_HEADERS_ALL_B 103 Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract
OKC_K_HEADERS_ALL_BH 103 This is a mirror image of base table OKC_K_HEADERS_ALL_B, please refer to the base table for detailed column level information
OKC_K_HEADERS_TL 17 Translatable columns from OKC_K_HEADERS_B, as per MLS standards.
OKC_K_HEADERS_TLH 18 This is a mirror image of base table OKC_K_HEADERS_TL, please refer to the base table for detailed column level information.
OKC_K_HISTORY_B 21 Contract status change history and history for any actions during contract life cycle
OKC_K_HISTORY_TL 10 Translatable columns from OKC_K_HISTORY_B, as per MLS standards.
OKC_K_ITEMS 25 Stores item attributes for Contract Lines.
OKC_K_ITEMS_H 24 This is mirror image of base table OKC_K_ITEMS, please refer to the base table for detailed column level information.
OKC_K_LINES_B 94 Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification.
OKC_K_LINES_BH 96 This is a mirror image of base table OKC_K_LINES_B, please refer to the base table for detailed column level information.
OKC_K_LINES_TL 16 Translatable columns from OKC_K_LINES_B, as per MLS standards.
OKC_K_LINES_TLH 17 This is a mirror image of base table OKC_K_LINES_TL, please refer to the base table for detailed column level information.
OKC_K_PARTY_ROLES_B 43 Records the three-way relationship between a contract, the parties to that contract, and the roles that the parties play as they participat
OKC_K_PARTY_ROLES_BH 41 This is a mirror image of base table OKC_K_PARTY_ROLES_B, please refer to the base table for detailed column level information.
OKC_K_PARTY_ROLES_TL 12 Translatable columns from OKC_K_PARTY_ROLES_B, as per MLS standards.
OKC_K_PARTY_ROLES_TLH 13 This is a mirror image of base table OKC_K_PARTY_ROLES_TL, please refer to the base table for detailed column level information.
OKC_K_PROCESSES 30 Defines the use of a particular process for a particular contract.
OKC_K_PROCESSES_H 31 This is a mirror image of base table OKC_K_PROCESSES, please refer to the base table for detailed column level information
OKC_K_REL_OBJS 30 An intersection entity which links a contract header or line to other objects in the schema in a predefined manner.
OKC_K_SALES_CREDITS 15 Records sales credits for the sale of services in a service contract.
OKC_K_SALES_CREDITS_H 16 This is a mirror image of base table OKC_K_SALES_CREDITS, please refer to the base table for detailed column level information
OKC_K_SEQ_HEADER 14 Holds the configuration rules for Autonumbering setup
OKC_K_SEQ_LINES 20 Holds the detail records for Autonumbering configuration
OKC_K_VERS_NUMBERS 10 Indicates the current version of the contract as a document.
OKC_K_VERS_NUMBERS_H 10 This is a mirror image of base table OKC_K_VERS_NUMBERS, please refer to the base table for detailed column level information.
OKC_LINE_STYLES_B 36 OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract.
OKC_LINE_STYLES_TL 13 Translatable columns from OKC_LINE_STYLES_B, as per MLS standards.
OKC_LINE_STYLE_ROLES 11 Party roles that may be associated with a contract line of a certain line style.
OKC_LINE_STYLE_SOURCES 13 Valid data sources for contract lines of a certain line style.
OKC_LSE_RULE_GROUPS 11 Rule groups associated with a contract line of a certain line style.
OKC_MASSCHANGE_REQ_DTLS 13 This table contains the details of the change requested in the mass change operation.
OKC_MLP_TEMPLATE_USAGES 21
OKC_MRV_T 6
OKC_NUMBER_SCHEMES_B 9 Translation table for Numbering schemes
OKC_NUMBER_SCHEMES_TL 10 Numbering schemes translation table
OKC_NUMBER_SCHEME_DTLS 11 Store the details for Numbering Schemes.
OKC_OPERATIONS_B 11 Set of processes performed by the application to, or as a result of, a contract.
OKC_OPERATIONS_TL 14 Translatable columns from OKC_OPERATIONS_B, as per MLS standards.
OKC_OPERATION_INSTANCES 20 An Operation Instance is an instance of a Contract Operation. The Operation Instance contains information about the instance and serves as a
OKC_OPERATION_LINES 22 The Operation Line provides additional information about what did happen or will happen for an Operation Instance.
OKC_OUTCOMES_B 33 Indicates the use of a process definition by a condition.
OKC_OUTCOMES_BH 33 This is a mirror image of base table OKC_OUTCOMES_B, please refer to the base table for detailed column level information
OKC_OUTCOMES_TL 12 Translatable columns from OKC_OUTCOMES_B, as per MLS standards.
OKC_OUTCOMES_TLH 12 This is a mirror image of base table OKC_OUTCOMES_TL, please refer to the base table for detailed column level information
OKC_OUTCOME_ARGUMENTS 16 Values to pass to process definition parameters.
OKC_OUTCOME_ARGUMENTS_H 16 This is a mirror image of base table OKC_OUTCOME_ARGUMENTS, please refer to the base table for detailed column level information
OKC_PH_LINE_BREAKS 23 This table will store the information about line breaks on a price hold - Not Used
OKC_PH_LINE_BREAKS_H 24 This is a mirror image of base table OKC_PH_LINE_BREAKS, please refer to the base table for detailed column level information - Not Used
OKC_PRICE_ADJUSTMENTS 68 Record of actual adjustments made to price based on price attribute values.
OKC_PRICE_ADJUSTMENTS_H 69 This is a mirror image of base table OKC_PRICE_ADJUSTMENTS, please refer to the base table for detailed column level information.
OKC_PRICE_ADJ_ASSOCS 17 Associates price adjustments to the object for which price has been adjusted.
OKC_PRICE_ADJ_ASSOCS_H 18 This is a mirror image of base table OKC_PRICE_ADJ_ASSOCS, please refer to the base table for detailed column level information.
OKC_PRICE_ADJ_ATTRIBS 19 Price attribute values which are based on a price adjustment.
OKC_PRICE_ADJ_ATTRIBS_H 20 This is a mirror image of base table OKC_PRICE_ADJ_ATTRIBS, please refer to the base table for detailed column level information.
OKC_PRICE_ATT_VALUES 217 Values of price attributes for an object to be used to derive the price for a contract header and contract line
OKC_PRICE_ATT_VALUES_H 218 Values of price attributes for an object to be used to derive the price for a contract header and contract line.
OKC_PROCESS_DEFS_B 38 This table stores information of PL/SQL processes or workflows within the application which are used as OUTCOME, CONTRACT PROCESS, QA PROCES
OKC_PROCESS_DEFS_TL 15 Translatable columns from OKC_PROCESS_DEFS_B, as per MLS standards.
OKC_PROCESS_DEF_PARMS_B 19 Records the parameters for a process definition, including such information as the parameter name, datatype, optionality, and default value.
OKC_PROCESS_DEF_PARMS_TL 13 Translatable columns from OKC_PROCESS_DEF_PARMS_B, as per MLS standards.
OKC_QA_CHECK_LISTS_B 29 Associates a list of quality assurance processes with a specific contract or contract template.
OKC_QA_CHECK_LISTS_TL 13 Translatable columns from OKC_QA_CHECK_LISTS_B, as per MLS standards.
OKC_QA_ERRORS_T 24 Temporary table to store quality assurance check errors and warnings
OKC_QA_LIST_PROCESSES 30 The usage of a process def in a particular QA check list.
OKC_QA_PROCESS_PARMS 29 Values to be provided to the process parameters when the QA check list is run.
OKC_QP_UPGRADE 12
OKC_REACT_INTERVALS 12 Duration of time within which reaction must occur for particular periods of time.
OKC_REACT_INTERVALS_H 13 History Table for table OKC_REACTION_INTERVALS
OKC_REPORT_HTM 13 Used for Contract Printing. Keeps HTML document produced withsql-xml-xsl-html transformation based on the query and stylesheet selected.
OKC_REPORT_PRM_B 14 SQL-XML Parameters. Used for Contract Printing
OKC_REPORT_PRM_TL 11 SQL-XML Parameters. Used for Contract Printing
OKC_REPORT_SQL_B 14 Used for Contract Printing. Keeps query for the sql-xml-xsl-html report.
OKC_REPORT_SQL_TL 12 Used for Contract Printing. Keeps help text about xml structure produced with XSUtilitybased on the query.Usage: for XSL writer.
OKC_REPORT_TAG_B 11 Published XML tags. Used for Contract Printing.Prior to 11.5.9 tags published in help tab.
OKC_REPORT_TAG_TL 11 Published XML tags. Used in Contracts Printing.Prior to 11.5.9 tags published in help tab.
OKC_REPORT_XML 12 Used for Contract Printing. Keeps XML document produced with XSUtility based on the query.
OKC_REPORT_XSL_B 11 Used for Contract Printing. Keeps stylesheet that drives XSLT in sql-xml-xsl-html report.
OKC_REPORT_XSL_TL 14 Used for Contract Printing. Stylesheet that drives XSLT in sql-xml-xsl-html report.Help text about tokens defined in stylesheet, usage: for
OKC_REPORT_XST 12 Used for Contract Printing. Combinations of sql and xsl that can produce reportwith sql-xml-xsl-html transformations.
OKC_REP_BOOKMARKS 10 Contract Repository. This table stores bookmarks created by users to access contracts quickly.
OKC_REP_CONTACT_ROLES_B 10 This table stores user-defined Contact Roles.
OKC_REP_CONTACT_ROLES_TL 11 This table stores the translatable information for Contact Roles.
OKC_REP_CONTRACTS_ALL 70 This table is the main Contracts table. This table stores the latest version of all contracts authored in Contract Repository.
OKC_REP_CONTRACTS_ALL_EXT_B 107
OKC_REP_CONTRACTS_ALL_EXT_TL 54
OKC_REP_CONTRACT_PARTIES 14 This table stores the Parties in a Contract. The Party can be from PO_VENDORS, HZ_PARTIES, or HR_ALL_ORGANIZATION_UNITS. A PARTY_ID with a
OKC_REP_CONTRACT_RELS 9 This table stores a relationship between two contracts that are created in Repository.
OKC_REP_CONTRACT_USAGES 30
OKC_REP_CONTRACT_VERS 70 This table stores previous versions of a contract.
OKC_REP_CONTRACT_VERS_EXT_B 106
OKC_REP_CONTRACT_VERS_EXT_TL 53
OKC_REP_CON_ACTIONS 11 This table stores valid 'Actions' for a given page mode and contract status. This is a SEED data table.
OKC_REP_CON_APPROVALS 13 This table stores a Contract's approval data. .
OKC_REP_CON_STATUS_HIST 11 This table stores the status changes history of a contract. Each version of a contract can have its own status history.
OKC_REP_IMP_CONTACTS_T 20
OKC_REP_IMP_CONTRACTS_T 64 This is a temporary table for storing imported contract header attributes. It is used for validating contract attributes, preparing contract
OKC_REP_IMP_DOCUMENTS_T 17 This is a temporary table for storing imported Contract Documents attributes. It is used for validating Contract Documents and generating er
OKC_REP_IMP_ERRORS_T 11 This is a temporary table that stores the error messages generated during the validation of the Import data. It is used to generate the out
OKC_REP_IMP_PARTIES_T 18 This is a temporary table for storing an imported contract party's attributes. It is used for validating contract parties, preparing partie
OKC_REP_IMP_RISKS_T 22
OKC_REP_PARTY_CONTACTS 17 This table stores the contacts for a party in a contract. The contact record can be from PO_VENDOR_CONTACTS, HZ_PARTIES, or PER_PEOPLE_F, d
OKC_REP_RECENT_CONTRACTS 9 The table stores a reference to the contract that a user recently viewed from the Contract Repository.
OKC_REP_RELATIONSHIPS_B 11 This table stores the seeded contract Relationships for Contract Repository.
OKC_REP_RELATIONSHIPS_TL 12 This table stores the translatable information for Contract Relationships.
OKC_REP_SIGNATURE_DETAILS 24 This table stores the Signature details of a Contract Party.
OKC_RESOLVED_TIMEVALUES 11 Instantiates a TIMEVALUE definition as an absolute trackable date.
OKC_RESP_PARTIES_B 11 This table contains responsible party codes for Contracts and Deliverables, striped by intent.
OKC_RESP_PARTIES_TL 14 Stores translatable information for the Responsible Party on a Contract or Deliverable
OKC_REVIEW_MESSAGES 6 This table is used to store the messages during the upoload of Word document
OKC_REVIEW_UPLD_HEADER 15 This table stores the header information during the upload of word document to strucutred terms
OKC_REVIEW_UPLD_TERMS 28 This table stores the details during the upload of a word dpcument to structured terms
OKC_REVIEW_VAR_VALUES 17 This table stores the variable information during the upload of word document to structured terms
OKC_RG_DEF_RULES 16 Defines what rule definitions are associated with what rule group definitions and the optionality of that association.
OKC_RG_PARTY_ROLES 12 Defines which party in a contract is acting as the subject of a rule group and which is acting as the object of the rule group.
OKC_RG_PARTY_ROLES_H 13 History Table for table OKC_RULE_GROUP_MODES
OKC_RG_ROLE_DEFS 30 Defines which roles can act as subject or object for a rule group for a contract subclass.
OKC_RISK_EVENTS_B 9 Stores the user-defined risk events.
OKC_RISK_EVENTS_TL 10 Translation table for Risk Events.
OKC_ROLES_B 12 For future use
OKC_ROLES_TL 12 For future use
OKC_ROLE_SOURCES 14 Defines the valid data sources for a PARTY playing a certain ROLE in a contract.
OKC_RULES_B 60 Structured data representation of free format text contained in an ARTICLE.
OKC_RULES_BH 61 History table for OKC_RULES_B.
OKC_RULES_TL 12 Translatable columns from OKC_RULES_B, as per MLS standards.
OKC_RULES_TLH 13 History table for OKC_RULES_TL.
OKC_RULE_DEFS_B 11 Contracts Rule Definitions base table- rules striped
OKC_RULE_DEFS_TL 13 Contracts Rule Definitions traslation table- rules striped
OKC_RULE_DEF_SOURCES 16 Valid data sources for a rule when it is used in a rule group.
OKC_RULE_GROUPS_B 31 Collection of RULES needed to inform an automated process about a business function.
OKC_RULE_GROUPS_BH 32 History table for OKC_RULE_GROUPS_B.
OKC_RULE_GROUPS_TL 11 Translatable columns from OKC_RULE_GROUPS_B, as per MLS standards.
OKC_RULE_GROUPS_TLH 12 History table for OKC_RULE_GROUPS_TL.
OKC_SCN_MAP_INTERFACE 5
OKC_SECTIONS_B 45 Sections are used to format clauses of a Contract while printing
OKC_SECTIONS_BH 46 History table for OKC_SECTIONS_B
OKC_SECTIONS_TL 11 Translatable columns from OKC_SECTIONS_B, as per MLS standards.Obsolete table - obsoleted in 11.5.10.
OKC_SECTIONS_TLH 12 Translatable columns from OKC_SECTIONS_B, as per MLS standards.Obsolete table - obsoleted in 11.5.10.
OKC_SECTION_CONTENTS 30 This table holds the components of a section like a label or article
OKC_SECTION_CONTENTS_H 31 History table for OKC_SECTION_CONTENTS
OKC_SPAN 30 Defines the legs, stages or intervals which compose a cycle, including their duration in some designated time unit.
OKC_STATUSES_B 13 User defined values that define a contract's status.
OKC_STATUSES_TL 13 Translatable columns from OKC_STATUSES_B, as per MLS standards.
OKC_STD_ARTICLES_B 25 Standard text commonly used in the creation of a contract. Desupported from 11.5.10 onwards.
OKC_STD_ARTICLES_TL 11 Translatable columns from OKC_STD_ARTICLES_B, as per MLS standards. Desupported from 11.5.10 onwards.
OKC_STD_ART_CLASSINGS 11 Defines which Standard Article Sets are commonly used in a certain subclass of contract.
OKC_STD_ART_INCMPTS 9 Registers incompatiblities between standard articles.
OKC_STD_ART_SET_MEMS 9 Records the membership of articles in a Standard Article Set.
OKC_STD_ART_VERSIONS_B 26 Maintains prior and future text for Standard Articles.
OKC_STD_ART_VERSIONS_TL 14 Translatable columns from OKC_STD_ART_VERSIONS_B, as per MLS standards.
OKC_SUBCLASSES_B 14 Determines the line style hiearchy of the contract, the valid rule groups, the valid party roles, and the commonly used standard article set
OKC_SUBCLASSES_TL 13 Translatable columns from OKC_SUBCLASSES_B, as per MLS standards.
OKC_SUBCLASS_RESPS 11 Defines the access level granted to a subclass of contract for a specific AOL responsibility.
OKC_SUBCLASS_RG_DEFS 14 Associates a SUBCLASS with a rule group definition.
OKC_SUBCLASS_ROLES 14 Associates a subclass with a role.
OKC_SUBCLASS_TOP_LINE 13 Associates a subclass with a top line in a line style hierarchy.
OKC_SUBJECT_GROUPS 9 Allows subjects to be grouped hierarchically to make it easier to organize and find articles.
OKC_TEMPLATE_USAGES 29 This entity will contain relationship between template and document where it is used.
OKC_TEMPLATE_USAGES_H 30 This entity will contain relationship between template and document where it is used. (history records)
OKC_TEMP_QA_RESULTS 10
OKC_TERMS_CLM_UDV_T 6
OKC_TERMS_DEVIATIONS_T 38 Temporary Table to store Contract Standard Deviations data
OKC_TERMS_TEMPLATES_ALL 50 Master table for contract terms templates
OKC_TERMS_UDV_WITH_PROCEDURE_T 6
OKC_TIMEVALUES 51 Quantifies the time component of a rule.
OKC_TIMEVALUES_B 47 Quantifies the time component of a rule.
OKC_TIMEVALUES_BH 48 History table for OKC_TIMEVALUES_B.
OKC_TIMEVALUES_H 52 This is a mirror image of base table OKC_TIMEVALUES, please refer to the base table for detailed column level information
OKC_TIMEVALUES_TL 14 This table is now obsolete
OKC_TIMEVALUES_TLH 15 This table is now obsolete
OKC_TIME_CODE_UNITS_B 27 Used to map the user defined time units in MTL_UNITS_OF_MEASURE to the known time units.
OKC_TIME_CODE_UNITS_TL 14 Translatable columns from OKC_TIME_CODE_UNITS_B, as per MLS standards.
OKC_TMPL_DRAFT_CLAUSES 15
OKC_UDA_TEMPLATES_ALL 17
OKC_USER_BINS 11 Denormalized entity used to maintain various lists of contracts for user portals.
OKC_USER_HOOK_CALLS 28 Calls made to pl/sql routines.
OKC_USER_HOOK_CALLS_H 29 This is a mirror image of base table OKC_USER_HOOK_CALLS, please refer to the base table for detailed column level information
OKC_VALUESETS_INTERFACE 24 This is the interface table for import of fnd flex value sets from external systems. All valid data in this table will be imported to FND s
OKC_VAL_LINE_OPERATIONS 10 Defines which line operations are valid choices for a top line style.
OKC_VARIABLES_INTERFACE 48 This is the interface table for import of user defined variables from external systems. All valid data in this table will be imported to OK
OKC_VARIABLE_DOC_TYPES 13 This table stores the document types that are associated to system-defined variables. This is used to determine the source of the system va
OKC_VS_VALUES_INTERFACE 22 This is the interface table for import of fnd flex values from external systems. All valid data in this table will be imported to FND schem
OKC_WORD_SYNC_T 7 Temporary table to store the contract document and clauses in word format
OKC_XPRT_DEVIATIONS_T 8 Temporary Table to store Contract Standard Deviation details (expert rule conditions with document values) data
OKC_XPRT_DOC_QUES_RESPONSE 5
OKC_XPRT_DOC_QUES_RESPONSE_H 6
OKC_XPRT_QUESTIONS_B 20 This entity stores the user questions, constants and expert variables.
OKC_XPRT_QUESTIONS_TL 12 Translation table for OKC_XPRT_QUESTIONS_B.
OKC_XPRT_QUESTION_ORDERS 13 This entity stores the order of the questions to be displayed at runtime. This is an intersection entity between templates and questions.
OKC_XPRT_RULE_CONDITIONS 15 This table stores all the conditions of the rules. This is a child entity of rule header entity.
OKC_XPRT_RULE_COND_ACTIVE 15 This table stores all the conditions of the rules. This is a child entity of rule header entity.
OKC_XPRT_RULE_COND_VALS 9 This table stores all the conditions values in expert rules. This is a child entity of rules conditions entity. This is required mainly to s
OKC_XPRT_RULE_COND_VALS_ACTIVE 9 This table stores all the conditions values in expert rules. This is a child entity of rules conditions entity. This is required mainly to s
OKC_XPRT_RULE_EVAL_CONDVAL_T 8 This table stores the document values needed for the rule condition evaluation
OKC_XPRT_RULE_EVAL_RESULT_T 12 This table stores the evaluation result of the rules and conditions at any point of time
OKC_XPRT_RULE_HDRS_ALL 22 This table has the rule header information for template specific rules as well as rules assigned at all templates in the Operating Unit
OKC_XPRT_RULE_HDRS_ALL_ACTIVE 22 This table has the header information of the active rules which are currenlty being revised
OKC_XPRT_RULE_OUTCOMES 12 This table will store the results defined in the expert rules. This is a child entity of rules header entity
OKC_XPRT_RULE_OUTCOMES_ACTIVE 12 This table will store the results defined in the expert rules. This is a child entity of rules header entity
OKC_XPRT_TEMPLATE_RULES 11 Intersection entity between rules and templates