My Oracle Support Banner

ORA-600[kksfbc-reparse-infinite-loop] After applying Oracle Application patch and Working With Payables Application (Doc ID 1067839.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2013***

Symptoms

This problem was observed  in Oracle 11.1.0.6 on a HP-UX Itanium server.

Problem description
This is an Oracle Apps environment and the invoice function is failing.

The ALERT LOG shows internal errors which is suspected to be the source of the failures.

Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_ora_19143.trc (incident=756639):
ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x9FFFFFFFBE50CAF8], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_756639/<SID>_ora_19143_i756639.trc

Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_ora_19143.trc (incident=756640):
ORA-00600: internal error code, arguments: [kxsGetRuntimeLock2], [0xC0000007BA22D878], [1], [1], [1], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_756640/<SID>_ora_19143_i756640.trc



The incident trace file for the kksfbc-reparse-infinite-loop error shows a failing statement:
SELECT DISTRIBUTION_TOTAL , POSTING_FLAG , APPROVAL_STATUS_LOOKUP_CODE , PO_NUMBER ,
NOTES_COUNT , HOLDS_COUNT , AMOUNT_HOLD_FLAG , VENDOR_HOLD_FLAG , ENCUMBERED_FLAG ,
PERIOD_NAME , SELECTED_FOR_PAYMENT_FLAG , UNPOSTED_VOID_PAYMENT_FLAG ,
DISCOUNT_PAY_DISTS_FLAG , PREPAYMENTS_APPLIED_FLAG , PAYMENTS_EXIST_FLAG ,
QUERY_PACKET_ID , PREPAY_AMOUNT_APPLIED , CANCELLED_BY_DISPLAY
FROM AP_INVOICES_DERIVED_V WHERE ROW_ID = :1


The function stack shows the error occurred while finding a cursor
. .  .. . kgerinv kgeasnmierr kksfbc kkspfda kpodny kpoal8 opiodr ttcpip . . . . .

Checking the time stamp between parent and dependents, we see there are out of sync conditions.

Changes

This can happen after upgrading to 11g, and while applying patches for (or installing a new version of) Oracle Applications.

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
Changes
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.