Last updated on OCTOBER 20, 2015

Applies to:

Symptoms

1. A Payables open interface import fails with the following error:
   
   
   *** 2013-06-18 06:42:32.067
   *** SESSION ID:(1274.64765) 2013-06-18 06:42:32.067
   *** CLIENT ID:(501566141) 2013-06-18 06:42:32.067
   *** SERVICE NAME:(prj1) 2013-06-18 06:42:32.067
   *** MODULE NAME:(e:PO:frm:POXRQVRQ) 2013-06-18 06:42:32.067
   *** ACTION NAME:(PO/GES_PURCHASING_SUPER_USER_AC) 2013-06-18 06:42:32.067
   
   Dump continued from file: /prj1/oracle/diag/rdbms/prj1/prj12/trace/prj12_ora_25342.trc
   ORA-00600: internal error code, arguments: [12337], [], [], [], [], [], [], [], [], [], [], []
   
   ========= Dump for incident 38596 (ORA 600 [12337]) ========
   
   *** 2013-06-18 06:42:32.068
   dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
   ----- Current SQL Statement for this session (sql_id=3tbwz7nu695fc) -----
   SELECT POLC.displayed_field, POLC.lookup_code FROM PO_LOOKUP_CODES POLC, PO_REQUISITION_LINES PORL WHERE PORL.requisition_line_id = 3010994 AND nvl(PORL.closed_code, 'OPEN') not in ('FINALLY CLOSED') AND nvl(PORL.cancel_flag, 'N') IN ('N','I') AND POLC.LOOKUP_TYPE = 'CONTROL ACTIONS' /* Allow only Fially Close for Drop Ship Requisition Line */ AND (POLC.lookup_code = 'FINALLY CLOSE' OR nvl(PORL.drop_ship_flag, 'N') <> 'Y') /* */ AND ((POLC.lookup_code in ('CANCEL REQ LINE', 'FINALLY CLOSE') AND (NOT EXISTS (SELECT 'need a so_line is not cancelled' FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, PO_SYSTEM_PARAMETERS POSP WHERE PORH.requisition_header_id = 473862 AND PORL.requisition_line_id = 3010994 AND PORH.requisition_header_id = PORL.requisition_header_id AND (OE_ORDER_IMPORT_INTEROP_PUB.Get_Open_Qty(POSP.order_source_id, PORH.requisition_header_id, PORL.requisition_line_id))>0) AND NOT EXISTS ( SELECT 'Check for lines in the interface table' FROM oe_lines_iface_all SOLI, po_system_parameters POSP, po_requisition_lines PORL, po_requisition_headers PORH WHERE PORH.requisition_header_id = 473862 AND PORL.requisition_line_id = 3010994 AND PORH.requisition_header_id = PORL.requisition_header_id AND SOLI.orig_sys_document_ref = to_char(PORH.requisition_header_id) AND SOLI.orig_sys_line_ref = to_char(PORL.requisition_line_id) AND SOLI.order_source_id = POSP.order_source_id)) /* OR (POLC.lookup_code in ('FINALLY CLOSE')) */ )) ORDER BY POLC.displayed_field
   
   
   
2. Review of the generated tracefiles reveals a call stack similar to:
   
   
   ... <- evaopn3 <- evareo <- expepr <- qkesEval_Int <- qkesEvalPred <- kkoecp <- kkerfp <- kkestGetMCOpns <- kkestAddMCPredToCtx <- kkestAddAppToMCCtx <- kkestBuildMCCtxFromApp <- kkecdn <- kkotap <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents <- apaqbdList <- apaqbd <- kkofkrSetup <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- ...

Changes

 No changes

Cause