Buyer Work Center: JBO-27122 Unexpected Error Occurs while Searching Requisitions With Returned Line(s) (Doc ID 2234481.1)

Last updated on FEBRUARY 17, 2017

Applies to:

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

Symptoms

After returning a line in a requisition through Buyer work center, then while searching for the returned requisition in Buyer work center requisitions page, the following error occurs


ERROR

You have encountered an unexpected error

Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

STEPS TO REPLICATE

The issue can be reproduced at will with the following steps:

1. Navigate to Purchasing responsibility
2. Buyer Work Center > Requisitions > Search for requisition # > select a single line
3. Click on Return
4. Uncheck "Return Entire Requisition" flag
5. Return requisition line successful
6. Buyer Work Center > Requisitions > Search requisitions > Search for the same requisition (which has one line already returned)

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