My Oracle Support Banner

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 JANUARY 16, 2018

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

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

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.