Russia Localization Form 'CLE_F221_VOP.fmx' Not Created After Applying Patch 20025629:R12.CLE.C, Error 'FRM-30085: Unable to adjust form for output' (Doc ID 2060471.1)

Last updated on NOVEMBER 14, 2016

Applies to:

EMEA Add-on Localizations - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.3 version, Russia Add-on Localizations

After applying the patch 20025629:R12.CLE.C, form 'CLE_F221_VOP.fmx' is not created. 

Error message from adwork004.log:


FRM-30064: Unable to parse statement SELECT trx.trx_number,
             fnd_currency.get_format_mask (trx.invoice_currency_code, 30)
            ) amount
,0 proforma_rem_amt
,trx.trx_date,trx.invoice_currency_code,trx.customer_trx_id trx_id, (select name from hr_all_organization_units where organization_id = trx.org_id) operating_unit
 FROM ar_cash_receipts_all rec,
      hz_cust_accounts acc,
      ra_customer_trx_all trx,
      ra_cust_trx_line_gl_dist_all dist,
      ra_cust_trx_types_all ractt
WHERE rec.pay_from_customer = acc.cust_account_id
  AND rec.pay_from_customer = trx.bill_to_customer_id
  AND rec.cash_receipt_id = :parameter.p_rec_id
  AND dist.customer_trx_id = trx.customer_trx_id
  ANd rec.currency_code=trx.invoice_Currency_code
  AND dist.account_class = 'REC'
  AND trx.cust_trx_type_id=ractt.cust_trx_type_id
  AND ractt.accounting_affect_flag = 'N'
  AND ractt.post_to_gl = 'N'
  AND trx.customer_trx_id NOT IN (SELECT FND_NUMBER.CANONICAL_TO_NUMBER(attribute9)
           FROM cle_ar_cash_receipt_ext
           WHERE attribute9 IS NOT NULL)
  AND dist.amount > 0.
ORA-03113: end-of-file on communication channel
Record Group INV_NUM_RG
Form: CLE_F221_VOP
FRM-30085: Unable to adjust form for output.


The issue can be reproduced at will with the following steps:
1. Set the parameter "optimizer_features_enable" as follows: 
optimizer_features_enable='' at init.ora file 


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