Search Results client_name

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AP.JE_CZ_EFT_CONTRACTS_ALL table is a localization data object within the Oracle E-Business Suite 12.1.1 / 12.2.2 JE – European Localizations product family. It stores the defining attributes of a Compatible Media contract established between a company and its bank, and it holds the range of Interval Numbers allocated to the accounting files transmitted within a payment file. The table is owned by the AP schema and is documented as VALID in the ETRM repository. Its 45-column physical schema and its single unique index on CONTRACT_ID indicate that it functions as a registration and control point for interval-based file numbering in Czech electronic funds transfer (EFT) processing.

From a Data Vault modeling perspective, the metadata heuristics classify this object as hub-leaning. This suggests that JE_CZ_EFT_CONTRACTS_ALL is best understood as a business-key hub whose natural business key is the contract identifier, with descriptive attributes attached. The classification is a modeling suggestion only and should be validated against the wider foreign-key graph before physical implementation of any vault structures.

Key Information Stored

The table is keyed on CONTRACT_ID, which serves as the surrogate primary key through constraint JE_CZ_EFT_CONTRACTS_ALL_PK and is also enforced by the unique index JE_CZ_EFT_CONTRACTS_U1. In practice this single column acts as both the physical surrogate key and the business-key candidate.

• CONTRACT_ID – the primary contract identifier; the join column to dependent allocation records.
• BRANCH_ID – foreign key to AMS_DLG_BRANCHES_B, identifying the bank branch associated with the contract.
• CLIENT_NAME and CLIENT_NUMBER – the contracting company's name and bank-assigned client number.
• SECURITY_FIXED_CODE – the fixed security code used for file authentication with the bank.
• AP_INTERVAL_START / AP_INTERVAL_END – the interval range reserved for Accounts Payable files.
• INTERVAL_START / INTERVAL_END – the overall allocated interval range for the contract.
• LAST_USED_INTERVAL, LAST_USED_TIMESTAMP, and LAST_BATCH_FORMATTED – the tracking columns that record the most recently consumed interval number and the last formatted batch, supporting sequential number control.
• PREVIOUS_INTERVAL – the preceding interval value, used for continuity checks.
• ORG_ID – the operating unit that owns the contract, enabling multi-org security.
• INACTIVE_DATE – the date the contract ceases to be active.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE – standard WHO and concurrent-program audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 – the standard Oracle EBS descriptive flexfield columns.

Common Use Cases and Queries

The most frequent access pattern retrieves the active contract for a given operating unit and its current interval position before generating an EFT payment file. A representative query is:

• Query active contracts for an operating unit: SELECT contract_id, client_name, client_number, interval_start, interval_end, last_used_interval, inactive_date FROM je_cz_eft_contracts_all WHERE org_id = :p_org_id AND inactive_date IS NULL;
• Determine the next interval to allocate: SELECT contract_id, last_used_interval, previous_interval, last_batch_formatted FROM je_cz_eft_contracts_all WHERE contract_id = :p_contract_id;
• Reconcile allocation records against the contract: join JE_CZ_CONT_ALLOC_ALL to this table on CONTRACT_ID to verify that each accounting file interval falls within the reserved range.
• Identify branch-level contract coverage: join to AMS_DLG_BRANCHES_B on BRANCH_ID to report which bank branches have active Compatible Media contracts.
• Audit interval exhaustion: compare LAST_USED_INTERVAL with INTERVAL_END to flag contracts approaching their allocated limit.

Related Objects

• JE_CZ_CONT_ALLOC_ALL – references this table via JE_CZ_CONT_ALLOC_ALL.CONTRACT_ID → JE_CZ_EFT_CONTRACTS_ALL.CONTRACT_ID; holds allocation detail tied to the contract.
• AMS_DLG_BRANCHES_B – referenced by JE_CZ_EFT_CONTRACTS_ALL.BRANCH_ID; supplies bank branch definitions.
• JE_CZ_EFT_CONTRACTS_ALL_PK – the primary key constraint on CONTRACT_ID.
• JE_CZ_EFT_CONTRACTS_U1 – the unique index on CONTRACT_ID, the documented business-key candidate.

Because the documented foreign-key graph is limited, integration with the broader Czech EFT payment process should be verified against the corresponding localization views and concurrent programs in the JE product before relying on undocumented relationships.