REL12.1 CE/AP: While Patching, CEXSTATI.fmx Did Not Generate Successfully Due To ORA-00904: "TC"."SUB_FAMILY_CODE": invalid identifier (Doc ID 2068962.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


While applying a patch, the CEXSTATI.fmx did not generate:

ERROR

The following Oracle Forms objects did not generate successfully:

ce forms/US CEXSTATI.fmx


DETAILED ERROR

FRM-30064: Unable to parse statement
select tc.type_dsp trx_type_dsp, tc.trx_code trx_code, tc.domain_code, tc.family_code,
tc.sub_family_code,tc.description Description
from ce_transaction_codes_v tc
where tc.bank_account_num = :lines.bank_account_num
and bank_account_currency_code = nvl(:headers.currency_code, bank_account_currency_code)
and bank_name = nvl(:headers.bank_name, bank_name)
and bank_branch_name = nvl(:headers.bank_branch_name, bank_branch_name) and
trunc(nvl(tc.start_date,sysdate)) <= trunc(sysdate) and
(tc.end_date is null or trunc(nvl(tc.end_date,sysdate)) > trunc(sysdate))
.
ORA-00904: "TC"."SUB_FAMILY_CODE": invalid identifier
Record Group TRX_CODES_RG
Form: CEXSTATI
FRM-30085: Unable to adjust form for output.
-------------------------------------------------------------------------

Generated    0 files successfully.
Generated    0 files with non-fatal warnings.
Generated    1 files with fatal errors.

adfrmgen is exiting with status 1

 

 

Cause

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 hundreds of Community platforms