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, 2020

Applies to:

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


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

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(
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(
at oracle.apps.pos.supplier.components.webui.CreateSiteCO.processRequest(


  Patch 13063675 was recently applied.


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.