Results for “ap_recon_record_specs”

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

Overview

AP_RECON_RECORD_SPECS is an Oracle Payables configuration table that defines bank reconciliation flat file structures consumed by the AutoClear process. AutoClear is the EBS feature responsible for automatically reconciling bank statement lines against Payables payment records. Because banks deliver statement data in heterogeneous flat file layouts, AutoClear requires a declarative mapping between physical file positions and the corresponding Oracle Payables columns for each bank account. AP_RECON_RECORD_SPECS stores exactly that mapping metadata, allowing the reconciliation engine to parse incoming files without custom code per bank.

In Oracle EBS 12.1.1 and 12.2.2, this table is a setup-time object: records are created and maintained as part of bank account reconciliation configuration rather than generated by transactional activity. The ETRM metadata notes that the table is "not implemented in this database," a common annotation for documentation repositories that do not carry live data, and it does not affect the object's role in a production instance. From a dimensional modeling perspective, the heuristic Data Vault classification is hub-leaning, driven by the presence of a surrogate primary key and outbound foreign key to AP_BANK_ACCOUNTS_ALL. This suggests AP_RECON_RECORD_SPECS can be treated as a hub-like entity keyed by RECON_RECORD_SPEC_ID, with descriptive attributes attached or modeled as a satellite.

Key Information Stored

The documented column set is compact and centers on identifying and scoping each reconciliation record specification:

• RECON_RECORD_SPEC_ID — surrogate primary key defined by AP_RECON_RECORD_SPECS_PK. This is the technical identifier used by all dependent tables.
• BANK_ACCOUNT_ID — foreign key to AP_BANK_ACCOUNTS_ALL, tying the flat file specification to a specific internal bank account. Together with BANK_NAME and AP_COLUMN_REFERENCE, this forms the unique index AP_RECON_RECORD_SPECS_UK1.
• BANK_NAME — the bank name as it appears in the incoming statement file, used to validate and route the record specification.
• AP_COLUMN_REFERENCE — the target Oracle Payables column that a parsed field maps to, defining how AutoClear interprets each record element.
• RECORD_LEVEL — indicates which level of the flat file structure (for example, header, detail, or trailer) the specification applies to.

AP_RECON_RECORD_SPECS_UK1 (BANK_NAME, BANK_ACCOUNT_ID, AP_COLUMN_REFERENCE, RECORD_LEVEL) is the business-key candidate unique index; RECON_RECORD_SPEC_ID remains the surrogate key.

Common Use Cases and Queries

Typical scenarios include validating reconciliation setup before AutoClear runs, diagnosing parse failures, and auditing which columns a bank account feeds. A representative query joins the specification to bank accounts:

SELECT r.recon_record_spec_id, r.bank_name, r.bank_account_id,
       r.ap_column_reference, r.record_level
FROM   ap_recon_record_specs r, ap_bank_accounts_all b
WHERE  r.bank_account_id = b.bank_account_id
AND    b.bank_account_name = :account_name;

Reconciliation support teams also group specifications by RECORD_LEVEL to confirm all required levels are configured, and join to AP_RECON_ERROR_CHK_GROUPS to review error-checking rules associated with each specification.

Related Objects

• AP_BANK_ACCOUNTS_ALL — referenced via BANK_ACCOUNT_ID; the parent bank account definition.
• AP_RECON_ERROR_CHK_GROUPS — child table joined on RECON_RECORD_SPEC_ID, holding error-check group definitions.
• AP_RECON_ERROR_CHK_GROUP_LINES — child table joined on RECON_RECORD_SPEC_ID, holding the individual error-check lines.
• AutoClear concurrent programs and Payables reconciliation setup UI — consume these specifications at runtime.