My Oracle Support Banner

R12: CE: Upgrade To EBS 12.2.5 Failed On Module CEXSTATI, FRM-30064, ORA-00904, FRM-30085 (Doc ID 2157729.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Cash Management - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.


On : 12.2.5 version, Other Issues
Upgrade to EBS EBS 12.1.3 to 12.2.5 failed on module CEXSTATI.fmx
Have a problem when installing patch 19676458 to upgrade from 12.2.0 to 12.2.5.
Getting the following message in u19676458.log, The following Oracle Forms objects did not generate successfully: ce forms/US CEXSTATI.fmx
An error occurred while generating Oracle Forms files.

Continue as if it were successful :


AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.
Here is the error adworker log:

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
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.






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

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