My Oracle Support Banner

R12: AP: Errors ORA-3113 and ORA-7445 [kgldtf] While Executing Payables Create Accounting Analyzer (Doc ID 2905952.1)

Last updated on OCTOBER 31, 2022

Applies to:

Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Running the Create Accounting Analyzer ends with Error ORA-7445.

The issue ONLY happens with this Payables Analyzer.

When running the Analyzer SQL script ap_accounting_analyze.sql, the error raised is:

  ERROR at line 1:
  ORA-03114: not connected to ORACLE

  ERROR at line 1:
  ORA-03113: end-of-file on communication channel

and the Alert .log file shows error:

  ORA-7445 [kgldtf+35]


The issue generates an incident trace that shows the following:

...
...
----- DDE Diagnostic Information Dump -----
Depth: 1
DDE flags: 0x0
Heap: 0x7f91489495f8
Incident Context pointer in diag: 0x7f91489aa420
Incident ID Cache: 0xe6874870
Invocation Context #: 0
----- Invocation Context Dump -----
Address: 0x7f91489a9b78
Phase: 3
flags: 0x10E0005
Incident ID: 64540
Error Descriptor: ORA-7445 [kgldtf] [SIGSEGV] [ADDR:0x28] [PC:0x4AEAF03] [Address not mapped to object] [] [] [] [] [] [] []
Error class: 0
Problem Key # of args: 1
Number of actions: 20
----- Incident Context Dump -----
Address: 0x7f91489aa420
Incident ID: 64540
Problem Key: ORA 7445 [kgldtf]
Error: ORA-7445 [kgldtf] [SIGSEGV] [ADDR:0x28] [PC:0x4AEAF03] [Address not mapped to object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: ssexhd []
[03]: sslssSynchHdlr []
[04]: sslsshandler []
[05]: __sighandler []
[06]: kgldtf [LIBCACHE]<-- Signaling
[07]: kgldtr [LIBCACHE]
[08]: kzpchkc [SEC]
[09]: kzpchkbu_internal [SEC]
[10]: ksfchk [VOS]
 ...
 ...


According to the Analyzer Log file and the incident trace, the SQL that causes the error is

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.