R11i: R12: OIE: Constraint "AP_POL_CONTEXT_U1" Violated Accessing the Internet Expenses Setup and Administration Responsibility (Doc ID 1273578.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Internet Expenses - Version 12.0.0 and later
Information in this document applies to any platform.
Constraint "AP_POL_CONTEXT_U1" Violated
Internet Expenses Setup and Administration responsibility

Symptoms

When attempting to access the Internet Expenses Setup and Administration - > Internet Expenses Setup
the following error occurs.

Error:
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "AP_POL_CONTEXT_U1" violated during post operation:"Insert" using SQL Statement "INSERT INTO AP_POL_CONTEXT(SELECTED_ORG_ID,USER_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7)".
## Detail 0 ##
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AP.AP_POL_CONTEXT_U1) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

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