Search Results procurement contracts
The OKC.OKC_BUS_DOC_TYPES_B
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a fundamental data structure within the Oracle Contracts Core module. This table serves as the repository for business document type definitions, which are critical for classifying and managing various contract and agreement documents across the Oracle Contracts application. Below is a detailed technical summary of its purpose, structure, and key attributes.
Purpose and Functional Context
The OKC_BUS_DOC_TYPES_B
table stores metadata about business document types, enabling Oracle Contracts to differentiate between contracts, amendments, renewals, and other agreement types. These document types drive workflow behavior, validation rules, and reporting categorization. The table is part of the Oracle Contracts Core schema (OKC
) and is tightly integrated with other key tables like OKC_BUS_DOC_TYPES_TL
(for translated descriptions) and OKC_CONTRACT_DOCS
(for document instances).
Key Columns and Structure
The table includes the following critical columns:
- DOC_TYPE_ID: Primary key, uniquely identifying each document type.
- DOC_TYPE_CODE: A short, unique identifier (e.g., "STANDARD" for standard contracts).
- START_DATE and END_DATE: Define the active period for the document type.
- CATEGORY_CODE: Groups document types into broader categories (e.g., "SALES" or "PURCHASE").
- ALLOW_AMENDMENTS_FLAG: Controls whether amendments are permitted for this document type.
- ALLOW_RENEWALS_FLAG: Determines if renewal workflows apply.
- SECURITY_GROUP_ID: Supports multi-org access control.
Integration with Oracle EBS Modules
The table integrates with:
- Oracle Workflow: Document types trigger specific approval workflows.
- Oracle Approval Management (AME): Rules may be conditioned on document types.
- Oracle Reports: Enables filtering contracts by type in analytics.
Technical Considerations
For implementations, note:
- The table is seed-data heavy, with Oracle-provided document types that can be extended but not modified.
- Custom document types require careful alignment with existing
CATEGORY_CODE
values to ensure UI consistency. - In EBS 12.2.2, the table supports Edition-Based Redefinition (EBR), allowing online patching.
Common Use Cases
Typical operations involving this table include:
- Configuring new contract types for industry-specific requirements.
- Extending expiration logic via the
END_DATE
column. - Driving conditional clauses in Contract Expert rules.
Performance and Indexing
The table is optimized for frequent reads but minimal writes. Key indexes include:
- Primary key index on
DOC_TYPE_ID
. - Unique index on
DOC_TYPE_CODE
. - Non-unique indexes on
CATEGORY_CODE
and date ranges for reporting.
In summary, OKC_BUS_DOC_TYPES_B
is a metadata cornerstone for Oracle Contracts, enabling precise document classification and process orchestration. Its design reflects Oracle EBS's emphasis on configurability while maintaining data integrity through strict code-based relationships.
-
File: R11510 CONTRACTS ERD.pdf
12.1.1
product: OKC - Contracts Core , size: 48.047 KBytes , file_type: PDF Diagram ,
-
File: R11510 CONTRACTS ERD.pdf
12.2.2
product: OKC - Contracts Core , size: 48.047 KBytes , file_type: PDF Diagram ,
-
File: R1158 CONTRACTS ERD.pdf
12.1.1
product: OKC - Contracts Core , size: 264.137 KBytes , file_type: PDF Diagram ,
-
File: R1158 CONTRACTS ERD.pdf
12.2.2
product: OKC - Contracts Core , size: 264.137 KBytes , file_type: PDF Diagram ,
-
File: R11510 Project Contracts ERD.pdf
12.1.1
product: OKE - Project Contracts , size: 108.209 KBytes , file_type: PDF Diagram ,
-
File: R11510 Project Contracts ERD.pdf
12.2.2
product: OKE - Project Contracts , size: 108.209 KBytes , file_type: PDF Diagram ,
-
File: Contracts Core 11510 ERD.pdf
12.2.2
product: OKC - Contracts Core , size: 248.514 KBytes , file_type: PDF Diagram ,
-
File: R1159 Contracts Intelligence ERD.pdf
12.2.2
product: OKI - Contracts Intelligence (Obsolete) , size: 27.657 KBytes , file_type: PDF Diagram ,
-
File: Contracts Core 11510 ERD.pdf
12.1.1
product: OKC - Contracts Core , size: 248.514 KBytes , file_type: PDF Diagram ,
-
File: R1159 Contracts Intelligence ERD.pdf
12.1.1
product: OKI - Contracts Intelligence , size: 27.657 KBytes , file_type: PDF Diagram ,
-
File: R11510 Service Contracts ERD.pdf
12.1.1
product: OKS - Service Contracts , size: 93.064 KBytes , file_type: PDF Diagram ,
-
File: R11510 Service Contracts ERD.pdf
12.2.2
product: OKS - Service Contracts , size: 93.064 KBytes , file_type: PDF Diagram ,
-
Lookup Type: BUSINESS_AREA
12.1.1
product: OKE - Project Contracts , meaning: Business Area , description: Business Area ,
-
Lookup Type: BUSINESS_AREA
12.2.2
product: OKE - Project Contracts , meaning: Business Area , description: Business Area ,
-
TABLE: OKC.OKC_BUS_DOC_TYPES_B
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_BUS_DOC_TYPES_B, object_name:OKC_BUS_DOC_TYPES_B, status:VALID,
-
TABLE: OKC.OKC_BUS_DOC_TYPES_B
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_BUS_DOC_TYPES_B, object_name:OKC_BUS_DOC_TYPES_B, status:VALID,
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
12.1.1 FND Design Data
12.1.1
-
12.1.1 FND Design Data
12.1.1
-
File: R12 Service Request Contracts, IB, Inventory Integration ERD.pdf
12.2.2
product: CS - Service , size: 43.533 KBytes , file_type: PDF Diagram ,
-
12.2.2 FND Design Data
12.2.2
-
APPS.PO_CONTERMS_WF_PVT SQL Statements
12.2.2
-
APPS.PO_CONTERMS_WF_PVT SQL Statements
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
VIEW: APPS.OKC_BUS_DOC_TYPES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_BUS_DOC_TYPES_V, object_name:OKC_BUS_DOC_TYPES_V, status:VALID,
-
VIEW: APPS.OKC_BUS_DOC_TYPES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_BUS_DOC_TYPES_V, object_name:OKC_BUS_DOC_TYPES_V, status:VALID,
-
File: OKPProduct_Dependencies.html
12.2.2
product: OKP - Contracts for Procurement (Obsolete) , size: 15.329 KBytes , file_type: HTML Report , description: OKPProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the OKP product. ,
-
View: OKC_KOL_SEARCH_KHEADERS_V
12.2.2
product: OKC - Contracts Core , description: Displays all the contracts, with their respective status, category, primary party name and role, and attached documents. Only contracts belonging to Contracts Core (OKC), Sales Contracts (OKO) and Contracts for Procurement (OKP) should be s , implementation_dba_data: Not implemented in this database ,
-
File: OKP_Dependencies.html
12.1.1
product: OKP - Contracts for Procurement (Obsolete) , size: 14.473 KBytes , file_type: HTML Report , description: OKP_Dependencies.html is an html report that documents dependencies to tables and views in the OKP product. ,
-
File: OKP_Tables.html
12.1.1
product: OKP - Contracts for Procurement (Obsolete) , size: 14.473 KBytes , file_type: HTML Report , description: OKP_Tables.html is an html report that documents the table and view definitions for the OKP product. ,
-
File: OKP_Tables.html
12.2.2
product: OKP - Contracts for Procurement (Obsolete) , size: 14.473 KBytes , file_type: HTML Report , description: OKP_Tables.html is an html report that documents the table and view definitions for the OKP product. ,
-
View: OKC_KOL_SEARCH_KHEADERS_V
12.1.1
product: OKC - Contracts Core , description: Displays all the contracts, with their respective status, category, primary party name and role, and attached documents. Only contracts belonging to Contracts Core (OKC), Sales Contracts (OKO) and Contracts for Procurement (OKP) should be s , implementation_dba_data: Not implemented in this database ,
-
File: OKPProduct_Dependencies.html
12.1.1
product: OKP - Contracts for Procurement (Obsolete) , size: 15.329 KBytes , file_type: HTML Report , description: OKPProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the OKP product. ,
-
File: OKP_Dependencies.html
12.2.2
product: OKP - Contracts for Procurement (Obsolete) , size: 14.473 KBytes , file_type: HTML Report , description: OKP_Dependencies.html is an html report that documents dependencies to tables and views in the OKP product. ,
-
File: R12 Service Request Contracts, IB, Inventory Integration ERD.pdf
12.1.1
product: CS - Service , size: 43.533 KBytes , file_type: PDF Diagram ,
-
APPS.POA_SAVINGS_CON dependencies on STANDARD
12.1.1
-
APPS.PON_CONTERMS_UTL_PVT dependencies on FND_PROFILE
12.2.2
-
APPS.POA_SAVINGS_CON dependencies on POA_BIS_SAVINGS
12.1.1
-
APPS.PON_CONTERMS_UTL_PVT dependencies on FND_PROFILE
12.1.1
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
12.2.2 FND Design Data
12.2.2
-
12.1.1 FND Design Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
12.1.1 FND Design Data
12.1.1
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 DBA Data
12.2.2