In Oracle iSupplier Portal and Oracle Supplier Lifecycle Management, Error Occurs When Buyers Attempt To Create a User Account For a Supplier Contact - ORA-20001 ORA-06512: at APPS.FND_USER_PKG (Doc ID 2963537.1)

Last updated on JULY 25, 2023

Applies to:

Oracle iSupplier Portal - Version 12.2.5 and later
Oracle Supplier Lifecycle Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

In Oracle iSupplier Portal and Oracle Supplier Lifecycle Management, Release 12.2.5 and later, an error occurs when buyers attempt to create a user account for a supplier contact, during the supplier registration process.

Due to this issue, buyers cannot create user accounts for the supplier contacts, and therefore those supplier contacts would not be able to log in to Oracle Applications and use iSupplier Portal Full Access responsibility.

Error

Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: An unexpected error occurred. Please contact your System Administrator
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_PKG", line 4445
ORA-06512: at line 1

  at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783)
  at oracle.apps.pos.request.webui.AddSupplierContactCO.processFormRequest(AddSupplierContactCO.java:186)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:924)
  at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
  at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1583)
  at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1598)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1136)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1102)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:957)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-20001: An unexpected error occurred. Please contact your System Administrator
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_PKG", line 4445
ORA-06512: at line 1

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
  at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
  at oracle.apps.pos.util.SSOUtil.testUserName(SSOUtil.java:95)
  at oracle.apps.pos.request.server.ContactRequestsVORowImpl.setEmailAddress(ContactRequestsVORowImpl.java:318)
  at oracle.apps.pos.request.server.SupplierContactAMImpl.validateTmpEmail(SupplierContactAMImpl.java:414)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:818)
  at oracle.apps.pos.onboard.server.FlexRegAMImpl.validateEmailAddress(FlexRegAMImpl.java:2741)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783)
  at oracle.apps.pos.request.webui.AddSupplierContactCO.processFormRequest(AddSupplierContactCO.java:186)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:924)
..
..

Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications as the Buyer user.
2. Navigate to Supplier Hub Americas Bus Admin responsibility > Supplier Home
3. On the Suppliers home page, click the Register New Supplier button.
4. Choose the desired Operating Unit value and click the Continue button.
5. On the On the "Suppliers: Register New Supplier" page, enter the mandatory (required) details and click the "Save & Continue" button.
6. On the New Supplier Request page, enter the Taxpayer ID value and save.
7. Scroll down to the Contact Directory region and click the Create button (or select existing contact).
8. On the Update Contact page, ensure that all required details are entered. Enable the checkbox "Create User Account For The Contact" and then click the Apply button. The error occurs at this point.

Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.

Changes

The business has recently performed configuration for SSO / OID / LDAP, as guided in:
- <Note:1992780.1> - Unable To Approve Or Update The Supplier And Supplier Site - Getting An Exception Error Message
- <Note:1371932.1> - Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 11gR1

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

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

In Oracle iSupplier Portal and Oracle Supplier Lifecycle Management, Error Occurs When Buyers Attempt To Create a User Account For a Supplier Contact - ORA-20001 ORA-06512: at APPS.FND_USER_PKG (Doc ID 2963537.1)

Applies to:

Symptoms

Changes

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!