R12.1.3 : 3 forms fail to generate : APXRICAD.fmx,APXIISIM.fmxAPXINWKB.fmx
Hi,
We have upgraded the database 11.1.0.7 to 11.2.0.3.
3 forms fail to generate : APXRICAD.fmx,APXIISIM.fmxAPXINWKB.fmx
with the following error :
-------------------------------------------
ERROR generating form "forms/US/APXIISIM.fmx" from input file
/module/apps/apps_st/appl/au/12.0.0/forms/US/APXIISIM.fmb
FRM-30064: Unable to parse statement SELECT classification_name, classification_code, country_code
FROM zx_fc_intended_use_v
WHERE (country_code = :INVOICES_FOLDER.taxation_country OR country_code is NULL)
AND effective_from <= :PARAMETER.p_tax_effective_date
AND (effective_to >= :PARAMETER.p_tax_effective_date OR effective_to is NULL)
AND (disable_date >= :parameter.p_tax_effective_date OR disable_date IS NULL) /*Bug13637178*/.