My Oracle Support Banner

R12: OIE: Error OIE Sequences Missing When Defining Duplication Detection Rules (Doc ID 2377426.1)

Last updated on JUNE 22, 2018

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.
Duplication Detection Rule
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27120: SQL error during query execution. Statement: select OIE_DUP_DETECT_RULES_S.nextval from dual at.....
OIE_DUP_DETECT_RULES_S
OIE_DUP_DETECT_RS_SUMMARY_S

Symptoms

On : 12.2.4 version, Expenses Administration Utils

When attempting to setup the Duplicate Detection rules in i-Expense and selecting Create Duplicate Detection Rules the following error message occurs (excerpts ONLY):

ERROR
-----------------------
Error page:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27120: SQL error during query execution. Statement: select OIE_DUP_DETECT_RULES_S.nextval from dual
at.....
(NOTE: Two more pages of error text)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In SSWA as Internet Expense Setup and Administration responsibility attempt to access he Duplicate Detection rules form.
2. Error occurs

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!


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