Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Getting compilation error for 2 forms when applying patch 17887429.

edited Aug 14, 2014 1:10AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

@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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center