R12: AP: JBO-27122 Create or Update Supplier Contacts (Doc ID 1912101.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After querying a particular supplier and selecting the Contact Directory link, after clicking the Update icon, receiving the following Error:
   
You have encountered an unexpected error.  Please contact the System Administrator for assistance.
Click here for exception details.

Error Page  
Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM
 (select
  pvs.vendor_site_id,
  pvs.vendor_site_code,
  pvs.vendor_id,
  hou.name, decode( sec_attr.number_value, null, 'N', 'Y') as  User_Sec_Attr,
  decode( sec_attr.number_value, null, 'N', 'Y') as Original_Sec_Attr ,
  pv.vendor_name as supplier_name, pvs.org_id as org_id
  from ap_supplier_sites_all pvs,hr_all_organization_units_tl hou,
  ak_web_user_sec_attr_values sec_attr,
  (select vendor_id, vendor_name from ap_suppliers pv start with pv.vendor_id
  = :1 connect by prior pv.vendor_id = pv.parent_vendor_id) pv
  where pvs.org_id=hou.organization_id
  and hou.language (+)= USERENV('LANG')
  and
  (pvs.inactive_date is null OR pvs.inactive_date >= sysdate)
  and sec_attr.web_user_id(+) = :2
  and sec_attr.ATTRIBUTE_CODE (+) = 'ICX_SUPPLIER_SITE_ID'
  and sec_attr.ATTRIBUTE_APPLICATION_ID (+) = 177
  and sec_attr.number_value(+) = pvs.vendor_site_id
  and pvs.vendor_id = pv.vendor_id) QRSLT  WHERE
  (mo_global.check_access(org_id) = 'Y') ORDER BY supplier_name,
  vendor_site_code
  at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
  at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
  at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAExce
  ption.java:993)
 
  ....
  (line 204)
  at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
  at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketRead Handler.java:260)
  at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
  at java.lang.Thread.run(Thread.java:595)
  java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
  at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java: 1134)

 

Steps to reproduce:
-------------
Login to Payables Responsability
Navigate to Supplier / Supplier Entry
Query a Supplier
Go to Contact Directory

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