Payable Open Interface Import Is failing With ORA-00600 [12337] (Doc ID 1564196.1)

Last updated on OCTOBER 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

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

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