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 laterOracle 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.
-------
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:
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:
----- 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
----- 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 :
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 |