iProcurement personalize view
One user created a personal view at buyer work center. He's not able to access the requisitions page after that.
user is getting error like "unexpected error.please contact system administrator"
Error Page |
Exception Details. |
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT prh.requisition_header_id REQUISITION_HEADER_ID , nvl2(prh.par_draft_id, pod.modification_number, prh.segment1) REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , DECODE(prl.item_id,NULL,prl.item_description,DECODE(msi.allow_item_desc_update_flag,'Y',prl.item_description,msit.description)) ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED |
Tagged:
2