My Oracle Support Banner

R12 AP Not Able To Create New Sites For The AP Suppliers - JBO-27122 Error (Doc ID 2532675.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

When customer tries to enter a supplier site he receives an error.

Steps:
1. Query a supplier
2. Press (B) Create for Supplier Site
3. Choose Address
4. Check Select, fill in Site Name and press (B) Apply. Then the error is raised:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'N' as select1, substr(:1,1,15) as Site_Name, organization_id, name,:2 as Site_Name_Display from hr_operating_units
WHERE mo_global.check_access(organization_id) = 'Y') QRSLT ORDER BY name
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
at oracle.apps.pos.supplier.components.webui.CreateSiteCO.processRequest(CreateSiteCO.java:114)
[...]

Changes

  Patch 13063675 was recently applied.

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
Symptoms
Changes
Cause
Solution
References


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