"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.
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