My Oracle Support Banner

Duplicate Detection fails java.sql.SQLException: ORA-20001: APP-SQLAP-10000 ORA-00933: SQL command not properly ended occurred in performDuplicateDetection (Doc ID 2134029.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When trying to click next from cash and other expenses page receive the following error:

 "java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-00933: SQL command not properly ended occurred in performDuplicateDetection with parameters (&PARAMETERS) while performing the following operation: ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 7643 ORA-06512: at line 1 "

Changes

Define a duplicate detection rule for Car Rental and click the check box for Merchant.

Enter information on the details page and enter the Merchant Name with an apostrophe ex. (Smith's Bar).

Cause

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
Symptoms
Changes
Cause
Solution
References


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