R12: CE: CEBG and CEFV Invalid Objects In APPS Schema (Doc ID 2402826.1)

Last updated on JUNE 11, 2024

Applies to:

Symptoms

Following business views are found invalid in apps schema:

CEBG_BANK_STATEMENT_LINES
CEBG_BANK_STATEMENTS
CEFG_BANK_STATEMENT_LINES
CEFG_BANK_STATEMENTS

View Generator output shows:

The following busienss views could not be generated.

CEFV_BANK_ACCOUNTS
bis_vg_compile.do_short_ddl
ORA-01789: query block has incorrect number of result columns[ do_ddl(APPLSYS, FND, 2, $statement$, CEFG_BANK_ACCOUNTS): private_do_ddl(APPS, APPLSYS, APPLSYS, 2, $statement$, CEFG_BANK_ACCOUNTS): do_cd_view(0, APPS, 2, CEFG_BANK_ACCOUNTS, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW CEFG_BANK_ACCOUNTS ( "BANK_ACCOUNT_ID" , "BANK_ACCOUNT_NAME" , "ALTERNATE_BANK_ACCOUNT_NAME" , "BANK_ACCOUNT_NUMBER" , "BANK_ACCOUNT_TYPE" , "ACCOUNT_TYPE" , "MULTICURRENCY_ALLOWED_FLAG" , "POOLED_ACCOUNT_FLAG" , "DESCRIPTION" , "MA' ]

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.