Purchase Requisition notification Can not open Errors out with JBO-27122: SQL error during statement
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,