Search Results hermittes helena of chin

The JE_CZ_EFT_CONTRACTS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a custom or localized table designed to support Electronic Funds Transfer (EFT) contract management, likely specific to the Czech Republic (as indicated by the "CZ" prefix). This table stores critical data related to EFT agreements between an organization and its business partners, facilitating automated payment processing. Below is a detailed technical and functional analysis of this table in the context of Oracle EBS.

1. Purpose and Functional Context

The JE_CZ_EFT_CONTRACTS_ALL table serves as a repository for EFT contract details, enabling organizations to manage payment agreements with vendors, customers, or employees. It integrates with Oracle Payables, Receivables, or Payroll modules to automate payment workflows while complying with Czech banking regulations. Key functionalities include:

Contract Storage: Captures EFT terms, such as payment methods, bank account linkages, and authorization details.
Multi-Org Support: The "_ALL" suffix indicates it stores data across multiple operating units, adhering to Oracle's Multi-Org architecture.
Localization: Tailored for Czech legal requirements, such as mandatory fields for VAT, tax IDs, or local banking standards (e.g., IBAN/BIC validation).

2. Key Columns and Structure

While the exact schema may vary, typical columns in JE_CZ_EFT_CONTRACTS_ALL include:

CONTRACT_ID: Primary key, uniquely identifying each EFT contract.
ORG_ID: Operating Unit identifier, enabling multi-org partitioning.
PARTY_ID: References HZ_PARTIES to link contracts to trading partners (vendors/customers).
BANK_ACCOUNT_ID: Foreign key to CE_BANK_ACCOUNTS or AP_BANK_ACCOUNTS_ALL, storing beneficiary account details.
CONTRACT_NUMBER: User-defined identifier for the agreement.
START_DATE/END_DATE: Defines the contract's validity period.
STATUS: Tracks active, expired, or terminated contracts.
PAYMENT_METHOD_CODE: References IBY_PAYMENT_METHODS to specify EFT, SEPA, or other payment types.
ATTRIBUTE_CATEGORY/ATTRIBUTE1-15: Flexfields for custom data capture.

3. Integration with Oracle EBS Modules

The table interacts with core EBS modules:

Oracle Payables (AP): Automates vendor payments using contract terms during payment batch processing.
Oracle Receivables (AR): Supports direct debit mandates from customers.
Cash Management (CE): Validates bank account details and reconciles payments.
Subledger Accounting (SLA): Ensures compliance with accounting rules for EFT transactions.

4. Technical Considerations

Indexing: Likely indexed on CONTRACT_ID, PARTY_ID, and ORG_ID for performance.
Audit Columns: Includes CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for compliance.
Security: Protected by Oracle's VPD (Virtual Private Database) policies in multi-org setups.

5. Customization and Extensions

Organizations may extend this table via:

Flexfields: Adding industry-specific attributes.
Triggers/APIs: Enforcing business rules (e.g., contract renewal alerts).
Workflow: Integrating with WF_ENGINE for approval routing.

6. Localization for Czech Republic

The table may enforce:

Czech-specific validations (e.g., VAT registration numbers via JE_CZ_TAX_REGISTRATIONS).
Integration with Czech banking interfaces for bulk payment files.

Conclusion

The JE_CZ_EFT_CONTRACTS_ALL table is a critical component for EFT automation in Oracle EBS 12.1.1/12.2.2, combining localization, multi-org support, and seamless integration with financial modules. Proper configuration ensures efficient payment processing while adhering to Czech regulatory requirements.

Lookup Type: JEDE_COUNTRY_NUMERIC_CODE 12.2.2
product: JE - European Localizations , meaning: JEDE COUNTRY NUMERIC CODE , description: German Numeric Country Codes ,
Lookup Type: JEDE_COUNTRY_SHORT_NAME 12.2.2
product: JE - European Localizations , meaning: JEDE COUNTRY SHORT NAME , description: German Country Short Names ,
Lookup Type: JEDE_COUNTRY_SHORT_NAME 12.1.1
product: JE - European Localizations , meaning: JEDE COUNTRY SHORT NAME , description: German Country Short Names ,
Lookup Type: JEDE_COUNTRY_NUMERIC_CODE 12.1.1
product: JE - European Localizations , meaning: JEDE COUNTRY NUMERIC CODE , description: German Numeric Country Codes ,
Lookup Type: JEES_EURO_COUNTRY_CODES 12.2.2
product: JE - European Localizations , meaning: European Country Codes for Spanish Reports , description: European Country Codes for Spanish Reports ,
Lookup Type: JEES_EURO_COUNTRY_CODES 12.1.1
product: JE - European Localizations , meaning: European Country Codes for Spanish Reports , description: European Country Codes for Spanish Reports ,
Lookup Type: JEZZ_DEGREE 12.2.2
product: JE - European Localizations , meaning: Degree , description: Number for degree reporting with a maximum length of 1 ,
Lookup Type: JEZZ_DEGREE 12.1.1
product: JE - European Localizations , meaning: Degree , description: Number for degree reporting with a maximum length of 1 ,
Lookup Type: JESE_FED_CODES 12.1.1
product: JE - European Localizations , meaning: JESE FED CODES , description: Swedish Federal Reserve Codes ,
Lookup Type: JESE_FED_CODES 12.2.2
product: JE - European Localizations , meaning: JESE FED CODES , description: Swedish Federal Reserve Codes ,
Lookup Type: JEIT_DECL_INC_COMPANY 12.2.2
product: JE - European Localizations , meaning: Declaration of Incorporated Company , description: Declaration of Incorporated Company ,
Lookup Type: JENO_RETURN_MESSAGES 12.1.1
product: JE - European Localizations , meaning: JENO RETURN MESSAGES , description: Return messages ,
Lookup Type: JEDK_EDI_PAYMENT_CHANNEL 12.2.2
product: JE - European Localizations , meaning: JEDK_EDI_PAYMENT_CHANNEL , description: Danish EDI Payment Channel ,
Concurrent Program: JEITARAA 12.2.2
execution_filename: JEITARAA , product: JE - European Localizations , user_name: JEITARAA , description: Italian AR VAT Annex Of Customers , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: JEDK_EDI_PAYMENT_CHANNEL 12.1.1
product: JE - European Localizations , meaning: JEDK_EDI_PAYMENT_CHANNEL , description: Danish EDI Payment Channel ,
Lookup Type: JENO_RETURN_MESSAGES 12.2.2
product: JE - European Localizations , meaning: JENO RETURN MESSAGES , description: Return messages ,
Concurrent Program: JEITARAA 12.1.1
execution_filename: JEITARAA , product: JE - European Localizations , user_name: JEITARAA , description: Italian AR VAT Annex Of Customers , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEBECSSR 12.2.2
execution_filename: JE_BE_CSSR_PKG.main , product: JE - European Localizations , user_name: JEBECSSR , description: Belgium report for reporting to National Bank of Belgium, in accordance with the CSSR Requirements , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: JEBECSSR 12.1.1
execution_filename: JE_BE_CSSR_PKG.main , product: JE - European Localizations , user_name: JEBECSSR , description: Belgium report for reporting to National Bank of Belgium, in accordance with the CSSR Requirements , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: JEBE_VAT_REPORT_BOXES 12.2.2
product: JE - European Localizations , meaning: JEBE VAT REPORT BOXES , description: VAT Box for Monthly VAT ,
Lookup Type: JEBE_VAT_REPORT_BOXES 12.1.1
product: JE - European Localizations , meaning: JEBE VAT REPORT BOXES , description: VAT Box for Monthly VAT ,
Lookup Type: JEIT_UPLOAD_TYPE 12.2.2
product: JE - European Localizations , meaning: Type of Upload , description: Type of Upload ,
Concurrent Program: JEITAPAA 12.1.1
execution_filename: JEITAPAA , product: JE - European Localizations , user_name: JEITAPAA , description: Italian AP VAT Register of Suppliers , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEITAPAA 12.2.2
execution_filename: JEITAPAA , product: JE - European Localizations , user_name: JEITAPAA , description: Italian AP VAT Register of Suppliers , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Table: JE_CZ_EFT_CONTRACTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CZ_EFT_CONTRACTS_ALL, object_name:JE_CZ_EFT_CONTRACTS_ALL, status:VALID, product: JE - European Localizations , description: This table will store all the relevant details of a Compatible Media contract between a company and its Bank. This table will contain the range of Interval Numbers allocated to the Accounting files used within the Payment file. , implementation_dba_data: AP.JE_CZ_EFT_CONTRACTS_ALL ,
Table: JE_CZ_EFT_CONTRACTS_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CZ_EFT_CONTRACTS_ALL, object_name:JE_CZ_EFT_CONTRACTS_ALL, status:VALID, product: JE - European Localizations , description: This table will store all the relevant details of a Compatible Media contract between a company and its Bank. This table will contain the range of Interval Numbers allocated to the Accounting files used within the Payment file. , implementation_dba_data: AP.JE_CZ_EFT_CONTRACTS_ALL ,
Lookup Type: JEES_ACTIVITY_415 12.1.1
product: JE - European Localizations , meaning: Spanish Modelo 415 Report Declarer Activities , description: Spanish Modelo 415 Report Declarer Activities ,
Lookup Type: JEES_ACTIVITY_415 12.2.2
product: JE - European Localizations , meaning: Spanish Modelo 415 Report Declarer Activities , description: Spanish Modelo 415 Report Declarer Activities ,
Table: JE_FR_DAS_310_NEW 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_310_NEW, object_name:JE_FR_DAS_310_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_310 table , implementation_dba_data: AP.JE_FR_DAS_310_NEW ,
Table: JE_FR_DAS_310_NEW 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_310_NEW, object_name:JE_FR_DAS_310_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_310 table , implementation_dba_data: AP.JE_FR_DAS_310_NEW ,
Table: JE_FR_DAS_020_NEW 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_020_NEW, object_name:JE_FR_DAS_020_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_020 table , implementation_dba_data: AP.JE_FR_DAS_020_NEW ,
Table: JE_FR_DAS_210_NEW 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_210_NEW, object_name:JE_FR_DAS_210_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_210 table , implementation_dba_data: AP.JE_FR_DAS_210_NEW ,
Table: JE_FR_DAS_020_NEW 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_020_NEW, object_name:JE_FR_DAS_020_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_020 table , implementation_dba_data: AP.JE_FR_DAS_020_NEW ,
Table: JE_FR_DAS_210_NEW 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_210_NEW, object_name:JE_FR_DAS_210_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_210 table , implementation_dba_data: AP.JE_FR_DAS_210_NEW ,
Table: JE_FR_DAS_300_NEW 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_300_NEW, object_name:JE_FR_DAS_300_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_300 table , implementation_dba_data: AP.JE_FR_DAS_300_NEW ,
Table: JE_FR_DAS_300_NEW 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_300_NEW, object_name:JE_FR_DAS_300_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_300 table , implementation_dba_data: AP.JE_FR_DAS_300_NEW ,
Table: JE_FI_NUMBER_VALIDATION 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FI_NUMBER_VALIDATION, object_name:JE_FI_NUMBER_VALIDATION, status:VALID, product: JE - European Localizations , description: Table of values for Finnish validation , implementation_dba_data: AP.JE_FI_NUMBER_VALIDATION ,
Table: JE_FR_DAS_010_NEW 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_010_NEW, object_name:JE_FR_DAS_010_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_010 table , implementation_dba_data: AP.JE_FR_DAS_010_NEW ,
Table: JE_CH_SAD_SEQUENCES 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CH_SAD_SEQUENCES, object_name:JE_CH_SAD_SEQUENCES, status:VALID, product: JE - European Localizations , description: Table of sequences for Swiss SAD payments , implementation_dba_data: AP.JE_CH_SAD_SEQUENCES ,
Table: JE_CH_SAD_SEQUENCES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_CH_SAD_SEQUENCES, object_name:JE_CH_SAD_SEQUENCES, status:VALID, product: JE - European Localizations , description: Table of sequences for Swiss SAD payments , implementation_dba_data: AP.JE_CH_SAD_SEQUENCES ,
Table: JE_DE_CHECKRUN_RESULTS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_DE_CHECKRUN_RESULTS, object_name:JE_DE_CHECKRUN_RESULTS, status:VALID, product: JE - European Localizations , description: Results of the German Payables EFT Format payments processed , implementation_dba_data: AP.JE_DE_CHECKRUN_RESULTS ,
Table: JE_FR_DAS_010_NEW 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FR_DAS_010_NEW, object_name:JE_FR_DAS_010_NEW, status:VALID, product: JE - European Localizations , description: New version of JE_FR_DAS_010 table , implementation_dba_data: AP.JE_FR_DAS_010_NEW ,
Table: JE_FI_NUMBER_VALIDATION 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_FI_NUMBER_VALIDATION, object_name:JE_FI_NUMBER_VALIDATION, status:VALID, product: JE - European Localizations , description: Table of values for Finnish validation , implementation_dba_data: AP.JE_FI_NUMBER_VALIDATION ,
Table: JE_DE_REMITTANCE_RESULTS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:JE.JE_DE_REMITTANCE_RESULTS, object_name:JE_DE_REMITTANCE_RESULTS, status:VALID, product: JE - European Localizations , description: Results of the German Direct Debit Format program in Receivables , implementation_dba_data: AR.JE_DE_REMITTANCE_RESULTS ,
Table: JE_IT_ABOVE_THR_HDR_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_ABOVE_THR_HDR_ALL, object_name:JE_IT_ABOVE_THR_HDR_ALL, status:VALID, product: JE - European Localizations , description: This table stores the parameter details of Italian Invoice Above Threshold Data extract Run , implementation_dba_data: JE.JE_IT_ABOVE_THR_HDR_ALL ,
Table: JE_IT_TRX_ABOVE_THR_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_TRX_ABOVE_THR_ALL, object_name:JE_IT_TRX_ABOVE_THR_ALL, status:VALID, product: JE - European Localizations , description: A table to store the detailed information of transactions which are eligible for Data Extraction , implementation_dba_data: JE.JE_IT_TRX_ABOVE_THR_ALL ,
Table: JE_DE_CHECKRUN_RESULTS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:JE.JE_DE_CHECKRUN_RESULTS, object_name:JE_DE_CHECKRUN_RESULTS, status:VALID, product: JE - European Localizations , description: Results of the German Payables EFT Format payments processed , implementation_dba_data: AP.JE_DE_CHECKRUN_RESULTS ,
Table: JE_DE_REMITTANCE_RESULTS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:JE.JE_DE_REMITTANCE_RESULTS, object_name:JE_DE_REMITTANCE_RESULTS, status:VALID, product: JE - European Localizations , description: Results of the German Direct Debit Format program in Receivables , implementation_dba_data: AR.JE_DE_REMITTANCE_RESULTS ,
Lookup Type: JEES_INVOICE_TYPE 12.1.1
product: JE - European Localizations , meaning: JEES INVOICE TYPE , description: Type of Invoice ,
Lookup Type: JEES_INVOICE_TYPE 12.2.2
product: JE - European Localizations , meaning: JEES INVOICE TYPE , description: Type of Invoice ,