My Oracle Support Banner

ORA-08102: index key not found Is Thrown When Applying Receipt to Transaction (Doc ID 2412622.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receipts Related

Steps to Reproduce  
1. Navigate to Receipts > Receipts
2. Open a receipt
3. Click Apply button and select a transaction as Apply To on Applications page.


ERROR
ORA-08102: index key not found, obj# 6800414, file 29, block 205889 (2)
ORA-06512: at "APPS.ARP_PROCESS_APPLICATION", line 4540
FRM - 40735 ON-INSERT trigger raised unhandled exception ORA - 08102


DEBUG messages
ar.plsql.GET_RULE_SET_ID.begin                                              ARP_APP_CALC_PKG: GET_RULE_SET_ID()+
ar.plsql.GET_RULE_SET_ID.end                                                 ARP_APP_CALC_PKG: GET_RULE_SET_ID()- Rule Set Id = 3
ar.plsql.ARP_APP_CALC_PKG.calc_applied_and_remaining    ARP_APP_CALC_PKG.calc_applied_and_remaining() Wrapper +

ar.plsql.arp_ps_pkg.update_p                                                 dump_debug: EXCEPTION: arp_ps_pkg.update_p(2)
ar.plsql.arp_util.populate_closed_dates                                 EXCEPTION: arp_ps_util.update_invoice_related_columns
ar.plsql.arp_util.populate_closed_dates                                 EXCEPTION: arp_process_application.receipt_application


----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x19ea702f8        73  package body APPS.FND_LOG
0x19ea702f8       216  package body APPS.FND_LOG
0x19b7a51b0       643  package body APPS.ARP_STANDARD
0x17161f3b8      1285  package body APPS.ARP_PS_PKG
0x19bf2d820      1323  package body APPS.ARP_PS_UTIL
0x19b9c5198      4000  package body APPS.ARP_PROCESS_APPLICATION
"ORA-08102: index key not found, obj# 6800414, file 29, block 205889 (2)"

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!


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