Procurement - EBS (MOSC)

MOSC Banner

Purchase Requisition notification Can not open Errors out with JBO-27122: SQL error during statement

edited Nov 12, 2019 12:22PM in Procurement - EBS (MOSC) 4 commentsAnswered ✓

Hi !

I am getting error while opening Purchase Requisition notification .

We are on Oracle EBS 12.1.3

I cant find enough info on Oracle Support.

Query runs just fine in TOAD and returns expected result.

Any help to resolve this issue ?

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT prl.requisition_header_id,

       prl.requisition_line_id,

       prl.line_num AS LINE,

       msi.concatenated_segments AS ITEM_NUMBER,

       prl.item_revision,

       prl.item_description AS DESCRIPTION,

       por_apprv_wf_util_grp.get_cost_center(prl.requisition_line_id) AS COST_CENTER,

       nvl(muom.unit_of_measure_tl, prl.unit_meas_lookup_code) AS UOM,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center