My Oracle Support Banner

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 later
Information 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


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