Not Able To Select "Internal Requisition Order Type" From the "Purchasing Options"

(Doc ID 2090169.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.


Using Purchasing, Version 12.2.4,

Attempting to use the list of values in the purchasing options - results in error - when attempting to setup the internal requisition type.

When using the purchasing options - upon selecting the internal order type - it should not error.

You have encountered an unexpected error.

Exception -
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ot.transaction_type_id,
from oe_transaction_types ot
where nvl(ot.po_required_flag,'N') = 'N'
  and nvl(ot.agreement_required_flag,'N') = 'N'
  and ot.org_id = :1
  and ot.transaction_type_code = 'ORDER') QRSLT WHERE (( UPPER(NAME) like UPPER( :1) )) ORDER BY NAME ASC
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Purchasing - setup/organizations/purchasing options
2. Locate the internal order type
3. Attempt to use the list of values
4. Unexpected error occurs.


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