'Manage Business Unit Function' displaying error while click on Save: "Remote Region error # " (Doc ID 2315990.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Symptoms

oracle.adfinternal.view.faces.renderkit.rich.RegionRenderer _logError
Supplemental Detail ALL: Remote Region error #18: An uncaught exception was thrown on the producer at "http://hcm-internal.oracleoutsourcing.com:10619/hcmCoreSetup/rr/" while trying to run an ADF Taskflow.
javax.servlet.ServletException: JBO-27023: Failed to validate all rows in a transaction.
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

Caused by: oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4769)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2196)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2527)

Caused by: oracle.jbo.RowValException: JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002133119 10 110 null ] in BUServiceProviderEO
at oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3296)
at oracle.jbo.server.EntityCache.validate(EntityCache.java:3821)
at oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2853)
at oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.validateEntity(OAEntityImpl.java:1465)
at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2946)
at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4747)

Caused by: oracle.jbo.AttrSetValException: JBO-FND:::FND_CMN_REC_COMB_VALS_EXST: <MESSAGE><NUMBER></NUMBER><TEXT>A record with this combination of values already exists.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>
at oracle.jbo.rules.AbstractValidator.createAttributeException(AbstractValidator.java:1910)
at oracle.jbo.rules.RulesBeanUtils.createException(RulesBeanUtils.java:399)
at oracle.jbo.rules.AbstractValidator.createException(AbstractValidator.java:1398)
at oracle.jbo.rules.JboAbstractValidator.createException(JboAbstractValidator.java:449)
at oracle.jbo.rules.AbstractValidator.doRaiseException(AbstractValidator.java:1453)

Changes

Please check the output of the SQL or SQL Script to be executed

->  select /*SR*/ * from FUN_ALL_BUSINESS_UNITS_V
    select /*SR*/ * from fun_bu_usages;
    select /*SR*/  * from fun_bu_service_providers;

Cause

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