Patch#17202262:R12.ZX.B failing to generate form ARXTWMAI.fmx
Hi,
Issue: Patch 17202262:R12.ZX.B Log
The following Oracle Forms objects did not generate successfully:
ar forms/US ARXTWMAI.fmx
An error occurred while generating Oracle Forms files.
Continue as if it were successful [No] : No
Freeing includes hash table
Freeing fixes hash table
Freeing basedons hash table
Freeing entities hash table
Cause:
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,
(
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,
Tagged:
0