Patch 13776681 - Fails With ORA-00933: SQL command not properly ended
Hello,
While trying to apply patch 13776681, the following error is received.
AD Worker error:
The following ORACLE error:
ORA-00933: SQL command not properly ended
occurred while executing the SQL statement:
CREATE FORCE VIEW APPS.AR_CM_NET_REV_DIST_FORM
("PREVIOUS_CUSTOMER_TRX_LINE_ID", "PREVIOUS_CUSTOMER_TRX_ID", "GL_DATE",
"AMOUNT", "NET_UNIT_PRICE", "PERIOD_SET_NAME") AS SELECT
previous_customer_trx_line_id , previous_customer_trx_id , trunc(gl_date)
, sum(amount) , sum(decode(credit_method_for_rules, 'UNIT', 0, 'LIFO', 0,
amount) ) / decode(sum(decode(credit_method_for_rules, '', quantity, 0) ),
0, 1, sum(decode(credit_method_for_rules, '', quantity, 0) ) ) ,