Search Results supplier bank account assign

The AP_RECON_CHECK_RESULTS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing reconciliation check results between Payables and General Ledger modules. This table plays a pivotal role in ensuring financial data integrity by capturing discrepancies identified during the reconciliation process. Below is a detailed analysis of its structure, purpose, and operational context.

1. Purpose and Functional Context

The AP_RECON_CHECK_RESULTS table is primarily used by the "Payables to General Ledger Reconciliation Report" (APXGLR.rdf). This report validates whether Payables accounting entries match corresponding General Ledger postings, ensuring accurate financial reporting. The table stores reconciliation exceptions when variances occur between AP and GL data, such as:

Mismatched posted amounts between Payables and GL
Missing accounting entries in either subsystem
Discrepancies in accounting period close statuses

2. Key Table Columns

The table contains these critical columns:

Column Name	Data Type	Description
RECON_ID	NUMBER	Primary key identifier
CHECK_ID	NUMBER	Foreign key to AP_RECON_CHECKS
RESULT_TYPE	VARCHAR2(30)	Type of discrepancy (AMOUNT/PERIOD/ENTRY)
RESULT_CODE	VARCHAR2(30)	Specific error code
RESULT_MESSAGE	VARCHAR2(2000)	Detailed error description
GL_BALANCE	NUMBER	Amount from GL perspective
AP_BALANCE	NUMBER	Amount from Payables perspective
PERIOD_NAME	VARCHAR2(15)	Accounting period in conflict
CREATION_DATE	DATE	Timestamp when discrepancy was logged

3. Integration Points

The table interacts with several key EBS components:

AP_RECON_CHECKS: Contains reconciliation check definitions
GL_JE_BATCHES: References GL batches that failed reconciliation
AP_ACCOUNTING_EVENTS: Links to source Payables transactions
AP_INVOICES: Connects to original invoice documents

4. Technical Implementation

Data flows into this table through:

The standard reconciliation concurrent program (APXRECON)
Custom extensions via AP_RECON_PKG procedures
Direct SQL inserts for manual reconciliation entries

5. Maintenance Considerations

For optimal performance:

Purge old records using AP_RECONCILIATION_PURGE_PKG
Create indexes on frequently queried columns (RECON_ID, CHECK_ID)
Monitor table growth during period-end close cycles

6. Troubleshooting Common Issues

Frequent reconciliation errors include:

GL_POSTED_FLAG='N': GL batches not posted
PERIOD_STATUS='Closed': Attempts to post to closed periods
AMOUNT_DIFFERENCES: Caused by manual GL adjustments

7. Customization Potential

The table supports extensions through:

Custom result types via FND_LOOKUPS
User-defined reconciliation checks
Additional descriptive columns (max 2000 chars)

This table serves as the system of record for financial controls between Payables and General Ledger, with strict retention policies recommended for audit compliance.

Lookup Type: BANK ACCOUNT OPTIONS 12.1.1
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: BANK ACCOUNT OPTIONS 12.2.2
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: ACCOUNT TYPE 12.1.1
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: ACCOUNT TYPE 12.2.2
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: BANK CHARGE BEARER 12.2.2
product: AP - Payables , meaning: Bank Charge Bearer , description: Indicates who bears bank charges ,
Lookup Type: BANK CHARGE BEARER 12.1.1
product: AP - Payables , meaning: Bank Charge Bearer , description: Indicates who bears bank charges ,
Lookup Type: DONT PAY REASON 12.2.2
product: AP - Payables , meaning: Dont Pay Reason , description: Reason for not paying an invoice selected for payment ,
Lookup Type: BANK BRANCH TYPE 12.1.1
product: AP - Payables , meaning: Bank Branch Type , description: Indicates which list the bank routing number is on ,
Lookup Type: BANK BRANCH TYPE 12.2.2
product: AP - Payables , meaning: Bank Branch Type , description: Indicates which list the bank routing number is on ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.1.1
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.2.2
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: DONT PAY REASON 12.1.1
product: AP - Payables , meaning: Dont Pay Reason , description: Reason for not paying an invoice selected for payment ,
Lookup Type: BANK CHARGE PAYMENT METHOD 12.1.1
product: AP - Payables , meaning: Bank Charge Payment Method , description: Payment method options when using bank charges ,
Lookup Type: BANK CHARGE PAYMENT METHOD 12.2.2
product: AP - Payables , meaning: Bank Charge Payment Method , description: Payment method options when using bank charges ,
Lookup Type: INV DIST ACCOUNT TYPES 12.2.2
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Lookup Type: BANK CHARGE PAYMENT TYPE 12.1.1
product: AP - Payables , meaning: Bank Charge Payment Type , description: Payment type options when using bank charges ,
Lookup Type: BANK CHARGE PAYMENT TYPE 12.2.2
product: AP - Payables , meaning: Bank Charge Payment Type , description: Payment type options when using bank charges ,
Lookup Type: INV DIST ACCOUNT TYPES 12.1.1
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Lookup Type: REJECT CODE 12.1.1
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: REJECT CODE 12.2.2
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: POSTED_PAYMENT_RPT_SORT 12.2.2
product: AP - Payables , meaning: Posted Payment Rpt Sort , description: Sort by option for posted payment report ,
Lookup Type: POSTED_PAYMENT_RPT_SORT 12.1.1
product: AP - Payables , meaning: Posted Payment Rpt Sort , description: Sort by option for posted payment report ,
Lookup Type: BANK_LISTING_ORDERS 12.1.1
product: AP - Payables , meaning: Bank Listing Orders , description: Select method of sorting in bank listing ,
Lookup Type: BANK_LISTING_ORDERS 12.2.2
product: AP - Payables , meaning: Bank Listing Orders , description: Select method of sorting in bank listing ,
Concurrent Program: APXBABAL 12.1.1
execution_filename: APXBABAL , product: AP - Payables , user_name: APXBABAL , description: Bank Account Listing , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXBABAL 12.2.2
execution_filename: APXBABAL , product: AP - Payables , user_name: APXBABAL , description: Bank Account Listing , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: PAY_DIST_TYPES 12.2.2
product: AP - Payables , meaning: Pay Dist Types , description: Line types of the ap_payment_distributions table ,
Lookup Type: PAY_DIST_TYPES 12.1.1
product: AP - Payables , meaning: Pay Dist Types , description: Line types of the ap_payment_distributions table ,
View: AP_BANK_CHARGE_BEAERER_SRS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_BANK_CHARGE_BEAERER_SRS_V, object_name:AP_BANK_CHARGE_BEAERER_SRS_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_BANK_CHARGE_BEAERER_SRS_V ,
View: AP_BANK_CHARGE_BEAERER_SRS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_BANK_CHARGE_BEAERER_SRS_V, object_name:AP_BANK_CHARGE_BEAERER_SRS_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_BANK_CHARGE_BEAERER_SRS_V ,
Concurrent Program: APXBABAL_XML 12.2.2
product: AP - Payables , user_name: Bank Account Listing (XML) - Not Supported: Reserved For Future Use , description: Bank Account Listing , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXBABAL_XML 12.1.1
product: AP - Payables , user_name: Bank Account Listing (XML) - Not Supported: Reserved For Future Use , description: Bank Account Listing , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: INVOICE IMPORT REJECTION 12.1.1
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: INVOICE IMPORT REJECTION 12.2.2
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: CARD EXCEPTION 12.2.2
product: AP - Payables , meaning: Card Exception , description: Procurement card transaction validation exception ,
Lookup Type: HOLD CODE 12.1.1
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Table: AP_RECON_CHECK_RESULTS 12.1.1
product: AP - Payables , description: Temporary storage of payment subtotals used for bank account reconciliation comparison , implementation_dba_data: Not implemented in this database ,
Table: AP_RECON_CHECK_RESULTS 12.2.2
product: AP - Payables , description: Temporary storage of payment subtotals used for bank account reconciliation comparison , implementation_dba_data: Not implemented in this database ,
Lookup Type: HOLD CODE 12.2.2
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: BANK_CHARGE_SORT_OPTION 12.1.1
product: AP - Payables , meaning: Bank Charge Sort Option , description: Bank Charge Sort Option ,
Lookup Type: BANK_CHARGE_SORT_OPTION 12.2.2
product: AP - Payables , meaning: Bank Charge Sort Option , description: Bank Charge Sort Option ,
Lookup Type: EDI REMITTANCE METHOD 12.1.1
product: AP - Payables , meaning: Edi Remittance Method , description: Indicates which partner is responsible to send the remittance advice ,
Lookup Type: EDI REMITTANCE METHOD 12.2.2
product: AP - Payables , meaning: Edi Remittance Method , description: Indicates which partner is responsible to send the remittance advice ,
Lookup Type: INSTITUTION TYPE 12.1.1
product: AP - Payables , meaning: Institution Type , description: Bank Branch Record Types ,
Lookup Type: INSTITUTION TYPE 12.2.2
product: AP - Payables , meaning: Institution Type , description: Bank Branch Record Types ,
Lookup Type: AE LINE TYPE 12.2.2
product: AP - Payables , meaning: Ae Line Type , description: Types of AP Accounting Entry Lines ,
Lookup Type: AE LINE TYPE 12.1.1
product: AP - Payables , meaning: Ae Line Type , description: Types of AP Accounting Entry Lines ,
Lookup Type: RECORD TYPE 12.1.1
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: RECEIPT PROGRAM 12.2.2
product: AP - Payables , meaning: Receipt Program , description: Automatic Receipt Program Types for Accounts Receivable ,
Lookup Type: RECEIPT PROGRAM 12.1.1
product: AP - Payables , meaning: Receipt Program , description: Automatic Receipt Program Types for Accounts Receivable ,