Turkey Add-on Localization: Form CLE_F147_APENBE.fmx Failed To Generate While Applying Patch 26392483
(Doc ID 2584007.1)
Last updated on SEPTEMBER 03, 2019
Applies to:
EMEA Add-on Localizations - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to apply Patch:26392483, the form CLE_F147_APENBE.fmx Failed To with following error
ERROR
-----------------------
FRM-30064: Unable to parse statement SELECT BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME,
CBAU.BANK_ACCT_USE_ID BANK_ACCT_USE_ID,
BA.BANK_ACCOUNT_ID BANK_ACCOUNT_ID,
BA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM,
CBB.BANK_BRANCH_NAME BANK_BRANCH_NAME,
CBB.BANK_NAME BANK_NAME
FROM CE_BANK_ACCT_USES_OU_V CBAU,
CE_BANK_ACCOUNTS BA,
CE_BANK_BRANCHES_V CBB ,
CLE_HZ_PARTIES_EXT CHPE,
CLE_HZ_PARTIES_EXT_DFV CHPD
WHERE CBAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID AND
BA.BANK_BRANCH_ID = CBB.BRANCH_PARTY_ID AND
CBB.bank_party_id = CHPE.dff_id1 AND
CHPE.rowid = CHPD.row_id
AND CHPD.endorsement = 'Y' AND
((BA.multi_currency_allowed_flag = 'Y' or BA.currency_code = nvl(:AP_END_BATCHES.CURRENCY_CODE, BA.currency_code)) AND CBAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID AND CBB.branch_party_id = BA.bank_branch_id AND SYSDATE < NVL(BA.END_DATE,SYSDATE+1) AND BA.ACCOUNT_CLASSIFICATION = 'INTERNAL' AND CBAU.ap_use_enable_flag = 'Y' AND CBAU.org_id = :AP_END_BATCHES.ORG_ID).
ORA-00904: "CHPD"."ENDORSEMENT": invalid identifier
Record Group BANK_ACCOUNTS
Form: CLE_F147_APENBE
FRM-30085: Unable to adjust form for output.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch: 26392483
2. FMX is not generated with this error.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |