Search Results create bank

The CE_BANK_UPGRADE_ERRORS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for tracking and managing errors encountered during the upgrade or migration of banking-related data. This table is part of the Cash Management (CE) module, which handles bank account management, cash positioning, and bank reconciliation. During an upgrade from a previous version of Oracle EBS to 12.1.1 or 12.2.2, banking data may require transformation or validation, and any issues arising from this process are logged in CE_BANK_UPGRADE_ERRORS for troubleshooting and resolution.

Purpose and Functionality

The primary purpose of CE_BANK_UPGRADE_ERRORS is to capture errors that occur during the upgrade of banking data, ensuring transparency and facilitating corrective actions. This table stores details such as error messages, affected records, and contextual information about the upgrade process. It acts as a diagnostic tool for administrators and functional consultants to identify and resolve data inconsistencies, missing references, or validation failures that may arise during the upgrade.

Key Columns and Structure

The table typically includes the following columns:

ERROR_ID: A unique identifier for each error record.
UPGRADE_RUN_ID: Links the error to a specific upgrade execution.
BANK_ACCOUNT_ID: References the bank account involved in the error.
ERROR_MESSAGE: A descriptive text explaining the issue encountered.
ERROR_TYPE: Classifies the error (e.g., validation, data mismatch).
STATUS: Indicates whether the error is unresolved, in progress, or resolved.
CREATION_DATE: Timestamp when the error was logged.
LAST_UPDATE_DATE: Timestamp of the last modification to the error record.

Common Error Scenarios

Errors logged in this table often stem from:

Data Integrity Issues: Missing or invalid references to banks, branches, or accounts.
Validation Failures: Incompatible formats for fields like IBAN or SWIFT codes.
Customization Conflicts: Customizations in older versions that conflict with the upgraded schema.
Configuration Gaps: Missing setup data required by the new version.

Resolution Process

To address errors in CE_BANK_UPGRADE_ERRORS, administrators typically:

Analyze the error message and affected data.
Cross-reference with upgrade documentation or Oracle Support.
Apply patches or manual fixes to resolve data inconsistencies.
Re-run the upgrade process or specific data migration scripts.
Update the error record status upon resolution.

Integration with Other Modules

The table interacts with other EBS modules like Accounts Payable (AP) and Accounts Receivable (AR), as banking data is shared across these modules. Errors in CE_BANK_UPGRADE_ERRORS may impact payment processing or bank reconciliation, making timely resolution critical.

Best Practices

To minimize errors during upgrades:

Conduct a pre-upgrade assessment of banking data.
Review Oracle's upgrade documentation and patches.
Test the upgrade in a non-production environment.
Monitor CE_BANK_UPGRADE_ERRORS proactively during the upgrade.

In summary, CE_BANK_UPGRADE_ERRORS is an essential component of Oracle EBS upgrades, providing visibility into banking data issues and enabling a smoother transition to newer versions. Proper management of this table ensures data integrity and operational continuity post-upgrade.

Lookup Type: CE_BANK_ADD_OPTION 12.2.2
product: CE - Cash Management , meaning: Create or add Bank Choice , description: Create or add Bank Choice ,
Lookup Type: CP_DYNAMIC_PROMPT 12.1.1
product: CE - Cash Management , meaning: Cash Position Dynamic Prompts ,
Lookup Type: CP_DYNAMIC_PROMPT 12.2.2
product: CE - Cash Management , meaning: Cash Position Dynamic Prompts ,
Lookup Type: CE_BRANCH_ADD_OPTION 12.1.1
product: CE - Cash Management , meaning: Create or add Branch choice , description: Create or add branch choice ,
Lookup Type: CE_BRANCH_ADD_OPTION 12.2.2
product: CE - Cash Management , meaning: Create or add Branch choice , description: Create or add Branch choice ,
Lookup Type: CE_BAT_SEARCH_FIELDS 12.2.2
product: CE - Cash Management , meaning: Bank Account Transfer search fields ,
Lookup Type: CE_BAT_SEARCH_FIELDS 12.1.1
product: CE - Cash Management , meaning: Bank Account Transfer search fields ,
Lookup Type: BANK_INSTITUTION_TYPE 12.2.2
product: CE - Cash Management , meaning: Bank Institution Type , description: Bank institution types lookup ,
Lookup Type: BANK_INSTITUTION_TYPE 12.1.1
product: CE - Cash Management , meaning: Bank Institution Type , description: Bank institution types lookup ,
Lookup Type: BANK_RELATIONSHIP_TYPE 12.2.2
product: CE - Cash Management , meaning: Bank Relationship Type , description: Bank relationship types lookup ,
Lookup Type: PAYMENTTEMPLATECODE_SEARCH_OPT 12.1.1
product: CE - Cash Management , meaning: Payment Template Code Poplist Search Option , description: payment template code poplist search option ,
Lookup Type: BANK_RELATIONSHIP_TYPE 12.1.1
product: CE - Cash Management , meaning: Bank Relationship Type , description: Bank relationship types lookup ,
Lookup Type: BANK_BRANCH_TYPE 12.1.1
product: CE - Cash Management , meaning: Bank Branch Type , description: Bank branch types lookup ,
Lookup Type: PAYMENTTEMPLATECODE_SEARCH_OPT 12.2.2
product: CE - Cash Management , meaning: Payment Template Code Poplist Search Option , description: payment template code poplist search option ,
Lookup Type: BANK_BRANCH_TYPE 12.2.2
product: CE - Cash Management , meaning: Bank Branch Type , description: Bank branch types lookup ,
Concurrent Program: ARPLABIR 12.1.1
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ARPLABIR 12.2.2
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: OPENING_BAL_TYPE 12.1.1
product: CE - Cash Management , meaning: Opening Bal Type , description: Opening Bal Type ,
Lookup Type: OPENING_BAL_TYPE 12.2.2
product: CE - Cash Management , meaning: Opening Bal Type , description: Opening Bal Type ,
Lookup Type: INSTITUTION_TYPE 12.2.2
product: CE - Cash Management , meaning: Bank Institution Type ,
Lookup Type: EXCHANGE_RATE_DATE_TYPE 12.2.2
product: CE - Cash Management , meaning: Exchange Rate Date Type , description: Exchange rate date defaulted for foreign currency bank ,
Lookup Type: INSTITUTION_TYPE 12.1.1
product: CE - Cash Management , meaning: Bank Institution Type ,
Lookup Type: EXCHANGE_RATE_DATE_TYPE 12.1.1
product: CE - Cash Management , meaning: Exchange Rate Date Type , description: Exchange rate date defaulted for foreign currency bank ,
Concurrent Program: ARPLABIM 12.2.2
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: SRC_TRX_TYPE 12.1.1
product: CE - Cash Management , meaning: Source Transaction Type ,
Lookup Type: SRC_TRX_TYPE 12.2.2
product: CE - Cash Management , meaning: Source Transaction Type ,
Concurrent Program: ARPLABIM 12.1.1
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ARPLABIMINT 12.1.1
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ARPLABIMINT 12.2.2
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: CE_BANK_UPGRADE_ERRORS 12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_BANK_UPGRADE_ERRORS, object_name:CE_BANK_UPGRADE_ERRORS, status:VALID, product: CE - Cash Management , description: This table stores errors that occurred when upgrading a bank, a bank branch, or a bank account. , implementation_dba_data: CE.CE_BANK_UPGRADE_ERRORS ,
Table: CE_BANK_UPGRADE_ERRORS 12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_BANK_UPGRADE_ERRORS, object_name:CE_BANK_UPGRADE_ERRORS, status:VALID, product: CE - Cash Management , description: This table stores errors that occurred when upgrading a bank, a bank branch, or a bank account. , implementation_dba_data: CE.CE_BANK_UPGRADE_ERRORS ,
Table: CE_BANK_UPGRADE_MODES 12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_BANK_UPGRADE_MODES, object_name:CE_BANK_UPGRADE_MODES, status:VALID, product: CE - Cash Management , description: This table stores the bank upgrade mode of each bank entity for source products that current bank tables reside in. , implementation_dba_data: CE.CE_BANK_UPGRADE_MODES ,
Table: CE_BANK_UPGRADE_MODES 12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_BANK_UPGRADE_MODES, object_name:CE_BANK_UPGRADE_MODES, status:VALID, product: CE - Cash Management , description: This table stores the bank upgrade mode of each bank entity for source products that current bank tables reside in. , implementation_dba_data: CE.CE_BANK_UPGRADE_MODES ,
Lookup Type: FC_VIEW_BY 12.2.2
product: CE - Cash Management , meaning: Fc View By , description: Fc View By ,
Table: CE_UPG_RELATIONSHIP_REC 12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_UPG_RELATIONSHIP_REC, object_name:CE_UPG_RELATIONSHIP_REC, status:VALID, product: CE - Cash Management , description: This table stores relationship information for bank, bank branch, and bank account contact including job title , implementation_dba_data: CE.CE_UPG_RELATIONSHIP_REC ,
Table: CE_UPG_RELATIONSHIP_REC 12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_UPG_RELATIONSHIP_REC, object_name:CE_UPG_RELATIONSHIP_REC, status:VALID, product: CE - Cash Management , description: This table stores relationship information for bank, bank branch, and bank account contact including job title , implementation_dba_data: CE.CE_UPG_RELATIONSHIP_REC ,
Lookup Type: BANK_ACCOUNT_TYPE 12.2.2
product: CE - Cash Management , meaning: Bank Account Type , description: Bank Account Type ,
Lookup Type: PURGE_TXCD_PROCESS_OPTION 12.2.2
product: CE - Cash Management , meaning: Purge Trx Codes Process Option , description: Process options for Purge Bank Transaction Codes ,
Lookup Type: BANK_ACCOUNT_FOR_DISPLAY 12.1.1
product: CE - Cash Management , meaning: Bank Account For Display ,
Concurrent Program: CESQLLDR 12.2.2
execution_filename: CE_BANK_STMT_SQL_LDR.call_sql_loader , product: CE - Cash Management , user_name: CESQLLDR , description: Executable for the Bank Statement Loader program , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: CEUNREC 12.2.2
execution_filename: CE_AUTO_BANK_UNREC.unreconcile_all , product: CE - Cash Management , user_name: Unreconcile Statement Lines , description: Unreconcile bank Statement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: BANK_ACCOUNT_TYPE 12.1.1
product: CE - Cash Management , meaning: Bank Account Type , description: Bank Account Type ,
Concurrent Program: CEBSLERR 12.2.2
execution_filename: CEBSLERR , product: CE - Cash Management , user_name: CEBSLERR , description: Executable for the Bank Statement Loader auto-execution report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: CEUNREC 12.1.1
execution_filename: CE_AUTO_BANK_UNREC.unreconcile_all , product: CE - Cash Management , user_name: Unreconcile Statement Lines , description: Unreconcile bank Statement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ARPLABRC 12.1.1
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: CERESTR 12.2.2
execution_filename: CE_PURGE.restore_process , product: CE - Cash Management , user_name: CERESTR , description: Restore Bank Statements , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: FC_VIEW_BY 12.1.1
product: CE - Cash Management , meaning: Fc View By , description: Fc View By ,
Lookup Type: BANK_ACCOUNT_FOR_DISPLAY 12.2.2
product: CE - Cash Management , meaning: Bank Account For Display ,
Concurrent Program: CESQLLDRINT 12.1.1
execution_filename: CE_BANK_STMT_SQL_LDR.call_sql_loader , product: CE - Cash Management , user_name: CESQLLDR , description: Executable for the Bank Statement Loader program , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ARPLABRC 12.2.2
execution_filename: CE_AUTO_BANK_REC.statement , product: CE - Cash Management , user_name: Automatic Bank Reconciliation , description: Cashbook - Automatic Bank Reconciliation , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,