Getting compilation error for 2 forms when applying patch 17887429.
@Hi Team,
Customer is getting compilation error for 2 forms when applying patch 17887429.
Worker log showing following error.
FRM-30436: Parent window not specified for canvas.View Canvas MAIN
FRM-30064: Unable to parse statement select * from
(
with cust as
(
SELECT rcr.related_cust_account_id
FROM hz_cust_acct_relate rcr
WHERE rcr.status='A'
AND rcr.bill_to_flag = 'Y'
AND rcr.cust_account_id = TO_NUMBER(DECODE(:app_folder.customer_id,
-1, :app_main.customer_id,
null, :app_main.customer_id,
:app_folder.customer_id))
UNION
SELECT TO_NUMBER(DECODE(:app_folder.customer_id,
-1, :app_main.customer_id,
null, :app_main.customer_id,