Search Results what is the risk of low production efficiency
The OKC_RISK_EVENTS_B
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Oracle Contracts module, specifically designed to store risk event data associated with contractual agreements. This table serves as the foundation for managing risk-related information, enabling organizations to track, analyze, and mitigate potential risks tied to contractual obligations. Below is a detailed summary of its structure, purpose, and integration within Oracle EBS.
Overview and Purpose
The OKC_RISK_EVENTS_B
table is part of the Oracle Contracts Core schema, which facilitates comprehensive contract lifecycle management. Risk events represent potential or actual occurrences that may impact contractual performance, financial outcomes, or compliance. This table captures essential details about these events, such as event type, severity, status, and associated contract references. By maintaining this data, organizations can proactively address risks, ensuring contractual adherence and minimizing financial or operational exposure.
Key Columns and Structure
The table comprises several key columns, each serving a distinct purpose:
- RISK_EVENT_ID: Primary key uniquely identifying each risk event.
- CONTRACT_ID: Foreign key linking the risk event to a specific contract in the
OKC_K_HEADERS_B
table. - EVENT_TYPE_CODE: Categorizes the risk event (e.g., financial, operational, legal).
- SEVERITY_CODE: Indicates the impact level (e.g., low, medium, high).
- STATUS_CODE: Tracks the event's lifecycle stage (e.g., open, in progress, resolved).
- DESCRIPTION: Detailed narrative of the risk event.
- CREATION_DATE and LAST_UPDATE_DATE: Audit columns recording when the event was created or modified.
- CREATED_BY and LAST_UPDATED_BY: Audit columns capturing the user responsible for the record.
Integration with Oracle EBS Modules
The OKC_RISK_EVENTS_B
table integrates with multiple Oracle EBS modules to provide a holistic view of contractual risks:
- Oracle Contracts Core: Directly links to contract headers (
OKC_K_HEADERS_B
) and lines (OKC_K_LINES_B
), ensuring risk events are tied to specific contractual terms. - Oracle Projects: Risk events may impact project deliverables, budgets, or timelines, necessitating synchronization with project management data.
- Oracle Financials: Financial risks (e.g., payment delays, penalties) may trigger adjustments in accounts payable/receivable or general ledger entries.
- Oracle Advanced Supply Chain: Operational risks (e.g., supplier delays) may affect procurement or inventory workflows.
Functional Significance
The table supports critical business processes:
- Risk Mitigation: Enables proactive identification and resolution of risks through alerts, workflows, and reporting.
- Compliance Tracking: Helps organizations adhere to regulatory requirements by documenting risk events and remediation efforts.
- Performance Analytics: Provides data for dashboards and reports, aiding in trend analysis and decision-making.
Technical Considerations
In Oracle EBS 12.1.1 and 12.2.2, the table adheres to standard Oracle database conventions, including:
- Indexing on
RISK_EVENT_ID
andCONTRACT_ID
for performance optimization. - Foreign key constraints ensuring data integrity with related tables.
- PL/SQL APIs for programmatic access and manipulation of risk event data.
Conclusion
The OKC_RISK_EVENTS_B
table is a pivotal element in Oracle EBS's contract risk management framework. By centralizing risk event data and integrating with core modules, it empowers organizations to manage contractual risks effectively, ensuring operational resilience and compliance. Its structured design and seamless interoperability make it indispensable for enterprises leveraging Oracle Contracts in EBS 12.1.1 or 12.2.2.
-
Lookup Type: OKC_RISK_LEVELS
12.1.1
product: OKC - Contracts Core , meaning: Risk levels , description: Risk levels for Repository contracts ,
-
Lookup Type: OKC_RISK_LEVELS
12.2.2
product: OKC - Contracts Core , meaning: Risk levels , description: Risk levels for Repository contracts ,
-
Table: OKC_RISK_EVENTS_B
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RISK_EVENTS_B, object_name:OKC_RISK_EVENTS_B, status:VALID, product: OKC - Contracts Core , description: Stores the user-defined risk events. , implementation_dba_data: OKC.OKC_RISK_EVENTS_B ,
-
Table: OKC_RISK_EVENTS_B
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RISK_EVENTS_B, object_name:OKC_RISK_EVENTS_B, status:VALID, product: OKC - Contracts Core , description: Stores the user-defined risk events. , implementation_dba_data: OKC.OKC_RISK_EVENTS_B ,
-
Table: OKC_RISK_EVENTS_TL
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RISK_EVENTS_TL, object_name:OKC_RISK_EVENTS_TL, status:VALID, product: OKC - Contracts Core , description: Translation table for Risk Events. , implementation_dba_data: OKC.OKC_RISK_EVENTS_TL ,
-
Table: OKC_RISK_EVENTS_TL
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RISK_EVENTS_TL, object_name:OKC_RISK_EVENTS_TL, status:VALID, product: OKC - Contracts Core , description: Translation table for Risk Events. , implementation_dba_data: OKC.OKC_RISK_EVENTS_TL ,
-
Table: OKC_RG_DEF_RULES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RG_DEF_RULES, object_name:OKC_RG_DEF_RULES, status:VALID, product: OKC - Contracts Core , description: Defines what rule definitions are associated with what rule group definitions and the optionality of that association. , implementation_dba_data: OKC.OKC_RG_DEF_RULES ,
-
Table: OKC_RG_DEF_RULES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RG_DEF_RULES, object_name:OKC_RG_DEF_RULES, status:VALID, product: OKC - Contracts Core , description: Defines what rule definitions are associated with what rule group definitions and the optionality of that association. , implementation_dba_data: OKC.OKC_RG_DEF_RULES ,
-
Table: OKC_OPERATION_LINES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_OPERATION_LINES, object_name:OKC_OPERATION_LINES, status:VALID, product: OKC - Contracts Core , description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. , implementation_dba_data: OKC.OKC_OPERATION_LINES ,
-
Table: OKC_OPERATION_LINES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_OPERATION_LINES, object_name:OKC_OPERATION_LINES, status:VALID, product: OKC - Contracts Core , description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. , implementation_dba_data: OKC.OKC_OPERATION_LINES ,
-
Lookup Type: OKC_TERM_QA_LIST
12.1.1
product: OKC - Contracts Core , meaning: OKC_TERM_QA_LIST ,
-
Lookup Type: OKC_TERM_QA_LIST
12.2.2
product: OKC - Contracts Core , meaning: OKC_TERM_QA_LIST ,
-
Table: OKC_XPRT_RULE_COND_VALS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_COND_VALS, object_name:OKC_XPRT_RULE_COND_VALS, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions values in expert rules. This is a child entity of rules conditions entity. This is required mainly because the RHS of the condition can have multiple values. , implementation_dba_data: OKC.OKC_XPRT_RULE_COND_VALS ,
-
Table: OKC_REP_BOOKMARKS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_BOOKMARKS, object_name:OKC_REP_BOOKMARKS, status:VALID, product: OKC - Contracts Core , description: Stores bookmarks to different object types. BOOKMARK_TYPE_CODE defines the type of the object that is bookmarked. OBJECT_ID is the primary key of that object. , implementation_dba_data: OKC.OKC_REP_BOOKMARKS ,
-
Table: OKC_RG_PARTY_ROLES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RG_PARTY_ROLES, object_name:OKC_RG_PARTY_ROLES, status:VALID, product: OKC - Contracts Core , description: 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. , implementation_dba_data: OKC.OKC_RG_PARTY_ROLES ,
-
Table: OKC_RG_PARTY_ROLES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_RG_PARTY_ROLES, object_name:OKC_RG_PARTY_ROLES, status:VALID, product: OKC - Contracts Core , description: 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. , implementation_dba_data: OKC.OKC_RG_PARTY_ROLES ,
-
Table: OKC_REP_IMP_ERRORS_T
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_IMP_ERRORS_T, object_name:OKC_REP_IMP_ERRORS_T, status:VALID, product: OKC - Contracts Core , description: This is a temporary table that stores the error messages generated during the validation of the Import data. It is used to generate the output CSV file with the invalid records and the relevant error messages. The data is deleted after ea , implementation_dba_data: OKC.OKC_REP_IMP_ERRORS_T ,
-
Lookup Type: OKC_LINE_RENEWAL_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Contract Line Renewal Types , description: Types of renewal for contract lines ,
-
Lookup Type: OKC_LINE_RENEWAL_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Contract Line Renewal Types , description: Types of renewal for contract lines ,
-
Table: OKC_XPRT_RULE_COND_ACTIVE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_COND_ACTIVE, object_name:OKC_XPRT_RULE_COND_ACTIVE, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions of the rules. This is a child entity of rule header entity. , implementation_dba_data: OKC.OKC_XPRT_RULE_COND_ACTIVE ,
-
Table: OKC_APP_FUNCTION_ACCESSES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_APP_FUNCTION_ACCESSES, object_name:OKC_APP_FUNCTION_ACCESSES, status:VALID, product: OKC - Contracts Core , description: Development-seeded table which is used to control access of objects based on their owning application and the application of the user , implementation_dba_data: OKC.OKC_APP_FUNCTION_ACCESSES ,
-
Table: OKC_APP_FUNCTION_ACCESSES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_APP_FUNCTION_ACCESSES, object_name:OKC_APP_FUNCTION_ACCESSES, status:VALID, product: OKC - Contracts Core , description: Development-seeded table which is used to control access of objects based on their owning application and the application of the user , implementation_dba_data: OKC.OKC_APP_FUNCTION_ACCESSES ,
-
Table: OKC_XPRT_RULE_CONDITIONS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_CONDITIONS, object_name:OKC_XPRT_RULE_CONDITIONS, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions of the rules. This is a child entity of rule header entity. , implementation_dba_data: OKC.OKC_XPRT_RULE_CONDITIONS ,
-
Table: OKC_XPRT_RULE_OUTCOMES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_OUTCOMES, object_name:OKC_XPRT_RULE_OUTCOMES, status:VALID, product: OKC - Contracts Core , description: This table will store the results of the expert rules. This is a child entity of rules header entity. , implementation_dba_data: OKC.OKC_XPRT_RULE_OUTCOMES ,
-
Table: OKC_XPRT_RULE_CONDITIONS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_CONDITIONS, object_name:OKC_XPRT_RULE_CONDITIONS, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions of the rules. This is a child entity of rule header entity. , implementation_dba_data: OKC.OKC_XPRT_RULE_CONDITIONS ,
-
Lookup Type: OKC_RENEWAL_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Contract Renewal Types , description: Types of renewal for contracts ,
-
Lookup Type: OKC_RENEWAL_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Contract Renewal Types , description: Types of renewal for contracts ,
-
Table: OKC_VARIABLE_DOC_TYPES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_VARIABLE_DOC_TYPES, object_name:OKC_VARIABLE_DOC_TYPES, status:VALID, product: OKC - Contracts Core , description: This table stores the document types that are associated to system-defined variables. This is used to determine the source of the system variable values. , implementation_dba_data: OKC.OKC_VARIABLE_DOC_TYPES ,
-
Table: OKC_REVIEW_MESSAGES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REVIEW_MESSAGES, object_name:OKC_REVIEW_MESSAGES, status:VALID, product: OKC - Contracts Core , description: This table is used to store the messages during the upoload of Word document , implementation_dba_data: OKC.OKC_REVIEW_MESSAGES ,
-
Table: OKC_ART_INTERFACE_ALL
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_ART_INTERFACE_ALL, object_name:OKC_ART_INTERFACE_ALL, status:VALID, product: OKC - Contracts Core , description: This is the interface table for import of standard clauses from external systems. All valid data in this table will be imported to OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS and OKC_ARTICLE_ADOPTIONS by the Clause Import Concurrent program. The , implementation_dba_data: OKC.OKC_ART_INTERFACE_ALL ,
-
Lookup Type: OKC_REL_OBJ
12.2.2
product: OKC - Contracts Core , meaning: Contract related Objects , description: Contract related Objects ,
-
Table: OKC_XPRT_RULE_OUTCOMES_ACTIVE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_OUTCOMES_ACTIVE, object_name:OKC_XPRT_RULE_OUTCOMES_ACTIVE, status:VALID, product: OKC - Contracts Core , description: This table will store the results defined in the expert rules. This is a child entity of rules header entity , implementation_dba_data: OKC.OKC_XPRT_RULE_OUTCOMES_ACTIVE ,
-
Lookup Type: OKC_REL_OBJ
12.1.1
product: OKC - Contracts Core , meaning: Contract related Objects , description: Contract related Objects ,
-
Table: OKC_REP_CONTRACT_RELS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_CONTRACT_RELS, object_name:OKC_REP_CONTRACT_RELS, status:VALID, product: OKC - Contracts Core , description: Stores the relationship between two contracts. The two related contracts are CONTRACT_ID and RELATED_CONTRACT_ID. RELATED_CONTRACT_ROLE is the role of contract RELATED_CONTRACT_ID. , implementation_dba_data: OKC.OKC_REP_CONTRACT_RELS ,
-
Table: OKC_VARIABLES_INTERFACE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_VARIABLES_INTERFACE, object_name:OKC_VARIABLES_INTERFACE, status:VALID, product: OKC - Contracts Core , description: This is the interface table for import of user defined variables from external systems. All valid data in this table will be imported to OKC_BUS_VARIABLES_B, OKC_BUS_VARIABLES_TL by the XML Based Clause Import Concurrent program. The user , implementation_dba_data: OKC.OKC_VARIABLES_INTERFACE ,
-
Table: OKC_VARIABLE_DOC_TYPES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_VARIABLE_DOC_TYPES, object_name:OKC_VARIABLE_DOC_TYPES, status:VALID, product: OKC - Contracts Core , description: This table stores the document types that are associated to system-defined variables. This is used to determine the source of the system variable values. , implementation_dba_data: OKC.OKC_VARIABLE_DOC_TYPES ,
-
Table: OKC_XPRT_QUESTION_ORDERS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_QUESTION_ORDERS, object_name:OKC_XPRT_QUESTION_ORDERS, status:VALID, product: OKC - Contracts Core , description: This entity stores the order of the questions to be displayed at runtime. This is an intersection entity between templates and questions. , implementation_dba_data: OKC.OKC_XPRT_QUESTION_ORDERS ,
-
Table: OKC_VALUESETS_INTERFACE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_VALUESETS_INTERFACE, object_name:OKC_VALUESETS_INTERFACE, status:VALID, product: OKC - Contracts Core , description: 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 schema by the XML Based Clause Import Concurrent program. The users are expected to upload data into , implementation_dba_data: OKC.OKC_VALUESETS_INTERFACE ,
-
Table: OKC_VS_VALUES_INTERFACE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_VS_VALUES_INTERFACE, object_name:OKC_VS_VALUES_INTERFACE, status:VALID, product: OKC - Contracts Core , description: 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 schema by the XML Based Clause Import Concurrent program. The users are expected to upload data into thi , implementation_dba_data: OKC.OKC_VS_VALUES_INTERFACE ,
-
Table: OKC_XPRT_RULE_COND_VALS_ACTIVE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_COND_VALS_ACTIVE, object_name:OKC_XPRT_RULE_COND_VALS_ACTIVE, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions values in expert rules. This is a child entity of rules conditions entity. This is required mainly to support multiple values for conditions on a rule , implementation_dba_data: OKC.OKC_XPRT_RULE_COND_VALS_ACTIVE ,
-
Table: OKC_XPRT_RULE_OUTCOMES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_OUTCOMES, object_name:OKC_XPRT_RULE_OUTCOMES, status:VALID, product: OKC - Contracts Core , description: This table will store the results defined in the expert rules. This is a child entity of rules header entity , implementation_dba_data: OKC.OKC_XPRT_RULE_OUTCOMES ,
-
Table: OKC_XPRT_QUESTION_ORDERS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_QUESTION_ORDERS, object_name:OKC_XPRT_QUESTION_ORDERS, status:VALID, product: OKC - Contracts Core , description: This entity stores the order of the questions to be displayed at runtime. This is an intersection entity between templates and questions. , implementation_dba_data: OKC.OKC_XPRT_QUESTION_ORDERS ,
-
Table: OKC_ART_RELS_INTERFACE
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_ART_RELS_INTERFACE, object_name:OKC_ART_RELS_INTERFACE, status:VALID, product: OKC - Contracts Core , description: This is the interface table for import of relationships between standard clauses from external systems. All valid data in this table will be imported to OKC_ART_RELATNS_ALL using XML Based Clause Import Concurrent program. The users are e , implementation_dba_data: OKC.OKC_ART_RELS_INTERFACE ,
-
Table: OKC_ART_INTERFACE_ALL
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_ART_INTERFACE_ALL, object_name:OKC_ART_INTERFACE_ALL, status:VALID, product: OKC - Contracts Core , description: This is the interface table for import of standard clauses from external systems. All valid data in this table will be imported to OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS and OKC_ARTICLE_ADOPTIONS by the Clause Import Concurrent program. T , implementation_dba_data: OKC.OKC_ART_INTERFACE_ALL ,
-
Table: OKC_REP_CONTRACTS_ALL
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_CONTRACTS_ALL, object_name:OKC_REP_CONTRACTS_ALL, status:VALID, product: OKC - Contracts Core , description: This is the main Contracts table. This table stores the latest version of all Repository-authored contracts. , implementation_dba_data: OKC.OKC_REP_CONTRACTS_ALL ,
-
Table: OKC_OPERATION_INSTANCES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_OPERATION_INSTANCES, object_name:OKC_OPERATION_INSTANCES, status:VALID, product: OKC - Contracts Core , description: An Operation Instance is an instance of a Contract Operation. The Operation Instance contains information about the instance and serves as a collection point for detailed information. , implementation_dba_data: OKC.OKC_OPERATION_INSTANCES ,
-
Table: OKC_OPERATION_INSTANCES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_OPERATION_INSTANCES, object_name:OKC_OPERATION_INSTANCES, status:VALID, product: OKC - Contracts Core , description: An Operation Instance is an instance of a Contract Operation. The Operation Instance contains information about the instance and serves as a collection point for detailed information. , implementation_dba_data: OKC.OKC_OPERATION_INSTANCES ,
-
Table: OKC_XPRT_RULE_COND_VALS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_XPRT_RULE_COND_VALS, object_name:OKC_XPRT_RULE_COND_VALS, status:VALID, product: OKC - Contracts Core , description: This table stores all the conditions values in expert rules. This is a child entity of rules conditions entity. This is required mainly to support multiple values for conditions on a rule , implementation_dba_data: OKC.OKC_XPRT_RULE_COND_VALS ,
-
Table: OKC_REP_CONTRACTS_ALL
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_CONTRACTS_ALL, object_name:OKC_REP_CONTRACTS_ALL, status:VALID, product: OKC - Contracts Core , description: This table is the main Contracts table. This table stores the latest version of all contracts authored in Contract Repository. , implementation_dba_data: OKC.OKC_REP_CONTRACTS_ALL ,
-
Table: OKC_OUTCOME_ARGUMENTS_H
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_OUTCOME_ARGUMENTS_H, object_name:OKC_OUTCOME_ARGUMENTS_H, status:VALID, product: OKC - Contracts Core , description: This is a mirror image of base table OKC_OUTCOME_ARGUMENTS, please refer to the base table for detailed column level information , implementation_dba_data: OKC.OKC_OUTCOME_ARGUMENTS_H ,