My Oracle Support Banner

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

Last updated on MAY 24, 2018

Applies to:

Oracle Cash Management - Version 12.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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