Search Results download transworld for pc
The OKC_REP_IMP_PARTIES_T
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository table within the Oracle Contracts (OKC) module. It serves as a temporary staging table for importing party-related data during contract integration or migration processes. This table is primarily utilized by the Oracle Contracts application programming interface (API) to validate, transform, and load party information into the core contract tables, ensuring data integrity and consistency.
Purpose and Functionality
TheOKC_REP_IMP_PARTIES_T
table acts as an intermediary storage for party data before it is processed and transferred to permanent contract tables such as OKC_K_PARTIES
. It facilitates bulk data operations, allowing users to import multiple party records in a single transaction. This is particularly useful during contract authoring, amendments, or mass data migrations where party information must be synchronized with contract terms.
Key Columns and Structure
The table contains columns that map to essential party attributes, including:- PARTY_ID: Unique identifier for the party record in the staging table.
- CONTRACT_ID: References the contract to which the party is associated.
- PARTY_ROLE_CODE: Defines the role of the party (e.g., "BUYER," "SELLER," "SIGNER").
- PARTY_NUMBER: Identifier for the party, often linked to
HZ_PARTIES
in Oracle Trading Community Architecture (TCA). - STATUS_FLAG: Indicates the processing status (e.g., "P" for pending, "E" for error, "S" for success).
- ERROR_MESSAGE: Captures validation errors during data processing.
Integration with Oracle TCA
The table integrates tightly with Oracle Trading Community Architecture (TCA), leveraging theHZ_PARTIES
table to validate and resolve party references. Before data is committed to permanent contract tables, the system cross-references party identifiers with TCA to ensure consistency and accuracy.
Data Flow and Processing
The typical workflow involvingOKC_REP_IMP_PARTIES_T
includes:
- Data Staging: Party data is inserted into the table via APIs or custom scripts.
- Validation: The Contracts API validates the data against business rules and TCA references.
- Transformation: Validated data is transformed into the format required by permanent tables.
- Loading: Processed records are moved to
OKC_K_PARTIES
and related tables. - Cleanup: Processed records are purged from the staging table.
Common Use Cases
- Contract Migration: Used during legacy system migrations to stage party data before loading into Oracle Contracts.
- Bulk Updates: Facilitates mass updates to party roles or affiliations across multiple contracts.
- Integration: Serves as an interface for third-party systems to feed party data into Oracle Contracts.
Technical Considerations
When working withOKC_REP_IMP_PARTIES_T
, developers should note:
- The table is session-specific; data is typically scoped to a user's session to avoid conflicts.
- Indexes on key columns like
CONTRACT_ID
andPARTY_ID
optimize performance during large imports. - Direct DML operations are discouraged; APIs such as
OKC_CONTRACT_PUB
should be used for data manipulation.
Conclusion
TheOKC_REP_IMP_PARTIES_T
table is a pivotal component in Oracle EBS Contracts, enabling efficient and reliable party data management. Its design supports high-volume data operations while maintaining integration with Oracle TCA and other core modules. Proper utilization of this table ensures seamless contract party administration in Oracle EBS 12.1.1 and 12.2.2 environments.
-
Lookup Type: OKC_DWNLOAD_FILE_FORMAT
12.1.1
product: OKC - Contracts Core , meaning: Download File Formats , description: Download file Formats ,
-
Lookup Type: OKC_DWNLOAD_FILE_FORMAT
12.2.2
product: OKC - Contracts Core , meaning: Download File Formats , description: Download file Formats ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_UPDATE
12.1.1
product: OKC - Contracts Core , meaning: Contracts Terms Authoring Actions in Update Mode , description: Contracts Terms Authoring Actions in Update Mode ,
-
Lookup Type: OKC_REP_CON_ACTIONS
12.1.1
product: OKC - Contracts Core , meaning: List of values for contract actions , description: List of values for contract actions for Repositoy ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_AMEND
12.2.2
product: OKC - Contracts Core , meaning: Contract Terms Authoring Actions in Amend Mode , description: Terms Authoring Allowed Actions for Amend Mode ,
-
Lookup Type: OKC_REP_CON_ACTIONS
12.2.2
product: OKC - Contracts Core , meaning: List of values for contract actions , description: List of values for contract actions for Repositoy ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_UPDATE
12.2.2
product: OKC - Contracts Core , meaning: Contracts Terms Authoring Actions in Update Mode , description: Contracts Terms Authoring Actions in Update Mode ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_AMEND
12.1.1
product: OKC - Contracts Core , meaning: Contract Terms Authoring Actions in Amend Mode , description: Terms Authoring Allowed Actions for Amend Mode ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_VIEW
12.1.1
product: OKC - Contracts Core , meaning: Contracts Terms Authoring Actions in View Mode , description: Contracts Terms Authoring Actions in View Mode ,
-
Lookup Type: OKC_TERMS_AUTH_ACTIONS_VIEW
12.2.2
product: OKC - Contracts Core , meaning: Contracts Terms Authoring Actions in View Mode , description: Contracts Terms Authoring Actions in View Mode ,
-
Lookup Type: OKC_11510_MIG_TEMPLATES
12.1.1
product: OKC - Contracts Core , meaning: OKC Dummy templates for 11.5.10 migration , description: OKC Dummy templates for 11.5.10 migration ,
-
Lookup Type: OKC_11510_MIG_TEMPLATES
12.2.2
product: OKC - Contracts Core , meaning: OKC Dummy templates for 11.5.10 migration , description: OKC Dummy templates for 11.5.10 migration ,
-
Lookup Type: OKC_DEL_ATTCH_ALLOW_MODIFY
12.2.2
product: OKC - Contracts Core , meaning: Allow Deliverable Attachment Modifications , description: Allow Deliverable Attachment Modifications - Update/Delete ,
-
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 ,
-
Lookup Type: OKC_REL_OBJ
12.1.1
product: OKC - Contracts Core , meaning: Contract related Objects , description: Contract related Objects ,
-
Lookup Type: OKC_SESG_TRANS_FOR_COL_HEADER
12.2.2
product: OKC - Contracts Core , meaning: Translation names for results table column headers in SES , description: Translation names for results table column headers in SES ,
-
Lookup Type: OKC_REL_OBJ
12.2.2
product: OKC - Contracts Core , meaning: Contract related Objects , description: Contract related Objects ,
-
Lookup Type: OKC_REP_CON_ACTIONS_SBCR
12.2.2
product: OKC - Contracts Core , meaning: Repository Contracts Actions for SBCR , description: Repository Contracts Actions for SBCR ,
-
Lookup Type: OKC_CONTINGENCY_RULES
12.2.2
product: OKC - Contracts Core , meaning: OKC_CONTINGENCY_RULES ,
-
Lookup Type: OKC_CONTINGENCY_RULES
12.1.1
product: OKC - Contracts Core , meaning: OKC_CONTINGENCY_RULES ,
-
Lookup Type: OKC_REP_CON_ACTIONS_CCT
12.2.2
product: OKC - Contracts Core , meaning: Actions for Closeout Checklist Template Contract , description: Actions for Closeout Checklist Template Contract ,
-
Table: OKC_REP_IMP_PARTIES_T
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_IMP_PARTIES_T, object_name:OKC_REP_IMP_PARTIES_T, status:VALID, product: OKC - Contracts Core , description: This is a temporary table for storing an imported contract party's attributes. It is used for validating contract parties, preparing parties data for importing into Contracts Repository schema and generating error messages for invalid part , implementation_dba_data: OKC.OKC_REP_IMP_PARTIES_T ,
-
Table: OKC_REP_IMP_CONTRACTS_T
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_IMP_CONTRACTS_T, object_name:OKC_REP_IMP_CONTRACTS_T, status:VALID, product: OKC - Contracts Core , description: This is a temporary table for storing imported contract header attributes. It is used for validating contract attributes, preparing contract header data for importing into Contracts Repository schema and generating error output file for inv , implementation_dba_data: OKC.OKC_REP_IMP_CONTRACTS_T ,
-
Table: OKC_ARTICLE_ADOPTIONS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_ARTICLE_ADOPTIONS, object_name:OKC_ARTICLE_ADOPTIONS, status:VALID, product: OKC - Contracts Core , description: This table stores the adoption details of a global clause version for the local organization. This table has rows for local organizations only. This stores rows for clause adoptions as AVAILABLE FOR ADOPTION, LOCALIZED and ADOPTED. , implementation_dba_data: OKC.OKC_ARTICLE_ADOPTIONS ,
-
Concurrent Program: OKCEXPTMPLCZ
12.1.1
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_template_pg , product: OKC - Contracts Core , user_name: Export Template to Configurator for Contract Expert , description: Export Template to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCEXPTMPLCZ
12.2.2
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_template_pg , product: OKC - Contracts Core , user_name: Export Template to Configurator for Contract Expert , description: Export Template to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: OKC_XPRT_RULES_QA_LIST
12.2.2
product: OKC - Contracts Core , meaning: Contract Expert Rules Quality Assurance Check List , description: Contract Expert Rules Quality Assurance Check List ,
-
Lookup Type: OKC_CONTRACT_SOURCES
12.2.2
product: OKC - Contracts Core , meaning: Contract Sources , description: Identifier of source system of a contract ,
-
Lookup Type: OKC_XPRT_RULES_QA_LIST
12.1.1
product: OKC - Contracts Core , meaning: Contract Expert Rules Quality Assurance Check List , description: Contract Expert Rules Quality Assurance Check List ,
-
Lookup Type: OKC_TERMS_UPLOAD_ACTIONS
12.2.2
product: OKC - Contracts Core , meaning: Review Upload Actions , description: Review Upload Actions ,
-
Lookup Type: OKC_REP_PARTY_ROLES
12.2.2
product: OKC - Contracts Core , meaning: List values for party roles , description: List values for party roles for Repository ,
-
Lookup Type: OKC_REP_PARTY_ROLES
12.1.1
product: OKC - Contracts Core , meaning: List values for party roles , description: List values for party roles for Repository ,
-
Concurrent Program: OKCRAQE
12.1.1
execution_filename: OKC_AQ_PVT.listen_event , product: OKC - Contracts Core , user_name: OKCRAQE , description: Listener for Events queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCRAQO
12.1.1
execution_filename: OKC_AQ_PVT.listen_outcome , product: OKC - Contracts Core , user_name: OKCRAQO , description: Listener for Outcomes queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCRAQO
12.2.2
execution_filename: OKC_AQ_PVT.listen_outcome , product: OKC - Contracts Core , user_name: OKCRAQO , description: Listener for Outcomes queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: OKC_TERMS_UPLOAD_ACTIONS
12.1.1
product: OKC - Contracts Core , meaning: Review Upload Actions , description: Review Upload Actions ,
-
Concurrent Program: OKCEXPRTVARIMP
12.2.2
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_variables , product: OKC - Contracts Core , user_name: OKCEXPRTVARIMP , description: Export Variables to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: OKC_REP_SBCR_REC_SET_ASIDE
12.2.2
product: OKC - Contracts Core , meaning: SBCR Recommendations for Set Aside , description: SBCR Recommendations for Set Aside ,
-
Concurrent Program: OKCRAQE
12.2.2
execution_filename: OKC_AQ_PVT.listen_event , product: OKC - Contracts Core , user_name: OKCRAQE , description: Listener for Events queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: OKC_CONTRACT_SOURCES
12.1.1
product: OKC - Contracts Core , meaning: Contract Sources , description: Identifier of source system of a contract ,
-
Concurrent Program: OKCEXPRTARTIMPALLORGS
12.2.2
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_articles_for_all_orgs , product: OKC - Contracts Core , user_name: OKCEXPRTARTIMPALLORGS , description: Export Articles to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCEXPRTARTIMPALLORGS
12.1.1
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_articles_for_all_orgs , product: OKC - Contracts Core , user_name: OKCEXPRTARTIMPALLORGS , description: Export Articles to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCEXPRTVARIMP
12.1.1
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_variables , product: OKC - Contracts Core , user_name: OKCEXPRTVARIMP , description: Export Variables to Configurator for Contract Expert , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Table: OKC_REP_IMP_DOCUMENTS_T
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_REP_IMP_DOCUMENTS_T, object_name:OKC_REP_IMP_DOCUMENTS_T, status:VALID, product: OKC - Contracts Core , description: This is a temporary table for storing imported Contract Documents attributes. It is used for validating Contract Documents and generating error messages for invalid records. The data is deleted after each Import process. , implementation_dba_data: OKC.OKC_REP_IMP_DOCUMENTS_T ,
-
Concurrent Program: OKCPALT1
12.1.1
execution_filename: OKC_TASK_ALERT_ESCL_PVT.okc_pdate_reach_pvt , product: OKC - Contracts Core , user_name: OKCPALT1 , description: Action Assembler for Scheduled Planned Date , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCPALT1
12.2.2
execution_filename: OKC_TASK_ALERT_ESCL_PVT.okc_pdate_reach_pvt , product: OKC - Contracts Core , user_name: OKCPALT1 , description: Action Assembler for Scheduled Planned Date , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCADPNEWORG
12.2.2
execution_filename: OKC_ADOPTIONS_GRP.AUTO_ADOPT_NEWORG , product: OKC - Contracts Core , user_name: OKCADPNEWORG , description: Auto Adoption of Global Clauses for a new Organization. , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: OKCEXPRTARTIMPONEORG
12.1.1
execution_filename: OKC_EXPRT_LIBRARY_CZIMP_GRP.ce_imp_articles_for_org , product: OKC - Contracts Core , user_name: OKCEXPRTARTIMPONEORG , description: Export Articles to Configurator for Contract Expert (One Org) , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: OKC_RENEWAL_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Contract Renewal Types , description: Types of renewal for contracts ,