My Oracle Support Banner

"Missing Right Parenthesis" Error Occurs When Adding Address Containing Single Quote (Doc ID 1630431.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Retail Fiscal Management - Version 13.2.5 and later
Oracle Retail Merchandising System - Version 13.2.5 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

In Oracle Retail Fiscal Management (RFM) 13.2.x, a"Missing right parenthesis" error occurs when adding a supplier address containing a single quote character.

Steps to Reproduce:

1. Create a new supplier.
2. Add a new address to the supplier, containing the single quote character ['] in Address Line 1.
3. Press Apply and OK.
4. Note the error:  'ORA-00907 : missing right parenthesis returned from program L10N_BR_FND_SQL.CHK_ADDR_UPDATE'


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.