R12 CEBG and CEFV Invalid Objects In APPS Schema
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.
Following business views are found invalid in apps schema:
View Generator output shows:
The following busienss views could not be generated.
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' ]
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms