AutoInvoice Ends with Error: APP-AR-11526: ORA-00907: missing right parenthesis appear (Doc ID 2119110.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Autoinvoice program ends with error below.

Error message from Autoinvoice Import Program log.

APP-AR-11526: ORA-00907: missing right parenthesis
SELECT
L.CUST_TRX_TYPE_ID, DECODE(L.CUST_TRX_TYPE_ID,
'1', '1',
'2',
APP-AR-11526: 7170481/ar/lib/raavar.lpc 211
SELECT
L.CUST_TRX_TYPE_ID, DECODE(L.CUST_TRX_TYPE_ID,
'1', '1',
'2', '2', -99),
L.INVOICING_RULE_NAME, DECODE(L.INVOICING_RULE_NAME,
'Arrears Invoice', '-3',
'Advance Invoice', '-2',
NULL, NULL, -99),
L.TERM_ID, DECODE(L.TERM_ID,
'4', '4',
'5', '5',
NULL, NULL, -99),
L.UOM_CODE, DECODE(L.UOM_CODE,
'M', 'M',
'M'', 'M'',
'M2', 'M2',
'M3', 'M3',
NULL, NULL, -99),
L.AGREEMENT_ID, DECODE(L.AGREEMENT_ID,
NULL, NULL, -99),
L.ACCOUNTING_RULE_ID, DECODE

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms