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

MOSC Banner

Patch 13776681 - Fails With ORA-00933: SQL command not properly ended

edited Dec 17, 2014 4:32PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

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

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