My Oracle Support Banner

ORA-00600 [kktget: bind pos > num bind vars] on DML (Doc ID 2317229.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Financials for India - Version 12.2.5 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

When using Oracle Payables, when a user attempts to access the invoice workbench form (APXINWKB.fmb) the error listed below occurs.

The error is also found when running the Payables Open Interface.

ERROR
-------
APP-SQLAP-10000: ORA-00600 internal error code AP_AIL_TABLE_HANDLER_PKG.Insert_Row < APXINKIN.Line_Sum_Folder_Block_DML2.Insert_Row


The issue can be reproduced at will with the following steps:

Product: Oracle Payable
Release: 12.2.5
Database: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.

A) Using Payables Manager responsibility

B) Navigate to Invoices : Inquiry > Invoices

 

On the database side, the following error is reported for the following statements generated by the Applications interface:

ORA-00600: internal error code, arguments: [kktget: bind pos > num bind vars], [52456442], [388], [386], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=<SQL_ID>) -----
INSERT INTO AP_INVOICE_LINES_ALL( INVOICE_ID , LINE_NUMBER , LINE_TYPE_LOOKUP_CODE , LINE_GROUP_NUMBER , REQUESTER_ID , DESCRIPTION , LINE_SOURCE , ORG_ID , INVENTORY_ITEM_ID , ITEM_DESCRIPTION , SERIAL_NUMBER , MANUFACTURER , MODEL_NUMBER , WARRANTY_NUMBER , GENERATE_DISTS , MATCH_TYPE , DISTRIBUTION_SET_ID , ACCOUNT_SEGMENT , BALANCING_SEGMENT , COST_CENTER_SEGMENT , OVERLAY_DIST_CODE_CONCAT , DEFAULT_DIST_CCID , PRORATE_ACROSS_ALL_ITEMS , ACCOUNTING_DATE , PERIOD_NAME , DEFERRED_ACCTG_FLAG , DEF_ACCTG_START_DATE , DEF_ACCTG_END_DATE , DEF_ACCTG_NUMBER_OF_PERIODS, DEF_ACCTG_PERIOD_TYPE , SET_OF_BOOKS_ID , AMOUNT , BASE_AMOUNT , ROUNDING_AMT , QUANTITY_INVOICED , UNIT_MEAS_LOOKUP_CODE , UNIT_PRICE , WFAPPROVAL_STATUS , DISCARDED_FLAG , ORIGINAL_AMOUNT , ORIGINAL_BASE_AMOUNT , ORIGINAL_ROUNDING_AMT , CANCELLED_FLAG , INCOME_TAX_REGION , TYPE_1099 , STAT_AMOUNT , PREPAY_INVOICE_ID , PREPAY_LINE_NUMBER , INVOICE_INCLUDES_PREPAY_FLAG, CORRECTED_INV_ID , CORRECTED_LINE_NUMBER , PO_HEADER_ID , PO_LINE_ID , PO_RELEASE_ID , PO_LINE_LOCATION_ID , PO_DISTRIBUTION_ID , RCV_TRANSACTION_ID , FINAL_MATCH_FLAG , ASSETS_TRACKING_FLAG , ASSET_BOOK_TYPE_CODE , ASSET_CATEGORY_ID , PROJECT_ID , TASK_ID , EXPENDITURE_TYPE , EXPENDITURE_ITEM_DATE , EXPENDITURE_ORGANIZATION_ID, PA_QUANTITY , PA_CC_AR_INVOICE_ID , PA_CC_AR_INVOICE_LINE_NUM, PA_CC_PROCESSED_CODE , AWARD_ID , AWT_GROUP_ID , PAY_AWT_GROUP_ID , REFERENCE_1 , REFERENCE_2 , RECEIPT_VERIFIED_FLAG , RECEIPT_REQUIRED_FLAG , RECEIPT_MISSING_FLAG , JUSTIFICATION , EXPENSE_GROUP , START_EXPENSE_DATE , END_EXPENSE_DATE , RECEIPT_CURRENCY_CODE , RECEIPT_CONVERSION_RATE , RECEIPT_CURRENCY_AMOUNT , DAILY_AMOUNT , WEB_PARAMETER_ID , ADJUSTMENT_REASON , MERCHANT_DOCUMENT_NUMBER , MERCHANT_NAME , MERCHANT_REFERENCE , MERCHANT_TAX_REG_NUMBER , MERCHANT_TAXPAYER_ID , COUNTRY_OF_SUPPLY , CREDIT_CARD_TRX_ID , COMPANY_PREPAID_INVOICE_ID, CC_REVERSAL_FLAG , CREATION_DATE , CREATED_BY , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , REQUEST_ID , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE20 , PRIMARY_INTENDED_USE , SHIP_TO_LOCATION_ID , PRODUCT_FISC_CLASSIFICATION, USER_DEFINED_FISC_CLASS , TRX_BUSINESS_CATEGORY , PRODUCT_TYPE , PRODUCT_CATEGORY , ASSESSABLE_VALUE , CONTROL_AMOUNT , TAX_REGIME_CODE , TAX , TAX_STATUS_CODE , TAX_RATE_CODE , TAX_RATE_ID , TAX_RATE , TAX_JURISDICTION_CODE , PURCHASING_CATEGORY_ID , COST_FACTOR_ID , RETAINED_AMOUNT , RETAINED_AMOUNT_REMAINING, RETAINED_INVOICE_ID , RETAINED_LINE_NUMBER , TAX_CLASSIFICATION_CODE ) VALUES ( :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B154 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , -(:B4 ) , :B3 , :B2 , :B1 )
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x30a67ee0f8 280 package body APPS.AP_AIL_TABLE_HANDLER_PKG

 OR

ORA-00600: internal error code, arguments: [kktget: bind pos > num bind vars], [52456442], [388], [386], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=<SQL_ID>) -----
UPDATE AP_INVOICE_LINES_ALL AIL SET TAX_ALREADY_CALCULATED_FLAG = NULL WHERE AIL.INVOICE_ID = :B1 AND NVL(AIL.TAX_ALREADY_CALCULATED_FLAG, 'N') = 'Y' AND NVL(AIL.HISTORICAL_FLAG, 'N') = 'N' AND NOT EXISTS (SELECT 'Line Determining Factors Exist' FROM ZX_LINES_DET_FACTORS ZF WHERE ZF.APPLICATION_ID = 200 AND ZF.ENTITY_CODE = 'AP_INVOICES' AND ZF.EVENT_CLASS_CODE IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') AND ZF.TRX_ID = AIL.INVOICE_ID AND ZF.TRX_LINE_ID = AIL.LINE_NUMBER)
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x30b5703858 501 package body APPS.AP_ETAX_SERVICES_PKG
0x30aa5d2940 117 package body APPS.AP_ETAX_PKG

 

Call stack is similar to :

... kktget2 kkmatr kkmLoadDMLViewTriggers kkmdrvend kkmdrv opiSem opiDeferredSem opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc ...

 
The object with ID=52456442 is an Apps trigger:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.